Large objects with DB2 for z/OS and OS/390 / Paolo Bruni ... [et al.].

Format:

Book

Author/Creator:

Bruni, Paolo., Author.

Series:

IBM redbooks.

Redbooks

Language:

English

Subjects (All):

Data structures (Computer science).

Object-oriented programming (Computer science).

Database management.

IBM Database 2.

Physical Description:

xx, 166 p. : ill.

Edition:

1st ed.

Place of Publication:

San Jose, CA : IBM, c2002.

Language Note:

English

Contents:

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.

Notes:

"This edition applies to Version 7 of IBM DATABASE 2 Universal Database Server for z/OS and OS/390 (DB2 UDB for z/OS and OS/390 Version 7), program number 5675-DB2."

"June 2002."

Includes bibliographical references and index.

OCLC:

61455161