Index

This index provides page-equivalent chapter references to the major topics covered in this book. Entries are organized alphabetically. Chapter numbers appear in parentheses; bold chapter numbers indicate the primary treatment of that topic.

A

Access path selection, (12), 8, 11 ACID properties, (7), 14 Actionable compression, (27), Appendix A Active log, (14), 15, 17 Address space (z/OS), (1), 18 ALLOCATE (z/OS), 10, Appendix D ALTER BUFFERPOOL command (z/OS), (9), Appendix D ALTER TABLE statement, (3), 4, Appendix B Anti-join, 12, Appendix A Application encoding, 26, Appendix D Application-period temporal table, (30) Archive log, (14), 15, 17 ARIES recovery algorithm, 14, Bibliography Array data type, (3), 21 Audit, (22), Appendix D Authentication, (22), 1 Authorization, (22), 19 AUTO_MAINT parameter, (11), Appendix D AUTO_RUNSTATS parameter, (11), Appendix D Automatic client reroute, (17), 18 Automatic storage, (4), Appendix C

B

B+ tree structure, (8), Appendix A BACKUP DATABASE command, (15), Appendix D Base table, 3 Batch processing, (10), 13 BIGINT data type, 3, Appendix B BIND command (z/OS), (19), 12 BLU Acceleration, (27), 12 BLOB data type, 3 Boolean data type (LUW), 3, Appendix B BSDS (z/OS), (14) Buffer pool, (9), 12, 16, Appendix A Buffer pool hit ratio, (9), 16, Appendix A Built-in functions, (6), Appendix B

C

Capacity planning, (16), Appendix A Cardinality estimation, (12), 11, Appendix A Catalog tables, (3), 11 CCSID (character encoding), (26), Glossary CHAR data type, 3, Appendix B CHECK DATA utility (z/OS), (11), Appendix D CHECK INDEX utility (z/OS), (8), Appendix D CHECK PENDING status, (11), 10, Appendix E Checkpoint, (14), 9 CLOB data type, 3 Client reroute, (17), 18 Clustering index, (8), 4, 11, 12 CLUSTERRATIO statistic, (8), 11, 12 COALESCE function, 6, Appendix B Column mask (RCAC), (22) Column-organized tables, (27), 12 COMMIT statement, (7), 14, 19 Common Table Expression (CTE), (6), Appendix B Compression, (13), 4, 27 Compression ratio estimation, Appendix A Concurrency control, (7), 12 Configuration parameters (LUW), (16), Appendix D Connection concentrator, (26), 16 Connection pooling, 20, 26, Appendix A COPY utility (z/OS), (15), Appendix D Correlation name, 6 Cost-based optimization, (12), Appendix A Coupling Facility, (18), 9 CREATE DATABASE command, (1), Appendix C, Appendix D CREATE INDEX statement, (8), Appendix B CREATE TABLE statement, (3), Appendix B Cursor, (19), 7 Cursor stability (CS), (7), 19

D

Data page, 4, 8, 9 Data sharing (z/OS), (18), 9, 15, 17 Data types, (3), Appendix B Database partitioning (DPF), (28), 4 DATE data type, 3, Appendix B Date arithmetic, 6, Appendix B DB2 Connect, (26), Appendix C db2advis (Design Advisor), (8), 12 db2audit command, (22), Appendix D db2batch command, (16), Appendix D db2ckbkp command, (15), Appendix D db2dart command, 16, Appendix D db2diag diagnostic log, (16), Appendix D db2expln command, (12), Appendix D db2level command, Appendix D db2look command, (11), Appendix D db2move command, (10), Appendix D db2pd command, (16), Appendix D db2support command, 16, Appendix D db2top command, (16), Appendix D db2val command, Appendix D DBeaver setup, Appendix C DBRM (z/OS), (19) DBCLOB data type, 3 DDL (Data Definition Language), (3), Appendix B Deadlock, (7), 16 DECIMAL data type, 3 DECFLOAT data type, 3, Appendix B DECLARE CURSOR, (19) Declared global temporary table, (5), 6, Appendix B DELETE statement, (5), Appendix B Delta backup, (15) DISPLAY ARCHIVE command (z/OS), Appendix D DISPLAY BUFFERPOOL command, (9), Appendix D DISPLAY DATABASE command, (4), Appendix D DISPLAY DDF command (z/OS), (26), Appendix D DISPLAY GROUP command (z/OS), (18), Appendix D DISPLAY THREAD command, (16), Appendix D DISPLAY UTILITY command (z/OS), Appendix D Distribution statistics (histograms), (11), 12 DML (Data Modification Language), (5), Appendix B Docker installation, (1), Appendix C DRDA protocol, (26) DSNTEP2 (z/OS), 19, Appendix D Dynamic SQL, (19), 12 Dynamic statement cache, (12), 19

E

EBCDIC encoding, (26), Glossary Embedded SQL, (19) Encryption, (22) Event monitor (LUW), (16) EXCEPT operator, 6, Appendix A EXPLAIN facility, (12), 16 EXPLAIN tables, (12) Expression-based index, (8), Appendix B Extent, 4 Extent size, (4)

F

Fanout (B+ tree), (8), Appendix A Federated database, (29) FETCH FIRST n ROWS, (6), 12, Appendix B Filter factor, (12), Appendix A FOR SYSTEM_TIME clause, (30), Appendix B Foreign key, (3), 11 Free space management, (4), 11, 13 Frequency value statistics, (11), 12 Full outer join, 6, Appendix B Function path, 21

G

GET DIAGNOSTICS statement, (19), 21 GETPAGE count, 9, 16, Appendix A Global temporary table, (5), 6, Appendix B GRANT statement, (22), Appendix B Group buffer pool, (18), 9 Group restart (z/OS data sharing), (18)

H

HADR (High Availability Disaster Recovery), (17), 15 Hash join, (12), Appendix A HAVING clause, (6) Histogram statistics, (11), 12, Appendix A Host variable, (19)

I

IBM Data Studio, Appendix C IBM Knowledge Center, Bibliography Identity column, (5), Appendix B IFCID (z/OS trace), (16), 22 Image copy (z/OS), (15), Appendix D IMPORT command (LUW), (10), Appendix D IN predicate, 6, 12 Incremental backup, (15) Index, (8), 3, 12 Index advisor (db2advis), (8), 12 Index compression, (8), 13 Index-only access, (12), 8 Inline statistics, (11), 10 INSERT statement, (5), Appendix B Installation, (1), Appendix C INTEGER data type, 3 INTERSECT operator, 6, Appendix A IRLM (z/OS lock manager), (7), 18 Isolation levels, (7), 19, Appendix B

J

Java application development, (20) JDBC connectivity, (20), Appendix C JDBC driver (IBM Data Server Driver), 20, Appendix C JCL (z/OS), 10, 15, Appendix D JOIN syntax, (6), Appendix B Join cost models, Appendix A Join methods, (12), Appendix A JSON functions, (31), Appendix B JSON_VALUE function, (31), Appendix B

K

Key (primary, foreign, index), (3), 8 Knowledge Center (IBM), Bibliography

L

LAG/LEAD functions, (6), Appendix B Latch contention, 16 Lateral join, 6, Appendix B LIKE predicate, 6, 12 LIKE statistics (column groups), (11), Glossary LIST APPLICATIONS command, (16), Appendix D LISTAGG function, 6, Appendix B Little's Law, Appendix A LOAD command (LUW), (10), Appendix D LOAD utility (z/OS), (10), Appendix D Lock avoidance (z/OS), (7), Glossary Lock escalation, (7), 16 Lock management, (7), 16, 18 Lock timeout, (7), 16, Appendix D Log file configuration, (14), Appendix D Log full (SQLCODE -964), (14), Appendix E LOGARCHMETH1 parameter, (14), 15, Appendix D Logging, (14), 7, 15 LOGPRIMARY/LOGSECOND parameters, (14), Appendix D

M

Materialized query table (MQT), (12), 27, Appendix B MERGE statement, (5), Appendix B Merge join (MSJOIN), (12), Appendix A Migration from Oracle, (35) MODIFY STATISTICS utility (z/OS), 11, Appendix D MON_GET table functions, (16), Appendix D Multi-column statistics, (11), 12, Appendix A Multi-row INSERT, (5), Appendix B

N

Native encryption, (22) Nested-loop join (NLJOIN), (12), Appendix A Nickname (federated), (29) NOT EXISTS subquery, 6, 12 NOT NULL constraint, (3) NULL handling, (3), 6, Appendix A Numeric data types, 3, Appendix B

O

ODBC connectivity, (20) OLAP functions. See Window functions OMEGAMON (z/OS monitoring), (16), Glossary Online REORG, (11), Appendix D OPTIMIZE FOR n ROWS, (12), Appendix B Optimizer, (12), 11, Appendix A Oracle compatibility mode, (35), Appendix E ORDER BY clause, (6), 12 Outer join, (6), Appendix B

P

Package, (19), 12 Package cache, (19), 16, Appendix D Page cleaner, (9), Appendix D Page size, (4), 8, Appendix A Parallel Sysplex, (18) Parallelism (intra-partition), (12), 16, Appendix D Partition, (4), 8, 10, 15 Partition-by-growth (z/OS), (4), Glossary Partition-by-range (z/OS), (4), Glossary PCTFREE parameter, (4), 11, 13 Performance monitoring, (16), Appendix D Phantom read, (7), Glossary Plan (z/OS), (19) Point-in-time recovery, (15), Appendix D Predicate evaluation, (12), Appendix A Predicate pushdown, (12), 29 Prefetch, (9), 12 Prefetcher (I/O server), (9), Appendix D Primary key, (3), 8 pureScale, (18), 17

Q

Query optimization. See Optimizer Query rewrite, (12) Query tuning, (12), 8, 11, 16

R

RACF (z/OS), (22) Range partitioning, (4), 28 RANK function, (6), Appendix B RCAC (Row and Column Access Control), (22) REBIND command, (19), 11 REBUILD INDEX utility (z/OS), (8), Appendix D RECOVER command (z/OS), (15), Appendix D Recovery, (15), 14, 17 Recovery time estimation, Appendix A Recursive CTE, (6), Appendix B Redbooks (IBM), Bibliography Referential integrity, (3), 11 REGEXP_LIKE function, 6, Appendix B REORG utility/command, (11), Appendix D REORGCHK command (LUW), (11) Repeatable read (RR), (7) RESTORE DATABASE command, (15), Appendix D RID (Record Identifier), 8, 12 RID list processing, (12), Appendix E Role (security), (22), Appendix B ROLLBACK statement, (7), 14 ROLLFORWARD DATABASE command, (15), Appendix D Row and Column Access Control, (22) Row compression, (13), Appendix A Row permission (RCAC), (22), Glossary ROW_NUMBER function, (6), Appendix B RUNSTATS utility/command, (11), 12, Appendix D

S

Sample database (IBM), Appendix C Savepoint, (7) Scalar function, (6), 21, Appendix B SECADM authority, (22) Security, (22) Segmented table space (z/OS), (4) SELECT FROM FINAL TABLE, (5), 20, Appendix B SELECT statement, (6), Appendix B Self-Tuning Memory Manager (STMM), (9), 16, Appendix D Semi-join, 12, Appendix A Sequence, (5), Appendix B SET INTEGRITY statement, (11) SET LOG command (z/OS), Appendix D SIMD processing, (27), Glossary SMALLINT data type, 3, Appendix B Snapshot monitoring (LUW, deprecated), 16 Sort heap, (9), 12, Appendix D Special registers, (6), Appendix B SPUFI (z/OS), (1), Appendix C SQL PL, (21) SQLCODE -803 (duplicate key), 3, Appendix B SQLCODE -911 (deadlock/timeout), (7), Appendix B SQLCODE -964 (log full), (14), Appendix B, Appendix E SQLCODE values, (19), Appendix B SQLSTATE values, (19), Appendix B START DATABASE command (z/OS), (4), Appendix D Statement concentrator, (12), Glossary Static SQL, (19), 12 Statistics. See RUNSTATS STOP DATABASE command (z/OS), (4), Appendix D Storage sizing, (16), Appendix A Stored procedure, (21), 19, 20 Subquery, (6), 12, Appendix B Sysplex workload balancing, (18), 26 System catalog. See Catalog tables System-period temporal table, (30)

T

Table function, (21), Appendix B Table scan (TBSCAN), (12), 8 Table space, (4), 15 Temporal table, (30), Appendix B TERM UTILITY command (z/OS), Appendix D Three-valued logic, (3), Appendix A Throughput measurement, (16) TIMESTAMP data type, 3, Appendix B Transaction isolation. See Isolation levels Trigger, (21), 5 TRUNCATE statement, (5), Appendix B Trusted context, (22), Glossary Two-phase commit, (26), 7

U

UDF (User-Defined Function), (21) Uncommitted read (UR), (7) Unicode support, 3, 26 UNION / UNION ALL, (6), Appendix A, Appendix B Unique index, (8), 3 Unit of work (UOW), (7), 14 Universal table space (z/OS), (4) UNLOAD utility (z/OS), (10), Appendix D UPDATE statement, (5), Appendix B Upgrade procedure, (36)

V

VARCHAR data type, 3, Appendix B VARCHAR_FORMAT function, 6, Appendix B View, (3), 6 Visual Explain, (12), Appendix C VSAM (z/OS), 4, Glossary

W

Window function, (6), 12, Appendix B WITH clause. See Common Table Expression WITH UR/CS/RS/RR clause, (7), Appendix B WLM (z/OS Workload Manager), (23), 18 Workload management, (23), 16 Write-ahead logging, (14)

X

XML data type, (31) XML support, (31), Appendix B XMLTABLE function, (31), Appendix B XQuery, (31)

Z

Zowe CLI, (1), Appendix C ZPARM (z/OS), (16), Appendix D z/OS address spaces, (1), Glossary z/OS commands, (16), Appendix D z/OS data sharing. See Data sharing z/OS utilities, (10), (11), (15), Appendix D