Tables 1-1 The LOBs functions that have been introduced after Version 6 . . . . . . . . . . . . . . . . . . . 5 2-1 Typical average size for large objects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2-2 Maximum number of LOB columns by partitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 2-3 DB2-generated construct . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 2-4 File option constants . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 3-1 Attributes for implicit database creation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3-2 Default values for implicitly created table spaces . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 3-3 Base table space created using automatic object creation . . . . . . . . . . . . . . . . . . . . . . 28 3-4 LOB table space created using automatic object creation . . . . . . . . . . . . . . . . . . . . . . 29 3-5 Auxiliary index created using automatic object creation . . . . . . . . . . . . . . . . . . . . . . . . 30 3-6 LOB table space created using CURRENT RULES STD . . . . . . . . . . . . . . . . . . . . . . . 30 3-7 Auxiliary index created using CURRENT RULES STD. . . . . . . . . . . . . . . . . . . . . . . . . 31 3-8 LOG column values scenarios . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 3-9 SYSIBM.SYSCOPY values for LOGGED attribute changes. . . . . . . . . . . . . . . . . . . . . 49 3-10 DB2 Unicode support - Additional useful resources . . . . . . . . . . . . . . . . . . . . . . . . . . 56 3-11 Choosing a LOB page size that minimizes getpages . . . . . . . . . . . . . . . . . . . . . . . . . 58 3-12 Choosing a LOB page size for LOBs that are all the same size . . . . . . . . . . . . . . . . . 59 3-13 Primary and secondary quantity with LOBs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 3-14 Summary of data set, partition, and partitioned table space sizes . . . . . . . . . . . . . . . 60 4-1 SQLTYPE and SQLLEN of LOB columns or LOB host variables in the SQLDA . . . . . 70 4-2 Casting large objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 4-3 Where large objects come from and how . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85