Index


A

Access control, 4, 12, 97, 98

Advanced Access Control Feature in, 44

Label Based Access Control (LBAC) in, 44, 105, 110, 111

Access plans, 251, 585

Action, trigger, 439

Activation time, trigger, 220–221, 438–439

Activity Monitor, 81

Add Database dialog, 182, 183

Administration Console, DWE, 46

ADO/ADO.NET, 52, 54

Advanced Access Control Feature, 44

AFTER trigger, 220–221, 439, 440, 442

Aggregations, 13

AIX, 8, 11, 36, 41, 42, 98, 155, 567, 568, 573

Alerts, Health Center, 73

Aliases, 179, 180, 192, 214–217, 245, 250, 575, 582–583, 586

chaining and, 214

constraints and, 214

Control Center to create, 215, 216

Create Alias dialog for, 215, 216

CREATE ALIAS for, 214–215

nicknames vs., 122, 214

SQL and, 172

uses for, 216–217

ALL PRIVILEGES clause, 129, 130, 134–136, 139, 144, 159

Alphablox Analytics, 47

ALTER, 7, 116, 119, 122, 129, 131, 134, 139, 141, 144,156, 158, 159, 574, 576, 577, 580, 583–585

ALTER TABLE, 416, 491

locks and, 483, 485

ALTERIN privilege, 115, 128, 138–139

Ambiguous cursors, 315

Analytics, 12, 13

APPC support, 40

Application Developer/Programmer, authorities and privileges using, 150t

Application programming interfaces (APIs), 48, 60

Application Requestor (AR), 43, 568

Application Server (AS), 43, 568

Arranging to take a certification exam, 17–19

AS/400, 8, 36, 102

ASC (ascending) sort, 592

Atomic nature of transactions, 322

ATTACH PARTITION, 416, 609

Audio, Video, and Image (AVI) extender, 55–56, 572

Authentication, 12, 98–103, 150, 190, 191, 573, 581

client-based, 100, 155

DATA_ENCRYPT, 101, 155, 573, 581

DATA_ENCRYPT_CMP, 101, 155, 573

Database Manager and, 99, 102–103, 155

Distributed Computing Environment (DCE) security services and, 98, 155

encryption and, 100, 101, 102, 155

external vs. internal facilities for, 98–99, 155

Generic Security Service Application Program Interface (GSS-API) and, 101, 155

GSS_Server_Encrypt and, 101, 155, 573

Kerberos for, 100, 155, 573, 581

KRB_Server_Encrypt and, 100, 155, 573

passwords in, 98–99

Server_Encrypt and, 100, 155, 573, 581

server-based, 99, 155

trusted vs. untrusted clients and, 102–103

type of, 99

user IDs in, 98–99

where performed, 99–102

Authorities, 103–113, 104, 151, 574. See also privileges

BINDADD, 113, 127, 137, 149t, 157, 171, 576, 577

BY ALL clause in, 138

common jobs and, required for, 148, 148–149t

CONNECT, 127, 137. See also CONNECT

CONNECT_QUIESCE, 127, 137

Control Center and, granting/revoking of, 125–126, 125, 126

CREATE_EXTERNAL_ROUTINE, 113, 127, 137, 149t

CREATE_NOT_FENCED_ROUTINE, 113–114, 127, 137

CREATETAB, 113, 127, 137, 157, 171, 574, 577

Database Administrator (DBADM), 3, 105, 110–111, 106, 118, 124, 127–144, 147t, 149t, 171, 196, 575–576, 579

Database Manager and, 103

database-level, and GRANT, 127

database-level, and REVOKE, 137–138

GRANT and, 111, 112, 127–137, 153

granting of, 123–147

IMPLICIT_SCHEMA, 127, 137

index, and GRANT, 130–131

index, and REVOKE, 140–141

indirect granting of, 124

iSeries and. See iSeries

Label-Based Access Control (LBAC) and, 105, 110, 111

Linux and. See Linux

Load (LOAD), 105, 112, 127, 137, 147t, 171, 576

nickname, and GRANT, 134–135

nickname, and REVOKE, 144

package, and GRANT, 133

package, and REVOKE, 143

PUBLIC and, 112, 121, 128, 131, 133, 138, 141, 143, 145, 171, 577, 579

requirements for granting/revoking, 146, 147t

REVOKE and, 137–146, 154

routine, and GRANT, 131–133

routine, and REVOKE, 131–133

schema, and GRANT, 128

schema, and REVOKE, 138–139

Security Administrator (SECADM), 105, 106, 111–112, 127, 137, 147t, 149t

sequence, and GRANT, 131

sequence, and REVOKE, 141

server, and GRANT, 133–134, 133

server, and REVOKE, 143–144

SQL and, 170, 171

stored procedures and, 152, 154, 160

System Administrator (SYSADM), 105–106, 108, 109, 110, 111, 118, 129, 130, 134, 139–144, 147t, 575–576, 579

System Control (SYSCTRL), 105–109, 110, 111, 147t, 149t, 574

System Maintenance (SYSMAINT), 105, 106, 108–109, 110, 147t, 149t, 574

System Monitor (SYSMON), 105, 106, 109–110, 147t, 149t

table space, and GRANT, 128

table space, and REVOKE, 138

table, and GRANT, 129

table, and REVOKE, 139

tables, 152, 153

UNIX and. See UNIX

view, and GRANT, 130

view, and REVOKE, 140

Windows and. See Windows

WITH GRANT OPTION and, 124

Authorizations, 97

AutoLoader utility (db2atld), 112

Automatic commit feature, 322

Automatic Maintenance, 3

Automatic Storage, 3

Autorestart, transactions and, 326

Availability, 7

data warehousing and, 86




DB2 9 Fundamentals Certification Study Guide
DB2 9 Fundamentals: Certification Study Guide
ISBN: 1583470727
EAN: 2147483647
Year: 2007
Pages: 93

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net