© Copyright IBM Corp. 2005. All rights reserved. xv
Tables
1-1 Relative cost of DB2 data types for SQL processing from lowest (top) to highest. . . . 5
1-2 Byte counts of columns by data type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
1-3 DB2 and Java data types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
1-4 Comparison between CHAR and VARCHAR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
1-5 The difference between EQUAL and IS NOT DISTINCT FROM. . . . . . . . . . . . . . . . 17
1-6 DB2 logging of updated rows. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
1-7 Contents of the denormalized code table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
1-8 A table with multi-valued columns to store aggregated data . . . . . . . . . . . . . . . . . . . 37
1-9 PARTKEYU values and partitioning key update behavior . . . . . . . . . . . . . . . . . . . . . 46
1-10 Default DSSIZE values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
1-11 Maximum record size supported by each page size, in bytes . . . . . . . . . . . . . . . . . . 55
3-1 Overview of partitioning design alternatives . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125
5-1 Characteristics of unique number generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138
6-1 Stored procedure only vs. enabling non-Java subprogram for result set passing . . 158
6-2 A subset of the DB2 MQ scalar functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164
6-3 DB2 MQ table functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165
7-1 Storing and retrieving XML data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178
8-1 Moving predicates to a better performing stage. . . . . . . . . . . . . . . . . . . . . . . . . . . . 198
8-2 Comparing CTTs and DTTs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211
9-1 Relevant values for multiple cursor repositioning . . . . . . . . . . . . . . . . . . . . . . . . . . 225
9-2 Dependencies on DECLARE and FETCH statements for scrollable cursors . . . . . 235
9-3 FETCH orientation keywords for scrollable cursors. . . . . . . . . . . . . . . . . . . . . . . . . 236
9-4 Comparing scrollable cursors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236
9-5 SQLCODEs for scrollable cursors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238
9-6 Candidate SQLCODEs for application retry logic . . . . . . . . . . . . . . . . . . . . . . . . . . 256
9-7 Error handling parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258
10-1 Differences between online and batch applications. . . . . . . . . . . . . . . . . . . . . . . . . 279
12-1 Table space, partition, and table lock types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331
12-2 Page and row lock types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331
12-3 Table space, table, and partition lock compatibility matrix. . . . . . . . . . . . . . . . . . . . 331
12-4 Page and row lock compatibility matrix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 332
12-5 Locks acquired for operations on LOBs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 332
12-6 Claim classes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 333
12-7 Termination of a unit of recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 350
13-1 Overview of locks acquired by various SQL statements . . . . . . . . . . . . . . . . . . . . . 361
13-2 Flow of nonconcurrent batch chain . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 378
15-1 P-lock modes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407

Get DB2 UDB for z/OS: Design Guidelines for High Performance and Availability now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.