DB15 - DB2 Programming with Large Objects - 1 Days

DateLocationDurationCostEnrolEnquiry
2022-07-13Virtual1 Day £600.00 (plus VAT)
Enquire

Course Description

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

DEFINING LARGE OBJECTS
Large Objects (LOBs)
LOB Definition
Base Table Definition
Altering A Table To Add LOB Data
Rowid Data Type
LOB Tablespace And Auxiliary Table Requirements
LOB Tablespace Considerations
LOB Tablespace Definition
Auxiliary Table Definition
Auxiliary Table - Index Definition
LOB Authorisations
Dropping LOB Tables
Hidden Rowid Generation

PROGRAMMING WITH LARGE OBJECTS
LOB Data Manipulation
Inserting Or Updating LOB Values
Declaring LOB Host Variables
Example Using LOB Variables
LOB Manipulation
Using LOB Locators
Declaring LOB Locator Host Variables
Holding Locators
Freeing Locators
Example Using LOB Locators
LOB Limitations
LOB Locator Considerations
LOB Locators and LOB Integrity
File Reference Variables
Defining File Reference Variables
File Reference Variables - Example
Loading Data using File Reference Variables
File Reference Variables - New DSNZPARM
Fetch Continue
Fetch Continue Example
Fetch Continue Considerations
Locking LOB Data
LOB Locking Summary
LOB Tablespace Logging
LOB Bufferpool Management

LARGE OBJECT UTILITY SUPPORT
Load Utility - LOB Data
Loading Rowids
Reorg Utility - LOB Data
Copy Utility - LOB Data
Recovering LOB Data to a Point-In-Time
LOB Recovery States
Procedure For Recovering Invalid LOBs
Recover Utility - LOB Data
The Check LOB Utility
Check LOB Considerations
Check Data Utility - Base Tablespace
Check Data Utility - Scope
Check Data Utility - Auxerror
Resetting Auxiliary Check Pending Status (ACHKP)
Resetting Auxiliary Warning Status (AUXW)

Course Enquiry