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