Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Summary of changes -- June 2002, First Edition -- November 2004, First Update -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 Summary of considerations -- Chapter 2. Large objects with DB2 -- 2.1 Object orientation with DB2 -- 2.2 Large objects with DB2 -- 2.3 The new data types -- 2.3.1 LOB locators -- 2.3.2 The ROWID -- Chapter 3. Creating LOBs -- 3.1 Data conversion -- 3.2 Storing LOBs -- 3.2.1 How to store them in DB2 -- 3.2.2 Creating a table containing LOBs -- 3.2.3 Creating the LOB table spaces -- 3.2.4 Creating the auxiliary tables -- 3.2.5 The auxiliary index -- 3.2.6 Adding a LOB column to an existing table -- 3.3 The CURRENT RULES special register -- 3.3.1 Impact on CREATE and DROP LOBs -- 3.3.2 Impact on cursors fetching LOB values -- 3.4 Feeding a LOB column -- 3.4.1 LOAD with LOB columns smaller than 32 KB -- 3.4.2 Inserting LOBs via host application -- Chapter 4. Using LOBs -- 4.1 SQL semantics with LOBs -- 4.2 LOB locators -- 4.2.1 Getting to know LOB locators -- 4.3 Handling BLOBs, CLOBs, DBCLOBs -- 4.3.1 Manipulating a LOB without retrieving it -- 4.3.2 Unloading a LOB via application -- 4.3.3 Finding the nth occurrence of a string -- 4.4 LOBs are different DB2 objects -- 4.4.1 Storage of LOBs -- 4.5 Locking -- 4.5.1 Locks with simple reads -- 4.5.2 Using ISOLATION (UR) for LOBs -- 4.5.3 Locks with INSERT -- 4.5.4 Locks with DELETE -- 4.5.5 Locks with UPDATE -- 4.5.6 Some general information about locking -- 4.6 Details about ROWID -- Chapter 5. DB2 Extenders and LOBs -- 5.1 Generalities -- 5.2 AVI Extenders -- 5.2.1 Desktop -- 5.2.2 Database -- 5.2.3 WLM environment -- 5.2.4 Administration tasks to enable a table to use extenders -- 5.3 XML Extenders.

5.3.1 XML Toolkit -- 5.3.2 WLM application environment -- 5.3.3 General host requirements -- 5.3.4 Workstation requirements -- 5.4 XML and LOBs -- Chapter 6. Data administration with LOBs -- 6.1 The DB2 Catalog and LOBs -- 6.1.1 Some catalog definitions for LOBs -- 6.1.2 LOBs defined in DB2 catalog -- 6.2 Utilities -- 6.2.1 LOAD -- 6.2.2 DSNTIAUL -- 6.2.3 UNLOAD -- 6.2.4 COPY -- 6.2.5 REPORT TABLESPACESET -- 6.2.6 RUNSTATS -- 6.2.7 REORG -- 6.2.8 CHECK LOB -- 6.2.9 CHECK DATA -- 6.2.10 CHECK INDEX -- 6.2.11 DSN1COPY -- 6.2.12 REPAIR -- 6.2.13 RECOVERY -- 6.3 Recovery scenario -- 6.4 Operational scenario -- Chapter 7. Performance with LOBs -- 7.1 LOB materialization -- 7.1.1 Using data spaces for LOBs -- 7.2 Buffer pools and group buffer pools -- 7.3 LOBs performance considerations -- 7.3.1 Logging with LOBs -- 7.3.2 LOBs processing -- 7.3.3 LOBs read performance -- 7.3.4 Comparing SQL accounting profiles -- 7.3.5 LOBs write performance -- 7.3.6 IFCIDs enhancements for LOBs -- 7.3.7 LOBs recommendations -- Appendix A. Sample jobs output -- A.1 DDL for a LOB environment -- A.2 Sample of DB2 PM accounting trace output -- A.3 Using file reference variables -- Appendix B. Unicode implementation -- B.1 Generate the conversion table -- B.2 Activate the UNICODE table -- Appendix C. Recent maintenance -- C.1 Requirements -- C.2 LOB related maintenance -- Appendix D. Additional material -- Locating the Web material -- Using the Web material -- System requirements for downloading the Web material -- How to use the Web material -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.