I

i5/OS, DB2, 36, 49–50, 60, 92, 568, 569

IBM, 17

IBM Certified Advanced Database Administrator-DB2 9

for Linux, UNIX, and Windows, 11–12, 12

IBM Certified Application Developer-DB2 9 Family, 8–10, 10

IBM Certified Database Administrator-DB2 9 for Linux, UNIX, Windows, 3–5, 5

IBM Certified Database Administrator-DB2 9 for z/OS, 6–8, 8

IBM Certified Database Associate-DB2 9 Fundamentals, 2–3, 3

IBM Certified Solution Designer-DB2 Data Warehouse Edition V9.1, 12–14, 15

IBM DB2 9 certification

certification process in, 15–34

arranging to take a certification exam in, 17–19

cost of exams, 19

identification requirements for, 19

preparing for the exams in, 15–17

taking the exam in, 19–34

Database Administrator (DBA) in, 3

IBM Certified Advanced Database Administrator-DB2 9 for Linux, UNIX, and Windows in, 11–12, 12

IBM Certified Application Developer-DB2 9 Family in, 8–10, 10

IBM Certified Database Administrator-DB2 9 for Linux, UNIX, Windows in, 3–5, 5

IBM Certified Database Administrator-DB2 9 for z/OS in, 6–8, 8

IBM Certified Database Associate-DB2 9 Fundamentals, 2–3, 3

IBM Certified Solution Designer-DB2 Data Warehouse Edition V9.1 in, 12–14, 15

IBM Information Management

IBM Learning Services, 15–17

IBM Tivoli. See Tivoli System

IBM Web sites, 16

IBMDEFAULTBP, 169

Identification requirements for taking exams, 19

Identity columns, 218, 583, 411–413, 455, 601

CYCLE clause for, 413

data types for, 455

sequences and vs., 218

Illustrations/exhibits, in IBM Certification exam, 25–26, 26, 27

Implicit granting of authorities/privileges, 123–124

IMPLICIT_SCHEMA, 113, 127, 137, 171, 193

IMPORT utility, 4, 14

IMS, 43, 54

IN predicate, 277–279, 596

INCLUDE, stored procedures and, 236

Inconsistency of data vs. concurrency, 466

INDEX, 7, 116, 123, 129, 134, 139, 144, 156, 158, 576, 577

Indexes, 6, 12, 78–81, 192, 219–214, 210, 244, 250, 365, 434–438, 448, 456, 459, 571, 582, 602, 603, 605, 606, 608

authorities and privileges using, GRANT and, 130–131

authorities and privileges using, REVOKE and, 140–141

CLUSTER option for, 437

clustering storage and, 210, 211, 436–438

Control Center for, 212, 213

CREATE INDEX for, 211–212, 212t, 435–438

Create Index wizard to create, 212, 213

Database Manager and, 212

Design Advisor in, 13, 78–81, 81, 88, 93, 568

explicit creation of, 434–435

extents and, 437

GROUP BY clause and, 210

keys in, 210, 211, 434, 435

multidimensional clustering (MDC), 12, 39, 80, 81, 437–438, 568

On-Line Transaction Processing (OLTP) and, 35, 45, 85–87, 94, 436, 571

ORDER BY clause and, 79, 210, 227, 268, 271, 285–287, 358, 592, 595, 596

partitioned tables and, 416

performance effects of, 214, 436

primary keys and, 211, 434

privileges available with, 118–119, 118

queries and, 210

REORG utility and table updates effects on, 4, 7, 438, 570

searching and, 210

tables and, 214

UNIQUE clause for, 211, 435

UNIQUE constraints and, 365, 374, 379–381, 380, 384, 403, 406, 408, 410, 421, 426, 456, 457, 602, 605

uses for, 210

Indirect granting of authorities/privileges, 124

Information Center Consultant, authorities and privileges using, 150t

Information Center, IBM, 16

Informational constraints, 374, 397–398, 398, 605

Informix, 38

Informix Data Source support, 40

Informix Dynamic Server (IDS), 43, 49

Inner joins, 298–301, 300, 354, 355–356, 588, 589–590

INSERT, 67, 112, 116, 117, 123, 129, 130, 134, 139, 140, 144, 149t, 156, 158, 245, 247, 253, 257–260, 259t, 346–347, 359, 449, 450, 569, 576, 577, 579, 584, 593, 596, 598–599, 605, 607

Insert Rule for referential integrity constraint, 386–389, 387, 388, 456, 602

locks and, 486

NULL and, 260, 263, 264, 279–280, 447, 587, 588, 595–596, 605

referential integrity constraints and, 385, 386–389, 387, 388, 456

SELECT and, 260

token values in, 259–260

triggers and, 225

VALUES clause in, 259, 260

WITH DEFAULT constraint in, 260

XML and, 333, 334

XQuery and, 337

Insert Rule for referential integrity constraint, 386–389, 387, 388, 456, 602

Instances, 161–164

DB2 INSTANCE environment variable for, 163

managing, 163–164, 164t

system commands for, 164

INSTEAD, 586

INSTEAD OF trigger, 220–221, 439, 440

INTEGER, 198, 600, 601

Integer (SMALLINT) data type, 198, 367, 601

Integrated development environment (IDE), 46

Intent exclusive (IX) lock, 481t, 486t, 488t, 489

Intent none (IN) lock, 480t, 486t, 488t

Intent share (IS) lock, 480t, 486t, 488t

Interleaved transactions, 467

International DB2

User's Group North American Conference, 17

Interparallelism, 11

INTERSECT ALL set operator, 310, 310

INTERSECT set operator, 309, 309, 591

Intraparallelism, 11, 43

iSeries, 8, 43, 54, 580

privileges and, routine type, 116, 119, 120, 122, 132–133, 135, 140, 144–145

iSeries Navigator, 49–50

Isolation levels, 325, 465, 497, 610, 611, 613

CHANGE ISOLATION for, 477

choosing proper level of, 475–476

Cursor Stability isolation level and, 468, 469, 472–473, 474, 476, 610, 612, 613

ISOLATION option for, 476

Read Stability isolation level and, 468, 469t, 471, 472, 476, 497, 501, 610, 611, 613

Repeatable Read, 468, 469t, 469–470, 470, 476, 495, 501, 610, 613

SELECT and, 477

specifying, 476–477

SQLSetConnectAttr() and, 477

TXNISOLATION and, 477

Uncommitted Read isolation level and, 325, 468, 469t, 474–476, 475, 498, 499, 501, 610, 611, 613

ISOLATION option, 476

iSystem, 568