Information center home
Supported browsers for the information center
What's new in the information center
Subscribing to information center updates
Learn to use the information center
Navigating in the information center
Searching for information
Searching the information center
Searching for messages and codes
Searching from external sources
Searching knowledge bases for known problems
Setting bookmarks in the information center
Printing topics in the information center
Creating a PDF catalog
Accessibility and keyboard shortcuts
Displaying information in your preferred language
How to read syntax diagrams
Dotted decimal syntax diagrams
Installable information center
Submitting feedback about information
Notices
Links to non-IBM Web sites
Supported browsers for the information center
What's new in the information center
Subscribing to information center updates
Learn to use the information center
Navigating in the information center
Searching for information
Searching the information center
Searching for messages and codes
Searching from external sources
Searching knowledge bases for known problems
Setting bookmarks in the information center
Printing topics in the information center
Creating a PDF catalog
Accessibility and keyboard shortcuts
Displaying information in your preferred language
How to read syntax diagrams
Dotted decimal syntax diagrams
Installable information center
Submitting feedback about information
Notices
Links to non-IBM Web sites
DB2 10 for z/OS
DB2 overview
DB2 for z/OS PDF books for information center topics
Introduction to DB2 for z/OS
An overview of DB2 and Information Management
Scenarios for using DB2
Availability and scalability for large businesses
Critical business information for decision makers
Data distribution and Web access
The IBM Information Agenda
DB2 data servers and environments
Enterprise servers
DB2 Database distributed editions
DB2 on smaller-scale servers
Personal, mobile, and pervasive environments
Multiple transaction and application environments
DB2 and network communication
Clients supported by DB2 data servers
Sources of data
Information Management tools
Application development tools
Middleware components
IBM Data Studio
IBM Rational Portfolio Manager
DB2 Connect
WebSphere Application Server
WebSphere Studio
WebSphere Host Integration
Federated database support through WebSphere Information Integrator
Data replication through InfoSphere Replication Server
WebSphere DataStage
WebSphere QualityStage
Client application programming interfaces
Open standards
DB2 concepts
Structured query language
Static SQL
Dynamic SQL
Deferred embedded SQL
Interactive SQL
SQL Call Level Interface and Open Database Connectivity
Java database connectivity and embedded SQL for Java
DB2 data structures
DB2 tables
DB2 indexes
DB2 keys
DB2 views
DB2 schemas and schema qualifiers
DB2 storage groups
DB2 databases
Storage structures
DB2 table spaces
DB2 index spaces
DB2 hash spaces
DB2 system objects
DB2 catalog
DB2 directory
Active and archive logs
Bootstrap data set
Buffer pools
Data definition control support database
Resource limit facility database
Work file database
DB2 and data integrity
Constraints
Unique constraints
Referential constraints
Check constraints
Triggers
Application processes, concurrency, and recovery
Locking, commit, and rollback
Unit of work
Unit of recovery
Rolling back work
Packages and application plans
Routines
Functions
Stored procedures
Sequences
Support for high availability
Application processes and transactions
Distributed data
Remote servers
Connectivity in distributed environments
pureXML
DB2 for z/OS architecture
z/Architecture and the z/OS operating system
DB2 in the z/OS environment
DB2 internal resource lock manager
DB2 and the z/OS Security Server
DB2 and DFSMS
DB2 attachment facilities
CICS attachment facility
IMS attachment facility
TSO attachment facility
Call attachment facility
Resource Recovery Services attachment facility
Distributed data facility
DB2 in a Parallel Sysplex environment
DB2 objects and their relationships
Logical database design using entity-relationship modeling
Data modeling
Entities for different types of relationships
One-to-one relationships
One-to-many relationships
Many-to-many relationships
Application of business rules to relationships
Attributes for entities
Naming conventions for attributes
Data types for attributes
Values for key attributes
Normalization to avoid redundancy
First normal form
Second normal form
Third normal form
Fourth normal form
Logical database design with Unified Modeling Language
Physical database design
Database design with denormalization
Customized data views
Database design with indexes
Database design with hash access
SQL: The language of DB2
Ways to access data
Ways to select data from columns
How a SELECT statement works
SQL functions and expressions
Concatenation of strings
Calculation of values in one or more columns
Calculation of aggregate values
Scalar functions
Nested functions
User-defined functions
CASE expressions
Ways to filter the number of returned rows
Retrieving and excluding rows with null values
Equalities and inequalities
How to test for equality
How to test for inequalities
How to test for equality or inequality in a set of columns
How to test for a false condition
Similarities of character data
Multiple conditions
Ranges of values
Values in a list
Ways to order rows
Sort key
Ascending order
Descending order
Sort keys with multiple columns
Sort keys with expressions
Ways to summarize group values
Ways to merge lists of values
Ways to specify search conditions
Ways to join data from more than one table
Inner join
Left outer join
Right outer join
Full outer join
Subqueries
Ways to access DB2 data that is not in a table
Ways to modify data
Insert statements
Update statements
Merge statements
Delete statements
Truncate statements
Ways to execute SQL
Static SQL
Dynamic SQL
DB2 ODBC
DB2 access for Java: SQLJ, JDBC, pureQuery
Interactive SQL
Use of DB2 Query Management Facility for Workstation
DB2 sample tables
Activity table (DSN81010.ACT)
Department table (DSN81010.DEPT)
Employee table (DSN81010.EMP)
Employee photo and resume table (DSN81010.EMP_PHOTO_RESUME)
Project table (DSN81010.PROJ)
Project activity table (DSN81010.PROJACT)
Employee-to-project activity table (DSN81010.EMPPROJACT)
Unicode sample table (DSN81010.DEMO_UNICODE)
Relationships among the sample tables
Views on the sample tables
Storage of sample application tables
Storage group for sample application data
Databases for sample application data
Table spaces for sample application data
Application programming for DB2
Development of DB2 applications in integrated development environments
WebSphere Studio Application Developer
DB2 Development add-in for Visual Studio .NET
Workstation application development tools
IBM Mashup Center
Programming languages and methods for developing application programs
Preparation process for an application program
Static SQL applications
Declaration of table and view definitions
Data access with host variables
Data access with host variable arrays
Data access with host structures
Row retrieval with a cursor
Ways to check the execution of SQL statements
Dynamic SQL applications
Types of dynamic SQL
Dynamic SQL programming concepts
Use of ODBC to execute dynamic SQL
Use of Java to execute static and dynamic SQL
SQLJ support
JDBC support
Use of an application program as a stored procedure
Languages used to create stored procedures
Stored procedure processing
Use of the SQL procedural language to create a stored procedure
Use of development tools to create a stored procedure
Setup of the stored procedure environment
Preparation of a stored procedure
How applications can call stored procedures
Implementation of your database design
Creation of tables
Types of tables
Creation of base tables
Creation of temporary tables
Creation of materialized query tables
Creation of a table with table-controlled partitioning
Creation of temporal tables
Definition of columns in a table
Column names
Data types
String data types
Numeric data types
Date, time, and timestamp data types
XML data type
Large object data types
ROWID data type
Distinct types
Encoding schemes for string data
How DB2 compares data types
Null and default values
Null values
Default values
Comparison of null values and default values
Use of check constraints to enforce validity of column values
Use of check constraints to insert rows into tables
Use of check constraints to update tables
Row design
Record lengths and pages
Designs that waste space
Creation of table spaces
Types of DB2 table spaces
Universal table spaces
Partition-by-growth table spaces
Range-partitioned universal table spaces
Table spaces that are exclusively segmented
Table spaces that are exclusively partitioned
EA-enabled table spaces and index spaces
Large object table spaces
XML table spaces
Simple table spaces
How DB2 implicitly creates a table space
How DB2 implicitly creates an XML table space
Storage structure for XML data
Assignment of table spaces to physical storage
Creation of indexes
Types of indexes
How indexes can help to avoid sorts
Index keys
General index attributes
Unique indexes
Nonunique indexes
Clustering indexes
Indexes that are padded or not padded
Index on expression
Compression of indexes
XML index attributes
Partitioned table index attributes
Partitioning indexes
Secondary indexes
Data-partitioned secondary indexes
Nonpartitioned secondary indexes
Example of data-partitioned and nonpartitioned secondary indexes
Creation of views
A view on a single table
A view that combines information from several tables
Inserts and updates of data through views
Creation of large objects
Creation of databases
Creation of relationships with referential constraints
How DB2 enforces referential constraints
Insert rules
Update rules
Delete rules
Construction of a referential structure
Tables in a referential structure
Creation of exception tables
Creation of triggers
Creation of user-defined functions
DB2 performance management
Initial steps for performance management
Performance objectives
Application design for performance
Origin of performance problems
Tools for performance analysis
Ways to move data efficiently through the system
The role of buffer pools in caching data
The effect of data compression on performance
How data organization can affect performance
Use of free space in data and index storage
Guidelines for data reorganization
Ways to improve performance for multiple users
Improved performance through the use of locks
Improved performance through concurrency control
Ways to improve query performance
Tools that help you improve query performance
Query and application performance analysis
Using EXPLAIN to understand the access path
Hash access paths
Management of DB2 operations
Tools that help you manage DB2
IBM Data Studio
DB2 Administration Tool
DB2 Interactive
DB2 command line processor
Use of commands and utilities to control DB2 operations
DB2 commands
DB2 utilities
Management of data sets
Authorization and security mechanisms for data access
How authorization IDs control data access
How authorization IDs hold privileges and authorities
Ways to control access to DB2 subsystems
Local DB2 access
Remote DB2 access
Ways to control access to data
Ways to control access to DB2 objects through explicit privileges and authorities
Row-level and column-level access control
Use of multilevel security to control access
Use of views to control access
Use of grant and revoke privileges to control access
Backup, recovery, and restart
Backup and recovery resources and tools
DB2 restart
Regular backups and data checks
Control of database changes and data consistency
Commit and rollback of transactions
Coordinated updates for consistency between servers
Events in the recovery process
Optimization of availability during backup and recovery
DB2 and the web
Web application environment
Components of web-based applications
Architectural characteristics of web-based applications
Benefits of DB2 for z/OS as a server
Web-based applications and WebSphere Studio Application Developer
XML and DB2
Benefits of using XML with DB2 for z/OS
Ways to use XML with DB2 for z/OS
SOA, XML, and web services
Distributed data access
Ways to implement distributed data in programs
Explicit CONNECT statements
Three-part names
Aliases
Comparison of three-part names and aliases
Ways that other tasks are affected by distributed data
Effects of distributed data on planning
Effects of distributed data on programming
Effects of distributed data on program preparation
How updates are coordinated across distributed systems
DB2 transaction manager support
Servers that support two-phase commit
Servers that do not support two-phase commit
Ways to reduce network traffic
Improvements in query efficiency
Reduction in the volume of messages
Block fetch
Rowset fetches and inserts
Optimization for large and small result sets
Performance improvements for dynamic SQL
Data sharing with your DB2 data
Advantages of DB2 data sharing
Improved availability of data
Scalable growth
Flexible configurations
Protected investments in people and skills
How DB2 protects data consistency in a data sharing environment
How updates are made in a data sharing environment
How DB2 writes changed data to disk in a data sharing environment
Ways that other tasks are affected by data sharing
Ways that availability is affected by data sharing
Index for introduction to DB2 for z/OS
DB2 Licensed Program Specifications
Planning for DB2
What's New?
Introduction to Version 10
Performance
Improvements from migrating to Version 10
Reduced CPU usage
Improved optimization techniques
Safe query optimization
Improved index matching for OR and IN predicates
Parallelism enhancements
Early application of stage 2 predicates
Collection of autonomic statistics
Support for high performance database access threads
DDF optimization for OPEN, FETCH, and CLOSE requests
I/O parallelism for index updates
Improvements to index access
Buffer pool enhancements
Support for z/OS enqueue management
Reduction in need for explicit REORG
Universal table space enhancements
Streaming LOBs and XML
Performance enhancements for local Java and ODBC applications
Backup and recovery enhancements
Enhanced monitoring of statement-level statistics for static and dynamic SQL statements
Improvements from DBA-level changes
Optimization of inline LOBs
Improved fast access to individual rows
Additional non-key columns in a unique index
Support for the MEMBER CLUSTER option
Performance improvements for the LOAD utility
Improvements requiring application changes
Extended support for the SQL procedural language
Dynamic statement cache enhancements
Access to currently committed data
Improvements from scalability enhancements
Reductions in log latch contention
Scalability
Reduction in catalog contention
Elimination of UTSERIAL lock for DB2 utilities
Increased size limitation for SPT01
Utilization of 64-bit run time
Work file enhancements
Support for extended address volumes (EAV)
Support for deleting data sharing members
Availability
Online schema enhancements
Online REORG enhancements
Adding an active log data set to the active log inventory
Retrieving consistent data with improved concurrency
Point-in-time recovery enhancements
Increased availability for CHECK utilities
Support for rotating any logical partition
Online member-specific location aliases
Online communications database enhancements
Optional TCP/IP domain names
Security and regulatory compliance
Support for row and column access control
Administrative privileges with finer granularity
Support for new z/OS security features
Security improvements from managing application data based on time
Application integration
Enhanced monitoring support
Support for 64-bit ODBC driver
DRDA support of Unicode encoding for system code pages
Elimination of DDF private protocol
Addition of extended indicator variables
New Universal Language Interface module (DSNULI)
IBM Data Server Driver for JDBC and SQLJ type 2 connectivity enhancements
XML
Addition of XML type modifier
XML schema validation
XML consistency checking with CHECK DATA
Support for multiple versions of XML documents
Support for updating part of an XML document
Support for binary XML
Support for XML date and time
Support for XML in routines
Support for DEFINE(NO) for LOB and XML table spaces
Support for XQuery
SQL
Support for temporal tables and system-period data versioning
Enhanced support for SQL scalar functions
Support for SQL table functions
Enhanced support for native SQL procedures
Extended support for implicit casting
Greater timestamp precision for applications
Support for TIMESTAMP WITH TIME ZONE
Support for moving sums and moving averages
Migration
Migration path from Version 8
Improvements to DB2 installation and samples
Simplified installation and configuration of DB2-supplied routines
DB2 catalog restructured
Leveraging your enterprise for information on demand
Seamless integration of XML data and relational data
Tools that support your enterprise
Accessing your enterprise data on demand with DB2 QMF
Managing your enterprise with DB2 Tools
Query optimization with IBM Data Studio
Additional value for customers migrating from Version 8
Key innovations in Version 9
Availability in Version 9
Online REORG with no BUILD2 phase
Faster replacement of one table with another
Universal table spaces
Better availability during REBUILD INDEX operations
Improved availability with column and index renaming capabilities
Modify EARLY code without an IPL
ALTER TABLESPACE and index logging improvements
Support for using SMS storage classes with DB2-defined data sets
DB2 support for extended address volumes (EAV)
Performance in Version 9
Reduction in CPU processing time for utilities
SQL optimization improvements
Better data for DB2 optimization with histogram statistics
Improved optimization techniques
Indexing improvements
Improved performance for varying-length rows
Relief for sequential key insert
Improved logging performance
Improved data insert performance
Security and regulatory compliance in Version 9
Roles and network trusted contexts
Improved auditing
Support for Secure Socket Layer protocol
More security options with INSTEAD OF triggers
Support for AES encryption
Compatibility and leadership with SQL
SQL consistency improvements
SELECT FROM UPDATE or SELECT FROM DELETE function
INSTEAD OF triggers
BIGINT data type and function
BINARY data type and function
File reference variables
INTERSECT keyword in a fullselect
EXCEPT keyword in a subselect
Native support for SQL procedures
Nested compound statements in native SQL procedures
Expanded support for not logging table spaces
OLAP specifications for RANK, DENSE_RANK, and ROW_NUMBER
COLLATION_KEY function
Capability to create an index on an expression
Automatic creation of a database, a table space, and all system-required objects
IBM Spatial Support for DB2 for z/OS
Leverage existing application programming skills
Enhancements to large object support
SQL enhancements for large objects
Utilities enhancements for large objects
Performance enhancements for large objects
SQL leadership: family firsts
TRUNCATE TABLE statement
DECFLOAT built-in data type
VARBINARY data type
Enhancements to optimistic concurrency control and update detection
MERGE and SELECT FROM MERGE statements
Index for What's New?
Planning for DB2 10 for z/OS
Command changes in Version 10
New commands in Version 10
Changed commands in Version 10
Changes to utilities in Version 10
Utility option changes in Version 10
Other utility changes in Version 10
SQL statement changes in Version 10
New SQL statements in Version 10
Changed SQL statements in Version 10
New functions in Version 10
Reserved words
Catalog changes in Version 10
New catalog tables in Version 10
Changed catalog tables in Version 10
New and changed indexes in Version 10
Performance monitoring and tuning changes in Version 10
Performance changes in Version 10
EXPLAIN table changes in Version 10
Format of PLAN_TABLE in Version 10
New and changed EXPLAIN table columns in Version 10
New and changed IFCIDs in Version 10
New IFCIDs in Version 10
Changed IFCIDs in Version 10
Planning when migrating from Version 8
Command changes in Version 9
New commands in Version 9
Changes to commands in Version 9
Changes to utilities in Version 9
Utility changes in Version 9
Other utility changes in Version 9
SQL statement changes in Version 9
New SQL statements in Version 9
Changed SQL statements in Version 9
New functions in Version 9
Reserved words
Other SQL language changes in Version 9
Catalog changes in Version 9
New catalog tables in Version 9
Changed catalog tables in Version 9
New and changed indexes in Version 9
Performance monitoring and tuning changes in Version 9
Performance changes in Version 9
EXPLAIN table changes in Version 9
Format of PLAN_TABLE in Version 9
Format of DSN_STATEMNT_TABLE in Version 9
Format of DSN_FUNCTION_TABLE in Version 9
New statement cache table in Version 9
New and changed IFCIDs in Version 9
New IFCIDs in Version 9
Changed IFCIDs in Version 9
Installing and migrating DB2
Installation and migration
Introduction to installation and migration
Installation and migration tools
Introduction to installation
Summary of installation steps
Introduction to migration from DB2 Version 8
Migration modes for DB2 8 to DB2 10
Migration to conversion mode from V8: Summary
Falling back to V8: Summary
Remigration from V8: Summary
Migration to enabling-new-function mode from V8: Summary
Migration from enabling-new-function mode from V8 to new-function mode: Summary
Reversion to conversion mode* from V8: Summary
Reversion to enabling-new-function mode* from V8: Summary
Migration from conversion mode* from V8 to enabling-new-function mode from V8: Summary
Migration from conversion mode* from V8 to new-function mode: Summary
Migration from enabling-new-function mode* from V8 to new-function mode: Summary
Premigration checklist for migration to DB2 Version 10 conversion mode from Version 8
Checklist for migration to DB2 Version 10 conversion mode from Version 8
Introduction to migration from DB2 Version 9.1
Migration modes for DB2 9 to DB2 10
Migration to conversion mode from V9: Summary
Falling back to V9: Summary
Remigration from V8: Summary
Migration to enabling-new-function mode from V9: Summary
Migration from enabling-new-function mode from V9 to new-function mode: Summary
Reversion to conversion mode* from V9: Summary
Reversion to enabling-new-function mode* from V9: Summary
Migration from conversion mode* from V9 to enabling-new-function mode from V9: Summary
Migration from conversion mode* from V9 to new-function mode: Summary
Migration from enabling-new-function mode* from V9 to new-function mode: Summary
Premigration checklist for migration to DB2 Version 10 conversion mode from Version 9.1
Checklist for migration to DB2 Version 10 conversion mode from Version 9.1
Preparing your system to install or migrate DB2
Hardware and software requirements
Required maintenance
Planning storage for DB2
DB2 subsystem storage requirements
DB2 catalog storage requirements
DB2 directory storage requirements
Active log data sets storage requirements
Bootstrap data sets storage requirements
Work file database storage requirements
Temporary table space storage requirements
Calculating the size of the longest row in the declared temporary table
Default database storage requirements
Dump data set size storage requirements
System databases storage requirements
Archive log data sets storage requirements
Profile tables storage requirements
Installation CLIST storage calculation
Virtual storage requirements for address spaces
DB2 distributed data facility address space (DSN1DIST) storage requirements
IRLM address space (IRLMPROC) storage requirements
DB2 system services address space (DSN1MSTR) storage requirements
DB2 database services address space (DSN1DBM1) storage requirements
Allied agent address space storage requirements
Administrative task scheduler address space storage requirements
WLM-established stored procedures address spaces storage requirements
Shared memory storage requirements
Common service area storage requirements
Calculating the storage requirement for the common service area
Calculating the storage requirement for the extended common service area
Virtual storage requirements for storage pools and working storage
Calculating buffer pool size
Calculating sort pool size
Calculating sort pool storage in local storage
Adjusting sort pool storage in buffer pool storage
Calculating RID pool size
Calculating EDM pool size
Calculating EDM pool space for the prepared-statement cache
Calculating EDM pool space for the skeleton copies of packages
Calculating EDM pool space for database descriptors
Calculating data set control block storage
Calculating working storage requirements
Calculating virtual storage below the 16-MB line
Calculating real storage requirements
Planning for performance of DB2
Converting EXPLAIN tables (before migration)
Changes that might affect your migration from Version 8
Compatibility mode is now called conversion mode (from Version 8 or Version 9.1)
Availability of new functions in conversion mode from Version 8 and new-function mode
Application and SQL release incompatibilities for migration from Version 8
Utility release incompatibilities for migration from Version 8
Command release incompatibilities for migration from Version 8
Security release incompatibilities for migration from Version 8
Storage release incompatibilities for migration from Version 8
Other release incompatibilities for migration from Version 8
Functions that are deprecated for systems migrating from Version 8
Functions that are no longer supported for systems migrating from Version 8
Changes that might affect your migration from Version 9.1
Availability of new functions in conversion mode from Version 9.1 and new-function mode
Application and SQL release incompatibilities for migration from Version 9.1
Utility release incompatibilities for migration from Version 9.1
Command release incompatibilities for migration from Version 9.1
Security release incompatibilities for migration from Version 9.1
Other release incompatibilities for migration from Version 9.1
Functions that are deprecated for systems migrating from Version 9.1
Functions that are no longer supported for systems migrating from Version 9.1
Preparing for DB2 data sharing
DB2 data sharing in a Parallel Sysplex
Parallel Sysplex components and requirements
Cross-system coupling facility component of z/OS
Coupling facility structures
Defining coupling facility structures
Authorization for DB2 to access coupling facility structures
Sysplex timer
Common z/OS libraries
Connectivity requirements in a Parallel Sysplex
Data sharing naming conventions
Data sharing group names
Group attachment names and subgroup attachment names
Member names
IRLM names
Coupling facility structure names
Naming recommendations for a DB2 data sharing environment
Planning for availability in a data sharing environment
Automatic restart of z/OS
Advantage of automatic restart
Automatic restart policies
Creating an automatic restart policy
Coupling facility availability
Recommendations for placement of coupling facilities
Preparations for coupling facility failures
Duplexed group buffer pool structure failures
Simplexed group buffer pool structure failures
Automatic recovery requirements
Simplexed SCA and lock structure failures
Duplexed SCA and lock structure failures
Preparations for connectivity failures
Preparations for coupling facility channel failure
How structures are rebuilt when connectivity is lost
Specifying when structure rebuilds occur after connectivity is lost
Rebuild events
Coupling facility volatility
Duplexed structures
How group buffer pool duplexing works
Characteristics of primary and secondary structures
Coupling facility storage considerations for duplexing
Duplexing requirements
Options for duplexing
Performance implications of duplexing
Estimating the effect of duplexing on CPU usage
Duplexing rebuild status
DB2 resource availability considerations
Implications of distributed systems on data sharing
Storage estimates for data sharing environments
Coupling facility structure size allocation
Coupling facility structure sizer
Recommendations for coupling facility sizes
Group buffer pool sizes
Storage estimate for group buffer pools that cache changed data
Storage estimate for caching all data
Storage estimate for caching no data
Storage estimate for caching LOB space maps (GBPCACHE SYSTEM)
PR/SM formulas for calculating sizes of group buffer pools
Lock structure size
Lock entry size parameter
Storage estimate for the lock structure
SCA size
How to change structure sizes
Dynamic changes to structure sizes
Automatic changes to structure sizes
IRLM storage size
IRLM priority setting
IRLM storage use
Calculating storage for the coordinator and the assistants
Storage estimate for the EDM pool in a data sharing environment
Before you enable DB2 data sharing
Connecting CICS to DB2 (optional)
Connecting DB2 to IMS (optional)
Registering the command prefixes, member group attachment name, and subgroup attachment name
Increasing the size of the BSDS
Increasing the size of the SYSLGRNX table space
Database design recommendation
Application design planning
CACHE option of CREATE SEQUENCE statement
Applications using CICSPlex System Manager
Storm-drain effect
How a CICS exit routine can avoid the storm-drain effect
A CICS enhancement that avoids the storm-drain effect
Order-dependent transactions
Binds of plans and packages that move to a new machine
Release coexistence considerations
Release coexistence in a distributed environment
Release coexistence in a data sharing environment
IRLM service and release coexistence
Loading the DB2 libraries
Editing the SMP/E jobs
Creating JOB statements
Choosing link list options
Accessing the correct DB2 program library
Performance implications of installation libraries
Naming conventions for DB2 library names
Specifying SMP/E data set options
Sharing SMP/E data sets with IMS
SMP/E data sets for two releases
Specifying a new SMP/E prefix for IRLM
DB2 utilities packaging
SMP/E jobs for DB2 utility products
Operation of DB2 utilities in a mixed-release data sharing environment
What you produce
Tailoring DB2 jobs to your environment using the installation CLIST
Running the installation CLIST
Making the DB2 ISPF libraries available to TSO
Updating the CLIST defaults input member: job DSNTIJXZ
DSNTXAZP tool
Multiple procedure libraries
System affinity for installation jobs
Invoking the CLIST
General instructions for using the installation CLIST
Output from the panel session
Actions that are allowed on panels
Panel descriptions
Directory of panel field names
Directory of subsystem parameters and application default values
Subsystem parameters that are not on installation panels
Subsystem parameter module and application defaults module values
Main panel: DSNTIPA1
INSTALL TYPE field
DATA SHARING field (DSHARE subsystem parameter)
FROM RELEASE field
DATA SET(MEMBER) NAME field
LIBRARY NAME PREFIX field
LIBRARY NAME SUFFIX field
DATA SET NAME PREFIX field
DATA SET NAME SUFFIX field
INPUT MEMBER NAME field
OUTPUT MEMBER NAME field
OTC license usage panel: DSNTIPO1
Notice and acceptance of OTC license panel: DSNTIPO2
LICENSE TERMS ACCEPTED field (OTC_LICENSE subsystem parameter)
DB2 catalog and directory panel: DSNTIPA2
CATALOG ALIAS field (CATALOG subsystem parameter)
DEFINE CATALOG field
DIRECTORY AND CATALOG DATA field (CATDDACL, CATDMGCL, and CATDSTCL subsystem parameters)
DIRECTORY AND CATALOG INDEXES field (CATXDACL, CATXMGCL, and CATXSTCL subsystem parameters)
COMPRESS SPT01 field (COMPRESS_SPT01 subsystem parameter)
SPT01 INLINE LENGTH field (SPT01_INLINE_LENGTH subsystem parameter)
Data parameters panel: DSNTIPA3
PERMANENT UNIT NAME field
TEMPORARY UNIT NAME field
CLIST ALLOCATION field
NON-VSAM DATA field
VSAM CATALOG, DEFAULT AND WORK FILE DATABASE field
LOG COPY 1, BSDS 2 field
LOG COPY 2, BSDS 1 field
Define group or member panel: DSNTIPK
GROUP NAME field (GRPNAME subsystem parameter)
MEMBER NAME field (MEMBNAME subsystem parameter)
WORK FILE DB field
GROUP ATTACH field (SSID DECP value)
SUBGRP ATTACH field
COORDINATOR field (COORDNTR subsystem parameter)
ASSISTANT field (ASSIST subsystem parameter)
RANDOM ATTACH field (RANDOMATT subsystem parameter)
DEL CF STRUCTS field (DEL_CFSTRUCTS_ON_RESTART subsystem parameter)
System resource data set names panel: DSNTIPH
COPY 1 NAME field
COPY 2 NAME field
NUMBER OF COPIES field (TWOACTV subsystem parameter)
COPY 1 PREFIX field
COPY 2 PREFIX field
NUMBER OF COPIES field (TWOARCH subsystem parameter)
COPY 1 PREFIX field (ARCPFX1 subsystem parameter)
COPY 2 PREFIX field (ARCPFX2 subsystem parameter)
TIMESTAMP ARCHIVES field (TSTAMP subsystem parameter)
Data set names panel 1: DSNTIPT
TEMP CLIST LIBRARY field
SAMPLE LIBRARY field
CLIST LIBRARY field
APPLICATION DBRM field
APPLICATION LOAD field
DECLARATION LIBRARY field
LINK LIST LIBRARY field
LOAD LIBRARY field
MACRO LIBRARY field
LOAD DISTRIBUTION field
EXIT LIBRARY field
DBRM LIBRARY field
IRLM LOAD LIBRARY field
IVP DATA LIBRARY field
INCLUDE LIBRARY field
Data set names panel 2: DSNTIPU
IBM LE RUNTIME LIBRARY field
IBM LE LINK EDIT LIB field
IBM LE PRELINK MSG LIB field
HIGH LEVEL ASSEMBLER LIB field
C/CPP COMPILER MODULE field
C/CPP COMPILER LIBRARY field
C/CPP HEADER LIBRARY field
C/370 COMPILER MESSAGES field
CPP CLASS LIB HEADERS field
CPP AUTO CALL LIBRARY field
CPP CLASS LIBRARY field
CPP PROCEDURE LIBRARY field
COBOL COMPILER LIBRARY field
FORTRAN COMPILER LIBRARY field
FORTRAN LINK EDIT LIB field
PL/I COMPILER LIBRARY field
Data set names panel 3: DSNTIPW
SYSTEM MACLIB field
SYSTEM PROCEDURES field
SORT LIBRARY field
IMS RESLIB field
ISPF ISPLINK MODULE field
GDDM MACLIB field
GDDM LOAD MODULES field
CICS LOAD LIBRARY field
CICS MACRO LIBRARY field
CICS COBOL LIBRARY field
CICS PL/I LIBRARY field
CICS EXCI LIBRARY field
Sizes panel 1: DSNTIPD
DATABASES field for panel DSNTIPD
TABLES field
COLUMNS field
VIEWS field
TABLE SPACES field
PLANS field
PLAN STATEMENTS field
PACKAGES field
PACKAGE STATEMENTS field
PACKAGE LISTS field
EXECUTED STMTS field
TABLES IN STMT field
LOB INLINE LENGTH field (LOB_INLINE_LENGTH subsystem parameter)
USER LOB VALUE STG field (LOBVALA subsystem parameter)
SYSTEM LOB VAL STG field (LOBVALS subsystem parameter)
USER XML VALUE STG field (XMLVALA subsystem parameter)
SYSTEM XML VALUE STG field (XMLVALS subsystem parameter)
Sizes panel 2: DSNTIP7
DEFINE DATA SETS field (IMPDSDEF subsystem parameter)
USE DATA COMPRESSION field (IMPTSCMP subsystem parameter)
TABLE SPACE ALLOCATION field (TSQTY subsystem parameter)
INDEX SPACE ALLOCATION field (IXQTY subsystem parameter)
VARY DS CONTROL INTERVAL field (DSVCI subsystem parameter)
OPTIMIZE EXTENT SIZING field (MGEXTSZ subsystem parameter)
REORDERED ROW FORMAT field (RRF subsystem parameter)
DEFAULT PARTITION SEGSIZE field (DPSEGSZ subsystem parameter)
Work file database panel: DSNTIP9
4K SORT PRIMARY SPACE field
4K SORT WORK TS'S field
4K SORT WORK SEG SIZE field
32K SORT PRIMARY SPACE field
32K SORT WORK TS'S field
32K SORT WORK SEG SIZE field
4K TEMP PRIMARY SPACE field
4K TEMP WORK TS’S field
4K TEMP WORK SEG SIZE field
32K TEMP PRIMARY SPACE field
32K TEMP WORK TS’S field
32K TEMP WORK SEG SIZE field
MAX TEMP STG/AGENT field (MAXTEMPS subsystem parameter)
SEPARATE WORK FILES field (WFDBSEP subsystem parameter)
MAX TEMP RID field (MAXTEMPS_RID subsystem parameter)
Thread management panel: DSNTIPE
DATABASES field for panel DSNTIPE
MAX USERS field (CTHREAD subsystem parameter)
MAX REMOTE ACTIVE field (MAXDBAT subsystem parameter)
MAX REMOTE CONNECTED field (CONDBAT subsystem parameter)
MAX TSO CONNECT field (IDFORE subsystem parameter)
MAX BATCH CONNECT field (IDBACK subsystem parameter)
MAX KEPT DYN STMTS field (MAXKEEPD subsystem parameter)
CONTRACT THREAD STG field (CONTSTOR subsystem parameter)
MANAGE THREAD STORAGE field (MINSTOR subsystem parameter)
LONG-RUNNING READER field (LRDRTHLD subsystem parameter)
PAD INDEXES BY DEFAULT field (PADIX subsystem parameter)
MAX OPEN FILE REFS field (MAXOFILR subsystem parameter)
Buffer pool sizes panel 1: DSNTIP1
DEFAULT 4-KB BUFFER POOL FOR USER DATA field (TBSBPOOL subsystem parameter)
DEFAULT 8-KB BUFFER POOL FOR USER DATA field (TBSBP8K subsystem parameter)
DEFAULT 16-KB BUFFER POOL FOR USER DATA field (TBSBP16K subsystem parameter)
DEFAULT 32-KB BUFFER POOL FOR USER DATA field (TBSBP32K subsystem parameter)
DEFAULT BUFFER POOL FOR USER LOB DATA field (TBSBPLOB subsystem parameter)
DEFAULT BUFFER POOL FOR USER XML DATA field (TBSBPXML subsystem parameter)
DEFAULT BUFFER POOL FOR USER INDEXES field (IDXBPOOL subsystem parameter)
BUFFERPOOL fields BP0 - BP29
Buffer pool sizes panel 2: DSNTIP2
BUFFERPOOL fields BP30 - BP32K9
Tracing parameters panel: DSNTIPN
AUDIT TRACE field (AUDITST subsystem parameter)
TRACE AUTO START field (TRACSTR subsystem parameter)
TRACE SIZE field (TRACTBL subsystem parameter)
SMF ACCOUNTING field (SMFACCT subsystem parameter)
SMF STATISTICS field (SMFSTAT subsystem parameter)
STATISTICS TIME field (STATIME subsystem parameter)
STATISTICS SYNC field (SYNCVAL subsystem parameter)
DATASET STATS TIME field (DSSTIME subsystem parameter)
MONITOR TRACE field (MON subsystem parameter)
MONITOR SIZE field (MONSIZE subsystem parameter)
UNICODE IFCIDS field (UIFCIDS subsystem parameter)
DDF/RRSAF ACCUM field (ACCUMACC subsystem parameter)
AGGREGATION FIELDS field (ACCUMUID subsystem parameter)
COMPRESS SMF RECS field (SMFCOMP subsystem parameter)
Operator functions panel: DSNTIPO
WTO ROUTE CODES field (ROUTCDE subsystem parameter)
RECALL DATABASE field (RECALL subsystem parameter)
RECALL DELAY field (RECALLD subsystem parameter)
RLF AUTO START field (RLF subsystem parameter)
RLST NAME SUFFIX field (RLFTBL subsystem parameter)
RLST ACCESS ERROR field (RLFERR subsystem parameter)
AUTO BIND field (ABIND subsystem parameter)
EXPLAIN PROCESSING field (ABEXP subsystem parameter)
DPROP SUPPORT field (EDPROP and CHGDC subsystem parameters)
SITE TYPE field (SITETYP subsystem parameter)
TRACKER SITE field (TRKRSITE subsystem parameter)
READ COPY2 ARCHIVE field (ARC2FRST subsystem parameter)
REAL TIME STATS field (STATSINT subsystem parameter)
Default startup modules panel: DSNTIPO3
PARAMETER MODULE field
APPL DEFAULTS field
ACCESS CONTROL field (ACCESS_CNTL_MODULE subsystem parameter)
IDENTIFY/AUTH field (IDAUTH_MODULE subsystem parameter)
SIGNON field (SIGNON_MODULE subsystem parameter)
Application programming defaults panel 1: DSNTIPF
LANGUAGE DEFAULT field (DEFLANG DECP value)
DECIMAL POINT IS field (DECIMAL DECP value)
STRING DELIMITER field (DELIM DECP value)
SQL STRING DELIMITER field (SQLDELI DECP value)
DIST SQL STR DELIMTR field (DSQLDELI DECP value)
MIXED DATA field (MIXED DECP value)
EBCDIC CCSID field (SCCSID, MCCSID, and GCCSID DECP values)
ASCII CCSID field (ASCCSID, AMCCSID, AGCCSID DECP values)
UNICODE CCSID field (USCCSID, UMCCSID, and UGCCSID DECP values)
DEF ENCODING SCHEME field (ENSCHEME DECP value)
APPLICATION ENCODING field (APPENSCH DECP value)
LOCALE LC_CTYPE field (LC_TYPE DECP value)
DECFLOAT ROUNDING MODE field (DEF_DECFLOAT_ROUND_MODE DECP value)
Application programming defaults panel 2: DSNTIP4
MINIMUM DIVIDE SCALE field (DECDIV3 subsystem parameter)
DECIMAL ARITHMETIC field (DECARTH DECP value)
USE FOR DYNAMICRULES field (DYNRULS DECP value)
DESCRIBE FOR STATIC field (DESCSTAT subsystem parameter)
DATE FORMAT field (DATE DECP value)
TIME FORMAT field (TIME DECP value)
LOCAL DATE LENGTH field (DATELEN DECP value)
LOCAL TIME LENGTH field (TIMELEN DECP value)
IMPLICIT TIME ZONE field (IMPLICIT_TIMEZONE DECP value)
STD SQL LANGUAGE field (STDSQL DECP value)
PAD NUL-TERMINATED field (PADNTSTR DECP value)
Performance and optimization panel: DSNTIP8
CURRENT DEGREE field (CDSSRDEF subsystem parameter)
CACHE DYNAMIC SQL field (CACHEDYN subsystem parameter)
OPTIMIZATION HINTS field (OPTHINTS subsystem parameter)
MAX DEGREE field (PARAMDEG subsystem parameter)
PARALLELISM EFFICIENCY field (PARA_EFF subsystem parameter)
IMMEDIATE WRITE field (IMMEDWRI subsystem parameter)
EVALUATE UNCOMMITTED field (EVALUNC subsystem parameter)
SKIP UNCOMM INSERTS field (SKIPUNCI subsystem parameter)
CURRENT REFRESH AGE field (REFSHAGE subsystem parameter)
CURRENT MAINT TYPES field (MAINTYPE subsystem parameter)
STAR JOIN QUERIES field (STARJOIN subsystem parameter)
MAX DATA CACHING field (MXDTCACH subsystem parameter)
PLAN MANAGEMENT field (PLANMGMT subsystem parameter)
PLAN MANAGEMENT SCOPE field (PLANMGMTSCOPE subsystem parameter)
RANDOMIZE XML DOCID field (XML_RANDOMIZE_DOCID subsystem parameter)
IRLM panel 1: DSNTIPI
INSTALL IRLM field
SUBSYSTEM NAME field (IRLMSID subsystem parameter)
RESOURCE TIMEOUT field (IRLMRWT subsystem parameter)
AUTO START field (IRLMAUT subsystem parameter)
PROC NAME field (IRLMPRC subsystem parameter)
TIME TO AUTOSTART field (IRLMSWT subsystem parameter)
U LOCK FOR RR/RS field (RRULOCK subsystem parameter)
X LOCK FOR SEARCHED U/D field (XLKUPDLT subsystem parameter)
START IRLM CTRACE field
IMS BMP TIMEOUT field (BMPTOUT subsystem parameter)
DL/I BATCH TIMEOUT field (DLITOUT subsystem parameter)
RETAINED LOCK TIMEOUT field (RETLWAIT subsystem parameter)
IRLM panel 2: DSNTIPJ
PAGE PROTECT field
MAX STORAGE FOR LOCKS field
LOCKS PER TABLE(SPACE) field (NUMLKTS subsystem parameter)
LOCKS PER USER field (NUMLKUS subsystem parameter)
DEADLOCK TIME field
DEADLOCK CYCLE field
MEMBER IDENTIFIER field
IRLM XCF GROUP NAME field
LOCK ENTRY SIZE field
NUMBER OF LOCK ENTRIES field
DISCONNECT IRLM field
DB2 utilities parameters panel 1: DSNTIP6
SYSTEM-LEVEL BACKUPS field (SYSTEM_LEVEL_BACKUPS subsystem parameter)
RESTORE/RECOVER field (RESTORE_ RECOVER_FROMDUMP subsystem parameter)
DUMP CLASS NAME field (UTILS_DUMP_CLASS_NAME subsystem parameter)
MAXIMUM TAPE UNITS field (RESTORE_TAPEUNITS subsystem parameter)
FAST REPLICATION field (CHECK_FASTREPLICATION subsystem parameter)
FAST RESTORE field (REC_FASTREPLICATION subsystem parameter)
FLASHCOPY PPRC field (FLASHCOPY_PPRC subsystem parameter)
DEFAULT TEMPLATE field (FCCOPYDDN subsystem parameter)
COPY field (FLASHCOPY_COPY subsystem parameter)
LOAD field (FLASHCOPY_LOAD subsystem parameter)
REORG TABLESPACE field (FLASHCOPY_REORG_TS subsystem parameter)
REBUILD INDEX field (FLASHCOPY_REBUILD_INDEX subsystem parameter)
REORG INDEX field (FLASHCOPY_REORG_INDEX subsystem parameter)
DB2 utilities parameters panel 2: DSNTIP61
TEMP DS UNIT NAME field (VOLTDEVT subsystem parameter)
UTIL TEMP STORCLAS field (UTIL_TEMP_STORCLAS subsystem parameter)
STATISTICS HISTORY field (STATHIST subsystem parameter)
STATISTICS ROLLUP field (STATROLL subsystem parameter)
UTILITY TIMEOUT field (UTIMOUT subsystem parameter)
UT SORT DATA SET ALLOCATION field (UTSORTAL subsystem parameter)
IGNORE SORTNUM STAT field (IGNSORTN subsystem parameter)
SET CHECK PENDING field (CHECK_SETCHKP subsystem parameter)
UT DB2 SORT USE field (DB2SORT subsystem parameter)
Protection panel: DSNTIPP
ARCHIVE LOG RACF field (PROTECT subsystem parameter)
USE PROTECTION field (AUTH subsystem parameter)
PLAN AUTH CACHE field (AUTHCACH subsystem parameter)
PACKAGE AUTH CACHE field (CACHEPAC subsystem parameter)
ROUTINE AUTH CACHE field (CACHERAC subsystem parameter)
AUTH EXIT LIMIT field (AEXITLIM subsystem parameter)
Protection panel 2: DSNTIPP1
SYSTEM ADMIN 1 field (SYSADM subsystem parameter)
SYSTEM ADMIN 2 field (SYSADM2 subsystem parameter)
SYSTEM OPERATOR 1 field (SYSOPR1 subsystem parameter)
SYSTEM OPERATOR 2 field (SYSOPR2 subsystem parameter)
SECURITY ADMIN 1 field (SECADM1 subsystem parameter)
SEC ADMIN 1 TYPE field (SECADM1_TYPE subsystem parameter)
SECURITY ADMIN 2 field (SECADM2 subsystem parameter)
SEC ADMIN 2 TYPE field (SECADM2_TYPE subsystem parameter)
SEPARATE SECURITY field (SEPARATE_SECURITY subsystem parameter)
UNKNOWN AUTHID field (DEFLTID subsystem parameter)
RESOURCE AUTHID field (RLFAUTH subsystem parameter)
BIND NEW PACKAGE field (BINDNV subsystem parameter)
DBADM CREATE AUTH field (DBACRVW subsystem parameter)
REVOKE DEP PRIV field (REVOKE_DEP_PRIVILEGES subsystem parameter)
ROUTINES CREATOR field
SEC DEF CREATOR field
MVS PARMLIB updates panel: DSNTIPM
SUBSYSTEM NAME field (SSID DECP value)
COMMAND PREFIX field
SUBSYSTEM MEMBER field
SUBSYSTEM SEQUENCE field
AUTH MEMBER field
AUTH SEQUENCE field
LINK LIST ENTRY field
LINK LIST SEQUENCE field
COMMAND SCOPE field
SUPPRESS SOFT ERRORS field (SUPERRS subsystem parameter)
Active log data set parameters: DSNTIPL
NUMBER OF LOGS field
OUTPUT BUFFER field (OUTBUFF subsystem parameter)
ARCHIVE LOG FREQ field
UPDATE RATE field
Checkpoint parameters: DSNTIPL1
CHECKPOINT TYPE field (CHKTYPE subsystem parameter)
RECORDS/CHECKPOINT field (CHKFREQ and CHKLOGR subsystem parameters)
MINUTES/CHECKPOINT field (CHKFREQ and CHKMINS subsystem parameters)
UR CHECK FREQ field (URCHKTH subsystem parameter)
UR LOG WRITE CHECK field (URLGWTH subsystem parameter)
LIMIT BACKOUT field (LBACKOUT subsystem parameter)
BACKOUT DURATION field (BACKODUR subsystem parameter)
RO SWITCH CHKPTS field (PCLOSEN subsystem parameter)
RO SWITCH TIME field (PCLOSET subsystem parameter)
LEVELID UPDATE FREQ field (DLDFREQ subsystem parameter)
Archive log data set parameters panel: DSNTIPA
ALLOCATION UNITS field (ALCUNIT subsystem parameter)
PRIMARY QUANTITY field (PRIQTY subsystem parameter)
SECONDARY QTY field (SECQTY subsystem parameter)
CATALOG DATA field (CATALOG subsystem parameter)
DEVICE TYPE 1 field (UNIT subsystem parameter)
DEVICE TYPE 2 field (UNIT2 subsystem parameter)
BLOCK SIZE field (BLKSIZE subsystem parameter)
READ TAPE UNITS field (MAXRTU subsystem parameter)
DEALLOC PERIOD field (DEALLCT subsystem parameter)
RECORDING MAX field (MAXARCH subsystem parameter)
WRITE TO OPER field (ARCWTOR subsystem parameter)
WTOR ROUTE CODE field (ARCWRTC subsystem parameter)
RETENTION PERIOD field (ARCRETN subsystem parameter)
QUIESCE PERIOD field (QUIESCE subsystem parameter)
COMPACT DATA field (COMPACT subsystem parameter)
SINGLE VOLUME field (SVOLARC subsystem parameter)
Databases and spaces to start automatically panel: DSNTIPS
RESTART OR DEFER field (RESTART subsystem parameter)
START NAMES field (ALL subsystem parameter)
Distributed data facility panel 1: DSNTIPR
DDF STARTUP OPTION field (DDF subsystem parameter)
DB2 LOCATION NAME field
DB2 NETWORK LUNAME field
DB2 NETWORK PASSWORD field
RLST ACCESS ERROR field (RLFERRD subsystem parameter)
RESYNC INTERVAL field (RESYNC subsystem parameter)
DDF THREADS field (CMTSTAT subsystem parameter)
MAX INACTIVE DBATS field (MAXTYPE1 subsystem parameter)
DB2 GENERIC LUNAME field
IDLE THREAD TIMEOUT field (IDTHTOIN subsystem parameter)
EXTENDED SECURITY field (EXTSEC subsystem parameter)
Distributed data facility panel 2: DSNTIP5
DRDA PORT field
SECURE PORT field
RESYNC PORT field
TCP/IP ALREADY VERIFIED field (TCPALVER subsystem parameter)
EXTRA BLOCKS REQ field (EXTRAREQ subsystem parameter)
EXTRA BLOCKS SRV field (EXTRASRV subsystem parameter)
TCP/IP KEEPALIVE field (TCPKPALV subsystem parameter)
POOL THREAD TIMEOUT field (POOLINAC subsystem parameter)
Routine parameters panel: DSNTIPX
WLM PROC NAME field
NUMBER OF TCBS field
MAX ABEND COUNT field (STORMXAB subsystem parameter)
TIMEOUT VALUE field (STORTIME subsystem parameter)
WLM ENVIRONMENT field (WLMENV subsystem parameter)
MAX OPEN CURSORS field (MAX_NUM_CUR subsystem parameter)
MAX STORED PROCS field (MAX_ST_PROC subsystem parameter)
MAXIMUM LE TOKENS field (LEMAX subsystem parameter)
BIF COMPATIBILITY field (BIF_COMPATIBILITY subsystem parameter)
ADMIN SCHEDULER field (ADMTPROC subsystem parameter)
Parameters for DB2-supplied routines panel: DSNTIPR1
FOR MOST DB2 ROUTINES field
FOR ROUTINES IDENTIFIED TO PROGRAM CONTROL field
FOR SERIALIZED ROUTINES field
FOR DB2 UTILITIES ROUTINES field
FOR DB2 XML PROCESSING ROUTINES field
FOR MOST DB2 JAVA ROUTINES field
FOR DB2 REXX ROUTINES field
FOR UNIFIED DEBUGGER ROUTINES field
FOR THE DB2 CICS ROUTINE field
FOR DB2 MQSERIES ROUTINES field
FOR DB2 WEB SERVICES ROUTINES field
ADVANCED CONFIGURATION OPTIONS field
DB2 routine selection panel: DSNTIPRA
Trace formatting routines panel: DSNTIPRB
Utility invocation routines panel: DSNTIPRC
Runtime statistics processing routines panel: DSNTIPRD
DB2 security routines panel: DSNTIPRE
Java and SQL procedure processing routines panel: DSNTIPRF
Unified debugger for Java and SQL routines panel: DSNTIPRH
XML schema processing routines panel: DSNTIPRI
IBM Text Search routines panel: DSNTIPRJ
Database metadata routines panel: DSNTIPRK
DB2 administration routines panel: DSNTIPRL
DB2 optimization routines panel: DSNTIPRM
CICS and IMS transaction invocation routines panel: DSNTIPRN
MQSeries routines panel: DSNTIPRO
Web services/SOAP routines panel: DSNTIPRP
Data definition control support panel: DSNTIPZ
INSTALL DD CONTROL SUPT field (RGFINSTL subsystem parameter)
CONTROL ALL APPLICATIONS field (RGFDEDPL subsystem parameter)
REQUIRE FULL NAMES field (RGFFULLQ subsystem parameter)
UNREGISTERED DDL DEFAULT field (RGFDEFLT subsystem parameter)
ART/ORT ESCAPE CHARACTER field (RGFESCP subsystem parameter)
REGISTRATION OWNER field (RGFCOLID subsystem parameter)
REGISTRATION DATABASE field (RGFDBNAM subsystem parameter)
APPL REGISTRATION TABLE field (RGFNMPRT subsystem parameter)
OBJT REGISTRATION TABLE field (RGFNMORT subsystem parameter)
Job editing panel: DSNTIPY
REMOTE LOCATION field
Job card information field
CLIST calculations panel 1: DSNTIPC
DSMAX field (DSMAX subsystem parameter)
EDM STATEMENT CACHE field (EDMSTMTC subsystem parameter)
EDM DBD CACHE field (EDMDBDC subsystem parameter)
EDM SKELETON POOL SIZE field (EDM_SKELETON_POOL subsystem parameter)
EDM LIMIT BELOW THE BAR (EDMPOOL subsystem parameter)
BUFFER POOL SIZE field
SORT POOL SIZE field (SRTPOOL subsystem parameter)
RID POOL SIZE field (MAXRBLK subsystem parameter)
CLIST messages fields for panel DSNTIPC
Storage messages fields
CLIST calculations panel 2: DSNTIPC1
CLIST messages fields for panel DSNTIPC1
Completing the CLIST processing
CLIST messages
Installation jobs that the CLIST tailors
Tailoring the installation jobs
Job DSNTIJUZ and the subsystem parameter load module, application defaults load module, and DSNHMCID
The update process
Updating parameters through the Update selection menu panel: DSNTIPB
Update selection menu panel: DSNTIPB
Panels to update field
Updating other parameters
Installing or migrating DB2
Installing DB2
Installation step 1: Define the SMS environment for DB2 catalog and directory data sets: DSNTIJSS
Installation step 2: Define DB2 to z/OS: DSNTIJMV
DSNTIJMV updates to SYS1.PARMLIB
DSNTIJMV updates to SYS1.PROCLIB
Language Environment options data sets for the DB2 core Java WLM environment
Installation step 3: Define the ICF catalog and alias: DSNTIJCA (optional)
Installation step 4: Define system data sets: DSNTIJIN
Job DSNTIJIN
Job DSNTIJDE
Installation step 5: Define DB2 initialization parameters: DSNTIJUZ
Installation step 6: Initialize system data sets: DSNTIJID, DSNTIJIE, and DSNTIJIF
Installation step 7: Define user authorization exit routines: DSNTIJEX (optional)
Installation step 8: Record DB2 data to SMF (optional)
Installation step 9: Establish subsystem security (optional)
Installation step 10: Connect DB2 to TSO
Make DB2 load modules available to TSO and batch users
Make DB2 CLISTs available to TSO and batch users (DSNTIJVC)
Ensure that PL/I options are available
Make DB2I panels, messages, and load modules available to ISPF and TSO
Connect DB2I panels to the ISPF main panel
Installation step 11: Connect DB2 to IMS (optional)
Installation step 12: Connect CICS to DB2 (optional)
Installation step 13: Define DB2 to z/OS
Installation step 14: Start the DB2 subsystem
Installation step 15: Tailor the DB2 catalog: DSNTIJTC
Installation step 16: Create default storage group, define temporary work files, and bind DB2 REXX Language Support: DSNTIJTM
Installation step 17: Define and bind DB2 objects: DSNTIJSG
Job DSNTIJSG
Installation step 18: Populate the user-maintained databases (optional)
Installation step 19: Configure DB2 for running stored procedures and user-defined functions
Tailoring DB2 subsystem parameters for stored procedures during installation (optional)
Setting up Language Environment for stored procedures during installation
Implementing RRS for stored procedures during installation
Setting up a WLM application environment for stored procedures during installation
Installation step 20: Set up DB2-supplied routines
Setting up the DB2 core WLM environments during installation
Installing DB2-supplied routines during installation
Job DSNTIJRT
Job DSNTIJRV
Installation step 21: Back up the DB2 directory and catalog: DSNTIJIC
Installation step 22: Set up the administrative task scheduler
Installation step 23: Verify a successful installation
Installation step 24: Enable additional capabilities for DB2
Support for a communications network
Support for Java
Installing a second DB2 subsystem on the same operating system
Implications of a second DB2 subsystem
Loading DB2 libraries for a second DB2 subsystem
Tailoring installation jobs for a second DB2 subsystem
Installing a second DB2 subsystem
Connecting the TSO attachment facility to a second DB2 subsystem
Connecting the IMS attachment facility to a second DB2 subsystem
Preparing a second DB2 subsystem for use
Verifying your installation process for a second DB2 subsystem
Enabling multiple DB2 subsystems to share disk storage
Data loading from remote locations
Special packages and plans for SPUFI
Running SPUFI at remote systems
Making SPUFI work with different terminal CCSIDs
Migrating DB2
Migrating your DB2 subsystem to conversion mode (from Version 8 or Version 9.1)
Migration step 1: Actions to complete before migration
Run premigration queries (DSNTIJPM)
Make adjustments for release incompatibilities
Define the SMS environment for the DB2 catalog and directory data sets (DSNTIJSS)
Save critical access paths
Examine all new and changed values for DB2I panels
Ensure that sample objects from your previous release are available
Make a backup copy of the BSDS for migration from Version 8
Change stored procedures that specify DSNWZPR as the external module name for migration from Version 8
Ensure that no utility jobs are running
Migration step 2: Run the link checker on your DB2 table spaces (optional)
Migration step 3: Determine which packages are invalid after migration (optional)
Migration step 4: Check for consistency between catalog tables (optional)
Migration step 5: Take image copies of the directory and catalog: DSNTIJIC
Migration step 6: Connect DB2 to TSO
Make DB2 load modules available to TSO and batch users
Make DB2 CLISTs available to TSO and batch users: DSNTIJVC
Make DB2I panels, messages, and load modules available to ISPF and TSO
Migration step 7: Connect DB2 to IMS (optional)
Migration step 8: Connect CICS to DB2 (optional)
Migration step 9: Stop DB2 Version 8 or Version 9.1 activity
Migration step 10: Back up your DB2 Version 8 or Version 9.1 volumes (optional)
Migration step 11: Define DB2 initialization parameters: DSNTIJUZ
DSNTIJUZ actions
Add a second BSDS
Migration step 12: Establish subsystem security (optional)
Migration step 13: Define DB2 Version 10 to z/OS: DSNTIJMV
DSNTIJMV actions
Migration step 14: Define system data sets: DSNTIJIN
Migration step 15: Define user authorization exit routines: DSNTIJEX (optional)
Migration step 16: IPL z/OS
Migration step 17: Start DB2 Version 10
Migration step 18: Tailor DB2 Version 10 catalog: DSNTIJTC
Migration step 19: Ensure that the catalog has no problems (optional)
Migration step 20: Rebuild indexes: DSNTIJRI (optional)
Migration step 21: Enable change data capture
Migration step 22: Prepare dynamic SQL program: DSNTIJTM
Migration step 23: Bind SPUFI and DCLGEN and user-maintained database activity: DSNTIJSG
Migration step 24: Convert EXPLAIN tables to the current format and encoding type
Migration step 25: Configure DB2 for running stored procedures and user-defined functions
Tailoring DB2 subsystem parameters for stored procedures during migration (optional)
Setting up Language Environment for stored procedures during migration
Implementing RRS for stored procedures during migration
Setting up a WLM application environment for stored procedures during migration
Migration step 26: Set up DB2-supplied routines
Setting up the DB2 core WLM environments during migration
Installing DB2-supplied routines during migration
Job DSNTIJRT
Job DSNTIJRV
Migration step 27: Verify views
Migration step 28: Take an image copy of the DB2 Version 10 conversion mode (from Version 8 or Version 9.1) catalog: DSNTIJIC
Migration step 29: Set up the administrative task scheduler
Migration step 30: Verify your DB2 Version 10 conversion mode (from Version 8 or Version 9.1) system (optional)
Migration step 31: Collect improved statistics (optional)
Falling back
Implications of falling back
Fallback procedure
Fallback step 1: Stop DB2 Version 10 activity
Fallback step 2: Reactivate DB2 Version 8 or Version 9.1 code: DSNTIJFV
Fallback step 3: Reconnect TSO, IMS, and CICS to DB2 Version 8 or Version 9.1
Fallback step 4: Start DB2 Version 8 or Version 9.1
Fallback step 5: Modify your DSNTIJIC job
Fallback step 6: Verify fallback
Fallback step 7: Update your Version 9.1 WLM environment for XSR_COMPLETE
Remigrating
Migrating your DB2 subsystem to new-function mode
Implications of migrating to Version 10 new-function mode
Migrating from conversion mode (from Version 8 or Version 9.1) to enabling-new-function mode (from Version 8 or Version 9.1)
Completing enabling-new-function mode (from Version 8 or Version 9.1) processing
Job DSNTIJEN
Job DSNTIJCI
Migrating from enabling-new-function mode (from Version 8 or Version 9.1) to new-function mode
Job DSNTIJNF
Job DSNTIJNG
Converting EXPLAIN tables for migration from Version 8
Reverting to conversion mode* (from Version 8 or Version 9.1) or enabling-new-function mode* (from Version 8 or Version 9.1)
Reverting to conversion mode* (from Version 8 or Version 9.1)
Reverting to enabling-new-function mode* (from Version 8 or Version 9.1)
Returning to enabling-new-function mode (from Version 8 or Version 9.1) or new-function mode
Moving from conversion mode* (from Version 8 or Version 9.1) to enabling-new-function mode (from Version 8 or Version 9.1)
Moving from conversion mode* (from Version 8 or Version 9.1) to new-function mode
Migrating from enabling-new-function mode* (from Version 8 or Version 9.1) to new-function mode
Installing, migrating, and enabling DB2 data sharing
Strategy for creating a data sharing group
Subsystem parameters and application defaults in a data sharing environment
Specifying a member's subsystem parameter load module
The scope and uniqueness of DB2 subsystem parameters
Updating subsystem parameters for a member
Application defaults parameters
Installing a new data sharing group
Enabling DB2 data sharing
Running the CLIST for enabling data sharing
Stopping DB2 activity
Identifying DB2 to z/OS
Altering the current active log data sets
Defining DB2 initialization parameters
Recording DB2 data to SMF (optional)
Connecting DB2 to TSO
Defining DB2 to z/OS
Starting the DB2 subsystem
Creating the default storage group, defining temporary work files, and binding DB2 REXX Language Support
Creating an image copy of the DB2 directory and catalog (optional)
Verifying that enabling data sharing was successful (optional)
Adding a new member
Running the CLIST for adding a new member
Identifying DB2 to z/OS
Defining system data sets
Defining DB2 initialization parameters
Initializing system data sets
Defining user authorization exit routines (optional)
Recording DB2 data to SMF (optional)
Establishing subsystem security (optional)
Connecting DB2 to IMS (optional)
Connecting CICS to DB2 (optional)
Defining DB2 to z/OS
Starting the DB2 subsystem
Creating the default storage group, defining temporary work files, and binding DB2 REXX Language Support
Creating an image copy of the DB2 directory and catalog
Verifying that adding a data sharing member was successful
Merging existing DB2 data into the group
Merging subsystems
Merging data
Existing distributed applications
Moving data that you are merging
Running REPAIR to modify OBID for a compression dictionary
Migrating an existing data sharing group to a new release
Migrating the first member of a group to Version 10
Migrating subsequent members of a group to Version 10
Running the CLIST for migrating data sharing members
Connecting DB2 to TSO
Connecting DB2 to IMS (optional)
Connecting CICS to DB2 (optional)
Stopping DB2 activity
Defining DB2 initialization parameters
Establishing subsystem security (optional)
Defining DB2 Version 10 to z/OS
IPL z/OS
Starting DB2 Version 10
Verifying your DB2 Version 10 conversion mode (from Version 8 or Version 9.1) system (optional)
Migrating a data sharing group to new-function mode
Mixed releases in a data sharing group
Special considerations for WLM-managed stored procedures in coexistence
Determining the release of a data sharing group in coexistence
Determining the function level of an IRLM group in coexistence
Call attachment and TSO attachment in coexistence
Automatic rebinds in coexistence
Disallowing all automatic rebinds
Disallowing the automatic remigration rebind
Recommendations for BIND in coexistence
Recommendations for utilities in coexistence
Load module names for running purchased utilities in coexistence
Recommendation for group restart in coexistence
Recommendation for SPUFI in coexistence
Testing the data sharing group
Testing group buffer pool caching
Testing global lock serialization
Testing concurrency
Testing Sysplex query parallelism
Falling back and remigrating in a data sharing environment
Falling back in a data sharing environment
Remigrating in a data sharing environment
Disabling and re-enabling DB2 data sharing
Disabling data sharing
Data recovery after disabling DB2 data sharing
Re-enabling DB2 data sharing
Renaming a member by performing an IPL
Renaming a member by stopping DB2
Verifying that installation or migration was successful with the sample applications
Installation verification phases and programs
Planning for verification
COBOL options to use with the installation verification procedures
C and C++ language options to use with the installation verification procedures
PL/I options to use with the installation verification procedures
Phase 0: Deleting the sample objects (DSNTEJ0)
Phase 1: Creating and loading sample tables
Job DSNTEJ1
Job DSNTEJ1L
Job DSNTEJ1P
Job DSNTEJ1U
Phase 2: Testing the batch environment
Job DSNTEJ2A
Job DSNTEJ2C
Job DSNTEJ2D
Job DSNTEJ2E
Job DSNTEJ2F
Job DSNTEJ2H
Job DSNTEJ2P
Job DSNTEJ2U
Phase 3: Testing SPUFI, DRDA access, dynamic SQL, and TSO
Testing SPUFI
Dynamic SQL and the ISPF/CAF application
Jobs DSNTEJ3C and DSNTEJ3P
Job DSNTEJ3M
Starting an application in an ISPF/TSO environment
Phase 4: Testing the IMS environment
Jobs DSNTEJ4C and DSNTEJ4P
Starting an application in an IMS environment
Using the phone application in IMS
Phase 5: Testing the CICS environment
Job DSNTEJ5A
Jobs DSNTEJ5C and DSNTEJ5P
Starting an application in a CICS environment
Using the phone application in CICS
Using CICS storage-handling facilities
Phase 6: Accessing data at a remote site
DRDA access sample
Job DSNTEJ6
Starting an application in an ISPF/TSO environment in phase 6
Stored procedure samples
Stored procedure sample without result set
Job DSNTEJ6S
Job DSNTEJ6P
Stored procedure sample with result set
Job DSNTEJ6T
Job DSNTEJ6D
Sample callers of utilities stored procedures
Job DSNTEJ6U
Job DSNTEJ6R
Job DSNTEJ6V
Job DSNTEJ6W
Job DSNTEJ6Z
Sample ODBA stored procedure
Job DSNTEJ61
Job DSNTEJ62
Sample SQL procedures
Job DSNTEJ63
Job DSNTEJ64
Job DSNTEJ65
Job DSNTEJ66
Phase 7: Accessing LOB data
Job DSNTEJ7
Job DSNTEJ71 (optional)
Job DSNTEJ73
Job DSNTEJ75
Job DSNTEJ76
Job DSNTEJ77
Job DSNTEJ78
Starting an application in an ISPF/TSO environment in phase 7
The sample applications
Printing options for the sample application listings
The sample application panels
Allowable combinations of values on the sample application panels
DATA field values on the sample application panels
Function keys on the sample application panels
Working with scenarios
Working with the project application scenario
Updating an activity
Working with the organization application scenario
Starting a new operation
Adding a new department
Deleting an entry
Transferring an employee
Working with the phone application scenario
Viewing or changing an employee's telephone number
Using the phone application under batch
Working with the distributed organization application scenario
Displaying department structure at the local location
Displaying department information at the local location
Updating a department at the local location
Adding an employee at a remote location
Erasing an employee at a remote location
Working with the employee resume and photo scenarios
Using the resume application in the LOB application scenario
Using the photo application in the LOB application scenario
Sample LOB table: EMP_PHOTO_RESUME
Edit exit routine
Huffman compression exit routine
Sample field procedure
Dynamic SQL statements: DSNTESA, DSNTESQ
DSNTESA
DSNTESQ
Dynamic SQL programs: DSNTIAD, DSNTEP2, DSNTIAUL
Working with additional capabilities for DB2
DB2-supplied stored procedures and user-defined functions
WLM management of stored procedures
Core WLM environments for DB2-supplied routines
DSNTWLMB tool
Sample SQL statements for installing DB2-supplied routines
Configuration control statements for DB2-supplied routines
Disabling DB2-supplied routines for validation
Setting up support for external SQL procedures
Additional steps for enabling the stored procedures and objects for XML schema support
Additional steps for enabling the administrative task scheduler and administrative enablement routines
Additional steps for enabling the CICS transaction invocation procedure
Additional steps for enabling the DSNAEXP EXPLAIN stored procedure
Additional steps for enabling the common SQL API stored procedures
Additional steps for enabling WebSphere MQ user-defined functions
Moving from previous versions of the WebSphere MQ user-defined functions
Converting from the AMI-based MQ functions to the MQI-based MQ functions
Starting the queue manager
Customizing WLM application environments for running WebSphere MQ user-defined function support
Verifying the DB2 and WebSphere MQ setup
Enabling DB2 web services
Additional steps for enabling web service user-defined functions
Supported web service calls
Enabling the web service user-defined function support for HTTPS
Enabling DB2 as a web service provider
Enabling DB2 as a web service consumer
The IBM Data Server Driver for JDBC and SQLJ
Connecting the IMS attachment facility
Making DB2 load modules available to IMS
Defining DB2 to IMS
Defining new programs and transactions to IMS
Defining DB2 plans for IMS applications (optional)
IMS language interface module
IMS attachment facility macro (DSNMAPN)
Connecting distributed database systems
The communications protocols
The role of the communications database (CDB)
The DRDA database protocol
Preparing your system for DRDA access
The private to DRDA protocol REXX tool (DSNTP2DP)
DRDA enhancements for migration from DB2 Version 8
DRDA enhancements for migration from DB2 Version 9
DDF installation and implications for DB2
Connecting systems with VTAM
Customize VTAM for DB2
Choosing names and a password
Choosing names for the local subsystem
Choosing a password for the local subsystem
Names that you need from the remote systems
Names that Spiffy Computer Company chose
Defining the DB2 subsystem to VTAM
The APPL statement
Options for which you must choose values
Options that you must code exactly as given
Options that must use VTAM defaults
Other options of interest
Options that are ignored by DB2
The MODEENT macro
Default VTAM modes
Sample mode entries
MODEENT options
Populating the communications database
VTAM-relevant columns of the SYSIBM.LOCATIONS table
VTAM-relevant columns of the SYSIBM.LUNAMES table
VTAM-relevant columns of the SYSIBM.USERNAMES table
Starting VTAM to use DB2
Tuning the VTAM system
Controlling buffer storage
Session-level pacing
Recommendation for APPL pacing option
Recommendation for MODEENT pacing options
Modifying class of service
Associating applications with modes
Update LUNAMES to associate modes with LU names
Update SYSIBM.LUMODES with conversation limits
Update SYSIBM.MODESELECT to associate plans with modes
When updates to CDB values take effect for VTAM connections
Calculating session limits
Calculating VTAM I/O buffer pool (IOBUF) storage
CNOS processing in DB2
Sample VTAM definitions to connect two DB2 subsystems
Basic VTAM definitions
Definitions for channel-connected DB2 subsystems
NCP-connected DB2 subsystems
Using the change log inventory utility to update the BSDS
Connecting systems with TCP/IP
TCP/IP terminology
Enabling TCP/IP communication
Preparing the Language Environment runtime library
Enabling DDF for UNIX System Services
DB2 configuration with TCP/IP
Customizing the TCP/IP data sets or files
Modifying the change log inventory job for using TCP/IP
Populating the communications database for use with TCP/IP
TCP/IP-relevant columns of the SYSIBM.LOCATIONS table
TCP/IP-relevant columns of the SYSIBM.IPLIST table
TCP/IP-relevant columns of the SYSIBM.IPNAMES table
TCP/IP-relevant columns of the SYSIBM.USERNAMES table
Starting TCP/IP support
Tuning TCP/IP
TCP/IP limitations
Initializing a TCP stack for use with a VIPA
Initializing a TCP stack for use with both IPv4 and IPv6 addresses
Two-phase commit for TCP/IP clients
Multiple TCP/IP stacks and DB2
Multiple DB2 subsystems with multiple TCP/IP stacks
Multiple DB2 subsystems with one TCP/IP stack
Specifying security requirements
Configuring the DB2 command line processor
Command line processor prerequisites
Setting up your system to use the DB2 command line processor
IBM Text Search for DB2 for z/OS
Creating tables for use by an accelerator product
Working with international data
Character conversion concepts
System-coded character set identifiers
Unicode support in DB2
Customizing support for Unicode
EBCDIC and ASCII support
Implications of character conversions
Euro symbol support
How an entry in SYSIBM.SYSSTRINGS works with character conversion
Conversion-related changes that require remote packages to be rebound
Locales for uppercase and lowercase conversion of EBCDIC data
Setting up z/OS to allow uppercase and lowercase conversion of Unicode and ASCII data
Index for installation and migration
DB2 Program Directory
DB2 administration
Administration
Designing a database
Database objects and relationships
Logical database design with the entity-relationship model
Modeling your data
Recommendations for logical data modeling
Practical examples of data modeling
Entities for different types of relationships
Entity attributes
Attribute names
Data types of attributes
Appropriate values for attributes
Entity normalization
Logical database design with Unified Modeling Language
Physical database design
Denormalization of tables
Views to customize what data users see
Indexes on table columns
Hash access on tables
Implementing your database design
Implementing DB2 databases
Creating DB2 databases
Dropping DB2 databases
Implementing DB2 storage groups
Advantages of storage groups
Control interval sizing
Creating DB2 storage groups
Enabling SMS to control DB2 storage groups
Deferring allocation of DB2-managed data sets
How DB2 extends data sets
DB2 space allocation
Primary space allocation
Secondary space allocation
Example of primary and secondary space allocation
Managing DB2 data sets with DFSMShsm
Migrating to DFSMShsm
How archive logs are recalled by DFSMShsm
The RECOVER utility and the DFSMSdss RESTORE command
Considerations for using the BACKUP SYSTEM utility and DFSMShsm
Incremental system-level backups
Managing your own data sets
Defining data sets
Data set naming conventions
Extending user-managed data sets
Deleting user-managed data sets
Defining index space storage
Creating EA-enabled table spaces and index spaces
Implementing DB2 table spaces
Creating a table space explicitly
Guidelines and recommendations for table spaces
General naming guidelines for table spaces
Coding guidelines for explicitly defined table spaces
Coding guidelines for implicitly defined table spaces
Examples of table space definitions
Implementing DB2 tables
Creating base tables
Guidelines for table names
Creating tables that use hash organization
Creating temporary tables
Creating created temporary tables
Creating declared temporary tables
Distinctions between DB2 base tables and temporary tables
Creating temporal tables
Temporal tables and system-period data versioning
Restrictions for system-period data versioning
Creating a system-period temporal table
Guidelines for system-period temporal tables
Guidelines for history tables
Creating an application-period temporal table
Creating bitemporal tables
Finding the name of a history table
Querying temporal tables
Creating materialized query tables
Creating tables that use table-controlled partitioning
Differences between partitioning methods
Automatic conversion to table-controlled partitioning
Nullable partitioning columns
Creating tables that use index-controlled partitioning
Creating a clone table
Exchanging data between a base table and clone table
Implementing DB2 views
Creating DB2 views
Guidelines for view names
How DB2 inserts and updates data through views
Dropping DB2 views
Implementing DB2 indexes
Creating DB2 indexes
Guidelines for defining indexes
How DB2 implicitly creates an index
Index versions
Implementing DB2 schemas
Creating a schema by using the schema processor
Processing schema definitions
Loading data into DB2 tables
Loading data with the LOAD utility
How the LOAD utility loads DB2 tables
Restricted status after LOAD
Loading data by using the INSERT statement
Inserting a single row
Inserting multiple rows
Implications of using an INSERT statement to load tables
Loading data from DL/I
Implementing DB2 stored procedures
Creating stored procedures
Dropping stored procedures
Implementing DB2 user-defined functions
Creating user-defined functions
Deleting user-defined functions
Estimating disk storage for user data
General approach to estimating storage
Calculating the space required for a table
Calculations for record lengths and pages
Estimating storage for LOBs
Estimating storage when using the LOAD utility
Calculating the space required for an index
Levels of index pages
Estimating storage from the number of index pages
Altering your database design
Altering DB2 databases
ALTER DATABASE options
Altering DB2 storage groups
Letting SMS manage your DB2 storage groups
Adding or removing volumes from a DB2 storage group
Migrating existing data sets to a solid-state drive
Altering table spaces
Materializing pending definition changes
Changing the logging attribute
The NOT LOGGED attribute
Changing the space allocation for user-managed data sets
Dropping, re-creating, or converting a table space
Rebalancing data in partitioned table spaces
Increasing the partition size of a partitioned table space
Altering a page set to contain DB2-defined extents
Altering DB2 tables
Adding a column to a table
Specifying a default value when altering a column
Altering the data type of a column
What happens to the column
What happens to an index on the column
Table space versions
Reorganizing table spaces
Recycling table space version numbers
Altering a table for referential integrity
Adding referential constraints to existing tables
Adding parent keys and foreign keys
Implications of adding parent or foreign keys
Dropping parent keys and foreign keys
Adding or dropping table check constraints
Adding a partition
Altering partitions
Changing the boundary between partitions
Rotating partitions
Extending the boundary of the last partition
Splitting the last partition into two
Inserting rows at the end of a partition
Adding XML columns
Altering tables to enable hash access
Altering the size of your hash spaces
Adding a system period and system-period data versioning to an existing table
Adding an application period to a table
Manipulating data in a system-period temporal table
Altering materialized query tables
Registering an existing table as a materialized query table
Changing a materialized query table to a base table
Changing the attributes of a materialized query table
Changing the definition of a materialized query table
Altering the assignment of a validation routine
Altering a table to capture changed data
Changing an edit procedure or a field procedure
Altering the subtype of a string column
Altering the attributes of an identity column
Changing data types by dropping and re-creating the table
Implications of dropping a table
Objects that depend on the dropped table
Re-creating a table
Moving a table to a table space of a different page size
Altering DB2 views
Altering views by using the INSTEAD OF trigger
Altering DB2 indexes
Alternative method for altering an index
Adding columns to an index
Adding a column to an index when you add the column to a table
Adding columns to the set of index keys of a unique index
Altering how varying-length index columns are stored
Altering the clustering of an index
Dropping and redefining a DB2 index
Reorganizing indexes
Recycling index version numbers
Altering stored procedures
Altering user-defined functions
Altering implicitly created XML objects
Changing the high-level qualifier for DB2 data sets
Defining a new integrated catalog alias
Changing the qualifier for system data sets
Changing the load module to reflect the new qualifier
Stopping DB2 when no activity is outstanding
Renaming system data sets with the new qualifier
Updating the BSDS with the new qualifier
Establishing a new xxxxMSTR cataloged procedure
Starting DB2 with the new xxxxMSTR and load module
Changing qualifiers for other databases and user data sets
Changing your work database to use the new high-level qualifier
Changing your work database for a new installation of DB2
Changing your work database for a migrated installation of DB2
Changing user-managed objects to use the new qualifier
Changing DB2-managed objects to use the new qualifier
Tools for moving DB2 data
Moving DB2 data
Moving a DB2 data set
Moving data without REORG or RECOVER
Moving DB2-managed data with REORG, RECOVER, or REBUILD
Scenario: Moving from index-controlled to table-controlled partitioning
Operation and recovery
DB2 basic operational concepts
Recommendations for entering commands
DB2 operator commands
Where DB2 commands are entered
Where command responses go
Authorities for DB2 commands
Unsolicited DB2 messages
Operational control options
Starting and stopping DB2
Starting DB2
Messages at start
Subsystem parameters at start
Application defaults module name at start
Restricting access to data
Ending the wait state at startup
Restart options after an abend
Stopping DB2
Submitting work to DB2
Submitting work by using DB2I
Running TSO application programs
DSN subcommands for TSO environments
Sources that DB2 checks to find authorization access for an application program
Running IMS application programs
Running CICS application programs
Running batch application programs
Running application programs using CAF
Running application programs using RRSAF
Scheduling administrative tasks
Interacting with the administrative task scheduler
Adding a task
Scheduling capabilities of the administrative task scheduler
Defining task schedules
Choosing an administrative task scheduler in a data sharing environment
UNIX cron format
Listing scheduled tasks
Listing the status of scheduled tasks
Listing the last execution status of scheduled tasks
Listing multiple execution statuses of scheduled tasks
Displaying the results of a stored procedure task
Updating the schedule for a task
Stopping the execution of a task
Removing a scheduled task
Manually starting the administrative task scheduler
Manually stopping the administrative task scheduler
Synchronization between administrative task schedulers in a data sharing environment
Troubleshooting the administrative task scheduler
Enabling tracing for administrative task scheduler problem determination
Recovering the administrative task scheduler task list
Problems executing a task
Problems in user-defined table functions
Problems in stored procedures
Architecture of the administrative task scheduler
The lifecycle of the administrative task scheduler
Task lists of the administrative task scheduler
Architecture of the administrative task scheduler in a data sharing environment
Accounting information for stored procedure tasks
Security guidelines for the administrative task scheduler
User roles in the administrative task scheduler
Protection of the interface of the administrative task scheduler
Protection of the resources of the administrative task scheduler
Secure execution of tasks in the administrative task scheduler
Execution of scheduled tasks in the administrative task scheduler
Multi-threading in the administrative task scheduler
Scheduling execution of a stored procedure
How the administrative task scheduler executes a stored procedure
How the administrative task scheduler works with Unicode
Scheduled execution of a JCL job
Execution of scheduled tasks in a data sharing environment
Time zone considerations for the administrative task scheduler
Monitoring and controlling DB2 and its connections
Controlling DB2 databases and buffer pools
Starting databases
Starting an object with a specific status
Starting a table space or index space that has restrictions
Monitoring databases
Obtaining information about application programs
Identifying who and what are using an object
Determining which programs are holding locks on an object
Obtaining information about and handling pages in error
Characteristics of pages that are in error
Displaying the logical page list
Removing pages from the logical page list
Displaying a write error page range
Making objects unavailable
Commands to stop databases
Altering buffer pools
Monitoring buffer pools
Controlling user-defined functions
Starting user-defined functions
Monitoring user-defined functions
Stopping user-defined functions
Controlling DB2 utilities
Starting online utilities
Monitoring and changing online utilities
Controlling DB2 stand-alone utilities
Stand-alone utilities
Controlling the IRLM
z/OS commands that operate on IRLM
Starting the IRLM
Stopping the IRLM
Monitoring threads
Types of threads
Output of the DISPLAY THREAD command
Displaying information about threads
Displaying information by location
Displaying information for non-DB2 locations
Displaying conversation-level information about threads
Displaying threads by LUWID
Displaying threads by type
Monitoring all DBMSs in a transaction
Controlling connections
Controlling TSO connections
Connecting to DB2 from TSO
Monitoring TSO and CAF connections
Disconnecting from DB2 while under TSO
Controlling CICS connections
Connecting from CICS
Restarting CICS
Defining CICS threads
Monitoring CICS threads
Displaying CICS-DB2 indoubt units of recovery
Recovering CICS-DB2 indoubt units of recovery
Displaying CICS postponed units of recovery
Disconnecting CICS applications
Disconnecting from CICS
Performing an orderly termination from CICS
Performing a forced termination from CICS
Controlling IMS connections
Connections to the IMS control region
IMS thread attachment
Duplicate IMS correlation IDs
Displaying IMS attachment facility threads
Terminating IMS attachment facility threads
Displaying IMS-DB2 indoubt units of recovery
Recovering IMS-DB2 indoubt units of recovery
Displaying postponed IMS-DB2 units of recovery
Resolving IMS residual recovery entries
IMS residual recovery entries
Controlling IMS dependent region connections
How IMS dependent region connections work
Disconnecting from IMS dependent regions
Monitoring activity on connections from DB2
Monitoring activity of connections from IMS
Disconnecting from IMS
Controlling RRS connections
Abnormal termination involving DB2 and RRS
Displaying RRS indoubt units of recovery
Recovering RRS indoubt units of recovery manually
Displaying RRS postponed units of recovery
Monitoring and displaying RRSAF connections
Disconnecting RRSAF applications from DB2
Controlling connections to remote systems
Starting DDF
Suspending DDF server activity
Resuming DDF server activity
Displaying information about DDF work
DB2 commands for monitoring connections to other systems
Displaying information about connections with other locations
Canceling dynamic SQL from a client application
Canceling threads
Effects of the CANCEL THREAD command
Monitoring and controlling stored procedures
Displaying information about stored procedures with DB2 commands
Displaying statistics about stored procedures
Displaying thread information about stored procedures
Determining the status of an application environment
Refreshing a WLM application environment for stored procedures
Obtaining diagnostic information and debugging stored procedures
Migrating stored procedures from test to production
Migrating native SQL procedures from test to production
Migrating external SQL procedures from test to production
Migrating external stored procedures from test to production
Monitoring DDF problems by using NetView
DDF alerts
Stopping DDF
Stopping DDF using the QUIESCE option
Stopping DDF using the FORCE option
Stopping DDF using VTAM commands
Controlling traces
Diagnostic traces for attachment facilities
Controlling the DB2 trace
Diagnostic trace for the IRLM
Controlling the resource limit facility (governor)
Changing subsystem parameter values
Setting the priority of stored procedures
Managing the log and the bootstrap data set
How database changes are made
Units of recovery and points of consistency
How DB2 rolls back work
How the initial DB2 logging environment is established
How DB2 creates log records
How DB2 writes the active log
How DB2 writes (offloads) the archive log
What triggers an offload
Role of the operator in the offload process
Messages that are returned during offloading
Effects of interruptions and errors on the offload process
Archive log data sets
How dual archive logging works
Tips for archiving
Tips for archiving to tape
Tips for archiving to disk
Tips for archiving with DFSMS
Automatic archive log deletion
How DB2 retrieves log records
Managing the log
Quiescing activity before offloading
Archiving the log
Adding an active log data set to the active log inventory
Dynamically changing the checkpoint frequency
Setting limits for archive log tape units
Monitoring the system checkpoint
Displaying log information
Resetting the log RBA
Log RBA range
Resetting the log RBA value in a data sharing environment
Resetting the log RBA value in a non-data sharing environment
Canceling and restarting an offload
Displaying the status of an offload
Discarding archive log records
Locating archive log data sets
Management of the bootstrap data set
Restoring dual-BSDS mode
BSDS copies with archive log data sets
Recommendations for changing the BSDS log inventory
Restarting DB2 after termination
Methods of restarting
Types of termination
Normal termination
Abnormal terminations (abends)
Normal restart and recovery
Phase 1: Log initialization
Phase 2: Current status rebuild
Phase 3: Forward log recovery
Phase 4: Backward log recovery
Automatic restart
Restart in a data sharing environment
Restart implications for table spaces that are not logged
Conditional restart
Terminating DB2 normally
Restarting automatically
Deferring restart processing
Deferral of restart
Performing conditional restart
Conditional restart with system-level backups
Options for recovery operations after conditional restart
Conditional restart records
Resolving postponed units of recovery
RECOVER POSTPONED command
Recovering from an error during RECOVER POSTPONED processing
Maintaining consistency across multiple systems
Multiple system consistency
Two-phase commit process
Commit coordinator and multiple participants
Illustration of multi-site update
Termination for multiple systems
Consistency after termination or failure
Normal restart and recovery for multiple systems
Multiple-system restart with conditions
Heuristic decisions about whether to commit or abort an indoubt thread
Resolving indoubt units of recovery
Resolution of IMS indoubt units of recovery
Resolution of CICS indoubt units of recovery
Resolution of RRS indoubt units of recovery
Resolving WebSphere Application Server indoubt units of recovery
Resolving remote DBMS indoubt units of recovery
Determining the coordinator's commit or abort decision
Recovering indoubt threads
Resetting the status of an indoubt thread
Backing up and recovering your data
Plans for backup and recovery
Plans for recovery of distributed data
Plans for extended recovery facility toleration
Plans for recovery of indexes
Preparation for recovery: a scenario
Events that occur during recovery
Complete recovery cycles
A recovery cycle example when using image copies
How DFSMShsm affects your recovery environment
Tips for maximizing data availability during backup and recovery
Where to find recovery information
How to report recovery information
Discarding SYSCOPY and SYSLGRNX records
Preparations for disaster recovery
System-wide points of consistency
Recommendations for more effective recovery from inconsistency
Actions to take to aid in successful recovery of inconsistent data
Actions to avoid in recovery of inconsistent data
How to recover multiple objects in parallel
Recovery of page sets and data sets
Recovery of the work file database
Page set and data set copies
Creating FlashCopy image copies
How to make concurrent copies using DFSMS
Backing up with RVA storage control or Enterprise Storage Server
System-level backups for object-level recoveries
Recovery of data to a prior point in time
Plans for point-in-time recovery
Point-in-time recovery with system-level backups
Point-in-time recovery using the RECOVER utility
Options for restoring data to a prior point in time
Data consistency for point-in-time recoveries
The RECOVER TOLOGPOINT option in a data sharing system
The RECOVER TOLOGPOINT option in a non-data sharing system
Recommendations for recovery of compressed data
Implications of moving data sets after a system-level backup
Recovery of table spaces
Recovery of partitioned table spaces
Recovery of segmented table spaces
Recovery of LOB table spaces
Recovery of XML table spaces
Recovery of table space sets
Recovery of partition-by-growth table spaces
Recovery of indexes
Recovery of indexes on altered tables
Recovery of indexes on tables in partitioned table spaces
Recovery of FlashCopy image copies
Preparing to recover to a prior point of consistency
Identifying objects to recover
Resetting exception status
Copying the data
Establishing a point of consistency
Preparing to recover an entire DB2 subsystem to a prior point in time using image copies or object-level backups
Creating essential disaster recovery elements
Resolving problems with a user-defined work file data set
Resolving problems with DB2-managed work file data sets
Recovering error ranges for a work file table space
Recovery of error ranges for a work file table space
Recovering after a conditional restart of DB2
Recovery of the catalog and directory
Regenerating missing identity column values
Recovery of tables that contain identity columns
Recovering a table space and all of its indexes
Recovery implications for objects that are not logged
Clearing the informational COPY-pending status (ICOPY)
The LOG option of the LOAD or REORG utilities
Clearing the RECOVER-pending status
Removing various pending states from LOB and XML table spaces
Restoring data by using DSN1COPY
Backing up and restoring data with non-DB2 dump and restore
Recovering accidentally dropped objects
How to avoid accidentally dropping objects
Recovering an accidentally dropped table
Recovering an accidentally dropped table space
Recovering accidentally dropped DB2-managed data sets
Recovering accidentally dropped user-managed data sets
Recovering a DB2 system to a given point in time using the RESTORE SYSTEM utility
Recovering by using DB2 restart recovery
Recovering by using FlashCopy volume backups
Making catalog definitions consistent with your data after recovery to a prior point in time
Recovery of catalog and directory tables
Performing remote site recovery from a disaster at a local site
Recovering with the BACKUP SYSTEM and RESTORE SYSTEM utilities
Recovering without using the BACKUP SYSTEM utility
Backup and recovery involving clone tables
Recovery of temporal tables with system-period data versioning
Data restore of an entire system
Reading log records
Contents of the log
Unit of recovery log records
Database exception table records
Typical unit of recovery log records
Types of changes to data
Checkpoint log records
Database page set control records
Other exception information
The physical structure of the log
Physical and logical log records
The log record header
The log control interval definition (LCID)
Log record type codes
Log record subtype codes
Interpreting data change log records
Reading log records with IFI
Gathering active log records into a buffer
Reading specific log records (IFCID 0129)
Reading complete log data (IFCID 0306)
Specifying the return area
Qualifying log records
Reading log records with OPEN, GET, and CLOSE
JCL DD statements for DB2 stand-alone log services
Data sharing members that participate in a read
Registers and return codes
Stand-alone log OPEN request
Stand-alone log GET request
Stand-alone log CLOSE request
Sample application that uses stand-alone log services
Reading log records with the log capture exit routine
Exit routines
Edit procedures
Specifying edit procedures
When edit routines are taken
Parameter list for edit procedures
Incomplete rows and edit routines
Expected output for edit routines
Validation routines
Specifying validation routines
When validation routines are taken
Parameter list for validation routines
Incomplete rows and validation routines
Expected output for validation routines
Date and time routines
Specifying date and time routines
When date and time routines are taken
Parameter list for date and time routines
Expected output for date and time routines
Conversion procedures
Specifying conversion procedures
When conversion procedures are taken
Parameter list for conversion procedures
Expected output for conversion procedures
Field procedures
Field-definition for field procedures
Specifying field procedures
When field procedures are taken
Control blocks for execution of field procedures
Parameter list (FPPL) for field procedures
Work area for field procedures
Information block (FPIB) for field procedures
Parameter value list (FPPVL) for field procedures
Value descriptor for field procedures
Field-definition (function code 8)
Field-encoding (function code 0)
Field-decoding (function code 4)
Log capture routines
Specifying log capture routines
When log capture routines are invoked
Parameter list for log capture routines
Routines for dynamic plan selection in CICS
General guidelines for writing exit routines
Coding rules for exit routines
Modifying exit routines
Execution environment for exit routines
Registers at invocation for exit routines
Parameter list for exit routines
Row formats for edit and validation routines
Column boundaries for edit and validation procedures
Null values for edit procedures, field procedures, and validation routines
Fixed-length rows for edit and validation routines
Varying-length rows for edit and validation routines
Varying-length rows with nulls for edit and validation routines
EDITPROCs and VALIDPROCs for handling basic and reordered row formats
Converting basic row format table spaces with edit and validation routines to reordered row format
Converting basic row format table spaces with edit routines to reordered row format
Converting basic row format table spaces with validation routines to reordered row format
Row format conversion for table spaces
Dates, times, and timestamps for edit and validation routines
Parameter list for row format descriptions
DB2 codes for numeric data in edit and validation routines
Stored procedures for administration
DSNACICS stored procedure
The DSNACICX user exit routine
DSNLEUSR stored procedure
DSNAIMS stored procedure
DSNAIMS2 stored procedure
ADMIN_COMMAND_DB2 stored procedure
ADMIN_COMMAND_DSN stored procedure
ADMIN_COMMAND_UNIX stored procedure
ADMIN_DS_BROWSE stored procedure
ADMIN_DS_DELETE stored procedure
ADMIN_DS_LIST stored procedure
ADMIN_DS_RENAME stored procedure
ADMIN_DS_SEARCH stored procedure
ADMIN_DS_WRITE stored procedure
ADMIN_INFO_HOST stored procedure
ADMIN_INFO_SMS stored procedure
ADMIN_INFO_SSID stored procedure
ADMIN_INFO_SQL stored procedure
Debugging ADMIN_INFO_SQL
ADMIN_INFO_SYSLOG stored procedure
ADMIN_INFO_SYSPARM stored procedure
ADMIN_JOB_CANCEL stored procedure
ADMIN_JOB_FETCH stored procedure
ADMIN_JOB_QUERY stored procedure
ADMIN_JOB_SUBMIT stored procedure
ADMIN_TASK_ADD stored procedure
ADMIN_TASK_CANCEL stored procedure
ADMIN_TASK_REMOVE stored procedure
ADMIN_TASK_UPDATE stored procedure
ADMIN_UTL_SCHEDULE stored procedure
ADMIN_UTL_SORT stored procedure
Common SQL API stored procedures
Versioning of XML documents
XML input document
Complete mode for returning valid XML input documents
XML output documents
XPath expressions for filtering output
XML message documents
GET_CONFIG stored procedure
GET_MESSAGE stored procedure
GET_SYSTEM_INFO stored procedure
Troubleshooting DB2 stored procedures
Index for administration
Data sharing
Introduction to DB2 data sharing
Advantages of DB2 data sharing
Improved data availability
Extended processing capacity
Configuration flexibility
Higher transaction rates
How DB2 protects data consistency
How an update happens
How DB2 writes changed data to disk
Implications of enabling DB2 data sharing
Communication options for data sharing groups
Database administration for data sharing
Options that affect data sharing performance
Commands for data sharing
Data recovery in data sharing environments
Maintenance of data sharing groups
Planning for DB2 data sharing
Installing, migrating, and enabling DB2 data sharing
Consolidating data sharing members
Potential configuration changes when you consolidate data sharing members
Removing members from the data sharing group
What data sets to keep when you quiesce a data sharing member
Quiescing a data sharing member
Deleting data sharing members
Deactivating data sharing members
Destroying data sharing members
Restoring deactivated data sharing members
Communicating with data sharing groups
Ways to access data sharing groups
TCP/IP access methods
Group access
DVIPA network addressing
Specify a DVIPA
Example of TCP/IP configuration statements
Configuration requirements
Prepare for failure recovery with DVIPA
DNS network addressing
Example of group access configuration
Member-specific access
Member-specific location aliases
Defining dynamic location aliases
Managing dynamic location aliases
Single-member access
Setting up DB2 for z/OS as a requester
Remote data sharing group requirements
SYSIBM.LOCATIONS
SYSIBM.IPNAMES
SYSIBM.IPLIST
How DB2 sends requests
Updates to the communications database for TCP/IP connections
Configuring data sharing groups as TCP/IP servers
Specifying the DRDA port number
Reserving the DRDA port
Specifying the resynchronization port numbers
Configuring subsets for member-specific access
Specifying a generic LU name and IPNAME value for the data sharing group
Example of configuring DB2 Connect to access a subset of a data sharing group
Connecting distributed partners in a TCP/IP network
Configuring a DB2 Connect requester to use group access
Configuring a DB2 requester to use group access
Configuring a DB2 requester to use member-specific access
SNA access methods
Member-routing access
Group-generic access
Single-member access
Setting up DB2 for z/OS as a requester
Remote data sharing group requirements
SYSIBM.LOCATIONS
SYSIBM.LUNAMES
SYSIBM.LULIST
How DB2 sends requests
Updates to the communications database for SNA connections
Configuring data sharing groups as servers
Configuring data sharing groups for group-generic access
Defining a generic LU name for the group
Using the originating member's LU name
Configuring members to use the group's generic LU name
Identifying the generic LU names of requesting data sharing groups
Specifying the LU names of requesters
Connecting distributed partners in an SNA network
Configuring a DB2 requester to use member-routing access
Configuring a DB2 requester to use group-generic access
Switching from group-generic to member-specific access
Preventing a member from processing requests
Update the BSDS with the DSNJU003 utility
Operating with data sharing
Commands for data sharing environments
Command routing
Command scope
Commands issued from application programs
Command authorization
Where messages are received
Effect of data sharing on sequence number caching
Starting a data sharing member
Stopping a data sharing member
States of connections and structures after stopping DB2
Normal shutdown
Abnormal shutdown
Submitting work to be processed
Group attachments and subgroup attachments
CICS and IMS applications with DB2 data sharing
Online utility jobs in data sharing environments
Stand-alone utility jobs
Monitoring the group
Obtaining information about the group
Obtaining information about structures
Displaying all structures
Displaying information about specific structures
Obtaining information about group buffer pools
Database monitoring options
Data sharing status descriptions
Pages in error
Physical read and write errors
Locks that are held during DB2 failure
Retained locks
Determining the data sharing member on which SQL statements run
Controlling connections to remote systems in a data sharing environment
Starting and stopping DDF
Monitoring connections to remote systems
Resetting generic LU information
Logging environment for data sharing
The impact of archiving logs in a data sharing group
How to avoid using the archive log
Recovering data
How recovery works in a data sharing group
Improving recovery performance
Recovery options for data sharing environments
System-level point-in-time recovery
BACKUP SYSTEM online utility
RESTORE SYSTEM online utility
Recovering a data sharing group in case of a disaster
Configuration of the recovery site
What to send to the recovery site
Recovery procedure differences
Recovery of pages on the logical page list
Recovery from coupling facility failures
Preparation for structure and connectivity failures
Failure scenarios
Coupling facility recovery scenarios
Problem: loss of coupling facility (CF)
Problem: Loss of group buffer pool structure (non-duplexed)
Problem: Loss of group buffer pool structure (duplexed)
Problem: Loss of lock structure
Problem: Loss of SCA structure
Problem: a subset of members have lost connectivity (non-duplexed)
Problem: a subset of members have lost connectivity (duplexed)
Problem: allocation failure of the group buffer pool
Problem: storage shortage in the group buffer pool
Problem: storage shortage in the SCA
Problem: storage shortage in the lock structure
Deallocating structures by force
Resolution of transaction manager indoubt units of recovery
Resolving indoubt transactions
Restarting DB2 after termination in a data sharing environment
Normal restart for a data sharing member
Active and retained locks
When retained locks are reacquired or purged
Restart light
Group restart phases
DB2 initialization
Current status rebuild
Peer CSR
Forward-log recovery
Peer forward-log recovery
Backward-log recovery
Protection of retained locks: failed-persistent connections
Handling coupling facility connections that hang
Postponed backout in a data sharing environment
Why postponed backout works in a data sharing environment
What data is unavailable?
Identifying objects in advisory restart-pending status
Restarting a member with conditions
Performing a cold start
Conditionally restarting without a cold start
Deferring recovery during restart
Starting duplexing for a structure
Stopping duplexing for a structure
Shutting down the coupling facility
Performance monitoring and tuning for data sharing environments
Monitoring tools
Resource Measurement Facility reports
DB2 trace
DB2 Performance Expert
Improving the performance of data sharing applications
DB2 address spaces involved in distributed data processing
Migration of batch applications
Resource limit facility implications for data sharing
Removal of group buffer pool dependency
Physical open of a page set of partition
Improving the response time for read-only queries
Planning for Sysplex query parallelism
Configuring the data sharing group members for Sysplex query parallelism
Setting workload management goals
How period switches work on parallelism assistants
Example: setting goals for the parallelism coordinator
Example: setting goals for the parallelism assistants
Way to display buffer pool thresholds
Buffer pool threshold for parallelism assistants
Sample configurations
Enabling parallel processing within an application
Enabling parallel processing within a data sharing group
Monitoring and tuning parallel queries
Ways to display data sharing information
How DB2 reports parallelism information
How the accounting trace monitors processor use
Techniques for improving response time
Ways to control the resources used by parallel operations
Disabling Sysplex query parallelism
Controls for disabling Sysplex query parallelism
Concurrency and locks in data sharing environments
Explicit hierarchical locking
A locking scenario
Traces that indicate whether locks have been propagated
Improving concurrency in data sharing environments
Avoiding false contention
Monitoring for false contention
How much contention is acceptable
How to reduce false contention
Decreasing lock entry size
How z/OS resolves contention problems
Deadlock detection and resource timeouts in data sharing environments
Global deadlock processing
Controlling deadlock detection
The global deadlock manager
The local deadlock detector
Relationship between local and global deadlock detection
Global timeout processing
Elapsed time until timeout, non-data-sharing
Elapsed time until timeout, data sharing
Ways to monitor DB2 locking activity
Lock monitoring with the DISPLAY DATABASE command
Lock monitoring with the coupling facility structure activity report
Calculating contention percentages
Lock monitoring with the DB2 statistics trace
Calculating global contention percentages
Lock monitoring with the DB2 accounting trace
Calculating false contention percentages
Measuring transaction locking optimizations
Lock monitoring with the DB2 performance trace
Changing the size of the lock structure
Changing the lock structure size dynamically
Changing the size of the lock structure by rebuilding
Tuning group buffer pools
Assigning page sets to group buffer pools
Recommendations for performance
How to keep data from being shared
How to define private data
Inter-DB2 interest and GBP-dependency
How DB2 tracks interest
Scenarios of P-Lock operations
Tuning recommendation to prevent DB2 from frequently going in and out of GBP-dependency
Determining the amount of inter-system sharing
Displaying GBP-dependent page sets
Determining GBP-dependency for a particular member
Physical locks in data sharing
Page set P-Locks
Retained P-locks
Page P-locks
P-lock monitoring
How to find information about page set P-locks
How to find information about page P-locks
Options for reducing space map page contention
Member affinity clustering
Indexes with randomized key columns to reduce hot spots
Control of tracking updates to reduce coupling facility overhead
Read operations
Where DB2 looks for a page
Testing the page validity
Prefetch processing
Use of caching for group buffer pools
Write operations
How the GBPCACHE option affects write operations
How DB2 writes to the group buffer pool
How DB2 writes from the group buffer pool to disk
Displaying the castout owner
Group buffer pool checkpoint
Default checkpoint frequency
How DB2 gathers checkpoint information
Monitoring and tuning group buffer pool checkpoint intervals
Group buffer pool thresholds
Group buffer pool class castout threshold
Group buffer pool castout threshold
Guidelines for group buffer pool thresholds
Ways to tune the castout thresholds
Example from MDETAIL report
Ways to monitor group buffer pools
Group buffer pool monitoring with the z/OS DISPLAY XCF,STR command
Group buffer pool monitoring with the coupling facility activity report of RMF
Group buffer pool monitoring with the DISPLAY GROUPBUFFERPOOL command
When to use DB2 statistics trace
Determining the correct size and ratio of group buffer pools
Group buffer pool size is too small
Monitoring storage of the group buffer pool
Too few directory entries
Too few data entries
Auto Alter capabilities
What to look for in a OMEGAMON statistics report
Changing group buffer pools
Changing the castout threshold values
Changing the checkpoint frequency
Changing the size of the group buffer pool
Changing the ratio of directory to data entries
Changing the GBPCACHE attribute
Access path selection in a data sharing group
Effect of member configuration on access path selection
How EXPLAIN works in a data sharing group
How DB2 maintains in-memory statistics in data sharing
Index for data sharing
DB2 internationalization
Introduction to character conversion
Character conversion terminology
Code pages and CCSIDs
Encoding schemes
ASCII
EBCDIC
Code point differences between EBCDIC CCSIDs
Unicode
UTFs
Unicode CCSIDs
Endianness
Situations in which character conversion occurs
Possible consequences of character conversion
Types of character conversion
Expanding conversion
Contracting conversion
Round-trip conversion
Enforced subset conversion
How DB2 for z/OS uses Unicode
Retrieving data from the DB2 catalog
SYSDUMMYx tables
Specifying that IFCID output should be in Unicode
Setting up DB2 to ensure that it interprets characters correctly
How DB2 performs character conversions
SYSIBM.SYSSTRINGS catalog table
Finding the CCSID values of your data sources
Specifying CCSIDs in DB2
Specifying subsystem CCSIDs
Subsystem CCSIDs and encoding schemes
Determining current subsystem CCSID and encoding scheme values
Specifying object CCSIDs
Setting up z/OS Unicode Services for DB2 for z/OS
Conversion image
Defining additional character conversions
Checking defined character conversions
Storing Unicode data
Deciding whether to store data as UTF-8 or UTF-16
Creating a Unicode table
Tips for handling any extra storage that Unicode data might require
Estimating the column size for Unicode data
Inserting data into a Unicode table
Inserting Unicode data into a non-Unicode table
Converting existing DB2 data to Unicode
Effects on access paths when converting data to Unicode
Application programming with Unicode data and multiple CCSIDs
Application encoding scheme
Specifying a CCSID for your application
Details of CCSID options for application programs
Examples of specifying CCSIDs for application data
Specifying CCSIDs for COBOL applications when using the DB2 coprocessor
Specifying CCSIDs for PL/I applications when using the DB2 coprocessor
PL/I PP compiler option
Specifying CCSIDs for C/C++ applications when using the DB2 coprocessor
Determining the CCSID of DB2 data
Determining the CCSID of a string value in an SQL statement
Objects with different CCSIDs in the same SQL statement
Differences between Unicode and EBCDIC sorting sequences
Specifying how DB2 calculates the length of a string
Specifying the sorting sequence for a language
Performing culturally correct case conversions
Locale
Generating escaped Unicode data
Normalization of Unicode strings
How DB2 handles Unicode supplementary characters
Processing Unicode data in COBOL applications
Processing Unicode data in PL/I applications
Processing Unicode data in C/C++ applications
Java applications and Unicode data
Green screen applications and Unicode data
Variant characters
DRDA character type parameters in Unicode
Debugging CCSID and Unicode problems
Potential problems when inserting non-Unicode data into a Unicode table
DB2 utilities and Unicode support
EXPLAIN Unicode support
DB2 ODBC Unicode support
IBM DB2 Tools Unicode support
The International Components for Unicode
Index for DB2 internationalization
Administering IBM Text Search for DB2 for z/OS
Introduction to IBM Text Search for DB2 for z/OS
Overview of IBM OmniFind Text Search Server for DB2 for z/OS
System requirements for enabling IBM Text Search for DB2 for z/OS
Migration considerations
System requirements for installing a text search server
Key concepts
Text search index creation and updates
Asynchronous indexing and triggers
Data sharing and IBM OmniFind Text Search Servers
Supported document formats
Document truncation
Supported data types
Text score and synonym support
Linguistic processing
Supported languages
Linguistic processing for Chinese, Japanese, and Korean documents
User roles
DB2 subsystem installer
DB2 database administrator
Text search server administrator
User performing search queries
Installing and configuring text search functions
Names of the installation files
Installing a text search server
Resolving an installation failure caused by Security-Enhanced Linux
Installing fixes on top of your current text search server
Configuring a text search server
Enabling text search support
Enabling text search support for DB2 Version 10
Enabling text search support for DB2 Version 9
Post-installation tasks for PTF UK31079
Updating private copies of the DB2 installation CLIST
Updating customized copies of the installation jobs
Post-installation tasks for PTF UK43841
Post-installation tasks for PTF UK51718
Creating the databases and routines
Rebinding packages of administration stored procedures
Setting up the WLM environment
Setting up the WLM environment for administration stored procedures
Setting up the runtime environment for Java routines
Populating the text search administration tables for DB2 10 for z/OS
Populating the text search administration tables for DB2 Version 9
Verifying the installation
Starting text search functions
Creating a text search index
Updating a text search index
Searching a text search index
Adding a text search server to the system
Administration stored procedures
SYSPROC.SYSTS_START
SYSPROC.SYSTS_STOP
SYSPROC.SYSTS_CREATE
SYSPROC.SYSTS_DROP
Dropping a table without previously calling SYSPROC.SYSTS_DROP
SYSPROC.SYSTS_UPDATE
Scheduling the SYSPROC.SYSTS_UPDATE stored procedure
Archive log consumption
Responding to an automatic takeover
SYSPROC.SYSTS_TAKEOVER
SYSPROC.SYSTS_RESTORE
Retrieving messages without truncation
Enabling trace for stored procedures
Overview of the event table
Checking the event table after calling SYSPROC.SYSTS_CREATE
Handling single document errors
Administering the event table
User-defined functions and search argument syntax
CONTAINS
Optimizing usage of the equality operator
SCORE
Optimizing usage of comparison operators
SYSFUN.SYSTS_ENCRYPT
Search argument syntax
Simple query examples
Advanced search operators
Operator precedence
Using the OR operator in a WHERE clause
Wildcard character limitations
Restrictions for search argument syntax
Example that uses the CONTAINS function and SCORE function
Using the RESULTLIMIT option in the CONTAINS and SCORE functions
XML search
XML search query grammar
XPath query examples
Administering a text search server
Starting a text search server
Stopping a text search server
Adding a synonym dictionary to a collection
Removing a synonym dictionary from a collection
Uninstalling a text search server
Command-line tools
Configuration Tool
Administration Tool
Synonym Tool
Text search administration tables
SYSIBMTS.SYSTEXTDEFAULTS administration table
SYSIBMTS.SYSTEXTINDEXES administration table
SYSIBMTS.SYSTEXTCOLUMNS administration table
SYSIBMTS.SYSTEXTSERVERS administration table
SYSIBMTS.SYSTEXTCONNECTINFO administration table
SYSIBMTS.SYSTEXTSTATUS administration table
SYSIBMTS.SYSTEXTCONFIGURATION administration table
SYSIBMTS.SYSTEXTLOCKS administration table
SYSIBMTS.SYSTEXTSERVERHISTORY administration table
Troubleshooting
Supporting concurrent index updates and search requests
Preventing a timeout abend
Troubleshooting invalid entries in administration tables
Troubleshooting SQL code -430
Troubleshooting SQL code -20212
Troubleshooting SQL code -20423 with message OF00801E
Messages and codes
Index for administering IBM Text Search for DB2 for z/OS
Administering IBM Spatial Support for DB2 for z/OS
About IBM Spatial Support for DB2 for z/OS
The purpose of IBM Spatial Support for DB2 for z/OS
How data represents geographic features
The nature of spatial data
Where spatial data comes from
Using functions to generate spatial data
Importing spatial data
How features, spatial information, spatial data, and geometries fit together
About geometries
Geometries
Properties of geometries
Types
Geometry coordinates
X and Y coordinates
Z coordinates
M coordinates
Interior, boundary, and exterior
Simple or non-simple
Closed
Empty or not empty
Minimum bounding rectangle (MBR)
Dimension
Spatial reference system identifier
Getting started with IBM Spatial Support for DB2 for z/OS
System requirements for installing IBM Spatial Support for DB2 for z/OS
Setting up and installing spatial support
Verifying the installation of spatial support
Inventory of resources supplied for your database
Enabling spatial support for the first time
Enabling spatial support when migrating from DB2 V9.1 for z/OS
Setting up spatial resources
How to use coordinate systems
Coordinate systems
Geographic coordinate system
Projected coordinate systems
Selecting or creating coordinate systems
How to set up spatial reference systems
Spatial reference systems
Deciding whether to use a default spatial reference system or create a new system
Spatial reference systems supplied with IBM Spatial Support for DB2 for z/OS
Creating a spatial reference system
Conversion factors that transform coordinate data into integers
Offset values
Scale factors
Units for offset values and scale factors
Calculating offset values
Calculating scale factors
Determining minimum and maximum coordinates and measures
Setting up spatial columns
Spatial columns
Spatial columns with viewable content
Spatial data types
Data types for single-unit features
Data types for multi-unit features
A data type for all features
Creating spatial columns
Creating inline spatial columns
Registering spatial columns
Populating spatial columns
About importing spatial data
Importing spatial data
Importing shape data to a new or existing table
Using indexes to access spatial data
Spatial indexes
Spatial grid indexes
Generation of spatial grid indexes
Use of spatial functions in a query
How a query uses a spatial grid index
Considerations for the number of grid levels and grid sizes
Number of grid levels
Grid cell sizes
Creating spatial grid indexes
Analyzing and generating spatial information
Environments for performing spatial analysis
Examples of how spatial functions operate
Functions that use indexes to optimize queries
Stored procedures
ST_alter_coordsys
ST_alter_srs
ST_create_coordsys
ST_create_index
ST_create_srs
ST_create_srs_2
ST_drop_coordsys
ST_drop_index
ST_drop_srs
ST_export_shape
ST_import_shape
ST_register_spatial_column
ST_unregister_spatial_column
Catalog views
The DB2GSE.GEOMETRY_COLUMNS catalog view
The DB2GSE.SPATIAL_REF_SYS catalog view
The DB2GSE.ST_COORDINATE_SYSTEMS catalog view
The DB2GSE.ST_GEOMETRY_COLUMNS catalog view
The DB2GSE.ST_SIZINGS catalog view
The DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view
The DB2GSE.ST_UNITS_OF_MEASURE catalog view
Spatial functions: categories and uses
Constructor functions
Functions that operate on data exchange formats
A function that creates geometries from coordinates
Examples
Conversion to well-known text (WKT) representation
Conversion to well-known binary (WKB) representation
Conversion to ESRI shape representation
Conversion to Geography Markup Language (GML) representation
Comparison functions
Spatial comparison functions
Functions that compare geographic features
Functions that check whether one geometry contains another
ST_Contains
ST_Within
Functions that check intersections between geometries
EnvelopesIntersect
ST_Intersects
ST_Crosses
ST_Overlaps
ST_Touches
Function that checks whether two geometries are identical
ST_Equals
Functions that return coordinate and measure information
ST_M
ST_MaxM
ST_MaxX
ST_MaxY
ST_MaxZ
ST_MinM
ST_MinX
ST_MinY
ST_MinZ
ST_X
ST_Y
ST_Z
Functions that return information about geometries within a geometry
ST_Centroid
ST_EndPoint
ST_GeometryN
ST_NumGeometries
ST_NumPoints
ST_PointN
ST_StartPoint
Functions that show information about boundaries, envelopes, and rings
Functions that return information about a geometry's dimensions
ST_Area
ST_Length
Functions that reveal whether a geometry is closed, empty, or simple
ST_IsClosed
ST_IsEmpty
ST_IsSimple
Function that identifies a geometry's spatial reference system
ST_SRID
Functions that generate new geometries from existing geometries
Function that converts one geometry to another
ST_Polygon
Functions that create new geometries with different space configurations
ST_Buffer
ST_ConvexHull
ST_Difference
ST_Intersection
ST_SymDifference
Function that derives one geometry from many
ST_Union
ST_UnionAggr
Function that returns distance information
Function that returns index information
Spatial functions: syntax and parameters
Considerations for spatial functions
EnvelopesIntersect
ST_Area
ST_AsBinary
ST_AsGML
ST_AsShape
ST_AsText
ST_Boundary
ST_Buffer
ST_Centroid
ST_Contains
ST_ConvexHull
ST_CoordDim
ST_Crosses
ST_Difference
ST_Dimension
ST_Disjoint
ST_Distance
ST_Endpoint
ST_Envelope
ST_Equals
ST_ExteriorRing
ST_Geometry
ST_GeometryN
ST_GeometryType
ST_GetIndexParms
ST_InteriorRingN
ST_Intersection
ST_Intersects
ST_IsClosed
ST_IsEmpty
ST_IsRing
ST_IsSimple
ST_Length
ST_LineFromWKB
ST_LineString
ST_LocateAlong
ST_LocateBetween
ST_M
ST_MaxM
ST_MaxX
ST_MaxY
ST_MaxZ
ST_MinM
ST_MinX
ST_MinY
ST_MinZ
ST_MLineFromWKB
ST_MPointFromWKB
ST_MPolyFromWKB
ST_MultiLineString
ST_MultiPoint
ST_MultiPolygon
ST_NumGeometries
ST_NumInteriorRing
ST_NumPoints
ST_Overlaps
ST_Point
ST_PointFromWKB
ST_PointN
ST_PointOnSurface
ST_PolyFromWKB
ST_Polygon
ST_Relate
ST_SRID
ST_StartPoint
ST_SymDifference
ST_Touches
ST_Union
ST_UnionAggr
ST_Within
ST_X
ST_Y
ST_Z
Supported data formats
Well-known text (WKT) representation
Well-known binary (WKB) representation
Shape representation
Geography Markup Language (GML) representation
Supported coordinate systems
Coordinate systems syntax
Supported linear units
Supported angular units
Supported spheroids
Supported prime meridians
Supported map projections
The DSN5SCLP program
Commands for the DSN5SCLP program
alter_cs
alter_srs
create_cs
create_idx
create_srs
create_srs_2
disable_spatial
drop_cs
drop_idx
drop_srs
enable_spatial
import_shape
register_spatial_column
unregister_spatial_column
Identifying IBM Spatial Support for DB2 for z/OS problems
How to interpret spatial support messages
Output parameters for spatial support stored procedures
Messages for spatial support stored procedures
Spatial support function messages
GSE Messages
GSE0001C
GSE0002C
GSE0003N
GSE0004C
GSE0006N
GSE0007N
GSE0008N
GSE0100N
GSE0101N
GSE0102N
GSE0103N
GSE0200N
GSE0201W
GSE0202N
GSE0203W
GSE0204N
GSE0205W
GSE0206N
GSE0207N
GSE0208N
GSE0209N
GSE0210W
GSE0211N
GSE0212N
GSE0214N
GSE0215N
GSE0216N
GSE0217N
GSE0218N
GSE0219N
GSE0220N
GSE0221N
GSE0222N
GSE0223N
GSE0224N
GSE0226N
GSE0227N
GSE0228N
GSE0230N
GSE0231N
GSE0300N
GSE0301N
GSE0302N
GSE0303N
GSE0304N
GSE0305N
GSE0306N
GSE0307N
GSE0308N
GSE1000N
GSE1001N
GSE1002N
GSE1003N
GSE1006N
GSE1009N
GSE1010N
GSE1011N
GSE1012N
GSE1013N
GSE1014N
GSE1015N
GSE1016N
GSE1017N
GSE1018N
GSE1019N
GSE1020N
GSE1021N
GSE1022N
GSE1023N
GSE1024N
GSE1025N
GSE1034N
GSE1035N
GSE1037N
GSE1038N
GSE1039N
GSE1040N
GSE1041N
GSE1043N
GSE1044N
GSE1045N
GSE1048N
GSE1049N
GSE2100N
GSE2101N
GSE2102N
GSE2103N
GSE2104N
GSE2105W
GSE2106N
GSE2107N
GSE2108N
GSE2109N
GSE2110N
GSE2111N
GSE2112N
GSE2113N
GSE2114N
GSE2115N
GSE2116N
GSE2117N
GSE2118N
GSE2119N
GSE2120N
GSE2121N
GSE2122N
GSE2123N
GSE2124N
GSE2125N
GSE2126N
GSE2127N
GSE2128N
GSE2129N
GSE2130N
GSE2131N
GSE2132N
GSE2133N
GSE2134N
GSE2299N
GSE3000N
GSE3001N
GSE3002N
GSE3003N
GSE3004N
GSE3005N
GSE3006N
GSE3007N
GSE3008N
GSE3009W
GSE3010W
GSE3011W
GSE3012N
GSE3013N
GSE3014N
GSE3015N
GSE3016N
GSE3020N
GSE3021N
GSE3022N
GSE3023N
GSE3024N
GSE3025N
GSE3026N
GSE3027N
GSE3028N
GSE3029N
GSE3030N
GSE3031N
GSE3032N
GSE3033N
GSE3034N
GSE3035W
GSE3036W
GSE3037N
GSE3038N
GSE3039N
GSE3040N
GSE3041N
GSE3042N
GSE3043N
GSE3044N
GSE3045N
GSE3046N
GSE3047N
GSE3048N
GSE3049N
GSE3050N
GSE3051N
GSE3052N
GSE3053N
GSE3300N
GSE3301N
GSE3302N
GSE3303N
GSE3400C
GSE3402C
GSE3403N
GSE3405N
GSE3406N
GSE3407N
GSE3408N
GSE3409N
GSE3410N
GSE3411N
GSE3412N
GSE3413N
GSE3414N
GSE3415N
GSE3416N
GSE3417N
GSE3418N
GSE3419N
GSE3420N
GSE3421N
GSE3422N
GSE3423N
GSE3424N
GSE3425N
GSE3426N
GSE3427N
GSE3428N
GSE3429N
GSE3430N
GSE3431N
GSE3432N
GSE3433N
GSE3600N
GSE3601N
GSE3602N
GSE3603N
GSE4000N
GSE4001N
GSE4002N
GSE4003N
GSE4004N
GSE4005N
GSE4006N
GSE4007N
GSE4008N
GSE4009N
GSE9990C
GSE9999C
Index for administering IBM Spatial Support for DB2 for z/OS
DB2 security
Managing security with DB2 facilities
Getting started with DB2 security
DB2 security solutions
What's new in DB2 10 for z/OS security?
DB2 data access control
ID-based access control within DB2
Role-based access control within DB2
Ownership-based access control within DB2
Access control through multilevel security
Access control external to DB2
DB2 subsystem access control
Managing access requests from local applications
Managing access requests from remote applications
Data set protection
RACF for data protection
Data encryption
Scenario: Securing data access at Spiffy Computer
Determining security objectives
Securing manager access to employee data
Creating views of employee data
Granting managers the SELECT privilege
Managing distributed access
Planning for distributed access
Implementing distributed access at the central server
Implementing distributed access at remote locations
Auditing manager access
Securing access to payroll operations and management
Creating views of payroll operations
Securing compensation accounts with update tables
Securing compensation updates with other measures
Granting privileges to payroll operations and management
Creating a RACF group for payroll operations
Creating a RACF group for payroll management
Auditing payroll operations and management
Managing access privileges of other authorities
Managing access by the DBADM authority
Managing access by the SYSADM authority
Managing access by object owners
Managing access by other users
Managing access through authorization IDs and roles
Authorization IDs and roles
Authorization IDs
Roles in a trusted context
Privileges and authorities
Explicit privileges
Explicit collection privileges
Explicit database privileges
Explicit package privileges
Explicit plan privileges
Explicit routine privileges
Explicit schema privileges
Explicit system privileges
Explicit table and view privileges
Explicit usage privileges
Explicit use privileges
Implicit privileges through object ownership
Administrative authorities
Installation SYSADM
SYSADM
SYSCTRL
Installation SYSOPR
SYSOPR
DBADM
DBCTRL
DBMAINT
PACKADM
System DBADM
SECADM
ACCESSCTRL
DATAACCESS
SQLADM
Common DB2 administrative authorities
Utility authorities for DB2 catalog and directory
Privileges by authorization ID and authority
Privileges required for common job roles and tasks
Checking access authorization for data definition statements
Privileges required for handling plans and packages
Privileges required for using dynamic SQL statements
Managing administrative authorities
Separating the SYSADM authority
Migrating the SYSADM authority
Creating roles or trusted contexts with the SECADM authority
Altering tables with the system DBADM authority
Accessing data with the DATAACCESS authority
Granting and revoking privileges with the ACCESSCTRL authority
Managing explicit privileges
Granting privileges to a role
Granting privileges to the PUBLIC ID
Granting privileges to remote users
Granting privileges through views
Granting privileges with the GRANT statement
Granting privileges to secondary IDs
Granting privileges to user groups
Granting privileges for binding plans
Granting privileges for rebinding plans and packages
Granting privileges for accessing distributed data
Revoking privileges with the REVOKE statement
Revoking dependent privileges
Revoking privileges granted by multiple IDs
Revoking privileges granted by all IDs
Revoking privileges granted by a role
Revoking all privileges from a role
Revoking privileges for views
Revoking privileges for materialized query tables
Revoking privileges for plans or packages
Revoking the SYSADM authority from users
Restrictions on privilege revocation
Managing implicit privileges
Managing implicit privileges through object ownership
Ownership of objects with unqualified names
Ownership of objects with qualified names
Ownership of objects within a trusted context
Changing object ownership
Granting implicit privileges of object ownership
Managing implicit privileges through plan or package ownership
Establishing or changing plan or package ownership
Establishing plan and package ownership in a trusted context
How DB2 resolves unqualified names
Validating authorization for executing plans or packages
Checking authorization at a DB2 database server
Checking authorization for executing an RRSAF application without a plan
Caching authorization IDs for better performance
Caching authorization IDs for plans
Caching authorization IDs for packages
Caching authorization IDs for routines
Authorizing plan or package access through applications
Restricting access of plans or packages to particular systems
Authorization checking for executing packages remotely
Managing implicit privileges through routines
Privileges required for executing routines
Granting privileges through routines
Implementing a user-defined function
Defining a user-defined function
Using a user-defined function
Authorization ID validation
Authorization behaviors for dynamic SQL statements
Run behavior
Bind behavior
Define behavior
Invoke behavior
Common attribute values for bind, define, and invoke behaviors
Determining authorization IDs for dynamic SQL statements in routines
Simplifying access authorization for routines
Using composite privileges
Performing multiple actions in one statement
Retrieving privilege records in the DB2 catalog
Catalog tables with privilege records
Retrieving all authorization IDs or roles with granted privileges
Retrieving multiple grants of the same privilege
Retrieving all authorization IDs or roles with the DBADM and system DBADM authorities
Retrieving all IDs or roles with access to the same table
Retrieving all IDs or roles with access to the same routine
Retrieving plans or packages with access to the same table
Retrieving privilege information through views
Implementing multilevel security with DB2
Multilevel security
Security labels
Determining the security label of a user
Security levels
Security categories
Users and objects in multilevel security
Global temporary tables with multilevel security
Materialized query tables with multilevel security
Constraints in a multilevel-secure environment
Field, edit, and validation procedures in a multilevel-secure environment
Triggers in a multilevel-secure environment
Mandatory access checking
Dominance relationships between security labels
Write-down control
Granting write-down privileges
Implementing multilevel security at the object level
Implementing multilevel security with row-level granularity
Creating tables with multilevel security
Adding multilevel security to existing tables
Removing tables with multilevel security
Caching security labels
Restricting access to the security label column
Managing data in a multilevel-secure environment
Using the SELECT statement with multilevel security
Using the INSERT statement with multilevel security
Using the UPDATE statement with multilevel security
Using the MERGE statement with multilevel security
Using the DELETE statement with multilevel security
Using the TRUNCATE statement with multilevel security
Using utilities with multilevel security
Implementing multilevel security in a distributed environment
Configuring TCP/IP with multilevel security
Configuring SNA with multilevel security
Managing access through RACF
Establishing RACF protection for DB2
Defining DB2 resources to RACF
Naming protected access profiles
Enabling RACF checking for the DSNR and SERVER classes
Enabling partner LU verification
Permitting RACF access
Defining RACF user IDs for DB2-started tasks
Adding RACF groups
Granting users and groups access
Granting authorization on DB2 commands
Permitting access from remote requesters
Enabling IMS transactions to use RACF authorization control of DB2 objects
Managing authorization for stored procedures
Authorizing IDs for using RRSAF
Specifying WLM-established server address spaces for stored procedures
Managing authorizations for creation of stored procedures in WLM environments
Authorizing users to refresh WLM environments
Controlling stored procedure access to non-DB2 resources by using RACF
Granting the CREATEIN privilege on schemas for stored procedures
Granting privileges for using distinct types
Granting privileges for using JAR files
Granting privileges for executing stored procedures and stored procedure packages
Controlling remote execution of stored procedures by using trusted contexts
Protecting connection requests that use the TCP/IP protocol
Establishing Kerberos authentication through RACF
Implementing DB2 support for enterprise identity mapping
Configuring the z/OS LDAP server
Setting up RACF for the z/OS LDAP server
Setting up the EIM domain controller
Adding the SAF user mapping plug-in data set to LNKLIST
Implementing DB2 support for distributed identity filters
Managing connection requests from local applications
Processing of connection requests
Using secondary IDs for connection requests
Processing of sign-on requests
Using secondary IDs for sign-on requests
Using sample connection and sign-on exit routines for CICS transactions
Managing connection requests from remote applications
Security mechanisms for DRDA and SNA
Security mechanisms for DB2 for z/OS as a requester
Security mechanisms for DB2 for z/OS as a server
Communications database for the server
SYSIBM.LUNAMES columns
SYSIBM.USERNAMES columns
Enabling change of user passwords
Authorization failure code
Managing inbound SNA-based connection requests
Processing of remote attachment requests
Controlling LU attachments to the network
Verifying partner LUs
Accepting remote attachment requests
Managing inbound IDs through DB2
Managing inbound IDs through RACF
Authenticating partner LUs
Encrypting passwords
Authenticating users through Kerberos
Translating inbound IDs
Associating inbound IDs with secondary IDs
Managing inbound TCP/IP-based connection requests
Processing of TCP/IP-based connection requests
Managing denial-of-service attacks
Preventing SQL injection attacks
Managing outbound connection requests
Communications database for the requester
SYSIBM.LUNAMES columns
SYSIBM.IPNAMES columns
SYSIBM.USERNAMES columns
SYSIBM.LOCATIONS columns
Processing of outbound connection requests
Translating outbound IDs
Sending passwords or password phrases
Sending RACF-encrypted passwords
Sending RACF PassTickets
Sending encrypted passwords or password phrases from DB2 for z/OS clients
Sending encrypted passwords from workstation clients
Managing access through row permissions and column masks
Row and column access control
Row permission
Column mask
Rules of row and column access control
Creating row permissions
Creating column masks
Modifying column masks to reference UDFs
Using INSERT on tables with row access control
Creating triggers for tables with row and column access control
Managing access through trusted contexts
Trusted contexts
Trusted connections
Defining trusted contexts
Creating local trusted connections
Establishing remote trusted connections by DB2 for z/OS requesters
Establishing remote trusted connections to DB2 for z/OS servers
Switching users of a trusted connection
Reusing a local trusted connection through the DSN command processor and DB2I
Reusing a remote trusted connection by DB2 for z/OS requesters
Reusing a remote trusted connection through DB2 for z/OS servers
Reusing a local trusted connection through RRSAF
Reusing a local trusted connection through the SQL CONNECT statement
Defining external security profiles
Enabling users to perform actions on behalf of others
Performing tasks on objects for other users
Managing access through data definition control
Data definition statements
Data definition control support
Registration tables
Installing data definition control support
Enabling data definition control
Controlling data definition by application name
Controlling data definition by application name with exceptions
Controlling data definition by object name
Controlling data definition by object name with exceptions
Registering object sets
Disabling data definition control
Managing registration tables and indexes
Creating registration tables and indexes
Naming registration tables and indexes
Dropping registration tables and indexes
Creating table spaces for registration tables
Adding columns to registration tables
Updating registration tables
Managing access through exit routines
Connection routines and sign-on routines
Specifying connection and sign-on routines
Sample connection and sign-on routines
When connection and sign-on routines are taken
Exit parameter list for connection and sign-on routines
Authorization ID parameter list for connection and sign-on routines
Input values for connection routines
Input values for sign-on routines
Expected output for connection and sign-on routines
Processing in sample connection and sign-on routines
Performance considerations for connection and sign-on routines
Debugging connection and sign-on routines
Session variables in connection and sign-on routines
Access control authorization exit routine
Specifying the access control authorization routine
The default access control authorization routine
When access control authorization routine is taken
Considerations for the access control authorization routine
When DB2 cannot provide an ACEE
Authorization IDs and ACEEs
Invalid and inoperative packages
Automatic rebind with DB2 roles
DB2 roles for the DYNAMICRULES(BIND) Option
Using DB2 roles for BINDAGENT
View authorization
Behavior of EXPLAIN STMTCACHE with the access control authorization routine
Dropping views
Caching of EXECUTE on plans, packages, and routines
Caching of dynamic SQL statements
Resolution of user-defined functions
Creating materialized query tables
Parameter list for access control authorization routines
Expected output for access control authorization routines
Handling return codes
Handling reason codes
Exception processing
Debugging access control authorization routines
Determining whether the access control authorization routine is active
RACF access control module
Protecting data through encryption and RACF
Encrypting your data with Secure Socket Layer support
AT-TLS configuration
SSL authentication level
Configuring SSL authentication levels
Creating and activating client certificate name filters
Configuring the DB2 server for SSL
Configuring the DB2 requester for SSL
Protecting data sets through RACF
Adding groups to control DB2 data sets
Creating generic profiles for data sets
Authorizing DB2 IDs to use data set profiles
Enabling DB2 IDs to create data sets
Encrypting your data through DB2 built-in functions
Defining columns for encrypted data
Defining column-level encryption
Creating views with column-level encryption
Using password hints with column-level encryption
Defining value-level encryption
Using password hints with value-level encryption
Encrypting non-character values
Using predicates for encrypted data
Optimizing performance of encrypted data
Auditing access to DB2
Determining active security measures
DB2 audit trace
Authorization IDs traced by auditing
Audit classes
Audit trace reports
Audit trace records
Limitations of the audit trace
Starting the audit trace
Stopping the audit trace
Collecting audit trace records
Formatting audit trace records
Auditing in a distributed data environment
DB2 audit policy
Audit category
Creating and activating audit policies
Auditing the use of an administrative authority
Auditing tables without specifying the AUDIT clause
Additional sources of audit information
Determining ID privileges and authorities
Auditing specific IDs or roles
Auditing specific tables
Ensuring data accuracy and integrity
Ensuring data presence and uniqueness
Protecting data integrity
Tracking data changes
Checking for lost and incomplete transactions
Ensuring data consistency
Using referential integrity for data consistency
Using locks for data consistency
Checking data consistency
Checking data consistency with SQL queries
Checking data consistency with the CHECK utilities
Checking data consistency with the DISPLAY DATABASE command
Checking data consistency with the REPORT utility
Checking data consistency with the operation log
Checking data consistency with internal integrity reports
Index for managing security
Managing security with the RACF access control module
Introduction to the RACF access control module
RACF checking for DB2 resources
Multilevel security
The DB2 access control authorization exit point
The default DB2 exit routine
When the RACF access control module is invoked
When the RACF access control module is bypassed
Planning
Mapping out the implementation tasks: A task roadmap
Identifying skill requirements
Planning for migration
Migrating from DB2 internal security
Sharing the RACF database
Choosing the RACF access control module customization options
Choosing the class scope
System considerations
Choosing the class name root and suffix
Choosing the error option
Customizing the number of exit work area cells
Planning RACF security for DB2
Installing the RACF access control module
Installing the RACF access control module
Testing that your exit routine is active
RACF informational messages
Defining classes for the RACF access control module
Defining class names for DB2 objects
Defining class names for DB2 objects in single-subsystem scope
Defining class names for DB2 objects in multiple-subsystem scope
Defining class names for administrative authorities
Defining class names for DB2 administrative authorities in single-subsystem scope
Defining class names for DB2 administrative authorities in multiple-subsystem scope
Protecting DB2 objects
DB2 object types
Defining resource names for DB2 objects
Using generic RACF profiles
DB2 object types and object names
Long object names
Privilege names
Protecting DB2 administrative authorities
Defining resource names for administrative authorities
DB2 administrative authorities and object names
Making your new RACF resources effective
If the class was not active
If the class was active
Debugging the RACF access control module
Dump titles for the RACF access control module
Using the content of XAPLDIAG
Parameter list for the access control authorization routine
Implicit privileges of ownership
Authorization and ownership checking with roles
Auditing for the RACF access control module
Example of resource checking
Using log string data
Examples for setting audit controls for DB2
Special considerations
Materialized query tables
DB2 data sharing
Authorization checking for implicitly created databases
Authorization checking for operations on views
Access to privileges based on factors other than RACF profiles
Implicit privileges of ownership
Matching schema names
Implicit privileges of ownership from other objects
Logging the Use of Administrative Authorities
Processing cache requests
CREATETMTAB privilege
CREATE VIEW privilege
CREATE ALIAS privilege
"Any table" privilege
"Any schema" privilege
UPDATE and REFERENCES authorization on DB2 table columns
The XAPLDIAG output parameter
DB2 aliases for system-directed access
Considerations for remote and local resources
DB2 GRANT statements
DB2 object names with blank characters
DB2 object names with special characters
Authority checking for all packages in a collection
AUTOBIND requests for user-defined functions
Identity used for authorization checks
When DB2 cannot provide an ACEE
Authorization ID, ACEE relationship
Invalid or inoperative packages
Dropping views
Caching of EXECUTE on plans
Caching of EXECUTE on packages and routines
Caching of dynamic SQL statements
Resolution of user-defined functions
Setting up profiles for DB2 roles
CREATE and BIND processing
Initialization
Failure to initialize
Return codes and reason codes from initialization
Deferring to native DB2 authorization
Removing the RACF access control module
Common problems and considerations
XAPLFUNC reference
Initialization (XAPLFUNC = 1)
Authorization checking (XAPLFUNC = 2)
FASTAUTH return code translation
Termination (XAPLFUNC = 3)
Supplied RACF resource classes for DB2
Authorization processing examples
Example 1: Allowing access (auditing for failures)
Example 2: Allowing access (auditing for all attempts)
Example 3: Denying access
Example 4: Deferring to DB2
Example 5: Allowing access (multiple-subsystem scope)
Example 6: Allowing access (single-subsystem scope)
RACF authorization checking reference
How to set the level of access
Buffer pool privileges
Collection privileges
Database privileges
Java archive (JAR) privileges
Package privileges
Plan privileges
Role privileges
Schema privileges
Sequence privileges
Storage group privileges
Stored procedure privileges
System privileges
Table privileges
Table space privileges
Trusted context privileges
User-defined distinct type privileges
User-defined function privileges
View privileges
DB2 RACF access control module messages
IRR900A
IRR901A
IRR902A
IRR903A
IRR904I
IRR905I
IRR906I
IRR907I
IRR908I
IRR909I
IRR910I
IRR911I
IRR912I
IRR913I
IRR914I
IRR915I
IRR916I
Index for RACF Access Control Module
Managing DB2 performance
Managing performance
Planning your performance strategy
Managing performance in general
Setting performance objectives and defining your workloads
Sizing your workloads
Translating resource requirements into performance objectives
Reviewing performance during external design
Reviewing performance during internal design
Reviewing performance during coding and testing
Reviewing performance after development
Planning to review performance data
Typical review questions
Validating your performance objectives
Managing system performance
z/OS performance options for DB2
Determining z/OS Workload Manager velocity goals
How DB2 assigns I/O priorities
Managing I/O processing, response time, and throughput
Controlling the number of I/O operations
Read operations
Prefetch I/O
The number of pages read by prefetch
Write operations
Making buffer pools large enough for the workload
Making I/O operations faster
Distributing data sets efficiently
Putting frequently used data sets on fast devices
Distributing the I/O
Partitioning schemes and data clustering for partitioned table spaces
Increasing the number of data sets for an index
Creating additional work file table spaces to reduce contention
Improving space allocation and pre-formatting
Avoiding excessively small extents
Enabling index I/O parallelism for INSERT operations
Configuring storage for performance
Storage servers and channel subsystems
Balancing the storage controller cache and buffer resources
Improving the use of real and virtual storage
Tuning database buffer pools
Buffer pool pages
Deciding whether to create additional buffer pools
Assigning table spaces and indexes to buffer pools
Buffer pool thresholds
Fixed buffer pool thresholds
Buffer pool thresholds that you can change
Guidelines for setting buffer pool thresholds
Choosing buffer pool sizes
Enabling automatic buffer pool size management
Allocating buffer pool storage to avoid paging
Choosing a page-stealing algorithm
Fixing a buffer pool in real storage
Designing EDM storage space for performance
EDM storage
Measuring the efficiency of EDM pools
Calculating the EDM statement cache hit ratio
Controlling DBD size for large databases
Increasing RID pool size
Improving the performance of sort processing
How sort work files are allocated
Managing the opening and closing of data sets
How DB2 determines the initial value of DSMAX
Evaluating the value of DSMAX
Switching to read-only for infrequently updated and infrequently accessed page sets
Improving disk storage
Selecting storage devices
Storage servers
Storage servers and advanced features
Using disk space effectively
Allocating and extending data sets
Planning the placement of DB2 data sets
Estimating concurrent I/O requests
Identifying crucial DB2 data sets
Changing catalog and directory size and location
Improving space allocation and pre-formatting
Avoiding excessively small extents
Configuring subsystems for concurrency
Estimating the storage needed for locks
IRLM startup procedure options
Setting installation options for wait times
Specifying the interval for detecting deadlocks
Specifying the amount of inactive time before a timeout
How DB2 calculates the wait time for timeouts
Specifying how long an idle thread can use resources
Specifying how long utilities wait for resources
Calculating wait times for drains
Optimizing subsystem parameters
Optimizing subsystem parameters for SQL statements by using profiles
Improving DB2 log performance
Improving log write performance
Types of log writes
Improving log read performance
Log statistics
Calculating average log record size
Improving log capacity
Total capacity and the number of logs
Choosing a checkpoint frequency
Increasing the number of active log data sets
Setting the size of active log data sets
Controlling the amount of log data
Controlling log size for utilities
Controlling log size for SQL operations
Managing DB2 threads
Setting thread limits
How DB2 allocates allied threads
Distributed database access threads
Controlling allocation and deallocation processing for database access threads
Setting thread limits for database access threads
Pooling of INACTIVE MODE threads for DRDA-only connections
Advantages of database access threads in INACTIVE mode
Enabling threads to be pooled
Timing out idle active threads
Variations on thread management
Reusing threads
Reusing threads through bind options
Analyzing the reuse of threads
Reusing threads for remote connections
Setting performance objectives by using z/OS Workload Manager
Classifying DDF threads
Classification attributes
Establishing performance periods for DDF threads
Establishing performance objectives for DDF threads
Setting CICS options for threads
Setting IMS options for threads
Setting TSO options for threads
Setting DB2 QMF options for threads
Tuning parallel processing
Disabling query parallelism
Improving the performance of stored procedures and user-defined functions
Maximizing the number of procedures or functions that run in an address space
Assigning stored procedures and functions to WLM application environments
Accounting for nested activities
Providing cost information, for accessing user-defined table functions, to DB2
Controlling resource usage
The DB2 system monitor
Limiting resources for a stored procedure
Setting limits for system resource usage by using the resource limit facility
Using reactive governing
Using predictive governing
Combining reactive and predictive governing
Limiting resource usage for packages
Limiting resource usage by client information for middleware servers
Managing resource limit tables
Creating resource limit tables
Populating resource limit tables
Starting and stopping resource limit tables
Restricted activity on resource limit tables
Governing statements from a remote site
Calculating service unit values for resource limit tables
Restricting bind operations
Restricting parallelism modes
Reducing processor resource consumption
Reusing threads for your high-volume transactions
Minimizing the use of DB2 traces
Improving concurrency
Concurrency and locks
Lock contention
Investigating and resolving timeout situations
Transaction locks
Lock size
The duration of a lock
Lock modes
Objects that are subject to locks
Indexes and data-only locking
Contention on the DB2 catalog
Locks on the skeleton tables (SKCT and SKPT)
Locks on the database descriptors (DBDs)
How DB2 chooses lock types
Locks acquired for SQL statements
Lock promotion
Lock escalation
Modes of transaction locks for various processes
Controlling DB2 locks for LOBs
LOB locks
Relationship between transaction locks and LOB locks
Hierarchy of LOB locks
LOB and LOB table space lock modes
LOB lock and LOB table space lock duration
When LOB table space locks are not taken
Controlling DB2 locks for XML data
XML locks
Locks that are acquired for operations on XML data
Hierarchy of XML locks
XML and XML table space lock modes
XML lock and XML table space lock duration
When XML table space locks are not taken
Claims and drains for concurrency control
Claims
Drains
How DB2 uses drain locks
Concurrency during REORG
Utility operations with nonpartitioned indexes
Utility locks on the catalog and directory
Compatibility of utilities
Designing databases for performance
Choosing data page sizes
Designing databases for concurrency
Specifying the maximum number of locks that a single process can hold
Specify the size of locks for a table space
Specifying the maximum number of locks that a process can hold on a table space
Controlling the number of LOB locks
Controlling the number of XML locks
Controlling XML lock escalation
Specifying a default value for the LOCKMAX option
Specifying lock modes for statements bound with ISOLATION RR or RS
Disabling update locks for searched UPDATE and DELETE
Avoiding locks during predicate evaluation
Disregarding uncommitted inserts
Organizing tables by hash for fast access to individual rows
Managing space and page size for hash-organized tables
Fine-tuning hash space and page size
Using materialized query tables to improve SQL performance
Configuring automatic query rewrite
Materialized query tables and automatic query rewrite
Queries that are eligible for rewrite
How DB2 considers automatic query rewrite
Automatic query rewrite—complex examples
Determining whether query rewrite occurred
Enabling automatic query rewrite
Creating a materialized query table
Rules for materialized query table
Registering an existing table as a materialized query table
Altering an existing materialized query table
Populating and maintaining materialized query tables
Populating a new materialized query table
Refreshing a system-maintained materialized query table
Refreshing user-maintained materialized query tables
Updating statistics on materialized query tables
Rules for using materialized query tables in a multilevel security environment
Enabling a materialized query table for automatic query rewrite
Recommendations for materialized query table and base table design
Designing materialized query tables for automatic query rewrite
Designing base tables for automatic query rewrite
Materialized query tables—examples shipped with DB2
Enabling efficient access for queries on star schemas
Indexes for efficient star schema processing
Improving performance for LOB data
Reserving free space
Compressing your data
Deciding whether to compress data
Calculating the space that is required for a dictionary
Calculating disk requirements for a dictionary
Calculating virtual storage requirements for a dictionary
Increasing free space for compressed data
Determining the effectiveness of compression
Evaluating your indexes
Choosing index page sizes
Eliminating unnecessary partitioning indexes
Dropping indexes that were created to avoid sorts
Using non-padded indexes
Compressing indexes
Index splitting for sequential INSERT activity
Programming applications for performance
Programming for concurrency
Bind options for locks
Choosing ACQUIRE and RELEASE options
Choosing an ISOLATION option
The ISOLATION (CS) option
The ISOLATION (UR) option
The ISOLATION (RS) option
The ISOLATION (RR) option
Choosing a CURRENTDATA option
The CURRENTDATA option for local access
CURRENTDATA for remote access
Lock avoidance
Problems with ambiguous cursors
Conflicting plan and package bind options
Using SQL statements to override isolation levels
Locking a table explicitly
When to use LOCK TABLE
The effect of LOCK TABLE
Recommendations for using LOCK TABLE
How access paths effect locks
Explicitly locking LOB tables
Controlling lock size for LOB table spaces
Explicitly locking XML data
Specifying the size of locks for XML data
Accessing currently committed data to avoid lock contention
Accessing currently committed data with a PREPARE statement
Accessing currently committed data with stored procedures
Accessing currently committed data with functions
Improving concurrency for applications that tolerate incomplete results
Writing efficient queries
Coding SQL statements as simply as possible
Coding queries with aggregate functions efficiently
Using non-column expressions efficiently
Materialized query tables and query performance
Encrypted data and query performance
XML data and query performance
Best practices for XML performance in DB2
Using predicates efficiently
Predicates
Predicate types
Indexable and non-indexable predicates
Stage 1 and stage 2 predicates
Boolean term predicates
Examples of predicate properties
When DB2 evaluates predicates
Summary of predicate processing
Ensuring that predicates are coded correctly
Predicate filter factors
Default filter factors for simple predicates
Filter factors for uniform distributions
Interpolation formulas
Filter factors for all distributions
Histogram statistics
How DB2 uses multiple filter factors to determine the cost of a query
Filter factor estimation for the XMLEXISTS predicate
Avoiding problems with correlated columns
Correlated columns
Impacts of correlated columns
Detecting correlated columns
Adding extra predicates to improve access paths
Predicate manipulation
How DB2 modifies IN predicates
How DB2 simplifies join operations
Predicates generated through transitive closure
Transformation of SQL predicates to XML predicates
Predicates with encrypted data
Using host variables efficiently
Writing efficient subqueries
Correlated and non-correlated subqueries
When DB2 transforms a subquery into a join
When DB2 correlates and de-correlates subqueries
Subquery tuning
Using scrollable cursors efficiently
Efficient queries for tables with data-partitioned secondary indexes
Making predicates eligible for index on expression
Improving the performance of queries for special situations
Using the CARDINALITY clause to improve the performance of queries with user-defined table function references
Reducing the number of matching columns
Rearranging the order of tables in a FROM clause
Improving outer join processing
Using a subsystem parameter to optimize queries with IN predicates
Providing more information to DB2 for access path selection
Fetching a limited number of rows
Minimizing the cost of retrieving few rows
Interaction between FETCH FIRST and OPTIMIZE FOR clauses
Favoring index access
Programming for parallel processing
Parallel processing
Methods of parallel processing
Partitioning for optimal parallel performance
Determining if a query is I/O- or processor-intensive
Determining the number of partitions for parallel processing
Working with a table space that is already partitioned
Making the partitions the same size
Working with partitioned indexes
Enabling parallel processing
Restrictions for parallelism
Improving performance for applications that access distributed data
Remote access
Application and requesting systems
BIND options for distributed applications
Improving performance for SQL statements in distributed applications
The effect of the OPTIMIZE FOR n ROWS clause in distributed applications
Fast implicit close
Ensuring block fetch
Continuous block fetch
Limited block fetch
Block fetch with scrollable cursors for DRDA
LOB and XML data and its effect on block fetch for DRDA
Optimizing for very large results sets for DRDA
Optimizing for small results sets for DRDA
Data encryption security options
Serving system
Maintaining data organization and statistics
Maintaining data organization
Determining when to reorganize indexes
LEAFNEAR and LEAFFAR columns
Deciding when to reorganize table spaces
Reorganizing LOB table spaces
Maintaining statistics in the catalog
Deciding whether to rebind after gathering statistics
Automating statistics maintenance
Autonomic statistics overview
Specifying time windows for collecting autonomic statistics
Scheduling autonomic statistics monitoring
Defining the scope of autonomic statistics monitoring
Scheduling log and alert history cleanup for autonomic statistics
ADMIN_UTL_MONITOR stored procedure
ADMIN_UTL_MODIFY stored procedure
ADMIN_UTL_EXECUTE stored procedure
Statistics used for access path selection
Filter factors and catalog statistics
How clustering affects access path selection
Additional statistics that provide index costs
Histogram statistics
Statistics for partitioned table spaces
Dynamic collection of index filtering estimates
Setting default statistics for created temporary tables
Collecting statistics by partition
Collecting history statistics
History statistics
Setting up your system for real-time statistics
When DB2 externalizes real-time statistics
How SQL operations affect real-time statistics counters
How utilities affect the real-time statistics
How LOAD affects real-time statistics
How REORG affects real-time statistics
How REBUILD INDEX affects real-time statistics
How RUNSTATS affects real-time statistics
How COPY affects real-time statistics
How RECOVER affects real-time statistics
Preventing inaccurate real-time statistics from non-DB2 utility operations
How creating objects affects real-time statistics
How dropping objects affects real-time statistics
Real-time statistics for special objects
Real-time statistics in data sharing
How the EXCHANGE command affects real-time statistics
How real-time statistics affect sort work data set allocation for DB2 utilities
Improving concurrency for real-time statistics data
Recovering the real-time statistics tables
Statistics accuracy
DSNACCOX stored procedure
DSNACCOR stored procedure
Updating catalog statistics to influence access path selection
Correlations in the catalog
Recommendation for COLCARDF and FIRSTKEYCARDF
Updating HIGH2KEY and LOW2KEY values
Statistics for distributions
Recommendation for using the TIMESTAMP column
Managing query access paths
Managing access path change at migration from Version 9
Managing access paths at migration from Version 8
Managing access path changes for periodic maintenance
Reusing and comparing access paths at bind and rebind
How DB2 identifies packages for reuse under BIND PACKAGE commands
Analyzing access path changes at bind or rebind
Rebinding packages when access path reuse fails
Switching to previous access paths
Plan management polices
Package copies
Saving access path information for static SQL statements
Maintaining copies of access paths by using profiles
Reverting to saved access paths for static SQL statements
Freeing saved access paths for static SQL statements
Influencing access path selection by using optimization hints
Optimization hints
Enabling optimization hints
Creating statement-level optimization hints and parameters
Suggesting access paths by creating statement level access path hints
Specifying statement-level optimization parameters
Populating query text for statement-level optimization hints
Looking up statement-level optimization hints
Deleting statement-level optimization hints
Creating PLAN_TABLE hints
How DB2 validates optimization hints
Coexistence of optimization hints
Limitations on optimization hints
Reoptimizing SQL statements at run time
Capturing reoptimized access paths
Reoptimization for statements with replaced literal values
Monitoring performance
Planning for performance monitoring
Continuous performance monitoring
Planning for periodic monitoring
Detailed performance monitoring
Exception performance monitoring
Tools and functions for performance monitoring
DB2 trace
Minimizing the effects of traces on DB2 performance
Types of DB2 traces
Statistics trace
Accounting trace
Audit trace
Performance trace
Monitor trace
Recording SMF trace data
Activating SMF
Allocating SMF buffers
Reporting data in SMF
Recording GTF trace data
Investigating SQL performance with EXPLAIN
IBM Tivoli OMEGAMON XE
Tivoli Decision Support for z/OS
Response time reporting
Using z/OS, CICS, and IMS tools
Monitoring system resources
Monitoring transaction manager throughput
Using profiles to monitor and optimize performance
Profiles
Creating profiles
Starting and stopping profiles
Monitoring threads and connections by using profiles
Programming for the instrumentation facility interface (IFI)
Submitting DB2 commands through IFI
Obtaining trace data through IFI
Passing data to DB2 through IFI
IFI functions
Invoking IFI from your program
Using IFI from stored procedures
COMMAND: Syntax and usage with IFI
Authorization for DB2 commands through IFI
Syntax for DB2 commands through IFI
Using READS requests through IFI
Authorization for READS requests through IFI
Syntax for READS requests through IFI
Which qualifications are used for READS requests issued through IFI?
Synchronous data and READS requests through IFI
Monitoring static SQL statements with READS calls
Monitoring the dynamic statement cache with READS calls
Monitoring deadlocks and timeouts with READS calls
Controlling the collection of SQL statement-level statistics
Using READA requests through IFI
Authorization for READA requests through IFI
Syntax for READA requests through IFI
Asynchronous data and READA requests through IFI
How DB2 processes READA requests through IFI
Using WRITE requests through IFI
Authorization for WRITE requests through IFI
Syntax for WRITE requests through IFI
Common communication areas for IFI calls
Instrumentation facility communications area (IFCA)
Return area
IFCID area
Output area
Using IFI in a data sharing group
Data integrity and IFI
Auditing data and IFI
Improving concurrency for IFI
Recovery considerations for IFI
Errors and IFI
Monitoring use of IBM specialty engines
IBM System z Integrated Information Processors
IBM System z Application Assist Processor
Monitoring the use of accelerators for DB2 for z/OS queries
Accelerators for DB2 for z/OS queries
Monitoring I/O and storage
Monitoring I/O activity of data sets
Monitoring and tuning buffer pools using online commands
The buffer pool hit ratio
Using OMEGAMON to monitor buffer pool statistics
Monitoring work file data sets
Monitoring statistics
Monitoring concurrency and locks
Scenario for analyzing concurrency
Analyzing concurrency
Concurrency in the accounting report
Lock suspension report
Lockout report
Lockout trace
Corrective decisions
OMEGAMON online locking conflict display
Using the statistics and accounting traces to monitor locking
Using EXPLAIN to identify locks chosen by DB2
Deadlock detection scenarios
Scenario: Two-way deadlock with two resources
Scenario: Three-way deadlock with three resources
Monitoring SQL performance
Monitoring SQL performance with IBM optimization tools
DB2-supplied user tables for optimization tools
Collecting statement-level statistics for SQL statements
Granting authorities for monitoring and tuning SQL statements
Using EXPLAIN to capture information about SQL statements.
Creating EXPLAIN tables
Capturing EXPLAIN information
Capturing EXPLAIN information under DB2 QMF
Parameter markers in place of host variables
When to use a constant
Static and dynamic queries
DSNAEXP stored procedure
Working with and retrieving EXPLAIN table data
Retrieving EXPLAIN table rows for a plan
Retrieving EXPLAIN table rows for a package
Correlating information across EXPLAIN tables
Columns for correlating EXPLAIN tables
Deleting EXPLAIN table rows
Monitoring hash access
Gathering information about SQL statements for IBM Software Support
Checking for invalid packages
Monitoring parallel operations
Monitoring DB2 in a distributed environment
The DISPLAY command
Tracing distributed events
Reporting server-elapsed time
Monitoring distributed processing with RMF
Duration of an enclave
RMF records for enclaves
Analyzing performance data
A general approach to problem analysis in DB2
Interpreting DB2 trace output
The sections of the trace output
SMF writer header section
GTF writer header section
Self-defining section
Reading the self-defining section for same-length data items
Reading the self-defining section for variable-length data items
Product section
Trace field descriptions
OMEGAMON accounting reports
The accounting report (short format)
The accounting report (long format)
Instrumentation facility interface (IFI) records
Trace data record format
Command record format
Interpreting data access by using EXPLAIN
Table space scan access(ACCESSTYPE='R' and PREFETCH='S')
Aggregate function access (COLUMN_FN_EVAL)
Hash access (ACCESSTYPE='H','HN', or 'MH')
Index access (ACCESSTYPE is 'I', 'IN', 'I1', 'N', 'MX', or 'DX')
Overview of index access
Costs of indexes
Indexes to avoid sorts
Index access paths
Matching index scan (MATCHCOLS>0)
The number of index columns used for matching (MATCHCOLS=n)
Index screening
Nonmatching index scan (ACCESSTYPE='I' and MATCHCOLS=0)
IN-list access (ACCESSTYPE='N' or 'IN')
Multiple index access (ACCESSTYPE='M', 'MX', 'MI', 'MU', 'DX', 'DI', or 'DU')
One-fetch access (ACCESSTYPE='I1')
Index-only access (INDEXONLY='Y')
Equal unique index (MATCHCOLS=number of index columns)
Index access for MERGE
Index access for UPDATE
Range-list index scan (ACCESSTYPE='NR')
Direct row access (PRIMARY_ACCESSTYPE='D')
Predicates that qualify for direct row access
Reverting to ACCESSTYPE
Access methods that prevent direct row access
Example: Coding with row IDs for direct row access
Scans limited to certain partitions (PAGE_RANGE='Y')
Parallel processing access (PARALLELISM_MODE='I', 'C', or 'X')
Complex trigger WHEN clause access (QBLOCKTYPE='TRIGGR')
Prefetch access paths (PREFETCH='D', 'S', 'L', or 'U')
Dynamic prefetch
Sequential prefetch
List prefetch
Sort access
Sorts of data
Sorts of RIDs
The effect of sorts on OPEN CURSOR
Join operations
Cartesian join with small tables first
Nested loop join (METHOD=1)
When a MERGE statement is used (QBLOCK_TYPE ='MERGE')
Merge scan join (METHOD=2)
Hybrid join (METHOD=4)
Star schema access
Star join access (JOIN_TYPE='S')
Pair-wise join access (JOIN_TYPE='P')
Enabling data caching for star schema queries
Subquery access
View and nested table expression access
Merge processing
Materialization
Performance of merge versus materialization
Using EXPLAIN to determine when materialization occurs
Using EXPLAIN to determine UNION, INTERSECT, and EXCEPT activity and query rewrite
Interpreting query parallelism
Examining PLAN_TABLE columns for parallelism
PLAN_TABLE examples showing parallelism
Estimating the cost of SQL statements
Cost categories
Retrieving rows from a statement table
Testing DB2 performance
Modeling a production environment on a test subsystem
Modeling your production system statistics in a test subsystem
Index for managing performance
Programming for DB2
Application programming and SQL
Planning for and designing DB2 applications
Application and SQL release incompatibilities for migration from Version 8
Application and SQL release incompatibilities for migration from Version 9.1
Determining the value of any SQL processing options that affect the design of your program
Determining the binding method
Changes that invalidate packages
Determining the value of any bind options that affect the design of your program
Programming applications for performance
Designing your application for recovery
Unit of work in TSO
Unit of work in CICS
Planning for program recovery in IMS programs
Unit of work in IMS online programs
Specifying checkpoint frequency in IMS programs
Checkpoints in IMS programs
Recovering data in IMS programs
Undoing selected changes within a unit of work by using savepoints
Planning for recovery of table spaces that are not logged
Designing your application to access distributed data
Remote servers and distributed data
Preparing for coordinated updates to two or more data sources
Forcing restricted system rules in your program
Creating a feed in IBM Mashup Center with data from a DB2 for z/OS server
Writing DB2 applications
Connecting to DB2 from your application program
Invoking the call attachment facility
Call attachment facility
Properties of CAF connections
Attention exit routines for CAF
Recovery routines for CAF
Making the CAF language interface (DSNALI) available
Requirements for programs that use CAF
How CAF modifies the content of registers
Implicit connections to CAF
CALL DSNALI statement parameter list
Summary of CAF behavior
CAF connection functions
CONNECT function for CAF
OPEN function for CAF
CLOSE function for CAF
DISCONNECT function for CAF
TRANSLATE function for CAF
Turning on a CAF trace
CAF return codes and reason codes
Sample CAF scenarios
Examples of invoking CAF
Invoking the Resource Recovery Services attachment facility
Resource Recovery Services attachment facility
Properties of RRSAF connections
Making the RRSAF language interface (DSNRLI) available
Requirements for programs that use RRSAF
How RRSAF modifies the content of registers
Implicit connections to RRSAF
CALL DSNRLI statement parameter list
Summary of RRSAF behavior
RRSAF connection functions
IDENTIFY function for RRSAF
SWITCH TO function for RRSAF
SIGNON function for RRSAF
AUTH SIGNON function for RRSAF
CONTEXT SIGNON function for RRSAF
SET_ID function for RRSAF
SET_CLIENT_ID function for RRSAF
CREATE THREAD function for RRSAF
TERMINATE THREAD function for RRSAF
TERMINATE IDENTIFY function for RRSAF
TRANSLATE function for RRSAF
FIND_DB2_SYSTEMS function for RRSAF
RRSAF return codes and reason codes
Sample RRSAF scenarios
Program examples for RRSAF
Universal language interface
Link-editing an application with DSNULI
Controlling the CICS attachment facility from an application
Detecting whether the CICS attachment facility is operational
Improving thread reuse in CICS applications
Coding SQL statements in application programs: General information
Declaring table and view definitions
DCLGEN (declarations generator)
Generating table and view declarations by using DCLGEN
Generating table and view declarations by using DCLGEN from DB2I
Data types that DCLGEN uses for variable declarations
Including declarations from DCLGEN in your program
Example: Adding DCLGEN declarations to a library
Defining the items that your program can use to check whether an SQL statement executed successfully
Defining SQL descriptor areas
Declaring host variables and indicator variables
Host variables
Host variable arrays
Host structures
Indicator variables, arrays, and structures
Setting the CCSID for host variables
Determining what caused an error when retrieving data into a host variable
Accessing an application defaults module
Compatibility of SQL and language data types
Embedding SQL statements in your application
Delimiting an SQL statement
Rules for host variables in an SQL statement
Retrieving a single row of data into host variables
Determining whether a retrieved value in a host variable is null or truncated
Determining whether a column value is null
Updating data by using host variables
Inserting a single row by using a host variable
Inserting null values into columns by using indicator variables or arrays
Host variable arrays in an SQL statement
Retrieving multiple rows of data into host variable arrays
Inserting multiple rows of data from host variable arrays
Retrieving a single row of data into a host structure
Including dynamic SQL in your program
Dynamic SQL
Differences between static and dynamic SQL
Possible host languages for dynamic SQL applications
Including dynamic SQL for non-SELECT statements in your program
Including dynamic SQL for fixed-list SELECT statements in your program
Including dynamic SQL for varying-list SELECT statements in your program
Dynamically executing an SQL statement by using EXECUTE IMMEDIATE
Dynamically executing an SQL statement by using PREPARE and EXECUTE
Dynamically executing a data change statement
Dynamically executing a statement with parameter markers by using the SQLDA
Enabling the dynamic statement cache
Dynamic SQL statements that DB2 can cache
Conditions for statement sharing
Finding information about statements in the statement cache
Keeping prepared statements after commit points
Limiting CPU time for dynamic SQL statements by using the resource limit facility
Reactive governing
Predictive governing
Checking the execution of SQL statements
Checking the execution of SQL statements by using the SQLCA
Displaying SQLCA fields by calling DSNTIAR
DSNTIAR
Defining a message output area
Possible return codes from DSNTIAR
A scenario for using DSNTIAR
Checking the execution of SQL statements by using SQLCODE and SQLSTATE
Checking the execution of SQL statements by using the WHENEVER statement
Checking the execution of SQL statements by using the GET DIAGNOSTICS statement
Data types for GET DIAGNOSTICS items
Handling SQL error codes
Arithmetic and conversion errors
Writing applications that enable users to create and modify tables
Saving SQL statements that are translated from end user requests
XML data in embedded SQL applications
Host variable data types for XML data in embedded SQL applications
XML column updates in embedded SQL applications
XML data retrieval in embedded SQL applications
Programming examples
Examples of programs that call stored procedures
Coding SQL statements in assembler application programs
Defining the SQL communications area, SQLSTATE, and SQLCODE in assembler
Defining SQL descriptor areas in assembler
Declaring host variables and indicator variables in assembler
Host variables in assembler
Indicator variables in assembler
Equivalent SQL and assembler data types
SQL statements in assembler programs
Delimiters in SQL statements in assembler programs
Macros for assembler applications
Programming examples in assembler
Coding SQL statements in C application programs
Defining the SQL communications area, SQLSTATE, and SQLCODE in C
Defining SQL descriptor areas in C
Declaring host variables and indicator variables in C
Host variables in C
Host variable arrays in C
Host structures in C
Indicator variables, indicator arrays, and host structure indicator arrays in C
Referencing pointer host variables in C programs
Declaring pointer host variables in C programs
Equivalent SQL and C data types
SQL statements in C programs
Delimiters in SQL statements in C programs
Programming examples in C
Sample dynamic and static SQL in a C program
Example C program that calls a stored procedure
Example C stored procedure with a GENERAL linkage convention
Example C stored procedure with a GENERAL WITH NULLS linkage convention
Coding SQL statements in COBOL application programs
Defining the SQL communications area, SQLSTATE, and SQLCODE in COBOL
Defining SQL descriptor areas in COBOL
Declaring host variables and indicator variables in COBOL
Host variables in COBOL
Host variable arrays in COBOL
Host structures in COBOL
Indicator variables, indicator arrays, and host structure indicator arrays in COBOL
Controlling the CCSID for COBOL host variables
Equivalent SQL and COBOL data types
SQL statements in COBOL programs
Delimiters in SQL statements in COBOL programs
Object-oriented extensions in COBOL
Programming examples in COBOL
Sample COBOL dynamic SQL program
Sample COBOL program with CONNECT statements
Sample COBOL program using aliases for three-part names
Example COBOL stored procedure with a GENERAL WITH NULLS linkage convention
Example COBOL stored procedure with a GENERAL linkage convention
Example COBOL program that calls a stored procedure
Coding SQL statements in Fortran application programs
Defining the SQL communications area, SQLSTATE, and SQLCODE in Fortran
Defining SQL descriptor areas in Fortran
Declaring host variables and indicator variables in Fortran
Host variables in Fortran
Indicator variables in Fortran
Equivalent SQL and Fortran data types
SQL statements in Fortran programs
Delimiters in SQL statements in Fortran programs
Coding SQL statements in PL/I application programs
Defining the SQL communications area, SQLSTATE, and SQLCODE in PL/I
Defining SQL descriptor areas in PL/I
Declaring host variables and indicator variables in PL/I
Host variables in PL/I
Host variable arrays in PL/I
Host structures in PL/I
Indicator variables in PL/I
Equivalent SQL and PL/I data types
SQL statements in PL/I programs
Delimiters in SQL statements in PL/I programs
Programming examples in PL/I
Example PL/I program that calls a stored procedure
Example PL/I stored procedure with a GENERAL linkage convention
Example PL/I stored procedure with a GENERAL WITH NULLS linkage convention
Coding SQL statements in REXX application programs
Defining the SQL communications area, SQLSTATE, and SQLCODE in REXX
Defining SQL descriptor areas in REXX
Equivalent SQL and REXX data types
SQL statements in REXX programs
Delimiters in SQL statements in REXX programs
Accessing the DB2 REXX language support application programming interfaces
Ensuring that DB2 correctly interprets character input data in REXX programs
Passing the data type of an input data type to DB2 for REXX programs
Setting the isolation level of SQL statements in a REXX program
Retrieving data from DB2 tables in REXX programs
Cursors and statement names in REXX
Programming examples in REXX
Sample DB2 REXX application
Example of how an indicator variable is used in a REXX program
Creating and modifying DB2 objects
Creating tables
Data types
Storing LOB data in a table
Large objects (LOBs)
Implicitly hidden ROWID columns
Identity columns
Creating tables for data integrity
Ways to maintain data integrity
Check constraints
CHECK-pending status
Referential constraints
Restrictions on cycles of dependent tables
Referential constraints on tables with multilevel security with row-level granularity
Informational referential constraints
Defining a parent key and unique index
Parent key columns
Defining a foreign key
Maintaining referential integrity when using data encryption
Creating work tables for the EMP and DEPT sample tables
Creating created temporary tables
Temporary tables
Creating declared temporary tables
Providing a unique key for a table
Fixing tables with incomplete definitions
Dropping tables
Defining a view
Views
Dropping a view
Creating a common table expression
Common table expressions
Examples of recursive common table expressions
Creating triggers
Invoking a stored procedure or user-defined function from a trigger
Inserting, updating, and deleting data in views by using INSTEAD OF triggers
Trigger packages
Trigger cascading
Order of multiple triggers
Interactions between triggers and referential constraints
Interactions between triggers and tables that have multilevel security with row-level granularity
Triggers that return inconsistent results
Sequence objects
DB2 object relational extensions
Creating a distinct type
Distinct types
Example of distinct types, user-defined functions, and LOBs
Defining a user-defined function
User-defined functions
External user-defined functions
SQL scalar functions
SQL table functions
Sourced functions
Components of a user-defined function definition
Writing an external user-defined function
Parameters for external user-defined functions
Making a user-defined function reentrant
Using special registers in a user-defined function or a stored procedure
Accessing transition tables in a user-defined function or stored procedure
Preparing an external user-defined function for execution
Abnormal termination of an external user-defined function
Saving information between invocations of a user-defined function by using a scratchpad
Example of creating and using a user-defined scalar function
User-defined function samples that ship with DB2
Determining the authorization cache size for stored procedures and user-defined functions
Creating a stored procedure
Stored procedures
Stored procedure parameters
Example of a simple stored procedure
SQL procedures
SQL procedure body
Examples of SQL procedures
External stored procedures
Differences between SQL procedures and external procedures
COMMIT and ROLLBACK statements in a stored procedure
Special registers in a stored procedure
Creating a native SQL procedure
Controlling the scope of variables in an SQL procedure
Nested compound statements in native SQL procedures
Statement labels for nested compound statements in native SQL procedures
Declaring cursors in an SQL procedure with nested compound statements
Handling SQL conditions in an SQL procedure
Handlers in an SQL procedure
Defining condition handlers that execute more than one statement
Controlling how errors are handled within different scopes in an SQL procedure
Retrieving diagnostic information by using GET DIAGNOSTICS in a handler
Ignoring a condition in an SQL procedure
Raising a condition within an SQL procedure by using the SIGNAL or RESIGNAL statements
Example of the SIGNAL statement in an SQL procedure
Example of the RESIGNAL statement in a handler
How SIGNAL and RESIGNAL statements affect the diagnostics area
Making copies of a package for a native SQL procedure
Replacing copies of a package for a version of a native SQL procedure
Creating a new version of a native SQL procedure
Multiple versions of native SQL procedures
Deploying a native SQL procedure to another DB2 for z/OS server
Migrating an external SQL procedure to a native SQL procedure
Using the DB2 precompiler to assist you in converting an external SQL procedure to a native SQL procedure
Changing an existing version of a native SQL procedure
Regenerating an existing version of a native SQL procedure
Removing an existing version of a native SQL procedure
Creating an external SQL procedure
Creating an external SQL procedure by using DSNTPSMP
DB2 for z/OS SQL procedure processor (DSNTPSMP)
Sample startup procedure for a WLM address space for DSNTPSMP
CALL statement syntax for invoking DSNTPSMP
Examples of invoking the SQL procedure processor (DSNTPSMP)
Result set that the SQL procedure processor (DSNTPSMP) returns
Creating an external SQL procedure by using JCL
Sample programs to help you prepare and run external SQL procedures
Creating an external stored procedure
Defining the linkage convention for an external stored procedure
Linkage conventions for external stored procedures
Example of GENERAL linkage convention
Example of GENERAL WITH NULLS linkage convention
Example of SQL linkage convention
DBINFO structure
Packages and plans for external stored procedures
Accessing other sites in an external procedure
Accessing non-DB2 resources in your stored procedure
Writing an external procedure to access IMS databases
Writing an external procedure to return result sets to a distributed client
Restrictions when calling other programs from an external stored procedure
Creating an external stored procedure as reentrant
External stored procedures as main programs and subprograms
Data types in stored procedures
REXX stored procedures
Modifying an external stored procedure definition
Creating multiple versions of external procedures and external SQL procedures
Adding and modifying data
Inserting data into tables
Inserting rows by using the INSERT statement
Inserting rows into a table from another table
Rules for inserting data into a ROWID column
Rules for inserting data into an identity column
Restrictions when assigning values to columns with distinct types
Inserting data and updating data in a single operation
Selecting values while merging data
Selecting values while inserting data
Preserving the order of a derived table
Adding data to the end of a table
Storing data that does not have a tabular format
Updating table data
Selecting values while updating data
Updating thousands of rows
Deleting data from tables
Selecting values while deleting data
Accessing data
Determining which tables you have access to
Displaying information about the columns for a given table
Retrieving data by using the SELECT statement
Selecting derived columns
Selecting XML data
Formatting the result table
Result tables
Eliminating redundant duplicate rows in the result table
Naming result columns
Ordering the result table rows
Numbering the rows in a result table
Ranking the rows
Combining result tables from multiple SELECT statements
Summarizing group values
Filtering groups
Finding rows that were changed within a specified period of time
Joining data from more than one table
Joining more than two tables
Inner joins
Outer joins
Full outer join
Left outer join
Right outer join
SQL rules for statements that contain join operations
Sample data for joins
Optimizing retrieval for a small set of rows
Creating recursive SQL by using common table expressions
Updating data as it is retrieved from the database
Avoiding decimal arithmetic errors
Precision for operations with decimal numbers
Controlling how DB2 rounds decimal floating point numbers
Implications of using SELECT *
Subqueries
Places where you can include a subquery
Correlated subqueries
Correlation names in references
Restrictions when using distinct types with UNION, EXCEPT, and INTERSECT
Comparison of distinct types
Nested SQL statements
Retrieving a set of rows by using a cursor
Cursors
Types of cursors
Held and non-held cursors
Accessing data by using a row-positioned cursor
Declaring a row cursor
Opening a row cursor
Specifying the action that the row cursor is to take when it reaches the end of the data
Executing SQL statements by using a row cursor
Closing a row cursor
Accessing data by using a rowset-positioned cursor
Declaring a rowset cursor
Opening a rowset cursor
Specifying the action that the rowset cursor is to take when it reaches the end of the data
Executing SQL statements by using a rowset cursor
Specifying the number of rows in a rowset
Closing a rowset cursor
Retrieving rows by using a scrollable cursor
Comparison of scrollable cursors
Scrolling through a table in any direction
Determining the number of rows in the result table for a static scrollable cursor
Removing a delete hole or update hole
Holes in the result table of a scrollable cursor
Accessing XML or LOB data quickly by using FETCH WITH CONTINUE
Dynamically allocating buffers when fetching XML and LOB data
Moving data through fixed-size buffers when fetching XML and LOB data
Determining the attributes of a cursor by using the SQLCA
Determining the attributes of a cursor by using the GET DIAGNOSTICS statement
Scrolling through previously retrieved data
Updating previously retrieved data
FETCH statement interaction between row and rowset positioning
Examples of fetching rows by using cursors
Specifying direct row access by using row IDs
ROWID columns
Ways to manipulate LOB data
LOB host variable, LOB locator, and LOB file reference variable declarations
LOB and XML materialization
Saving storage when manipulating LOBs by using LOB locators
Indicator variables and LOB locators
Valid assignments for LOB locators
Avoiding character conversion for LOB locators
Deferring evaluation of a LOB expression to improve performance
LOB file reference variables
DB2-generated LOB file reference variable constructs
Examples of declaring file reference variables
Referencing a sequence object
Retrieving thousands of rows
Determining when a row was changed
Checking whether an XML column contains a certain value
Accessing DB2 data that is not in a table
Ensuring that queries perform sufficiently
Items to include in a batch DL/I program
Invoking a user-defined function
Determining the authorization ID for invoking user-defined functions
Ensuring that DB2 executes the intended user-defined function
How DB2 resolves functions
Checking how DB2 resolves functions by using DSN_FUNCTION_TABLE
DSN_FUNCTION_TABLE
Restrictions when passing arguments with distinct types to functions
Cases when DB2 casts arguments for a user-defined function
Calling a stored procedure from your application
Passing large output parameters to stored procedures by using indicator variables
Data types for calling stored procedures
Calling a stored procedure from a REXX procedure
Preparing a client program that calls a remote stored procedure
How DB2 determines which stored procedure to run
Calling different versions of a stored procedure from a single application
Invoking multiple instances of a stored procedure
Designating the active version of a native SQL procedure
Temporarily overriding the active version of a native SQL procedure
Specifying the number of stored procedures that can run concurrently
Retrieving the procedure status
Writing a program to receive the result sets from a stored procedure
DB2-supplied stored procedures
WLM_REFRESH stored procedure
WLM_SET_CLIENT_INFO stored procedure
DSN_WLM_APPLENV stored procedure
DSNACICS stored procedure
The DSNACICX user exit routine
DSNAIMS stored procedure
DSNAIMS2 stored procedure
DSNACCOR stored procedure
XSR_REGISTER stored procedure
XSR_ADDSCHEMADOC stored procedure
XSR_COMPLETE stored procedure
XSR_REMOVE stored procedure
Coding methods for distributed data
Accessing distributed data by using three-part table names
Accessing remote declared temporary tables by using three-part table names
Accessing distributed data by using explicit CONNECT statements
Specifying a location alias name for multiple sites
Releasing connections
Transmitting mixed data
Identifying the server at run time
SQL limitations at dissimilar servers
Support for executing long SQL statements in a distributed environment
Distributed queries against ASCII or Unicode tables
Restrictions when using scrollable cursors to access distributed data
Restrictions when using rowset-positioned cursors to access distributed data
WebSphere MQ with DB2
WebSphere MQ messages
WebSphere MQ message handling
WebSphere MQ message handling with the MQI
DB2 MQI services
DB2 MQI policies
DB2 MQ functions and DB2 MQ XML stored procedures
Generating XML documents from existing tables and sending them to an MQ message queue
Shredding XML documents from an MQ message queue
DB2 MQ tables
Basic messaging with WebSphere MQ
Sending messages with WebSphere MQ
Retrieving messages with WebSphere MQ
Application to application connectivity with WebSphere MQ
Asynchronous messaging in DB2 for z/OS
MQListener in DB2 for z/OS
Configuring MQListener in DB2 for z/OS
Environment variables for logging and tracing MQListener
Configuration table: SYSMQL.LISTENERS
Configuring MQListener tasks
Creating a sample stored procedure to use with MQ Listener
MQListener error processing
MQListener examples
DB2 as a web services consumer and provider
Deprecated: The SOAPHTTPV and SOAPHTTPC user-defined functions
The SOAPHTTPNV and SOAPHTTPNC user-defined functions
SQLSTATEs for DB2 as a web services consumer
Preparing an application to run on DB2 for z/OS
Setting the DB2I defaults
Processing SQL statements
Processing SQL statements by using the DB2 precompiler
Data sets that the precompiler uses
Input to the DB2 precompiler
Starting the precompiler dynamically when using JCL procedures
Precompiler option list format
DD name list format
Page number format
Output from the DB2 precompiler
Processing SQL statements by using the DB2 coprocessor
Support for compiling a COBOL program that includes SQL from an assembler program
Translating command-level statements in a CICS program
Differences between the DB2 precompiler and the DB2 coprocessor
Options for SQL statement processing
Descriptions of SQL processing options
Defaults for SQL processing options
SQL options for DRDA access
Program preparation options for remote packages
Compiling and link-editing an application
Binding an application
Binding a DBRM to a package
Binding packages at a remote location
Creating a package version
Binding a DBRM that is in an HFS file to a package or collection
Command line processor BIND command
Binding an application plan
How DB2 identifies packages at run time
Specifying the location of the package that DB2 is to use
Specifying the package collection that DB2 is to use
Overriding the values that DB2 uses to resolve package lists
Bind process for remote access
Bind options for remote access
Checking which BIND PACKAGE options a particular server supports
Binding a batch program
Conversion of DBRMs that are bound to a plan to DBRMs that are bound to a package
Converting an existing plan into packages to run remotely
Setting the program level
DYNAMICRULES bind option
Determining the authorization cache size for plans
Authorization cache
Determining the authorization cache size for packages
Dynamic plan selection
Rebinding an application
Rebinding a package
Rebinding a plan
Rebinding lists of plans and packages
Generating lists of REBIND commands
Sample program to create REBIND subcommands for lists of plans and packages
Sample SELECT statements for generating REBIND commands
Sample JCL for running lists of REBIND commands
Automatic rebinding
Specifying the rules that apply to SQL behavior at run time
DB2 program preparation overview
Input and output data sets for DL/I batch jobs
DB2-supplied JCL procedures for preparing an application
JCL to include the appropriate interface code when using the DB2-supplied JCL procedures
Tailoring DB2-supplied JCL procedures for preparing CICS programs
DB2I primary option menu
DB2I panels that are used for program preparation
DB2 Program Preparation panel
DB2I Defaults Panel 1
DB2I Defaults Panel 2
Precompile panel
Bind Package panel
Bind Plan panel
Defaults for Bind Package panel
Defaults for Bind Plan panel
System Connection Types panel
Panels for entering lists of values
Program Preparation: Compile, Link, and Run panel
DB2I panels that are used to rebind and free plans and packages
Bind/Rebind/Free Selection panel
Rebind Package panel
Rebind Trigger Package panel
Rebind Plan panel
Free Package panel
Free Plan panel
Running an application on DB2 for z/OS
DSN command processor
DB2I Run panel
Running a program in TSO foreground
Running a DB2 REXX application
Invoking programs through the Interactive System Productivity Facility
ISPF
Invoking a single SQL program through ISPF and DSN
Invoking multiple SQL programs through ISPF and DSN
Loading and running a batch program
Authorization for running a batch DL/I program
Restarting a batch program
Finding the DL/I batch checkpoint ID
Running stored procedures from the command line processor
Command line processor CALL statement
Example of running a batch DB2 application in TSO
Example of calling applications in a command procedure
Testing and debugging an application program on DB2 for z/OS
Designing a test data structure
Analyzing application data needs
Authorization for test tables and applications
Example SQL statements to create a comprehensive test structure
Populating the test tables with data
Methods for testing SQL statements
Executing SQL by using SPUFI
SPUFI
Content of a SPUFI input data set
The SPUFI panel
Changing SPUFI defaults
CURRENT SPUFI DEFAULTS panel
CURRENT SPUFI DEFAULTS - PANEL 2 panel
Setting the SQL terminator character in a SPUFI input data set
Controlling toleration of warnings in SPUFI
Output from SPUFI
Testing an external user-defined function
Testing a user-defined function by using the Debug Tool for z/OS
Testing a user-defined function by routing the debugging messages to SYSPRINT
Testing a user-defined function by using driver applications
Testing a user-defined function by using SQL INSERT statements
Debugging stored procedures
Debugging stored procedures with the Debug Tool and IBM VisualAge COBOL
Debugging a C language stored procedure with the Debug Tool and C/C++ Productivity Tools for z/OS
Debugging stored procedures by using the Unified Debugger
Debugging stored procedures with the Debug Tool for z/OS
Recording stored procedure debugging messages in a file
Driver applications for debugging procedures
DB2 tables that contain debugging information
Debugging an application program
Locating the problem in an application
Error and warning messages from the precompiler
SYSTERM output from the precompiler
SYSPRINT output from the precompiler
Techniques for debugging programs in TSO
Techniques for debugging programs in IMS
Techniques for debugging programs in CICS
Finding a violated referential or check constraint
DB2 sample applications and data
DB2 sample applications
Types of sample applications
Application languages and environments for the sample applications
Sample applications in TSO
Sample applications in IMS
Sample applications in CICS
DSNTIAUL
DSNTIAD
DSNTEP2 and DSNTEP4
Index for application programming and SQL
Programming for Java
Introduction to Java application development for DB2
Supported drivers for JDBC and SQLJ
JDBC driver and database version compatibility
DB2 for z/OS and IBM Data Server Driver for JDBC and SQLJ levels
DB2 for Linux, UNIX, and Windows and IBM Data Server Driver for JDBC and SQLJ levels
JDBC application programming
Example of a simple JDBC application
How JDBC applications connect to a data source
Connecting to a data source using the DriverManager interface with the IBM Data Server Driver for JDBC and SQLJ
URL format for IBM Data Server Driver for JDBC and SQLJ type 4 connectivity
URL format for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity
Connecting to a data source using the DataSource interface
How to determine which type of IBM Data Server Driver for JDBC and SQLJ connectivity to use
JDBC connection objects
Creating and deploying DataSource objects
Java packages for JDBC support
Learning about a data source using DatabaseMetaData methods
DatabaseMetaData methods for identifying the type of data source
Variables in JDBC applications
JDBC interfaces for executing SQL
Creating and modifying database objects using the Statement.executeUpdate method
Updating data in tables using the PreparedStatement.executeUpdate method
JDBC executeUpdate methods against a DB2 for z/OS server
Making batch updates in JDBC applications
Learning about parameters in a PreparedStatement using ParameterMetaData methods
Data retrieval in JDBC applications
Retrieving data from tables using the Statement.executeQuery method
Retrieving data from tables using the PreparedStatement.executeQuery method
Making batch queries in JDBC applications
Learning about a ResultSet using ResultSetMetaData methods
Characteristics of a JDBC ResultSet under the IBM Data Server Driver for JDBC and SQLJ
Specifying updatability, scrollability, and holdability for ResultSets in JDBC applications
Multi-row SQL operations in JDBC applications
Testing whether the current row of a ResultSet is a delete hole or update hole in a JDBC application
Inserting a row into a ResultSet in a JDBC application
Testing whether the current row was inserted into a ResultSet in a JDBC application
Calling stored procedures in JDBC applications
Retrieving multiple result sets from a stored procedure in a JDBC application
Retrieving a known number of result sets from a stored procedure in a JDBC application
Retrieving an unknown number of result sets from a stored procedure in a JDBC application
Keeping result sets open when retrieving multiple result sets from a stored procedure in a JDBC application
LOBs in JDBC applications with the IBM Data Server Driver for JDBC and SQLJ
Progressive streaming with the IBM Data Server Driver for JDBC and SQLJ
LOB locators with the IBM Data Server Driver for JDBC and SQLJ
LOB operations with the IBM Data Server Driver for JDBC and SQLJ
Java data types for retrieving or updating LOB column data in JDBC applications
ROWIDs in JDBC with the IBM Data Server Driver for JDBC and SQLJ
Update and retrieval of timestamps with time zone information in JDBC applications
Distinct types in JDBC applications
Savepoints in JDBC applications
Retrieval of automatically generated keys in JDBC applications
Retrieving auto-generated keys for an INSERT statement
Retrieving auto-generated keys for an UPDATE, DELETE, or MERGE statement
Using named parameter markers in JDBC applications
Using named parameter markers with PreparedStatement objects
Using named parameter markers with CallableStatement objects
Providing extended client information to the data source with IBM Data Server Driver for JDBC and SQLJ-only methods
Providing extended client information to the data source with client info properties
Client info properties support by the IBM Data Server Driver for JDBC and SQLJ
Extended parameter information with the IBM Data Server Driver for JDBC and SQLJ
Using DB2PreparedStatement methods or constants to provide extended parameter information
Using DB2ResultSet methods or DB2PreparedStatement constants to provide extended parameter information
XML data in JDBC applications
XML column updates in JDBC applications
XML data retrieval in JDBC applications
Invocation of routines with XML parameters in Java applications
Binary XML format in Java applications
Java support for XML schema registration and removal
Inserting data from file reference variables into tables in JDBC applications
Transaction control in JDBC applications
IBM Data Server Driver for JDBC and SQLJ isolation levels
Committing or rolling back JDBC transactions
Default JDBC autocommit modes
Exceptions and warnings under the IBM Data Server Driver for JDBC and SQLJ
Handling an SQLException under the IBM Data Server Driver for JDBC and SQLJ
Handling an SQLWarning under the IBM Data Server Driver for JDBC and SQLJ
Retrieving information from a BatchUpdateException
Memory use for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS
Disconnecting from data sources in JDBC applications
SQLJ application programming
Example of a simple SQLJ application
Connecting to a data source using SQLJ
SQLJ connection technique 1: JDBC DriverManager interface
SQLJ connection technique 2: JDBC DriverManager interface
SQLJ connection technique 3: JDBC DataSource interface
SQLJ connection technique 4: JDBC DataSource interface
SQLJ connection technique 5: Use a previously created connection context
SQLJ connection technique 6: Use the default connection
Java packages for SQLJ support
Variables in SQLJ applications
Indicator variables in SQLJ applications
Comments in an SQLJ application
SQL statement execution in SQLJ applications
Creating and modifying database objects in an SQLJ application
Performing positioned UPDATE and DELETE operations in an SQLJ application
Iterators as passed variables for positioned UPDATE or DELETE operations in an SQLJ application
Making batch updates in SQLJ applications
Data retrieval in SQLJ applications
Using a named iterator in an SQLJ application
Using a positioned iterator in an SQLJ application
Multiple open iterators for the same SQL statement in an SQLJ application
Multiple open instances of an iterator in an SQLJ application
Using scrollable iterators in an SQLJ application
Calling stored procedures in SQLJ applications
Retrieving multiple result sets from a stored procedure in an SQLJ application
LOBs in SQLJ applications with the IBM Data Server Driver for JDBC and SQLJ
Java data types for retrieving or updating LOB column data in SQLJ applications
SQLJ and JDBC in the same application
Controlling the execution of SQL statements in SQLJ
ROWIDs in SQLJ with the IBM Data Server Driver for JDBC and SQLJ
TIMESTAMP WITH TIME ZONE values in SQLJ applications
Distinct types in SQLJ applications
Savepoints in SQLJ applications
XML data in SQLJ applications
XML column updates in SQLJ applications
XML data retrieval in SQLJ applications
XMLCAST in SQLJ applications
Inserting data from file reference variables into tables in SQLJ applications
SQLJ utilization of SDK for Java Version 5 function
Transaction control in SQLJ applications
Setting the isolation level for an SQLJ transaction
Committing or rolling back SQLJ transactions
Handling SQL errors and warnings in SQLJ applications
Handling SQL errors in an SQLJ application
Handling SQL warnings in an SQLJ application
Closing the connection to a data source in an SQLJ application
Java stored procedures and user-defined functions
Setting up the environment for Java routines
Setting up the WLM application environment for Java routines
WLM address space startup procedure for Java routines
WLM application environment values for Java routines
Runtime environment for Java routines
Defining Java routines and JAR files to DB2
Definition of a Java routine to DB2
Definition of a JAR file for a Java routine to DB2
SQLJ.INSTALL_JAR stored procedure
SQLJ.DB2_INSTALL_JAR stored procedure
SQLJ.REPLACE_JAR stored procedure
SQLJ.DB2_REPLACE_JAR stored procedure
SQLJ.REMOVE_JAR stored procedure
SQLJ.ALTER_JAVA_PATH stored procedure
Java routine programming
Differences between Java routines and stand-alone Java programs
Differences between Java routines and other routines
Static and non-final variables in a Java routine
Writing a Java stored procedure to return result sets
Techniques for testing a Java routine
Preparing and running JDBC and SQLJ programs
Program preparation for JDBC programs
Program preparation for SQLJ programs
Binding SQLJ applications to access multiple database servers
Program preparation for Java routines
Preparation of Java routines with no SQLJ clauses
Preparing Java routines with no SQLJ clauses to run from a JAR file
Preparing Java routines with no SQLJ clauses and no JAR file
Preparation of Java routines with SQLJ clauses
Preparing Java routines with SQLJ clauses to run from a JAR file
Preparing Java routines with SQLJ clauses and no JAR file
Creating JAR files for Java routines
Running JDBC and SQLJ programs
JDBC and SQLJ reference information
Data types that map to database data types in Java applications
Date, time, and timestamp values that can cause problems in JDBC and SQLJ applications
Data loss for timestamp data in JDBC and SQLJ applications
Retrieval of special values from DECFLOAT columns in Java applications
Properties for the IBM Data Server Driver for JDBC and SQLJ
Common IBM Data Server Driver for JDBC and SQLJ properties for all database products
Common IBM Data Server Driver for JDBC and SQLJ properties for DB2 servers
Common IBM Data Server Driver for JDBC and SQLJ properties for DB2 for z/OS and IBM Informix
Common IBM Data Server Driver for JDBC and SQLJ properties for IBM Informix and DB2 Database for Linux, UNIX, and Windows
IBM Data Server Driver for JDBC and SQLJ properties for DB2 Database for Linux, UNIX, and Windows
IBM Data Server Driver for JDBC and SQLJ properties for DB2 for z/OS
IBM Data Server Driver for JDBC and SQLJ properties for IBM Informix
IBM Data Server Driver for JDBC and SQLJ configuration properties
Driver support for JDBC APIs
IBM Data Server Driver for JDBC and SQLJ support for SQL escape syntax
SQLJ statement reference information
SQLJ clause
SQLJ host-expression
SQLJ implements-clause
SQLJ with-clause
SQLJ connection-declaration-clause
SQLJ iterator-declaration-clause
SQLJ executable-clause
SQLJ context-clause
SQLJ statement-clause
SQLJ SET-TRANSACTION-clause
SQLJ assignment-clause
SQLJ iterator-conversion-clause
Interfaces and classes in the sqlj.runtime package
sqlj.runtime.ConnectionContext interface
sqlj.runtime.ForUpdate interface
sqlj.runtime.NamedIterator interface
sqlj.runtime.PositionedIterator interface
sqlj.runtime.ResultSetIterator interface
sqlj.runtime.Scrollable interface
sqlj.runtime.AsciiStream class
sqlj.runtime.BinaryStream class
sqlj.runtime.CharacterStream class
sqlj.runtime.ExecutionContext class
sqlj.runtime.SQLNullException class
sqlj.runtime.StreamWrapper class
sqlj.runtime.UnicodeStream class
IBM Data Server Driver for JDBC and SQLJ extensions to JDBC
DBBatchUpdateException interface
DB2BaseDataSource class
DB2BlobFileReference class
DB2CallableStatement interface
DB2ClientRerouteServerList class
DB2ClobFileReference class
DB2Connection interface
DB2ConnectionPoolDataSource class
DB2DatabaseMetaData interface
DB2Diagnosable interface
DB2Driver class
DB2ExceptionFormatter class
DB2FileReference class
DB2JCCPlugin class
DB2ParameterMetaData interface
DB2PooledConnection class
DB2PoolMonitor class
DB2PreparedStatement interface
DB2ResultSet interface
DB2ResultSetMetaData interface
DB2RowID interface
DB2SimpleDataSource class
DB2Sqlca class
DB2Statement interface
DB2SystemMonitor interface
DB2TraceManager class
DB2TraceManagerMXBean interface
DB2Types class
DB2XADataSource class
DB2Xml interface
DB2XmlAsBlobFileReference class
DB2XmlAsClobFileReference class
DBTimestamp class
JDBC differences between versions of the IBM Data Server Driver for JDBC and SQLJ
Examples of ResultSetMetaData.getColumnName and ResultSetMetaData.getColumnLabel values
Error codes issued by the IBM Data Server Driver for JDBC and SQLJ
SQLSTATEs issued by the IBM Data Server Driver for JDBC and SQLJ
How to find IBM Data Server Driver for JDBC and SQLJ version and environment information
Commands for SQLJ program preparation
sqlj - SQLJ translator
db2sqljcustomize - SQLJ profile customizer
db2sqljbind - SQLJ profile binder
db2sqljprint - SQLJ profile printer
Installing the IBM Data Server Driver for JDBC and SQLJ
Installing the IBM Data Server Driver for JDBC and SQLJ as part of a DB2 installation
Jobs for loading the IBM Data Server Driver for JDBC and SQLJ libraries
Environment variables for the IBM Data Server Driver for JDBC and SQLJ
Customization of IBM Data Server Driver for JDBC and SQLJ configuration properties
Enabling the DB2-supplied stored procedures used by the IBM Data Server Driver for JDBC and SQLJ
Values for the WLM environment for IBM Data Server Driver for JDBC and SQLJ stored procedures
Creation of IBM Data Server Driver for JDBC and SQLJ stored procedures
DB2Binder utility
DB2LobTableCreator utility
Verify the installation of the IBM Data Server Driver for JDBC and SQLJ
Upgrading the IBM Data Server Driver for JDBC and SQLJ to a new version
Installing the z/OS Application Connectivity to DB2 for z/OS feature
Jobs for loading the z/OS Application Connectivity to DB2 for z/OS libraries
Environment variables for the z/OS Application Connectivity to DB2 for z/OS feature
Security under the IBM Data Server Driver for JDBC and SQLJ
User ID and password security under the IBM Data Server Driver for JDBC and SQLJ
User ID-only security under the IBM Data Server Driver for JDBC and SQLJ
Encrypted password, user ID, or user ID and password security under the IBM Data Server Driver for JDBC and SQLJ
Kerberos security under the IBM Data Server Driver for JDBC and SQLJ
IBM Data Server Driver for JDBC and SQLJ trusted context support
IBM Data Server Driver for JDBC and SQLJ support for SSL
Configuring connections under the IBM Data Server Driver for JDBC and SQLJ to use SSL
Configuring the Java Runtime Environment to use SSL
Security for preparing SQLJ applications with the IBM Data Server Driver for JDBC and SQLJ
Java client support for high availability on IBM data servers
Java client support for high availability for connections to DB2 Database for Linux, UNIX, and Windows servers
Configuration of DB2 Database for Linux, UNIX, and Windows automatic client reroute support for Java clients
Example of enabling DB2 Database for Linux, UNIX, and Windows automatic client reroute support in Java applications
Configuration of DB2 Database for Linux, UNIX, and Windows workload balancing support for Java clients
Example of enabling DB2 Database for Linux, UNIX, and Windows workload balancing support in Java applications
Operation of automatic client reroute for connections to DB2 Database for Linux, UNIX, and Windows from Java clients
Operation of alternate group support
Operation of workload balancing for connections to DB2 Database for Linux, UNIX, and Windows
Application programming requirements for high availability for connections to DB2 Database for Linux, UNIX, and Windows servers
Client affinities for DB2 Database for Linux, UNIX, and Windows
Configuration of client affinities for Java clients for DB2 Database for Linux, UNIX, and Windows connections
Example of enabling client affinities in Java clients for DB2 Database for Linux, UNIX, and Windows connections
Java client support for high availability for connections to IBM Informix servers
Configuration of IBM Informix high-availability support for Java clients
Example of enabling IBM Informix high availability support in Java applications
Operation of automatic client reroute for connections to IBM Informix from Java clients
Operation of workload balancing for connections to IBM Informix from Java clients
Application programming requirements for high availability for connections from Java clients to IBM Informix servers
Client affinities for connections to IBM Informix from Java clients
Configuration of client affinities for Java clients for IBM Informix connections
Example of enabling client affinities in Java clients for IBM Informix connections
Java client direct connect support for high availability for connections to DB2 for z/OS servers
Configuration of Sysplex workload balancing and automatic client reroute for Java clients
Example of enabling DB2 for z/OS Sysplex workload balancing and automatic client reroute in Java applications
Operation of Sysplex workload balancing for connections from Java clients to DB2 for z/OS servers
Operation of automatic client reroute for connections from Java clients to DB2 for z/OS
Operation of alternate group support
Application programming requirements for high availability for connections from Java clients to DB2 for z/OS servers
Failover support with IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS
JDBC and SQLJ connection pooling support
IBM Data Server Driver for JDBC and SQLJ statement caching
IBM Data Server Driver for JDBC and SQLJ type 4 connectivity JDBC and SQLJ distributed transaction support
Example of a distributed transaction that uses JTA methods
JDBC and SQLJ global transaction support
Problem diagnosis with the IBM Data Server Driver for JDBC and SQLJ
DB2Jcc - IBM Data Server Driver for JDBC and SQLJ diagnostic utility
Examples of using configuration properties to start a JDBC trace
Example of a trace program under the IBM Data Server Driver for JDBC and SQLJ
Techniques for monitoring IBM Data Server Driver for JDBC and SQLJ Sysplex support
Tracing IBM Data Server Driver for JDBC and SQLJ C/C++ native driver code
db2jcctrace - Format IBM Data Server Driver for JDBC and SQLJ trace data for C/C++ native driver code
System monitoring for the IBM Data Server Driver for JDBC and SQLJ
Index for programming for Java
Programming for ODBC
Introduction to DB2 ODBC
DB2 ODBC background information
Differences between DB2 ODBC and ODBC 3.0
DB2 ODBC support for ODBC features
Differences between DB2 ODBC and embedded SQL
Advantages of using DB2 ODBC
Considerations for choosing between SQL and DB2 ODBC
Conceptual view of a DB2 ODBC application
Initialization and termination of an ODBC program
Handles
ODBC connection model
DB2 ODBC restrictions on the ODBC connection model
How to specify the connection type
How to connect to one or more data sources
Transaction processing in DB2 ODBC
Statement handle allocation
Preparation and execution of SQL statements
Functions for binding parameters in SQL statements
How an ODBC program processes results
Processing query (SELECT, VALUES) statements
Processing UPDATE, DELETE, INSERT, and MERGE statements
Processing other statements
Commit and rollback in DB2 ODBC
When to call SQLEndTran()
Effects of calling SQLEndTran()
Function for freeing statement handles
Diagnostics
Function return codes
SQLSTATEs for ODBC error reporting
SQLCA retrieval in an ODBC application
Data types and data conversion
C and SQL data types
C data types that do not map to SQL data types
Data conversion
Characteristics of string arguments
Length of string arguments
Nul-termination of strings
String truncation
Interpretation of strings
Functions for querying environment and data source information
Configuring DB2 ODBC and running sample applications
Running the SMP/E jobs for DB2 ODBC installation
The DB2 ODBC runtime environment
Connectivity requirements
Extra performance linkage
64-bit ODBC driver
DB2 ODBC runtime environment setup
Binding DBRMs to create packages
Impact of package bind options
Return codes from ODBC package binding
Binding the application plan
Setting up DB2 ODBC for the z/OS UNIX environment
Overview of preparing and executing a DB2 ODBC application
DB2 ODBC application requirements
Preparing and executing an ODBC application
Compiling an ODBC application
Compiling non-XPLINK applications
Compiling 31-bit XPLINK applications
Compiling 64-bit applications
Prelinking and link-editing an ODBC application
Prelinking and link-editing non-XPLINK applications
Link-editing 31-bit XPLINK applications
Link-editing 64-bit applications
Executing an ODBC application
How to define a subsystem to DB2 ODBC
DB2 ODBC initialization file
How to use the initialization file
Structure of the initialization file
DB2 ODBC initialization keywords
Database metadata stored procedures
Migrating to the current DB2 ODBC driver
Migrating an ODBC 31-bit application to a 64-bit application
Example 64-bit ODBC application
ODBC Functions
Status of support for ODBC functions
SQLAllocConnect() - Allocate a connection handle
SQLAllocEnv() - Allocate an environment handle
SQLAllocHandle() - Allocate a handle
SQLAllocStmt() - Allocate a statement handle
SQLBindCol() - Bind a column to an application variable
SQLBindFileToCol() - Associate a column with a file reference
SQLBindFileToParam() - Bind a parameter marker to a file reference
SQLBindParameter() - Bind a parameter marker to a buffer or LOB locator
SQLBulkOperations() - Add, update, delete or fetch a set of rows
SQLCancel() - Cancel statement
SQLCloseCursor() - Close a cursor and discard pending results
SQLColAttribute() - Get column attributes
SQLColAttributes() - Get column attributes
SQLColumnPrivileges() - Get column privileges
SQLColumns() - Get column information
SQLConnect() - Connect to a data source
SQLDataSources() - Get a list of data sources
SQLDescribeCol() - Describe column attributes
SQLDescribeParam() - Describe parameter marker
SQLDisconnect() - Disconnect from a data source
SQLDriverConnect() - Use a connection string to connect to a data source
SQLEndTran() - End transaction of a connection
SQLError() - Retrieve error information
SQLExecDirect() - Execute a statement directly
SQLExecute() - Execute a statement
SQLExtendedFetch() - Fetch an array of rows
SQLFetch() - Fetch the next row
SQLFetchScroll() - Fetch the next row
SQLForeignKeys() - Get a list of foreign key columns
SQLFreeConnect() - Free a connection handle
SQLFreeEnv() - Free an environment handle
SQLFreeHandle() - Free a handle
SQLFreeStmt() - Free (or reset) a statement handle
SQLGetConnectAttr() - Get current attribute setting
SQLGetConnectOption() - Return current setting of a connect option
SQLGetCursorName() - Get cursor name
SQLGetData() - Get data from a column
SQLGetDiagRec() - Get multiple field settings of diagnostic record
SQLGetEnvAttr() - Return current setting of an environment attribute
SQLGetFunctions() - Get functions
SQLGetInfo() - Get general information
SQLGetLength() - Retrieve length of a string value
SQLGetPosition() - Find the starting position of a string
SQLGetSQLCA() - Get SQLCA data structure
SQLGetStmtAttr() - Get current setting of a statement attribute
SQLGetStmtOption() - Return current setting of a statement option
SQLGetSubString() - Retrieve a portion of a string value
SQLGetTypeInfo() - Get data type information
SQLMoreResults() - Check for more result sets
SQLNativeSql() - Get native SQL text
SQLNumParams() - Get number of parameters in an SQL statement
SQLNumResultCols() - Get number of result columns
SQLParamData() - Get next parameter for which a data value is needed
SQLParamOptions() - Specify an input array for a parameter
SQLPrepare() - Prepare a statement
SQLPrimaryKeys() - Get primary key columns of a table
SQLProcedureColumns() - Get procedure input/output parameter information
SQLProcedures() - Get a list of procedure names
SQLPutData() - Pass a data value for a parameter
SQLRowCount() - Get row count
SQLSetColAttributes() - Set column attributes
SQLSetConnectAttr() - Set connection attributes
SQLSetConnection() - Set connection handle
SQLSetConnectOption() - Set connection option
SQLSetCursorName() - Set cursor name
SQLSetEnvAttr() - Set environment attributes
SQLSetParam() - Bind a parameter marker to a buffer
SQLSetPos - Set the cursor position in a rowset
SQLSetStmtAttr() - Set statement attributes
SQLSetStmtOption() - Set statement attribute
SQLSpecialColumns() - Get special (row identifier) columns
SQLStatistics() - Get index and statistics information for a base table
SQLTablePrivileges() - Get table privileges
SQLTables() - Get table information
SQLTransact() - Transaction management
Advanced features
Functions for setting and retrieving environment, connection, and statement attributes
Functions for setting and retrieving environment attributes
Functions for setting and retrieving connection attributes
Functions for setting and retrieving statement attributes
ODBC and distributed units of work
Functions for establishing a distributed unit-of-work connection
Coordinated connections in a DB2 ODBC application
Global transactions in ODBC programs
Use of ODBC for querying the DB2 catalog
Catalog query functions
Input arguments on catalog functions
Catalog functions example
The DB2 ODBC shadow catalog
Using arrays to pass parameter values
Retrieval of a result set into an array
Column-wise binding for array data
Row-wise binding for array data
The ODBC row status array
Column-wise and row-wise binding example
ODBC limited block fetch
Scrollable cursors in DB2 ODBC
Scrollable cursor characteristics in DB2 ODBC
Relative and absolute scrolling in DB2 ODBC applications
Steps for retrieving data with scrollable cursors in a DB2 ODBC application
ODBC scrollable cursor example
Performing bulk inserts with SQLBulkOperations()
Updates to DB2 tables with SQLSetPos()
Updating rows in a rowset with SQLSetPos()
Deleting rows in a rowset with SQLSetPos()
Input and retrieval of long data in pieces
Providing long data for bulk inserts and positioned updates
Examples of using decimal floating point data in an ODBC application
Using LOBs
Using LOB locators
LOB and LOB locator example
LOB file reference variables in ODBC applications
XML data in ODBC applications
XML column updates in ODBC applications
XML data retrieval in ODBC applications
Distinct types in DB2 ODBC applications
Stored procedures
Advantages of using stored procedures
Stored procedure calls in a DB2 ODBC application
Rules for a DB2 ODBC stored procedure
Result sets from stored procedures
Programming stored procedures to return result sets
Restrictions on stored procedures returning result sets
Programming DB2 ODBC client applications to receive result sets
Multithreaded and multiple-context applications in DB2 ODBC
DB2 ODBC support for multiple Language Environment threads
When to use multiple Language Environment threads
DB2 ODBC support of multiple contexts
Multiple contexts, one Language Environment thread
Multiple contexts, multiple Language Environment threads
External contexts
Application deadlocks
Application encoding schemes and DB2 ODBC
Types of encoding schemes
Application programming guidelines for handling different encoding schemes
DB2 ODBC API entry points
Functions for binding host variables to C types
Suffix-W API function syntax
Examples of handling the application encoding scheme
Example of binding result set columns to retrieve UCS-2 data
Example of binding UTF-8 data to parameter markers
Example of retrieving UTF-8 data into application variables
Example of using suffix-W APIs
Embedded SQL and DB2 ODBC in the same program
Vendor escape clauses
Function for determining ODBC vendor escape clause support
Escape clause syntax
ODBC-defined SQL extensions
ODBC date, time, and timestamp data
ODBC outer join syntax
LIKE predicate escape clause
Stored procedure CALL
ODBC scalar functions
Extended indicators in ODBC applications
ODBC programming hints and tips
Guidelines for avoiding common problems
Check the DB2 ODBC initialization file
Limit the number of rows that an application can fetch
Cast parameter markers to distinct types or distinct types to source types
Techniques for improving application performance
Set isolation levels for maximum concurrency and data consistency
Disable cursor hold behavior for more efficient resource use
Code ODBC functions for efficient data retrieval
Limit the use of catalog functions
Use dynamic SQL statement caching
Turn off statement scanning
Techniques for reducing network flow
Use SQLSetColAttributes() to reduce network flow
Disable autocommit to reduce network flow
Use arrays to send and retrieve data
Use LOBs to manipulate large data values at the server
Techniques for maximizing application portability
Use column position in function-generated result sets
Use SQLDriverConnect() instead of SQLConnect()
Problem diagnosis
ODBC trace types
Application trace
Formats for the trace file name
Example of application trace output
ODBC diagnostic trace
Capturing ODBC diagnostic trace information in z/OS
Capturing ODBC diagnostic trace information in the z/OS UNIX environment
ODBC diagnostic trace commands
Specifications for the diagnostic trace file
Stored procedure trace
Tracing a client application
Obtaining an application trace for a stored procedure
Obtaining a diagnostic trace for a stored procedure
Obtaining an application trace for a client application and a stored procedure
Obtaining a diagnostic trace for a client application and a stored procedure
Abnormal termination
Internal error code
DB2 ODBC reference information
DB2 ODBC and ODBC differences
DB2 ODBC and ODBC drivers
ODBC APIs and data types
Isolation levels
Extended scalar functions
Errors returned by extended scalar functions
String functions
Date and time functions
System functions
SQLSTATE cross reference
Data conversion between the application and the database server
SQL data type attributes
Precision of SQL data types
Scale of SQL data types
Length of SQL data types
Display size of SQL data types
SQL to C data conversion
SQL to C conversion for character data
SQL to C conversion for graphic data
SQL to C conversion for numeric data
SQL to C conversion for binary data
SQL to C conversion for date data
SQL to C conversion for time data
SQL to C conversion for timestamp data
SQL to C conversion for ROWID data
SQL to C conversion for XML data
SQL to C data conversion examples
C to SQL data conversion
C to SQL conversion for character data
C to SQL conversion for numeric data
C to SQL conversion for binary data
C to SQL conversion for double-byte character data
C to SQL conversion for date data
C to SQL conversion for time data
C to SQL conversion for timestamp data
C to SQL data conversion examples
Deprecated functions
Deprecated functions and their replacements
Changes to SQLGetInfo() InfoType argument values
Changes to SQLSetConnectAttr() attributes
Changes to SQLSetEnvAttr() attributes
Changes to SQLSetStmtAttr() attributes
ODBC 3.0 driver behavior
SQLSTATE mappings
Changes to datetime data types
Example DB2 ODBC code
DSN8O3VP sample application
Client application calling a DB2 ODBC stored procedure
Index for programming for ODBC
Programming for XML
Prerequisites for using pureXML
Setting up the XML schema repository
Defining the WLM environment and JCL startup procedure for C language XML schema repository stored procedures
Defining the WLM environment and JCL startup procedure for the Java language XML schema repository stored procedure
Defining the XML schema repository stored procedures to DB2
Binding the IBM Data Server Driver for JDBC and SQLJ packages for the XML schema repository
Testing the XML schema repository setup
Overview of pureXML
pureXML data model
Sequences and items
Atomic values
Nodes
Document nodes
Element nodes
Attribute nodes
Text nodes
Processing instruction nodes
Comment nodes
Data model generation
Comparison of the XML model and the relational model
XML data type
Tutorial for pureXML
Working with XML data
Creation of tables with XML columns
Altering tables with XML columns
Storage structure for XML data
Limitation of XML virtual storage usage
Insertion of rows with XML column values
Updates of XML columns
Updates of entire XML documents
Partial updates of XML documents
Deletion of rows with XML documents from tables
XML versions
XML support in triggers
XML parsing
XML parsing and whitespace handling
XML parsing and DTDs
XML schema validation
XML schema validation and ignorable whitespace
XML schema validation with an XML type modifier
How DB2 chooses an XML schema from an XML type modifier
Revalidation after XML document updates
XML schema validation with DSN_XMLVALIDATE
Moving from SYSFUN.DSN_XMLVALIDATE to SYSIBM.DSN_XMLVALIDATE
How DB2 chooses an XML schema for DSN_XMLVALIDATE
How to determine whether an XML document has been validated
Casts between XML data types and SQL data types
Examples of casts from XML schema data types to SQL data types
Retrieving XML data
Retrieval of an entire XML document from an XML column
XMLQUERY function for retrieval of portions of an XML document
Non-empty sequences returned by XMLQUERY
Empty sequences returned by XMLQUERY
XMLEXISTS predicate for querying XML data
Constant and parameter marker passing to XMLEXISTS and XMLQUERY
XMLTABLE function for returning XQuery results as a table
XMLTABLE advantages
XMLTABLE example: Inserting values returned from XMLTABLE
XMLTABLE example: Returning one row for each occurrence of an item
XMLTABLE example: Specifying a default value for a column in the result table
XMLTABLE example: Specifying an ordinality column in the result table
XML support in native SQL routines
Requests for data in XML columns by earlier DB2 clients
Functions for constructing XML values
Special character handling in SQL/XML publishing functions
XML serialization
Differences in an XML document after storage and retrieval
XML data indexing
Pattern expressions
Namespace declarations in XML index definitions
Data types associated with pattern expressions
XML schemas and XML indexes
The UNIQUE keyword in an XML index definition
Access methods with XML indexes
Example of DOCID ANDing access (ACCESSTYPE='DI')
Example of DOCID ORing access (ACCESSTYPE='DU')
Examples of index definitions and queries that use them
Examples of XML index usage by equal predicates
Examples of XML index usage by predicates that test for node existence
Example of XML index usage by predicates with case-insensitive comparisons
Example of index usage for an XMLEXISTS predicate with the fn:starts-with function
Example of index usage for an XMLEXISTS predicate with the fn:substring function
Example of XML index usage by join predicates
Example of XML index usage by queries with XMLTABLE
XML support in DB2 utilities
XML schema management with the XML schema repository (XSR)
DB2-supplied stored procedures for XML schema registration and removal
XSR_REGISTER stored procedure
XSR_ADDSCHEMADOC stored procedure
XSR_COMPLETE stored procedure
XSR_REMOVE stored procedure
Example of XML schema registration and removal using stored procedures
DB2 application programming language support for XML
XML data in Java applications
XML data in embedded SQL applications
Host variable data types for XML data in embedded SQL applications
XML column updates in embedded SQL applications
XML data retrieval in embedded SQL applications
XML data in ODBC applications
XML column updates in ODBC applications
XML data retrieval in ODBC applications
Data types for archiving XML documents
XML data encoding
Background information on XML internal encoding
XML encoding considerations
Encoding considerations for input of XML data to a DB2 table
Encoding considerations for retrieval of XML data from a DB2 table
XML data encoding in JDBC and SQLJ applications
XML encoding scenarios
Encoding scenarios for input of internally encoded XML data to a DB2 table
Encoding scenarios for input of externally encoded XML data to a database
Encoding scenarios for retrieval of XML data with implicit serialization
Encoding scenarios for retrieval of XML data with explicit XMLSERIALIZE
Mappings of encoding names to effective CCSIDs for stored XML data
Mappings of CCSIDs to encoding names for textual XML output data
Overview of XQuery
Best applications for XQuery or XPath
XML namespaces and qualified names in DB2 XQuery
Case sensitivity in DB2 XQuery
Whitespace in DB2 XQuery
Comments in DB2 XQuery
XQuery type system
Overview of the type system
Constructor functions for built-in data types
Generic data types
xs:anyType
xs:anySimpleType
xs:anyAtomicType
Data types for untyped data
xs:untyped
xs:untypedAtomic
xs:string
Numeric data types
xs:decimal
xs:double
xs:integer
Range limits for numeric types
xs:boolean
Date and time data types
xs:date
xs:dateTime
xs:dayTimeDuration
xs:duration
xs:time
xs:yearMonthDuration
Casts between XML schema data types
XQuery prologs and expressions
Prologs
Boundary-space declaration
Copy-namespaces declaration
Namespace declarations
Default namespace declarations
Expressions
Expression evaluation and processing
Atomization
Type promotion
Subtype substitution
Primary expressions
Literals
Predefined entity references
Character references
Variable references in DB2 XQuery
Parenthesized expression
Context item expressions
Function calls
Path expressions
Axis steps
Axes
Node tests
Predicates
Abbreviated syntax for path expressions
Sequence expressions
Expressions that construct sequences
Filter expressions
Arithmetic expressions
Comparison expressions
Value comparisons
General comparisons
Node comparisons
Logical expressions
XQuery constructors
Enclosed expressions in constructors
Direct element constructors
Namespace declaration attributes
Boundary whitespace in direct element constructors
In-scope namespaces of a constructed element
Document node constructors
Processing instruction constructors
Direct processing instruction constructors
Comment constructors
Direct comment constructors
FLWOR expressions
Syntax of FLWOR expressions
for and let clauses
for clauses
let clauses
for and let clauses in the same expression
Variable scope in for and let clauses
where clauses
order by clauses
return clauses
FLWOR examples
Conditional expressions
Basic updating expressions
Delete expression
Insert expression
Replace expression
Castable expressions
Regular expressions
Descriptions of XQuery functions
fn:abs function
fn:adjust-date-to-timezone function
fn:adjust-dateTime-to-timezone function
fn:adjust-time-to-timezone function
fn:avg function
fn:boolean function
fn:compare function
fn:concat function
fn:contains function
fn:count function
fn:current-date function
fn:current-dateTime function
fn:current-time function
fn:data function
fn:dateTime function
fn:day-from-date function
fn:day-from-dateTime function
fn:days-from-duration function
fn:distinct-values function
fn:hours-from-dateTime function
fn:hours-from-duration function
fn:hours-from-time function
fn:implicit-timezone function
fn:minutes-from-dateTime function
fn:minutes-from-duration function
fn:minutes-from-time function
fn:month-from-date function
fn:month-from-dateTime function
fn:months-from-duration function
fn:normalize-space function
fn:last function
fn:local-name function
fn:lower-case function
fn:matches function
fn:max function
fn:min function
fn:name function
fn:not function
fn:position function
fn:replace function
fn:round function
fn:seconds-from-datetime function
fn:seconds-from-duration function
fn:seconds-from-time function
fn:starts-with function
fn:string function
fn:string-length function
fn:substring function
fn:sum function
fn:timezone-from-date function
fn:timezone-from-dateTime function
fn:timezone-from-time function
fn:tokenize function
fn:translate function
fn:upper-case function
fn:year-from-date function
fn:year-from-datetime function
fn:years-from-duration function
Index for programming for XML
Implementing DB2 stored procedures
Stored procedures
Configuring DB2 for running stored procedures and user-defined functions
Tailoring DB2 subsystem parameters for stored procedures during installation (optional)
Setting up Language Environment for stored procedures during installation
Implementing RRS for stored procedures during installation
Setting up a WLM application environment for stored procedures during installation
Creating a stored procedure
Creating a native SQL procedure
Creating an external SQL procedure
Creating an external stored procedure
Dropping stored procedures
Calling a stored procedure from your application
Running stored procedures from the command line processor
Altering stored procedures
Debugging stored procedures
Improving the performance of stored procedures and user-defined functions
Migrating an external SQL procedure to a native SQL procedure
Migrating stored procedures from test to production
Troubleshooting for DB2
Techniques for troubleshooting problems
Searching for messages and codes
DB2 messages
How to interpret message numbers
Subcomponent identifiers
How to find additional information about messages
DSNA messages
DSNA002E
DSNA201E
DSNA202E
DSNA203E
DSNA204E
DSNA205E
DSNA206E
DSNA207E
DSNA208E
DSNA209E
DSNA301I
DSNA302I
DSNA303I
DSNA304I
DSNA305I
DSNA306I
DSNA307I
DSNA308I
DSNA309I
DSNA310I
DSNA311I
DSNA312I
DSNA313I
DSNA314I
DSNA315I
DSNA316I
DSNA317I
DSNA318I
DSNA319I
DSNA320I
DSNA321I
DSNA601I
DSNA602I
DSNA603I
DSNA604I
DSNA605I
DSNA606I
DSNA607I
DSNA608I
DSNA609I
DSNA610I
DSNA611I
DSNA612I
DSNA613I
DSNA614I
DSNA615I
DSNA616I
DSNA617I
DSNA618I
DSNA619I
DSNA620I
DSNA621I
DSNA622I
DSNA623I
DSNA624I
DSNA625I
DSNA626I
DSNA627I
DSNA629I
DSNA631I
DSNA632I
DSNA634I
DSNA635I
DSNA636I
DSNA637I
DSNA638I
DSNA639I
DSNA640I
DSNA643I
DSNA644I
DSNA645I
DSNA646I
DSNA648I
DSNA649I
DSNA650I
DSNA651I
DSNA652I
DSNA653I
DSNA654I
DSNA655I
DSNA656I
DSNA657I
DSNA659I
DSNA660I
DSNA661I
DSNA662I
DSNA663I
DSNA664I
DSNA665I
DSNA667I
DSNA668I
DSNA670I
DSNA671I
DSNA672I
DSNA673I
DSNA674I
DSNA675I
DSNA676I
DSNA677I
DSNA678I
DSNA679I
DSNA681I
DSNA682I
DSNA683I
DSNA684I
DSNA690I
DSNA691I
DSNA692I
DSNA693I
DSNA694I
DSNB messages
DSNB200I
DSNB204I
DSNB207I
DSNB209I
DSNB212I
DSNB215I
DSNB217I
DSNB219I
DSNB221I
DSNB223I
DSNB224I
DSNB225I
DSNB226I
DSNB227I
DSNB228I
DSNB229I
DSNB232I
DSNB235A
DSNB250E
DSNB260I
DSNB301E
DSNB302I
DSNB303E
DSNB304I
DSNB305I
DSNB306I
DSNB307I
DSNB308I
DSNB309I
DSNB310I
DSNB311I
DSNB312I
DSNB313I
DSNB314I
DSNB315I
DSNB316I
DSNB319A
DSNB320I
DSNB321I
DSNB322I
DSNB323I
DSNB325A
DSNB327I
DSNB330I
DSNB331I
DSNB332I
DSNB333I
DSNB335I
DSNB338I
DSNB339I
DSNB340I
DSNB350I
DSNB351I
DSNB352I
DSNB353I
DSNB354I
DSNB357I
DSNB401I
DSNB402I
DSNB404I
DSNB406I
DSNB408I
DSNB409I
DSNB410I
DSNB411I
DSNB412I
DSNB413I
DSNB414I
DSNB415I
DSNB420I
DSNB421I
DSNB440I
DSNB441I
DSNB453I
DSNB455I
DSNB456I
DSNB459I
DSNB460I
DSNB463I
DSNB464I
DSNB466I
DSNB467I
DSNB468I
DSNB469I
DSNB499I
DSNB501I
DSNB502I
DSNB504I
DSNB506I
DSNB507I
DSNB508I
DSNB510I
DSNB511I
DSNB512I
DSNB514I
DSNB516I
DSNB517I
DSNB519I
DSNB520I
DSNB521I
DSNB522I
DSNB524I
DSNB526I
DSNB527I
DSNB529I
DSNB530I
DSNB531I
DSNB532I
DSNB533I
DSNB534I
DSNB536I
DSNB538I
DSNB539I
DSNB540I
DSNB541I
DSNB542I
DSNB543I
DSNB544I
DSNB551I
DSNB552I
DSNB553I
DSNB555I
DSNB601I
DSNB602I
DSNB603I
DSNB605I
DSNB609I
DSNB610I
DSNB740I
DSNB741I
DSNB742I
DSNB743I
DSNB744I
DSNB745I
DSNB749I
DSNB750I
DSNB751I
DSNB752I
DSNB753I
DSNB755I
DSNB756I
DSNB757I
DSNB758I
DSNB759I
DSNB760I
DSNB761I
DSNB762I
DSNB763I
DSNB764I
DSNB765I
DSNB766I
DSNB767I
DSNB768I
DSNB769I
DSNB770I
DSNB771I
DSNB772I
DSNB773I
DSNB774I
DSNB776I
DSNB777I
DSNB778I
DSNB780I
DSNB781I
DSNB782I
DSNB783I
DSNB784I
DSNB785I
DSNB786I
DSNB787I
DSNB788I
DSNB789I
DSNB790I
DSNB791I
DSNB792I
DSNB793I
DSNB794I
DSNB795I
DSNB796I
DSNB797I
DSNB798I
DSNB799I
DSNB800I
DSNB801I
DSNB802I
DSNB803I
DSNB804I
DSNB805I
DSNB806I
DSNB807I
DSNB808I
DSNB809I
DSNB812I
DSNB813I
DSNB814I
DSNB815I
DSNB816I
DSNB890I
DSNB891I
DSNB892I
DSNE messages
DSNET20I
DSNE004E
DSNE005A
DSNE006A
DSNE008I
DSNE009I
DSNE010I
DSNE011I
DSNE100I
DSNE101I
DSNE102I
DSNE103E
DSNE104E
DSNE105E
DSNE106E
DSNE107E
DSNE108E
DSNE109E
DSNE110E
DSNE111E
DSNE112E
DSNE113E
DSNE114E
DSNE117E
DSNE118E
DSNE119E
DSNE120E
DSNE121E
DSNE122E
DSNE123I
DSNE124E
DSNE125E
DSNE126E
DSNE127I
DSNE128I
DSNE130I
DSNE131I
DSNE132I
DSNE133E
DSNE136I
DSNE137I
DSNE231A
DSNE232A
DSNE233A
DSNE234A
DSNE235A
DSNE236A
DSNE237A
DSNE240A
DSNE241A
DSNE242A
DSNE243A
DSNE244A
DSNE245A
DSNE246A
DSNE247A
DSNE248A
DSNE250A
DSNE252A
DSNE283A
DSNE288A
DSNE291A
DSNE292I
DSNE293A
DSNE294I
DSNE295A
DSNE296A
DSNE297A
DSNE298A
DSNE340I
DSNE345I
DSNE346I
DSNE351A
DSNE352A
DSNE353A
DSNE354A
DSNE355A
DSNE359A
DSNE360A
DSNE361I
DSNE363A
DSNE364A
DSNE365A
DSNE366A
DSNE367A
DSNE368A
DSNE370A
DSNE371A
DSNE372A
DSNE374A
DSNE375A
DSNE376A
DSNE377A
DSNE378A
DSNE379A
DSNE381A
DSNE383A
DSNE384A
DSNE385A
DSNE386A
DSNE387I
DSNE388A
DSNE389A
DSNE390A
DSNE391I
DSNE392I
DSNE393I
DSNE395I
DSNE396A
DSNE601I
DSNE603E
DSNE604E
DSNE605E
DSNE606E
DSNE607E
DSNE609E
DSNE610I
DSNE611I
DSNE612I
DSNE613I
DSNE614I
DSNE615I
DSNE616I
DSNE617I
DSNE618I
DSNE620I
DSNE621I
DSNE622I
DSNE623I
DSNE624I
DSNE625I
DSNE626I
DSNE627I
DSNE800A
DSNE803A
DSNE804A
DSNE808A
DSNE901I
DSNE903I
DSNE904I
DSNE905I
DSNE908E
DSNE909E
DSNE910E
DSNE920E
DSNE921E
DSNE922E
DSNE923E
DSNE924E
DSNE925E
DSNE926E
DSNE927E
DSNE928E
DSNE929E
DSNE930E
DSNE931E
DSNE932I
DSNE935I
DSNE936I
DSNE937I
DSNE938I
DSNE939E
DSNE940E
DSNE941I
DSNE942E
DSNE943E
DSNE944I
DSNE947I
DSNE948I
DSNE949E
DSNE950E
DSNE952I
DSNE953I
DSNE954I
DSNE955I
DSNE956A
DSNE957I
DSNE958I
DSNE960E
DSNE964E
DSNE965E
DSNE966E
DSNE967E
DSNE969E
DSNE970E
DSNE971E
DSNE974E
DSNE975E
DSNE976E
DSNF messages
DSNF001I
DSNF700I
DSNG messages
DSNG001I
DSNG002I
DSNG003I
DSNG004I
DSNG005I
DSNG006I
DSNG007I
DSNG008I
DSNG009I
DSNG010I
DSNG011I
DSNH messages
DSNH003I
DSNH004I
DSNH005I
DSNH006I
DSNH007I
DSNH008I
DSNH009I
DSNH010I
DSNH011I
DSNH012I
DSNH013I
DSNH014I
DSNH016I
DSNH019I
DSNH021I
DSNH022I
DSNH023I
DSNH024I
DSNH025I
DSNH026I
DSNH027I
DSNH028I
DSNH029I
DSNH030I
DSNH031I
DSNH032I
DSNH033I
DSNH034I
DSNH038I
DSNH041I
DSNH042I
DSNH049I
DSNH050I
DSNH051I
DSNH052I
DSNH053I
DSNH057I
DSNH060I
DSNH078I
DSNH080I
DSNH081I
DSNH083I
DSNH084I
DSNH088I
DSNH090I
DSNH091I
DSNH097I
DSNH101I
DSNH102I
DSNH103I
DSNH104I
DSNH105I
DSNH107I
DSNH109I
DSNH110I
DSNH111W
DSNH113I
DSNH115I
DSNH117I
DSNH120I
DSNH125I
DSNH126I
DSNH129I
DSNH130I
DSNH131I
DSNH132I
DSNH142I
DSNH170I
DSNH171I
DSNH182I
DSNH184I
DSNH198I
DSNH199I
DSNH203I
DSNH204I
DSNH205I
DSNH206I
DSNH207I
DSNH251I
DSNH270I
DSNH290I
DSNH291I
DSNH292I
DSNH303I
DSNH310I
DSNH312I
DSNH313I
DSNH314I
DSNH330I
DSNH331I
DSNH332I
DSNH350I
DSNH372I
DSNH385I
DSNH401I
DSNH402I
DSNH404I
DSNH405I
DSNH408I
DSNH414I
DSNH434I
DSNH435I
DSNH449I
DSNH451I
DSNH457I
DSNH473I
DSNH487I
DSNH490I
DSNH491I
DSNH504I
DSNH506I
DSNH520I
DSNH521I
DSNH522I
DSNH527I
DSNH557I
DSNH558I
DSNH562I
DSNH577I
DSNH580I
DSNH581I
DSNH582I
DSNH585I
DSNH586I
DSNH587I
DSNH590I
DSNH599I
DSNH612I
DSNH628I
DSNH630E
DSNH637I
DSNH643I
DSNH644I
DSNH683I
DSNH684I
DSNH739I
DSNH740I
DSNH741I
DSNH750I
DSNH751I
DSNH752I
DSNH753I
DSNH754I
DSNH755I
DSNH756I
DSNH757I
DSNH758I
DSNH759I
DSNH760I
DSNH794I
DSNH867I
DSNH901I
DSNH902I
DSNH904I
DSNH1760I
DSNH4001I
DSNH4408I
DSNH4700I
DSNH4701I
DSNH4702I
DSNH4760I
DSNH4761I
DSNH4762I
DSNH4763I
DSNH4770I
DSNH4771I
DSNH4772I
DSNH4773I
DSNH4775I
DSNH4777I
DSNH4778I
DSNH4779I
DSNH4780I
DSNH4781I
DSNH4782I
DSNH4783I
DSNH4784I
DSNH4785I
DSNH4787I
DSNH4788I
DSNH4789I
DSNH4920I
DSNH5011I
DSNH5033I
DSNH5034I
DSNH5035I
DSNH5036I
DSNH5037I
DSNH20008I
DSNH20060I
DSNH20061I
DSNH20111I
DSNH20120I
DSNH20129I
DSNH20148I
DSNH20228I
DSNH20289I
DSNH20367I
DSNH20428I
DSNH20474I
DSNI messages
DSNI001I
DSNI002I
DSNI003I
DSNI004I
DSNI005I
DSNI006I
DSNI007I
DSNI008I
DSNI009I
DSNI010I
DSNI011I
DSNI012I
DSNI013I
DSNI014I
DSNI015I
DSNI016I
DSNI017I
DSNI018I
DSNI019I
DSNI020I
DSNI021I
DSNI022I
DSNI023I
DSNI024I
DSNI025I
DSNI026I
DSNI027I
DSNI028I
DSNI029I
DSNI030I
DSNI031I
DSNI032I
DSNI033I
DSNI034I
DSNI036I
DSNI037I
DSNI038I
DSNI040I
DSNI041I
DSNI042I
DSNI043I
DSNI044I
DSNI045I
DSNI046I
DSNI047I
DSNI048I
DSNI049I
DSNJ messages
DSNJ001I
DSNJ002I
DSNJ003I
DSNJ004I
DSNJ005I
DSNJ006I
DSNJ007I
DSNJ008E
DSNJ009E
DSNJ010I
DSNJ011I
DSNJ012I
DSNJ013I
DSNJ014I
DSNJ015I
DSNJ016E
DSNJ017E
DSNJ020I
DSNJ030I
DSNJ031I
DSNJ032I
DSNJ033E
DSNJ050I
DSNJ070I
DSNJ071I
DSNJ072E
DSNJ073I
DSNJ096E
DSNJ098E
DSNJ099I
DSNJ100I
DSNJ101E
DSNJ102I
DSNJ103I
DSNJ104I
DSNJ105I
DSNJ106I
DSNJ107I
DSNJ108I
DSNJ109I
DSNJ110E
DSNJ111E
DSNJ112E
DSNJ113E
DSNJ114I
DSNJ115I
DSNJ116I
DSNJ117I
DSNJ118I
DSNJ119I
DSNJ120I
DSNJ121I
DSNJ122I
DSNJ123I
DSNJ124I
DSNJ125I
DSNJ126I
DSNJ127I
DSNJ128I
DSNJ129I
DSNJ130I
DSNJ131I
DSNJ132I
DSNJ138I
DSNJ139I
DSNJ140I
DSNJ150E
DSNJ151I
DSNJ152I
DSNJ153E
DSNJ154I
DSNJ156I
DSNJ157I
DSNJ200I
DSNJ201I
DSNJ202I
DSNJ203I
DSNJ204I
DSNJ205I
DSNJ206I
DSNJ207I
DSNJ208E
DSNJ209I
DSNJ210I
DSNJ211I
DSNJ212I
DSNJ213I
DSNJ214I
DSNJ215I
DSNJ216I
DSNJ217I
DSNJ218I
DSNJ219I
DSNJ220I
DSNJ221I
DSNJ222I
DSNJ223I
DSNJ224I
DSNJ225I
DSNJ226I
DSNJ227I
DSNJ228I
DSNJ229I
DSNJ230I
DSNJ231I
DSNJ232I
DSNJ233I
DSNJ234I
DSNJ235I
DSNJ236I
DSNJ237I
DSNJ238I
DSNJ239I
DSNJ240I
DSNJ241I
DSNJ242I
DSNJ243I
DSNJ244I
DSNJ245I
DSNJ246I
DSNJ247E
DSNJ248I
DSNJ249I
DSNJ250E
DSNJ251E
DSNJ253I
DSNJ254I
DSNJ255I
DSNJ256I
DSNJ260I
DSNJ261I
DSNJ266I
DSNJ301I
DSNJ302I
DSNJ303I
DSNJ304I
DSNJ305I
DSNJ306I
DSNJ307I
DSNJ310I
DSNJ311I
DSNJ312I
DSNJ313I
DSNJ314I
DSNJ315I
DSNJ316I
DSNJ317I
DSNJ318I
DSNJ319I
DSNJ320I
DSNJ321I
DSNJ322I
DSNJ323I
DSNJ324I
DSNJ325I
DSNJ326I
DSNJ327I
DSNJ328I
DSNJ329I
DSNJ330I
DSNJ331I
DSNJ332I
DSNJ333I
DSNJ334I
DSNJ335I
DSNJ336I
DSNJ337I
DSNJ338I
DSNJ339I
DSNJ340I
DSNJ341I
DSNJ350I
DSNJ351I
DSNJ352W
DSNJ353I
DSNJ354I
DSNJ355I
DSNJ356I
DSNJ357E
DSNJ359I
DSNJ361I
DSNJ362E
DSNJ363I
DSNJ364I
DSNJ370I
DSNJ371I
DSNJ372I
DSNJ373I
DSNJ374I
DSNJ401I
DSNJ402I
DSNJ403I
DSNJ404E
DSNJ405E
DSNJ406E
DSNJ407I
DSNJ408I
DSNJ409I
DSNJ410E
DSNJ411I
DSNJ412E
DSNJ413E
DSNJ414I
DSNJ415E
DSNJ416I
DSNJ417I
DSNJ418I
DSNJ419I
DSNJ420I
DSNJ421I
DSNJ422I
DSNJ423I
DSNJ424I
DSNJ425I
DSNJ426I
DSNJ427I
DSNJ428I
DSNJ429I
DSNJ430I
DSNJ431I
DSNJ432I
DSNJ433I
DSNJ434I
DSNJ435I
DSNJ436I
DSNJ437I
DSNJ438I
DSNJ439I
DSNJ440I
DSNJ441I
DSNJ442I
DSNJ443I
DSNJ444I
DSNJ445I
DSNJ446I
DSNJ447I
DSNJ700I
DSNJ701E
DSNJ702E
DSNJ703E
DSNJ704I
DSNJ705I
DSNJ706I
DSNJ707E
DSNJ708I
DSNJ711E
DSNJ712E
DSNJ713E
DSNJ990I
DSNJ991I
DSNJ992I
DSNJ993I
DSNJ994I
DSNJ995I
DSNJ996I
DSNJ997I
DSNJ998I
DSNL messages
DSNL001I
DSNL002I
DSNL003I
DSNL004I
DSNL005I
DSNL006I
DSNL007I
DSNL008I
DSNL009I
DSNL010I
DSNL011I
DSNL012I
DSNL013I
DSNL014I
DSNL015I
DSNL016I
DSNL017I
DSNL018I
DSNL019I
DSNL020I
DSNL021I
DSNL022I
DSNL023I
DSNL024I
DSNL025I
DSNL026I
DSNL027I
DSNL028I
DSNL029I
DSNL030I
DSNL031I
DSNL032I
DSNL033I
DSNL034E
DSNL035I
DSNL036I
DSNL037I
DSNL038E
DSNL039E
DSNL040E
DSNL041E
DSNL042E
DSNL043I
DSNL044I
DSNL045I
DSNL046I
DSNL047I
DSNL048I
DSNL065I
DSNL066I
DSNL067I
DSNL068I
DSNL069I
DSNL070I
DSNL071I
DSNL072I
DSNL073I
DSNL080I
DSNL081I
DSNL082I
DSNL083I
DSNL084I
DSNL085I
DSNL086I
DSNL087I
DSNL088I
DSNL089I
DSNL090I
DSNL092I
DSNL093I
DSNL096I
DSNL099I
DSNL100I
DSNL101I
DSNL102I
DSNL105I
DSNL106I
DSNL199I
DSNL200I
DSNL203I
DSNL204I
DSNL300I
DSNL301I
DSNL302I
DSNL303I
DSNL304I
DSNL305I
DSNL306I
DSNL307I
DSNL308I
DSNL309I
DSNL310I
DSNL311I
DSNL312I
DSNL313I
DSNL314I
DSNL315I
DSNL400E
DSNL401E
DSNL402I
DSNL403I
DSNL404E
DSNL405I
DSNL406I
DSNL407I
DSNL408I
DSNL409I
DSNL410I
DSNL411E
DSNL412I
DSNL413I
DSNL414E
DSNL415I
DSNL416I
DSNL417E
DSNL418E
DSNL419I
DSNL420I
DSNL421I
DSNL422I
DSNL423I
DSNL424I
DSNL425I
DSNL429I
DSNL432I
DSNL433I
DSNL434E
DSNL438I
DSNL439I
DSNL440I
DSNL441I
DSNL442I
DSNL443I
DSNL444I
DSNL445I
DSNL446I
DSNL447I
DSNL448I
DSNL449I
DSNL450I
DSNL451I
DSNL452I
DSNL453I
DSNL454I
DSNL455I
DSNL500I
DSNL501I
DSNL502I
DSNL504I
DSNL510I
DSNL511I
DSNL512I
DSNL513I
DSNL514I
DSNL515I
DSNL516I
DSNL517I
DSNL518I
DSNL519I
DSNL520I
DSNL521I
DSNL523I
DSNL600I
DSNL700I
DSNL701I
DSNL702I
DSNL703I
DSNL704I
DSNL705I
DSNL706I
DSNL800I
DSNM messages
DSNM001I
DSNM002I
DSNM003I
DSNM004I
DSNM005I
DSNM100I
DSNM104I
DSNP messages
DSNP001I
DSNP002I
DSNP003I
DSNP004I
DSNP005I
DSNP006I
DSNP007I
DSNP008I
DSNP009I
DSNP010I
DSNP011I
DSNP012I
DSNP013I
DSNP014I
DSNP015I
DSNP016I
DSNP017I
DSNP018I
DSNP019I
DSNP020I
DSNP021I
DSNP022I
DSNP026I
DSNP027I
DSNP028I
DSNP030I
DSNP031I
DSNQ messages
DSNQ001I
DSNQ002I
DSNQ003I
DSNQ004I
DSNQ010I
DSNQ011I
DSNQ012I
DSNQ020I
DSNQ021I
DSNQ022I
DSNQ030I
DSNQ040I
DSNQ060I
DSNQ061I
DSNQ070I
DSNQ071I
DSNQ072I
DSNQ073I
DSNQ074I
DSNQ075I
DSNQ080I
DSNQ081I
DSNQ082I
DSNR messages
DSNR001I
DSNR002I
DSNR003I
DSNR004I
DSNR005I
DSNR006I
DSNR007I
DSNR009I
DSNR010I
DSNR011I
DSNR014I
DSNR015I
DSNR016I
DSNR017I
DSNR018I
DSNR020I
DSNR021I
DSNR022I
DSNR023I
DSNR024I
DSNR025I
DSNR026I
DSNR030I
DSNR031I
DSNR034E
DSNR035I
DSNR036I
DSNR037I
DSNR038I
DSNR039I
DSNR040I
DSNR042I
DSNR043E
DSNR044E
DSNR045I
DSNR046I
DSNR047I
DSNR048I
DSNR050I
DSNR051I
DSNR052I
DSNR053I
DSNR054I
DSNR055I
DSNR056I
DSNR057I
DSNR058I
DSNR059I
DSNR060I
DSNR061I
DSNR062I
DSNR063I
DSNR064I
DSNR065I
DSNS messages
DSNS001I
DSNS002I
DSNS003I
DSNS004I
DSNT messages
DSNT000I
DSNT001I
DSNT002I
DSNT003I
DSNT004I
DSNT005I
DSNT006I
DSNT007I
DSNT008I
DSNT009I
DSNT010I
DSNT011I
DSNT012I
DSNT013I
DSNT014I
DSNT015I
DSNT016I
DSNT017I
DSNT018I
DSNT019I
DSNT020I
DSNT021I
DSNT022I
DSNT023I
DSNT024I
DSNT025I
DSNT026I
DSNT027I
DSNT028I
DSNT029I
DSNT030I
DSNT031I
DSNT032I
DSNT033I
DSNT034I
DSNT035I
DSNT036I
DSNT037I
DSNT038I
DSNT039I
DSNT040I
DSNT041I
DSNT042I
DSNT043I
DSNT044I
DSNT045I
DSNT046I
DSNT047I
DSNT048I
DSNT049I
DSNT050I
DSNT051I
DSNT052I
DSNT053I
DSNT054I
DSNT055I
DSNT089I
DSNT090I
DSNT091I
DSNT092I
DSNT093I
DSNT094I
DSNT095I
DSNT096I
DSNT097I
DSNT098I
DSNT099I
DSNT101I
DSNT102I
DSNT103I
DSNT104I
DSNT105I
DSNT106I
DSNT107I
DSNT108I
DSNT109I
DSNT200I
DSNT201I
DSNT202I
DSNT203I
DSNT204I
DSNT205I
DSNT206I
DSNT207I
DSNT208I
DSNT209I
DSNT210I
DSNT211I
DSNT212I
DSNT213I
DSNT214I
DSNT215I
DSNT216I
DSNT217I
DSNT218I
DSNT219I
DSNT220I
DSNT221I
DSNT222I
DSNT223I
DSNT224I
DSNT225I
DSNT226I
DSNT227I
DSNT228I
DSNT229I
DSNT230I
DSNT231I
DSNT232I
DSNT233I
DSNT234I
DSNT235I
DSNT236I
DSNT237I
DSNT238I
DSNT239I
DSNT240I
DSNT241I
DSNT242I
DSNT243I
DSNT244I
DSNT245I
DSNT246I
DSNT247I
DSNT248I
DSNT249I
DSNT250I
DSNT251I
DSNT252I
DSNT253I
DSNT254I
DSNT255I
DSNT256I
DSNT257I
DSNT258I
DSNT259I
DSNT260I
DSNT261I
DSNT262I
DSNT263I
DSNT264I
DSNT265I
DSNT266I
DSNT267I
DSNT268I
DSNT269I
DSNT270I
DSNT271I
DSNT280I
DSNT281I
DSNT282I
DSNT284I
DSNT285I
DSNT286I
DSNT287I
DSNT288I
DSNT289I
DSNT290I
DSNT291I
DSNT292I
DSNT293I
DSNT294I
DSNT295I
DSNT300I
DSNT301I
DSNT302I
DSNT304I
DSNT305I
DSNT306I
DSNT307I
DSNT308I
DSNT309I
DSNT310I
DSNT311I
DSNT312I
DSNT313I
DSNT314I
DSNT315I
DSNT316I
DSNT317I
DSNT318I
DSNT331I
DSNT332I
DSNT350I
DSNT352I
DSNT358I
DSNT359I
DSNT360I
DSNT361I
DSNT362I
DSNT363I
DSNT364I
DSNT365I
DSNT366I
DSNT367I
DSNT368I
DSNT375I
DSNT376I
DSNT377I
DSNT378I
DSNT379I
DSNT380I
DSNT381I
DSNT382I
DSNT383I
DSNT384I
DSNT386I
DSNT387I
DSNT388I
DSNT389I
DSNT390I
DSNT391I
DSNT392I
DSNT393I
DSNT394I
DSNT395I
DSNT396I
DSNT397I
DSNT398I
DSNT399I
DSNT400I
DSNT402I
DSNT404I
DSNT405E
DSNT406I
DSNT407I
DSNT408I
DSNT409I
DSNT410I
DSNT411I
DSNT412I
DSNT413I
DSNT414I
DSNT415I
DSNT416I
DSNT417I
DSNT418I
DSNT419I
DSNT422I
DSNT424I
DSNT425I
DSNT426I
DSNT427I
DSNT428I
DSNT429I
DSNT430I
DSNT431I
DSNT433I
DSNT434I
DSNT435I
DSNT436I
DSNT437I
DSNT438I
DSNT439I
DSNT440I
DSNT442E
DSNT443I
DSNT444I
DSNT445I
DSNT446I
DSNT448I
DSNT449I
DSNT450I
DSNT451I
DSNT454I
DSNT456I
DSNT457I
DSNT458I
DSNT459I
DSNT460I
DSNT461I
DSNT462I
DSNT463I
DSNT464I
DSNT465I
DSNT466I
DSNT467I
DSNT468I
DSNT469I
DSNT470I
DSNT471I
DSNT472I
DSNT473I
DSNT474I
DSNT475I
DSNT476I
DSNT477I
DSNT478I
DSNT479I
DSNT480I
DSNT481I
DSNT482I
DSNT483I
DSNT485I
DSNT486I
DSNT487I
DSNT488I
DSNT489I
DSNT490I
DSNT491I
DSNT492I
DSNT493I
DSNT494I
DSNT495I
DSNT496I
DSNT497I
DSNT498I
DSNT499I
DSNT500I
DSNT501I
DSNT502I
DSNT503I
DSNT504I
DSNT505I
DSNT506I
DSNT507I
DSNT508I
DSNT509I
DSNT510I
DSNT511I
DSNT512I
DSNT513I
DSNT514I
DSNT515I
DSNT516I
DSNT517I
DSNT518I
DSNT519I
DSNT526I
DSNT527I
DSNT528I
DSNT530I
DSNT531I
DSNT532I
DSNT533I
DSNT534I
DSNT540I
DSNT541I
DSNT542I
DSNT543I
DSNT544I
DSNT545I
DSNT546I
DSNT547I
DSNT550I
DSNT551I
DSNT552I
DSNT555I
DSNT556I
DSNT557I
DSNT558I
DSNT560I
DSNT561I
DSNT562I
DSNT563I
DSNT564I
DSNT568I
DSNT569I
DSNT570I
DSNT571I
DSNT601I
DSNT602I
DSNT603I
DSNT604I
DSNT694I
DSNT695I
DSNT696I
DSNT700I
DSNT701I
DSNT702I
DSNT703I
DSNT704I
DSNT705I
DSNT706I
DSNT707I
DSNT708I
DSNT709I
DSNT710I
DSNT711I
DSNT712I
DSNT713I
DSNT714I
DSNT715E
DSNT716E
DSNT717I
DSNT718I
DSNT719I
DSNT720I
DSNT721I
DSNT722I
DSNT723I
DSNT724E
DSNT725E
DSNT726I
DSNT727I
DSNT735I
DSNT736I
DSNT740I
DSNT741I
DSNT742I
DSNT743I
DSNT744I
DSNT745I
DSNT746I
DSNT747I
DSNT748I
DSNT749I
DSNT750I
DSNT751I
DSNT752I
DSNT753I
DSNT758I
DSNT759I
DSNT760I
DSNT771I
DSNT772I
DSNT800I
DSNT801I
DSNT802I
DSNT803I
DSNT804I
DSNT805I
DSNT806I
DSNT807I
DSNT809E
DSNT810E
DSNT811E
DSNT812I
DSNT813I
DSNT814I
DSNT815I
DSNT816I
DSNT818I
DSNU messages
DSNU000I
DSNU001I
DSNU002I
DSNU003I
DSNU004I
DSNU005I
DSNU006I
DSNU007I
DSNU008I
DSNU009I
DSNU010I
DSNU011I
DSNU012I
DSNU013I
DSNU014I
DSNU015I
DSNU016I
DSNU017I
DSNU018I
DSNU019I
DSNU020I
DSNU021I
DSNU024I
DSNU025I
DSNU028I
DSNU030I
DSNU031I
DSNU032I
DSNU033I
DSNU034I
DSNU035I
DSNU036I
DSNU037I
DSNU038I
DSNU039I
DSNU040I
DSNU041I
DSNU042I
DSNU044I
DSNU046I
DSNU047I
DSNU048I
DSNU049I
DSNU050I
DSNU051I
DSNU052I
DSNU053I
DSNU054I
DSNU055I
DSNU056I
DSNU057I
DSNU058I
DSNU059I
DSNU060I
DSNU061I
DSNU062I
DSNU063I
DSNU064I
DSNU065I
DSNU066I
DSNU067I
DSNU068I
DSNU069I
DSNU070I
DSNU071I
DSNU072I
DSNU073I
DSNU074I
DSNU075I
DSNU076I
DSNU077I
DSNU078I
DSNU079I
DSNU080I
DSNU081I
DSNU082I
DSNU083I
DSNU084I
DSNU085I
DSNU086I
DSNU087I
DSNU088I
DSNU089I
DSNU090I
DSNU091I
DSNU092I
DSNU093I
DSNU094I
DSNU095I
DSNU096I
DSNU097I
DSNU099I
DSNU100I
DSNU103I
DSNU104I
DSNU105I
DSNU106I
DSNU107I
DSNU108I
DSNU109I
DSNU110I
DSNU111I
DSNU112I
DSNU113I
DSNU114I
DSNU115I
DSNU116I
DSNU118I
DSNU120I
DSNU121I
DSNU122I
DSNU123I
DSNU124I
DSNU125I
DSNU126I
DSNU160I
DSNU161I
DSNU162I
DSNU164I
DSNU166I
DSNU170I
DSNU172I
DSNU180I
DSNU181I
DSNU182I
DSNU183I
DSNU184I
DSNU185I
DSNU186I
DSNU188I
DSNU189I
DSNU190I
DSNU191I
DSNU192I
DSNU200I
DSNU201I
DSNU202I
DSNU203I
DSNU204I
DSNU205I
DSNU206I
DSNU207I
DSNU208I
DSNU209I
DSNU210I
DSNU211I
DSNU212I
DSNU213I
DSNU214I
DSNU215I
DSNU231I
DSNU232I
DSNU233I
DSNU234I
DSNU235I
DSNU236I
DSNU241I
DSNU242I
DSNU243I
DSNU244I
DSNU245I
DSNU246I
DSNU247I
DSNU250I
DSNU251I
DSNU252I
DSNU253I
DSNU254I
DSNU255I
DSNU256I
DSNU257I
DSNU258I
DSNU259I
DSNU260I
DSNU269I
DSNU270I
DSNU271I
DSNU272I
DSNU274I
DSNU275I
DSNU280I
DSNU281I
DSNU282I
DSNU283I
DSNU284I
DSNU286I
DSNU287I
DSNU288I
DSNU289I
DSNU290I
DSNU291I
DSNU292I
DSNU293I
DSNU294I
DSNU295I
DSNU296I
DSNU297I
DSNU298I
DSNU299I
DSNU300I
DSNU301I
DSNU302I
DSNU303I
DSNU304I
DSNU305I
DSNU306I
DSNU307I
DSNU308I
DSNU309I
DSNU310I
DSNU311I
DSNU312I
DSNU313I
DSNU314I
DSNU315I
DSNU316I
DSNU317I
DSNU318I
DSNU319I
DSNU320I
DSNU321I
DSNU322I
DSNU323I
DSNU324I
DSNU325I
DSNU326I
DSNU327I
DSNU328I
DSNU329I
DSNU330I
DSNU331I
DSNU332I
DSNU333I
DSNU334I
DSNU335I
DSNU336I
DSNU337I
DSNU338I
DSNU339I
DSNU340I
DSNU341I
DSNU342I
DSNU343I
DSNU344I
DSNU345I
DSNU346I
DSNU347I
DSNU348I
DSNU349I
DSNU350I
DSNU351I
DSNU352I
DSNU353I
DSNU354I
DSNU355I
DSNU356I
DSNU357I
DSNU358I
DSNU359I
DSNU360I
DSNU361I
DSNU362I
DSNU363I
DSNU364I
DSNU365I
DSNU366I
DSNU367I
DSNU368I
DSNU369I
DSNU370I
DSNU371I
DSNU372I
DSNU373I
DSNU374I
DSNU375I
DSNU376I
DSNU377I
DSNU378I
DSNU379I
DSNU380I
DSNU381I
DSNU382I
DSNU383I
DSNU384I
DSNU385I
DSNU386I
DSNU387I
DSNU390I
DSNU391I
DSNU392I
DSNU393I
DSNU394I
DSNU395I
DSNU396I
DSNU397I
DSNU398I
DSNU399I
DSNU400I
DSNU401I
DSNU402I
DSNU403I
DSNU404I
DSNU406I
DSNU407I
DSNU408I
DSNU409I
DSNU410I
DSNU411I
DSNU412I
DSNU413I
DSNU414I
DSNU415I
DSNU416I
DSNU417I
DSNU418I
DSNU420I
DSNU421I
DSNU422I
DSNU423I
DSNU424I
DSNU425I
DSNU426I
DSNU427I
DSNU428I
DSNU429I
DSNU430I
DSNU431I
DSNU432I
DSNU434I
DSNU440I
DSNU441I
DSNU442I
DSNU443I
DSNU445I
DSNU446I
DSNU447I
DSNU448I
DSNU449I
DSNU454I
DSNU458I
DSNU459I
DSNU460I
DSNU461I
DSNU462I
DSNU463I
DSNU464I
DSNU470I
DSNU471I
DSNU472I
DSNU473I
DSNU474I
DSNU475I
DSNU476I
DSNU477I
DSNU478I
DSNU479I
DSNU480I
DSNU481I
DSNU482I
DSNU483I
DSNU484I
DSNU485I
DSNU500I
DSNU501I
DSNU502I
DSNU503I
DSNU504I
DSNU505I
DSNU506I
DSNU507I
DSNU508I
DSNU509I
DSNU510I
DSNU511I
DSNU512I
DSNU513I
DSNU514I
DSNU515I
DSNU516I
DSNU517I
DSNU518I
DSNU519I
DSNU520I
DSNU521I
DSNU522I
DSNU523I
DSNU524I
DSNU525I
DSNU526I
DSNU527I
DSNU528I
DSNU529I
DSNU530I
DSNU531I
DSNU532I
DSNU533I
DSNU534I
DSNU535I
DSNU536I
DSNU537I
DSNU538I
DSNU539I
DSNU540I
DSNU541I
DSNU542I
DSNU543I
DSNU544I
DSNU545I
DSNU546I
DSNU547I
DSNU548I
DSNU549I
DSNU550I
DSNU551I
DSNU552I
DSNU553I
DSNU554I
DSNU555I
DSNU556I
DSNU557I
DSNU558I
DSNU559I
DSNU560I
DSNU561I
DSNU562I
DSNU563I
DSNU564I
DSNU565I
DSNU566I
DSNU568I
DSNU569I
DSNU570I
DSNU571I
DSNU572I
DSNU573I
DSNU575I
DSNU577I
DSNU578I
DSNU579I
DSNU580I
DSNU581I
DSNU582I
DSNU583I
DSNU584I
DSNU585I
DSNU586I
DSNU587I
DSNU588I
DSNU589I
DSNU590I
DSNU591I
DSNU592I
DSNU593I
DSNU594I
DSNU595I
DSNU596I
DSNU597I
DSNU598I
DSNU599I
DSNU600I
DSNU601I
DSNU602I
DSNU603I
DSNU604I
DSNU605I
DSNU606I
DSNU607I
DSNU608I
DSNU609I
DSNU610I
DSNU611I
DSNU612I
DSNU613I
DSNU614I
DSNU615I
DSNU616I
DSNU617I
DSNU618I
DSNU619I
DSNU620I
DSNU621I
DSNU622I
DSNU623I
DSNU624I
DSNU625I
DSNU626I
DSNU627I
DSNU628I
DSNU629I
DSNU630I
DSNU632I
DSNU633I
DSNU634I
DSNU635I
DSNU636I
DSNU637I
DSNU638I
DSNU639I
DSNU640I
DSNU641I
DSNU642I
DSNU643I
DSNU644I
DSNU645I
DSNU646I
DSNU647I
DSNU648I
DSNU650I
DSNU651I
DSNU652I
DSNU653I
DSNU654I
DSNU655I
DSNU656I
DSNU657I
DSNU658I
DSNU659I
DSNU660I
DSNU661I
DSNU662I
DSNU663I
DSNU664I
DSNU665I
DSNU666I
DSNU668I
DSNU669I
DSNU670I
DSNU672I
DSNU673I
DSNU676I
DSNU677I
DSNU678I
DSNU679I
DSNU680I
DSNU681I
DSNU682I
DSNU683I
DSNU684I
DSNU685I
DSNU686I
DSNU687I
DSNU688I
DSNU689I
DSNU691I
DSNU692I
DSNU694I
DSNU696I
DSNU697I
DSNU698I
DSNU699I
DSNU700I
DSNU701I
DSNU702I
DSNU703I
DSNU705I
DSNU706I
DSNU707I
DSNU708I
DSNU709I
DSNU710I
DSNU711I
DSNU712I
DSNU713I
DSNU715I
DSNU717I
DSNU718I
DSNU719I
DSNU720I
DSNU721I
DSNU722I
DSNU725I
DSNU726I
DSNU727I
DSNU728I
DSNU729I
DSNU730I
DSNU731I
DSNU732I
DSNU733I
DSNU735I
DSNU736I
DSNU737I
DSNU739I
DSNU740I
DSNU741I
DSNU742I
DSNU743I
DSNU745I
DSNU747I
DSNU749I
DSNU750I
DSNU751I
DSNU752I
DSNU756I
DSNU758I
DSNU759I
DSNU760I
DSNU762I
DSNU764I
DSNU765I
DSNU766I
DSNU767I
DSNU768I
DSNU769I
DSNU770I
DSNU771I
DSNU772I
DSNU773I
DSNU774I
DSNU775I
DSNU776I
DSNU777I
DSNU778I
DSNU780I
DSNU781I
DSNU782I
DSNU783I
DSNU784I
DSNU790I
DSNU795I
DSNU796I
DSNU805I
DSNU806I
DSNU807I
DSNU809I
DSNU811I
DSNU813I
DSNU814I
DSNU815I
DSNU816I
DSNU817I
DSNU820I
DSNU822I
DSNU823I
DSNU824I
DSNU826I
DSNU827I
DSNU830I
DSNU831I
DSNU832I
DSNU833I
DSNU834I
DSNU840I
DSNU841I
DSNU842I
DSNU843I
DSNU844I
DSNU845I
DSNU846I
DSNU848I
DSNU849I
DSNU850I
DSNU851I
DSNU852I
DSNU853I
DSNU860I
DSNU861I
DSNU862I
DSNU863I
DSNU864I
DSNU865I
DSNU866I
DSNU867I
DSNU868I
DSNU869I
DSNU870I
DSNU871I
DSNU872I
DSNU873I
DSNU874I
DSNU875I
DSNU876I
DSNU877I
DSNU900I
DSNU901I
DSNU902I
DSNU903I
DSNU904I
DSNU905I
DSNU906I
DSNU907I
DSNU908I
DSNU909I
DSNU910I
DSNU911I
DSNU912I
DSNU913I
DSNU914I
DSNU915I
DSNU916I
DSNU917I
DSNU919I
DSNU920I
DSNU921I
DSNU922I
DSNU923I
DSNU924I
DSNU925I
DSNU926I
DSNU927I
DSNU928I
DSNU929I
DSNU930I
DSNU931I
DSNU932I
DSNU935I
DSNU936I
DSNU938I
DSNU939I
DSNU971I
DSNU972I
DSNU973I
DSNU993I
DSNU994I
DSNU995I
DSNU996I
DSNU997I
DSNU998I
DSNU999I
DSNU1000I
DSNU1001I
DSNU1002I
DSNU1003I
DSNU1004I
DSNU1005I
DSNU1006I
DSNU1007I
DSNU1008I
DSNU1009I
DSNU1010I
DSNU1011I
DSNU1012I
DSNU1013I
DSNU1014I
DSNU1015I
DSNU1016I
DSNU1017I
DSNU1018I
DSNU1019I
DSNU1020I
DSNU1021I
DSNU1022I
DSNU1023I
DSNU1024I
DSNU1025I
DSNU1026I
DSNU1027I
DSNU1028I
DSNU1029I
DSNU1030I
DSNU1031I
DSNU1032I
DSNU1033I
DSNU1034I
DSNU1035I
DSNU1036I
DSNU1037I
DSNU1038I
DSNU1039I
DSNU1040I
DSNU1041I
DSNU1042I
DSNU1043I
DSNU1044I
DSNU1045I
DSNU1046I
DSNU1047I
DSNU1048I
DSNU1049I
DSNU1050I
DSNU1051I
DSNU1052I
DSNU1053I
DSNU1100I
DSNU1101I
DSNU1102I
DSNU1103I
DSNU1104I
DSNU1105I
DSNU1106I
DSNU1107I
DSNU1108I
DSNU1109I
DSNU1110I
DSNU1111I
DSNU1112I
DSNU1113I
DSNU1114I
DSNU1115I
DSNU1116I
DSNU1117I
DSNU1118I
DSNU1120I
DSNU1121I
DSNU1122I
DSNU1124I
DSNU1125I
DSNU1126I
DSNU1127I
DSNU1128I
DSNU1129I
DSNU1130I
DSNU1132I
DSNU1133I
DSNU1134I
DSNU1140I
DSNU1141I
DSNU1142I
DSNU1143I
DSNU1144I
DSNU1147I
DSNU1148I
DSNU1149I
DSNU1150I
DSNU1151I
DSNU1152I
DSNU1153I
DSNU1154I
DSNU1155I
DSNU1156I
DSNU1157I
DSNU1158I
DSNU1160I
DSNU1161I
DSNU1162I
DSNU1163I
DSNU1164I
DSNU1165I
DSNU1166I
DSNU1167I
DSNU1168I
DSNU1170I
DSNU1171I
DSNU1172I
DSNU1173I
DSNU1174I
DSNU1175I
DSNU1176I
DSNU1177I
DSNU1178I
DSNU1179I
DSNU1180I
DSNU1184I
DSNU1188I
DSNU1189I
DSNU1190I
DSNU1191I
DSNU1192I
DSNU1193I
DSNU1194I
DSNU1195I
DSNU1196I
DSNU1197I
DSNU1198I
DSNU1199I
DSNU1201I
DSNU1202I
DSNU1203I
DSNU1204I
DSNU1211I
DSNU1212I
DSNU1213I
DSNU1214I
DSNU1217I
DSNU1218I
DSNU1219I
DSNU1220I
DSNU1221I
DSNU1222I
DSNU1223I
DSNU1224I
DSNU1225I
DSNU1226I
DSNU1227I
DSNU1228I
DSNU1229I
DSNU1230I
DSNU1231I
DSNU1232I
DSNU1233I
DSNU1234I
DSNU1235I
DSNU1236I
DSNU1237I
DSNU1238I
DSNU1239I
DSNU1241I
DSNU1242I
DSNU1250I
DSNU1251I
DSNU1252I
DSNU1253I
DSNU1254I
DSNU1255I
DSNU1256I
DSNU1257I
DSNU1258I
DSNU1259I
DSNU1271I
DSNU1300I
DSNU1301I
DSNU1302I
DSNU1303I
DSNU1304I
DSNU1305I
DSNU1306I
DSNU1307I
DSNU1308I
DSNU1309I
DSNU1310I
DSNU1311I
DSNU1312I
DSNU1313I
DSNU1314I
DSNU1315I
DSNU1316I
DSNU1350I
DSNU1351I
DSNU1352I
DSNU1353I
DSNU1354I
DSNU1355I
DSNU1356I
DSNU1357I
DSNU1358I
DSNU1360I
DSNU1361I
DSNU1362I
DSNU1363I
DSNU1364I
DSNU1365I
DSNU1368I
DSNU1369I
DSNU1370I
DSNU1371I
DSNU1373I
DSNU1374I
DSNU1375I
DSNU1376I
DSNU1378I
DSNU1379I
DSNU1400I
DSNU1401I
DSNU1402I
DSNU1403I
DSNU1404I
DSNU1405I
DSNU1406I
DSNU1407I
DSNU1408I
DSNU1409I
DSNU1410I
DSNU1411I
DSNU1450I
DSNU1455I
DSNU1457I
DSNU1458I
DSNU1459I
DSNU1502I
DSNU1504I
DSNU1505I
DSNU1506I
DSNU1507I
DSNU1508I
DSNU1510I
DSNU1511I
DSNU1512I
DSNU1513I
DSNU1519I
DSNU1520I
DSNU1521I
DSNU1522I
DSNU1523I
DSNU1524I
DSNU1525I
DSNU1526I
DSNU1527I
DSNU1528I
DSNU1530I
DSNU1540I
DSNU1541I
DSNU1542I
DSNU1543I
DSNU1550I
DSNU1551I
DSNU1552I
DSNU1553I
DSNU1554I
DSNU1555I
DSNU1556I
DSNU1557I
DSNU1558I
DSNU1559I
DSNU1560I
DSNU1561I
DSNU1562I
DSNU1563I
DSNU1600I
DSNU1601I
DSNU1602I
DSNU1603I
DSNU1604I
DSNU1606I
DSNU1607I
DSNU1608I
DSNU1609I
DSNU1610I
DSNU1611I
DSNU1612I
DSNU1614I
DSNU1615I
DSNU1616I
DSNU1618I
DSNU1619I
DSNU1621I
DSNU1623I
DSNU1624I
DSNU1626I
DSNU1627I
DSNU1628I
DSNU1629I
DSNU1630I
DSNU1631I
DSNU1632I
DSNU1633I
DSNU1634I
DSNU1635I
DSNU1636I
DSNU1637I
DSNU1638I
DSNU1639I
DSNU1640I
DSNU1702I
DSNU1703I
DSNU1704I
DSNU1706I
DSNU1708I
DSNU1710I
DSNU1712I
DSNU1714I
DSNU1716I
DSNU1720I
DSNU1722I
DSNU1724I
DSNU1725I
DSNU1726I
DSNU1727I
DSNU1728I
DSNU1730I
DSNU1732I
DSNU1734I
DSNU1735I
DSNU1801I
DSNU2700I
DSNU2801I
DSNU2802I
DSNU2803I
DSNU3030I
DSNU3330I
DSNU3333I
DSNU3334I
DSNU3340I
DSNU3341I
DSNU3342I
DSNU3343I
DSNV messages
DSNV029E
DSNV086E
DSNV401I
DSNV402I
DSNV406I
DSNV413I
DSNV414I
DSNV415I
DSNV416I
DSNV417I
DSNV418I
DSNV424I
DSNV426I
DSNV427I
DSNV428I
DSNV429I
DSNV431I
DSNV434I
DSNV435I
DSNV436I
DSNV437I
DSNV439I
DSNV440I
DSNV441I
DSNV442I
DSNV443I
DSNV444I
DSNV445I
DSNV447I
DSNV448I
DSNV449I
DSNV450I
DSNV451I
DSNV452I
DSNV453I
DSNV456I
DSNV457I
DSNV458I
DSNV459I
DSNV460I
DSNV461I
DSNV462I
DSNV463I
DSNV464I
DSNV465I
DSNV466I
DSNV467I
DSNV471I
DSNV473I
DSNV474I
DSNV475I
DSNV476I
DSNV480I
DSNV481I
DSNV482I
DSNV485I
DSNV490I
DSNV492I
DSNV497I
DSNV501I
DSNV502I
DSNV503I
DSNV504I
DSNV505I
DSNV507I
DSNV508I
DSNV509I
DSNV510I
DSNV511I
DSNV512I
DSNV516I
DSNV517I
DSNW messages
DSNW001I
DSNW002I
DSNW004I
DSNW005I
DSNW006I
DSNW007I
DSNW008I
DSNW009I
DSNW010I
DSNW011I
DSNW013I
DSNW014I
DSNW015I
DSNW016I
DSNW017I
DSNW018I
DSNW020I
DSNW022I
DSNW023I
DSNW024I
DSNW025I
DSNW026I
DSNW027I
DSNW028I
DSNW029I
DSNW030I
DSNW032I
DSNW033I
DSNW034I
DSNW035I
DSNW036I
DSNW037I
DSNW038I
DSNW039I
DSNW040I
DSNW041I
DSNW049I
DSNW050I
DSNW051I
DSNW052I
DSNW053I
DSNW054I
DSNW055I
DSNW056I
DSNW060I
DSNW061I
DSNW062I
DSNW063I
DSNW108I
DSNW109I
DSNW120I
DSNW121I
DSNW122I
DSNW123I
DSNW124I
DSNW125I
DSNW126I
DSNW127I
DSNW128I
DSNW129I
DSNW130I
DSNW131I
DSNW132I
DSNW133I
DSNW135I
DSNW137I
DSNW138I
DSNW139I
DSNW140I
DSNW141I
DSNW142I
DSNW143I
DSNW147I
DSNW148I
DSNW149I
DSNW150I
DSNW151I
DSNW152I
DSNW153I
DSNW154I
DSNW155I
DSNW156I
DSNW157I
DSNW158I
DSNW159I
DSNW160I
DSNW161I
DSNW162I
DSNW163I
DSNW164I
DSNW165I
DSNW166I
DSNW167I
DSNW168I
DSNW169I
DSNW170I
DSNW171I
DSNW172I
DSNW173I
DSNW174I
DSNW175I
DSNW176I
DSNW177I
DSNW178I
DSNW179I
DSNW180I
DSNW181I
DSNW182I
DSNW183I
DSNW184I
DSNW185I
DSNW186I
DSNW187I
DSNW188I
DSNW189I
DSNW190I
DSNW192I
DSNW193I
DSNW194I
DSNW195I
DSNW196I
DSNW198I
DSNW199I
DSNX messages
DSNX100I
DSNX101I
DSNX102I
DSNX103I
DSNX104I
DSNX105I
DSNX106I
DSNX200I
DSNX201I
DSNX202I
DSNX203I
DSNX204I
DSNX205I
DSNX206I
DSNX207I
DSNX208E
DSNX209E
DSNX210I
DSNX211I
DSNX230I
DSNX231I
DSNX232E
DSNX233E
DSNX234I
DSNX800I
DSNX801I
DSNX802I
DSNX809I
DSNX810I
DSNX811I
DSNX812I
DSNX813I
DSNX814I
DSNX815I
DSNX816I
DSNX818I
DSNX819I
DSNX820I
DSNX821I
DSNX822I
DSNX823I
DSNX830I
DSNX859I
DSNX860I
DSNX861I
DSNX862I
DSNX880I
DSNX881I
DSNX905I
DSNX906I
DSNX908I
DSNX922I
DSNX923I
DSNX930I
DSNX940I
DSNX941I
DSNX942I
DSNX943I
DSNX944I
DSNX945I
DSNX946I
DSNX947I
DSNX950I
DSNX951I
DSNX955I
DSNX956I
DSNX957I
DSNX958I
DSNX960E
DSNX961I
DSNX962I
DSNX966I
DSNX967I
DSNX968I
DSNX969I
DSNX970I
DSNX971I
DSNX972I
DSNX974I
DSNX975I
DSNX977I
DSNX978I
DSNX980E
DSNX981E
DSNX982I
DSNX983I
DSNX984I
DSNX985I
DSNX986I
DSNX987I
DSNX988I
DSNX989I
DSNX990E
DSNX991I
DSNX992E
DSNX993I
DSNX994I
DSNY messages
DSNY001I
DSNY002I
DSNY003I
DSNY004I
DSNY005I
DSNY006I
DSNY007I
DSNY008I
DSNY009I
DSNY010I
DSNY011I
DSNY012I
DSNY014I
DSNY015I
DSNY020I
DSNY024I
DSNY025I
DSNZ messages
DSNZ002I
DSNZ003I
DSNZ004I
DSNZ006I
DSNZ007I
DSNZ008I
DSNZ009I
DSNZ010I
DSNZ011I
DSNZ012I
DSNZ013I
DSNZ014I
DSNZ015I
DSNZ016I
DSNZ017I
DSN1 messages
DSN1110E
DSN1111E
DSN1112E
DSN1113E
DSN1114E
DSN1115E
DSN1116E
DSN1117E
DSN1118E
DSN1119E
DSN1120E
DSN1121E
DSN1122E
DSN1123E
DSN1124E
DSN1125E
DSN1126E
DSN1127E
DSN1128E
DSN1129E
DSN1130E
DSN1131E
DSN1132E
DSN1133E
DSN1134E
DSN1135E
DSN1136E
DSN1137I
DSN1138E
DSN1139E
DSN1140E
DSN1141E
DSN1142E
DSN1143E
DSN1144E
DSN1146E
DSN1147E
DSN1148E
DSN1150I
DSN1151I
DSN1152I
DSN1153I
DSN1154I
DSN1155I
DSN1156I
DSN1157I
DSN1158I
DSN1159I
DSN1160I
DSN1162I
DSN1163E
DSN1164E
DSN1170E
DSN1171E
DSN1172E
DSN1173E
DSN1174E
DSN1175E
DSN1176E
DSN1177E
DSN1178E
DSN1179E
DSN1180E
DSN1181E
DSN1182E
DSN1183E
DSN1184E
DSN1185E
DSN1196I
DSN1197I
DSN1198I
DSN1210E
DSN1211E
DSN1212I
DSN1213I
DSN1214I
DSN1215I
DSN1216E
DSN1217E
DSN1218I
DSN1219E
DSN1220E
DSN1221E
DSN1222E
DSN1223E
DSN1224I
DSN1300E
DSN1303E
DSN1309E
DSN1401I
DSN1402I
DSN1409I
DSN1410I
DSN1411I
DSN1700E
DSN1701E
DSN1702E
DSN1703E
DSN1704E
DSN1705E
DSN1706E
DSN1707E
DSN1708E
DSN1709E
DSN1710E
DSN1711E
DSN1712I
DSN1713I
DSN1714I
DSN1715E
DSN1716E
DSN1717I
DSN1718E
DSN1719I
DSN1720I
DSN1800I
DSN1801I
DSN1802I
DSN1803I
DSN1804I
DSN1805I
DSN1806I
DSN1807I
DSN1808I
DSN1809I
DSN1810I
DSN1811I
DSN1812I
DSN1813I
DSN1814I
DSN1815I
DSN1816I
DSN1817I
DSN1818I
DSN1819I
DSN1820I
DSN1821I
DSN1822I
DSN1823I
DSN1824I
DSN1825I
DSN1826I
DSN1827I
DSN1828I
DSN1829I
DSN1830I
DSN1831I
DSN1833I
DSN1834I
DSN1835I
DSN1930I
DSN1931I
DSN1937I
DSN1938I
DSN1939I
DSN1940I
DSN1941I
DSN1942I
DSN1943I
DSN1944I
DSN1945I
DSN1946I
DSN1947I
DSN1948I
DSN1950I
DSN1951I
DSN1952I
DSN1953I
DSN1954I
DSN1955I
DSN1956I
DSN1957I
DSN1958I
DSN1959I
DSN1960I
DSN1961I
DSN1962I
DSN1963I
DSN1964I
DSN1965I
DSN1966I
DSN1967I
DSN1968I
DSN1969I
DSN1970I
DSN1971I
DSN1972I
DSN1973I
DSN1974I
DSN1975I
DSN1976I
DSN1977I
DSN1978I
DSN1979I
DSN1980I
DSN1981I
DSN1982I
DSN1983I
DSN1984I
DSN1985I
DSN1986I
DSN1987I
DSN1988I
DSN1989I
DSN1990I
DSN1991I
DSN1992I
DSN1993I
DSN1994I
DSN1995I
DSN1996I
DSN1997I
DSN1998I
DSN1999I
DSN3 messages
DSN3001I
DSN3002I
DSN3004I
DSN3006I
DSN3007I
DSN3008I
DSN3010I
DSN3011I
DSN3012I
DSN3013I
DSN3014I
DSN3015I
DSN3016I
DSN3017I
DSN3018I
DSN3019I
DSN3020I
DSN3021I
DSN3022I
DSN3023I
DSN3024I
DSN3025I
DSN3026I
DSN3027I
DSN3028I
DSN3029I
DSN3030I
DSN3031I
DSN3100I
DSN3101I
DSN3102I
DSN3103I
DSN3104I
DSN3105I
DSN3106I
DSN3107I
DSN3108I
DSN3109I
DSN3111I
DSN3112I
DSN3113I
DSN3114I
DSN3115I
DSN3116I
DSN3117I
DSN3118I
DSN3119I
DSN3120I
DSN3121I
DSN3201I
DSN3458I
DSN3580I
DSN3581I
DSN5 messages
DSN5001I
DSN7 messages
DSN7000I
DSN7003I
DSN7100I
DSN7114I
DSN7401I
DSN7403I
DSN7404I
DSN7405I
DSN7406I
DSN7407I
DSN7408I
DSN7409I
DSN7501A
DSN7502I
DSN7503I
DSN7504I
DSN7505A
DSN7506A
DSN7507I
DSN7508I
DSN7509I
DSN7510I
DSN7511I
DSN7512A
DSN7513I
DSN7514I
DSN7515I
DSN8 messages
DSN8000I
DSN8001I
DSN8002I
DSN8003I
DSN8004I
DSN8005E
DSN8006E
DSN8007E
DSN8008I
DSN8011I
DSN8012I
DSN8013I
DSN8014I
DSN8015E
DSN8016E
DSN8017E
DSN8018I
DSN8019E
DSN8021I
DSN8022I
DSN8023I
DSN8024I
DSN8025E
DSN8026E
DSN8027E
DSN8028I
DSN8031I
DSN8032I
DSN8033I
DSN8034I
DSN8035E
DSN8036E
DSN8037E
DSN8038I
DSN8039E
DSN8041I
DSN8042I
DSN8043I
DSN8044I
DSN8045E
DSN8046E
DSN8047E
DSN8051I
DSN8053I
DSN8056I
DSN8057I
DSN8058I
DSN8060E
DSN8061E
DSN8062E
DSN8064E
DSN8065E
DSN8066E
DSN8067E
DSN8068E
DSN8069E
DSN8070E
DSN8072E
DSN8073E
DSN8074E
DSN8075E
DSN8076E
DSN8079E
DSN8080E
DSN8081E
DSN8082E
DSN8083E
DSN8200E
DSN8202E
DSN8203E
DSN8210I
DSN8212E
DSN8213E
DSN8214E
DSN8215E
DSN8216E
DSN8217E
DSN8220E
DSN8222E
DSN8223E
DSN8230E
DSN8231E
DSN8233E
DSN8235E
DSN8236E
DSN8237E
DSN8238E
DSN8240E
DSN8242E
DSN8243E
DSN9 messages
DSN9000I
DSN9001I
DSN9002I
DSN9003I
DSN9004I
DSN9005I
DSN9006I
DSN9007I
DSN9008I
DSN9009I
DSN9010I
DSN9011I
DSN9012I
DSN9013I
DSN9014I
DSN9015I
DSN9016I
DSN9017I
DSN9018I
DSN9019I
DSN9020I
DSN9021I
DSN9022I
DSN9023I
DSN9024I
DSN9025I
DSN9026I
DSN9027I
DSN9028I
DSN9029I
DSN9030I
DSN9031I
DSN9032I
DSN9033I
DSN9034I
DSN9035I
DSN9036I
DSN9037I
DSN9038I
New, changed, and deleted messages
New messages
Changed messages
Deleted messages
Updated message explanations
z/OS diagnostic services
Resource types
DB2 codes
How to interpret code numbers
Subcomponent identifiers
How to find additional information about messages
SQL codes
Successful execution SQL codes
000
+012
+020
+098
+100
+110
+111
+117
+162
+203
+204
+205
+206
+217
+218
+219
+220
+222
+231
+236
+237
+238
+239
+252
+304
+331
+335
+347
+354
+361
+364
+385
+394
+395
+402
+403
+434
+438
+440
+445
+462
+464
+466
+494
+495
+535
+541
+551
+552
+558
+562
+585
+599
+610
+645
+650
+653
+655
+658
+664
+738
+799
+802
+806
+807
+863
+883
+4726
+20002
+20007
+20122
+20141
+20187
+20237
+20245
+20270
+20271
+20272
+20348
+20360
+20365
+20367
+20371
+20378
+20458
+20459
+20460
+20461
+20468
+20520
+30100
SQL error codes
-007
-010
-011
-029
-051
-056
-057
-058
-060
-078
-079
-084
-087
-096
-097
-101
-102
-103
-104
-105
-107
-108
-109
-110
-112
-113
-114
-115
-117
-118
-119
-120
-121
-122
-123
-125
-126
-127
-128
-129
-130
-131
-132
-133
-134
-136
-137
-138
-142
-144
-147
-148
-150
-151
-152
-153
-154
-156
-157
-158
-159
-160
-161
-164
-170
-171
-173
-180
-181
-182
-183
-184
-185
-186
-187
-188
-189
-190
-191
-197
-198
-199
-203
-204
-205
-206
-208
-212
-214
-216
-219
-220
-221
-222
-224
-225
-227
-228
-229
-240
-242
-243
-244
-245
-246
-247
-248
-249
-250
-251
-253
-254
-270
-300
-301
-302
-303
-304
-305
-309
-310
-311
-312
-313
-314
-327
-330
-331
-332
-333
-336
-338
-340
-341
-342
-343
-344
-345
-346
-348
-350
-351
-352
-353
-354
-355
-356
-359
-363
-365
-372
-373
-374
-390
-392
-393
-396
-397
-398
-399
-400
-401
-402
-404
-405
-406
-407
-408
-409
-410
-412
-413
-414
-415
-416
-417
-418
-419
-420
-421
-423
-426
-427
-430
-431
-433
-435
-438
-440
-441
-443
-444
-449
-450
-451
-452
-453
-454
-455
-456
-457
-458
-461
-469
-470
-471
-472
-473
-475
-476
-478
-480
-482
-483
-487
-490
-491
-492
-495
-496
-497
-499
-500
-501
-502
-503
-504
-507
-508
-509
-510
-511
-512
-513
-514
-516
-517
-518
-519
-525
-526
-530
-531
-532
-533
-534
-536
-537
-538
-539
-540
-542
-543
-544
-545
-546
-548
-549
-551
-552
-553
-554
-555
-556
-557
-559
-562
-567
-571
-573
-574
-575
-577
-578
-579
-580
-581
-582
-583
-584
-585
-586
-589
-590
-592
-593
-594
-601
-602
-603
-604
-607
-611
-612
-613
-614
-615
-616
-618
-619
-620
-621
-622
-623
-624
-625
-626
-627
-628
-629
-631
-632
-633
-634
-635
-636
-637
-638
-639
-640
-643
-644
-646
-647
-650
-651
-652
-653
-655
-658
-660
-661
-662
-663
-665
-666
-667
-668
-669
-670
-671
-672
-676
-677
-678
-679
-680
-681
-682
-683
-684
-685
-686
-687
-688
-689
-690
-691
-692
-693
-694
-695
-696
-697
-713
-715
-716
-717
-718
-719
-720
-721
-722
-723
-724
-725
-726
-729
-730
-731
-732
-733
-734
-735
-736
-737
-739
-740
-741
-742
-746
-747
-748
-750
-751
-752
-763
-764
-765
-766
-767
-768
-769
-770
-771
-773
-775
-776
-778
-779
-780
-781
-782
-783
-784
-785
-787
-797
-798
-802
-803
-804
-805
-807
-808
-811
-812
-817
-818
-819
-820
-822
-840
-842
-843
-845
-846
-867
-870
-872
-873
-874
-875
-876
-877
-878
-879
-880
-881
-882
-900
-901
-902
-904
-905
-906
-908
-909
-910
-911
-913
-917
-918
-919
-922
-923
-924
-925
-926
-927
-929
-939
-947
-948
-950
-951
-952
-981
-989
-991
-992
-1403
-1760
-2001
-4302
-4700
-4701
-4704
-4705
-4706
-4709
-4710
-4727
-4730
-4731
-4732
-4733
-4734
-4735
-4736
-4737
-4738
-4739
-5001
-5012
-7008
-16000
-16001
-16002
-16003
-16005
-16007
-16009
-16011
-16012
-16015
-16016
-16020
-16022
-16023
-16024
-16026
-16029
-16031
-16032
-16033
-16036
-16038
-16041
-16046
-16047
-16048
-16049
-16051
-16052
-16055
-16056
-16057
-16061
-16065
-16066
-16067
-16068
-16069
-16075
-16080
-16081
-16085
-16086
-16087
-16088
-16089
-16246
-16247
-16248
-16249
-16250
-16251
-16252
-16253
-16254
-16255
-16257
-16258
-16259
-16260
-16262
-16265
-16266
-20003
-20004
-20005
-20008
-20016
-20019
-20046
-20058
-20060
-20070
-20071
-20072
-20073
-20074
-20091
-20092
-20093
-20094
-20100
-20101
-20102
-20104
-20106
-20107
-20108
-20110
-20111
-20117
-20120
-20123
-20124
-20125
-20127
-20129
-20142
-20143
-20144
-20146
-20147
-20148
-20163
-20165
-20166
-20177
-20178
-20179
-20180
-20181
-20182
-20183
-20185
-20186
-20200
-20201
-20202
-20203
-20204
-20207
-20210
-20211
-20212
-20213
-20223
-20224
-20227
-20228
-20232
-20235
-20240
-20248
-20249
-20252
-20257
-20258
-20260
-20264
-20265
-20266
-20275
-20281
-20283
-20286
-20289
-20295
-20300
-20304
-20305
-20306
-20310
-20311
-20312
-20313
-20314
-20315
-20327
-20328
-20329
-20330
-20331
-20332
-20335
-20338
-20339
-20340
-20345
-20353
-20354
-20355
-20356
-20361
-20362
-20363
-20365
-20366
-20369
-20372
-20373
-20374
-20377
-20380
-20381
-20382
-20385
-20398
-20399
-20400
-20409
-20410
-20411
-20412
-20422
-20423
-20424
-20425
-20426
-20427
-20428
-20433
-20434
-20444
-20447
-20448
-20457
-20465
-20469
-20470
-20471
-20472
-20473
-20474
-20475
-20476
-20477
-20478
-20479
-20487
-20488
-20490
-20491
-20493
-20497
-20517
-20522
-20523
-20524
-20525
-20527
-20528
-20531
-30000
-30002
-30005
-30020
-30021
-30025
-30030
-30040
-30041
-30050
-30051
-30052
-30053
-30060
-30061
-30070
-30071
-30072
-30073
-30074
-30080
-30081
-30082
-30090
-30104
-30105
-30106
DB2 reason codes
X'C1......' codes
00C10002
00C10003
00C10004
00C10005
00C10201
00C10202
00C10203
00C10204
00C10205
00C10206
00C10207
00C10208
00C10209
00C10210
00C10824
00C10831
00C12001
00C12002
00C12003
00C12004
00C12005
00C12006
00C12007
00C12008
00C12009
00C12010
00C12011
00C12012
00C12013
00C12014
00C12015
00C12016
00C12018
00C12019
00C12020
00C12021
00C12022
00C12023
00C12024
00C12025
00C12026
00C12027
00C12028
00C12029
00C12030
00C12031
00C12032
00C12033
00C12034
00C12201
00C12202
00C12203
00C12204
00C12205
00C12206
00C12207
00C12208
00C12209
00C12211
00C12212
00C12214
00C12217
00C12219
00C12220
00C12221
00C12222
00C12223
00C12230
00C12822
00C12823
00C12824
00C12825
00C12831
00C12832
00C12850
X'C2......' codes
00C20021
00C20031
00C20069.
00C2006A
00C200A1
00C200A2
00C200A3
00C200A4
00C200A5
00C200A6
00C200A8
00C200A9
00C200AA
00C200AB
00C200AD
00C200AE
00C200AF
00C200B0
00C200B1
00C200B2
00C200B3
00C200B4
00C200B5
00C200B6
00C200B7
00C200B8
00C200BA
00C200BB
00C200BC
00C200BD
00C200BE
00C200C0
00C200C1
00C200C2
00C200C3
00C200C5
00C200C6
00C200C7
00C200C8
00C200C9
00C200CB
00C200CC
00C200CF
00C200D0
00C200D1
00C200D2
00C200D3
00C200D4
00C200D5
00C200D6
00C200D7
00C200D8
00C200E0
00C200E1
00C200E2
00C200E5
00C200E6
00C200E8
00C200E9
00C200EA
00C200EB
00C200EC
00C200ED
00C200EF
00C200F0
00C200F1
00C200F2
00C200F3
00C200F4
00C200F6
00C200F7
00C200F8
00C200F9
00C200FA
00C200FB
00C200FC
00C200FD
00C200FE
00C200FF
00C20101
00C20102
00C20103
00C20104
00C20105
00C20106
00C20107
00C20108
00C20109
00C2010A
00C2010B
00C2010C
00C2010D
00C2010E
00C2010F
00C20110
00C20111
00C20112
00C20113
00C20120
00C20200
00C20203
00C20204
00C20205
00C20206
00C20207
00C20208
00C20210
00C20211
00C20220
00C20221
00C20222
00C20223
00C20224
00C20230
00C20231
00C20232
00C20233
00C20250
00C20251
00C20252
00C20254
00C20255
00C20256
00C20257
00C20258
00C20259
00C2025A
00C2025B
00C2025C
00C20260
00C20261
00C20262
00C20263
00C20264
00C20267
00C20268
00C20269
00C2026A
00C2026B
00C2026C
00C202A1
00C202A2
00C202A3
00C202A4
00C202A5
00C202A6
00C202A7
00C202A8
00C202AA
00C202AB
00C202AC
00C202AD
00C202AE
00C202AF
00C202B0
00C202B1
00C202B2
00C202B3
00C202B4
00C202B5
00C202B6
00C202B7
00C202C0
00C202C1
00C202C2
00C202C3
00C202C4
00C202C5
00C202D0
00C202D1
00C202D2
00C20300
00C20301
00C20302
00C20303
00C20304
00C20305
00C20306
00C20307
00C2030B
00C2030C
X'C5......' codes
00C50001
00C50002
00C50003
00C50005
00C50007
00C50008
00C50009
00C50100
00C50101
00C50102
00C50103
00C50104
00C50108
00C50109
00C50110
00C50111
X'C6......' codes
00C60001
X'C8......' codes
00C89011
00C89012
00C89013
00C89014
00C89015
00C89016
00C89017
00C89018
00C89019
00C8901a
00C89041
X'C9......' codes
00C9000A
00C90026
00C90060
00C90063
00C90064
00C9006D
00C90070
00C9007D
00C9007E
00C9007F
00C90080
00C90081
00C90082
00C90083
00C90084
00C90085
00C90086
00C90087
00C90088
00C90089
00C9008A
00C9008B
00C9008C
00C9008D
00C9008E
00C9008F
00C90090
00C90091
00C90092
00C90093
00C90094
00C90095
00C90096
00C90097
00C90098
00C90099
00C9009A
00C9009B
00C9009C
00C9009D
00C9009E
00C9009F
00C900A0
00C900A1
00C900A3
00C900A4
00C900A5
00C900A6
00C900A7
00C900A8
00C900A9
00C900AA
00C900AB
00C900AC
00C900AD
00C900AE
00C900AF
00C900B2
00C900BA
00C900BC
00C900BE
00C900BF
00C900C0
00C900C1
00C900C4
00C900C5
00C900C6
00C900C7
00C900C8
00C900C9
00C900CB
00C900CC
00C900CD
00C900CE
00C900CF
00C900D0
00C900D1
00C900D2
00C900D3
00C900D7
00C900D8
00C900D9
00C900DA
00C90101
00C90102
00C90103
00C90105
00C90106
00C90107
00C90108
00C90109
00C9010B
00C9010C
00C9010D
00C9010E
00C9010F
00C90110
00C90111
00C90112
00C90120
00C90121
00C90124
00C90202
00C90203
00C90205
00C90206
00C90207
00C90210
00C90211
00C90212
00C90213
00C90214
00C90215
00C90216
00C90218
00C90219
00C9021A
00C9021B
00C9021C
00C9021D
00C9021E
00C9021F
00C90220
00C90221
00C90222
00C90301
00C90303
00C90304
00C90305
00C90306
00C90611
00C90614
00C9062E
00C9062F
00C90630
00C906FF
00C90D01
X'D1......' codes
00D10010
00D10011
00D10012
00D10013
00D10014
00D10015
00D10016
00D10017
00D10018
00D10019
00D10020
00D10021
00D10022
00D10023
00D10024
00D10025
00D10026
00D10027
00D10028
00D10029
00D1002A
00D1002B
00D1002C
00D1002D
00D10030
00D10031
00D10040
00D10044
00D10048
00D10050
00D10061
00D10062
00D10063
00D10101
00D10102
00D10103
00D10104
00D10105
00D10106
00D10107
00D10108
00D10109
00D1010A
00D1010B
00D1010C
00D1010D
00D1010E
00D1010F
00D10110
00D10111
00D10112
00D10113
00D10114
00D10115
00D10116
00D10117
00D10130
00D10150
00D10210
00D10219
00D10220
00D10221
00D10222
00D10223
00D10230
00D10231
00D10232
00D10240
00D10250
00D10251
00D10252
00D10253
00D10254
00D10255
00D10256
00D10261
00D10262
00D10263
00D10264
00D10265
00D10266
00D10267
00D10268
00D10269
00D10301
00D10302
00D10303
00D10304
00D10305
00D10306
00D10307
00D10308
00D10309
00D1030A
00D10310
00D10311
00D10312
00D10319
00D10322
00D10323
00D10324
00D10325
00D10326
00D10327
00D10328
00D10329
00D1032A
00D1032B
00D1032C
00D1032D
00D1032E
00D1032F
00D10330
00D10331
00D10332
00D10333
00D10334
00D10335
00D10340
00D10341
00D10342
00D10343
00D10345
00D10347
00D10348
00D10349
00D10350
00D10401
00D10402
00D10403
00D10404
00D10405
00D10406
00D10410
00D10411
00D10412
00D10413
00D10414
00D10415
00D10416
00D10417
00D10500
00D10501
00D10700
00D10701
00D10800
00D10901
00D10902
00D10903
00D10904
00D10905
00D10906
00D10907
00D10908
00D10909
00D10910
00D10916
00D10917
00D1F001
X'D3......' codes
00D30000
00D30001
00D30002
00D30003
00D30004
00D30005
00D30008
00D30009
00D3000A
00D3000B
00D3000C
00D3000D
00D3000E
00D3000F
00D30010
00D30011
00D30012
00D30013
00D30014
00D30015
00D30016
00D30018
00D30019
00D3001A
00D3001B
00D3001C
00D3001D
00D3001E
00D3001F
00D30020
00D30021
00D30022
00D3002D
00D3002E
00D3002F
00D30030
00D30031
00D30032
00D30033
00D30034
00D30035
00D30036
00D30037
00D30038
00D30039
00D3003A
00D3003B
00D3003C
00D3003D
00D30040
00D30041
00D30042
00D30043
00D30044
00D30045
00D30046
00D300F1
00D300F2
00D300F3
00D300F4
00D300F5
00D300F6
00D300F7
00D300F8
00D300F9
00D300FA
00D300FB
00D300FC
00D300FD
00D300FE
00D300FF
00D30100
00D30101
00D30103
00D30104
00D30105
00D30106
00D30109
00D3010A
00D3010B
00D3010C
00D3010D
00D3010E
00D3010F
00D30110
00D30111
00D30113
00D30114
00D30115
00D31010
00D31011
00D31012
00D31013
00D31014
00D31018
00D31019
00D3101A
00D3101B
00D3101C
00D31020
00D31022
00D31023
00D31024
00D31025
00D31026
00D31027
00D31029
00D3102A
00D3102B
00D3102D
00D3102E
00D31030
00D31031
00D31032
00D31033
00D31034
00D31035
00D31036
00D31037
00D31038
00D31039
00D3103A
00D3103B
00D3103C
00D3103D
00D3103E
00D3103F
00D31040
00D31041
00D31042
00D31043
00D31044
00D31045
00D31046
00D31047
00D31048
00D31049
00D3104A
00D3104B
00D3104C
00D3104D
00D3104E
00D3104F
00D31050
00D31052
00D31055
00D31056
00D31057
00D31058
00D31059
00D3105A
00D3105B
00D31100
00D31101
00D31102
00D31103
00D31104
00D31105
00D31106
00D31107
00D31108
00D31109
00D3110A
00D3110B
00D31110
00D31111
00D31112
00D31113
00D31114
00D31115
00D31116
00D31117
00D31118
00D31119
00D3111A
00D3111B
00D3111C
00D3111e
00D3111F
00D31200
00D31201
00D31202
00D31203
00D31204
00D31205
00D31206
00D34401
00D34404
00D34405
00D34406
00D34407
00D34408
00D34409
00D3440B
00D3440C
00D3440D
00D3440E
00D3440F
00D34410
00D34411
00D34412
00D34413
00D34414
00D34415
00D34416
00D34417
00D34418
00D34419
00D3441C
00D3441D
00D3441E
00D3441F
00D34422
00D34423
00D34424
00D34425
00D34426
00D34427
00D34428
00D34429
00D3442B
00D3442E
00D3442F
00D34432
00D34433
00D34434
00D34436
00D34438
00D3443A
00D3443B
00D3443C
00D3443D
00D3443E
00D3443F
00D34440
00D34441
00D34442
00D34445
00D34447
00D34448
00D34449
00D3444A
00D3444C
00D3444F
00D34450
00D35000
00D35011
00D35030
00D35101
00D35102
00D35103
00D35104
00D35105
00D35106
00D35107
00D35108
00D35109
00D3510A
00D3510B
00D3510C
00D3510D
00D3510E
00D3510F
00D35110
00D35111
00D35112
00D35113
00D35114
00D35115
00D35116
00D35117
00D35118
00D35119
00D3511A
00D3511B
00D3511C
00D3511D
00D3511E
00D3511F
00D35120
00D35121
00D35122
00D351FF
00D35201
00D35202
00D35203
00D35204
00D35205
00D35206
00D35207
00D35208
00D35209
00D3520A
00D3520B
00D3520C
00D3520D
00D3520E
00D35301
00D35302
00D35303
00D35304
00D35305
00D35306
00D35307
00D35308
00D35309
00D3530A
00D3530B
00D3530C
00D3530D
00D3530E
00D3530F
00D35310
00D35311
00D35312
00D35313
00D35314
00D35315
00D35316
00D35401
00D35501
00D35502
00D35601
00D35602
00D35603
00D35604
00D35605
00D35606
00D35607
00D35608
00D35609
00D35610
00D35611
00D35701
00D35702
00D35703
00D35704
00D35705
00D35706
00D35707
00D35708
00D35709
00D3570A
00D3570B
00D3570C
00D3570D
00D35801
00D35802
00D35803
00D35804
00D35805
00D35806
00D35807
00D35808
00D35809
00D35901
00D35902
00D35903
00D35904
00D35905
00D35906
00D35907
00D35908
00D35909
00D3590A
00D3590B
00D3590C
00D3590D
00D3590E
00D3590F
00D35910
00D35911
00D35912
00D35913
00D35914
00D35915
00D35917
00D35918
00D35919
00D3591A
00D3591B
00D3591C
00D3591D
00D3591E
00D3591f
00D35920
00D35921
00D35922
00D35923
00D35924
00D35925
00D35926
00D35A01
00D35A02
00D35A03
00D35A04
00D35B01
00D35B02
00D35B03
00D35B04
00D35B05
00D35B06
00D35B07
00D35B08
00D35B09
00D35B0A
00D35B0B
00D35B0C
00D35B0D
00D35B0E
00D35B0F
00D35B10
00D35B11
00D35B12
00D35B13
00D35B14
00D35B15
00D35B16
00D35B17
00D35C01
00D35C02
00D35C03
00D35C04
00D35C05
00D35C06
00D35C07
00D35C08
00D35C09
00D35C0A
00D35C0B
00D35C0C
00D35C0D
00D35C0E
00D35C0F
00D35C10
00D35C11
00D35C12
00D35C13
00D35C14
00D35C15
00D35C16
00D35C17
00D35C18
00D35C19
00D35C1A
00D35C1B
00D35C1C
00D35C1D
00D35C1E
00D35C1F
00D35C20
00D35C21
00D35C22
00D35C23
00D35C24
00D35C25
00D35C26
00D35C27
00D35C28
00D35C29
00D35C2A
00D35C2E
00D35C2F
00D35C30
00D35C31
00D35C32
00D35C33
00D35C34
00D35C35
00D35D01
00D35D02
00D35D03
00D35D04
00D35D05
00D35D06
00D35D07
00D35D08
00D35D09
00D35D0A
00D35D0B
00D35D0C
00D35D0D
00D35D0E
00D35D0F
00D35D10
00D35D11
00D35D12
00D35D13
00D35D14
00D35D15
00D35D16
00D35D17
00D35D18
00D35D19
00D35D1A
00D35D1B
00D35D1C
00D35D1D
00D35D1E
00D35D1F
00D35D20
00D35D21
00D35D22
00D35D23
00D35D24
00D35D25
00D35D27
00D35D28
00D35D29
00D35D2A
00D35D2B
00D35D2C
00D35D2D
00D35D2E
00D35E00
00D35E01
00D35E02
00D35E03
00D35E04
00D35E05
00D35E06
00D35E07
00D35E08
00D35E09
00D35E0A
00D35E0B
00D35E0C
00D35E0D
00D35E0E
00D35E0F
00D35E10
00D35E11
00D35E12
00D35E13
00D35E14
00D35E15
00D35E16
00D35E17
00D35E18
00D35E19
00D35E1A
00D35E1B
00D35E1C
00D35E1D
00D35E1E
00D35E1F
00D35E20
00D35E21
00D35E22
00D35E23
00D35E24
00D35E25
00D35E26
00D35E27
00D35E28
00D35E29
00D35E2A
00D35E2B
00D35E2C
00D35E2D
00D35E2E
00D35E2F
00D35E30
00D35E31
00D35E32
00D35E33
00D35E34
00D35E35
00D35E36
00D35E37
00D35E38
00D35E39
00D35E3A
00D35E3B
00D35E3C
00D35E3D
00D35E3E
00D35E3F
00D35E40
00D35E41
00D35E42
00D35E43
00D35E44
00D35E45
00D35E46
00D35E47
00D35E48
00D35E49
00D35E4A
00D35E4B
00D35E4C
00D35E4D
00D35E4E
00D35E4F
00D35E50
00D35E51
00D35E52
00D35E53
00D35E54
00D35E55
00D35E56
00D35E57
00D35E58
00D35E59
00D35E5A
00D35E5B
00D35E5C
00D35E5D
00D35E5E
00D35E5F
00D35E60
00D35E61
00D35E62
00D35E63
00D35E67
00D35E68
00D35E69
00D35E6A
00D35E6B
00D35E6C
00D35E6D
00D35E6E
00D35E6F
00D35E70
00D35E71
00D35E72
00D35E73
00D35E74
00D35E75
00D35E76
00D35E77
00D35E78
00D35E79
00D35E7A
X'D4......' codes
00D40001
00D40008
00D40061
00D40062
00D40063
00D40069
00D44011
00D44021
00D44022
00D44023
00D44024
00D44025
00D44031
00D44032
00D44033
00D44034
00D44035
00D44036
00D44037
00D44038
00D44039
00D44050
00D44051
00D44052
00D44053
00D44054
00D44055
00D44056
00D44057
X'D5......' codes
00D50001
00D50002
00D50003
00D50004
00D50005
X'D6......' codes
00D60001
00D60100
00D60803
00D60C02
00D60C03
X'D7......' codes
00D70001
00D70002
00D70003
00D70004
00D70005
00D70006
00D70007
00D70008
00D70009
00D70010
00D70011
00D70012
00D70013
00D70014
00D70015
00D70016
00D70017
00D70018
00D70019
00D70020
00D70021
00D70022
00D70023
00D70024
00D70025
00D70026
00D70027
00D70028
00D70029
00D70030
00D70040
00D70041
00D70042
00D70043
00D70044
00D70045
00D70046
00D70051
00D70052
00D70100
00D79999
X'D9......' codes
00D90000
00D90003
00D90004
00D90010
00D90011
00D90012
00D90013
00D90014
00D9001F
00D90020
00D90021
00D90022
00D90050
00D900E0
00D900E1
00D900EB
00D900EC
00D900F1
00D900F2
00D900F3
00D900F4
00D900F5
00D900F7
00D900F8
00D900F9
00D900FA
00D90100
00D90110
00D90111
00D91001
00D91044
00D92001
00D92003
00D92004
00D92011
00D92012
00D92013
00D92021
00D92022
00D92023
00D92024
00D92025
00D93001
00D93002
00D9300F
00D93011
00D93012
00D93013
00D93100
00D94001
00D94002
00D9400F
00D94011
00D94012
00D94014
00D95001
00D95011
00D96001
00D96011
00D96021
00D96022
00D96031
00D96032
00D96041
00D98001
00D98011
00D98021
00D98022
00D98031
00D98032
00D98600
00D98601
00D98602
00D98603
00D98604
00D98605
00D99001
00D99002
00D99003
00D99004
00D99900
00D9AAAA
00D9BBBB
00D9CCCC
00D9EEEE
X'E2......' codes
00E20001
00E20002
00E20003
00E20004
00E20005
00E20006
00E20007
00E20008
00E20009
00E2000A
00E2000B
00E2000C
00E2000D
00E2000E
00E2000F
00E20010
00E20011
00E20012
00E20013
00E20014
00E20015
00E20016
00E20017
00E20018
00E20019
00E2001A
00E2001B
00E2001C
00E2001D
00E2001E
00E2001F
00E20020
00E20021
00E20022
00E20023
00E20024
00E20025
00E20026
00E20027
00E20028
00E20029
00E2002A
00E2002B
00E2002E
00E2002F
00E20030
00E20031
00E20032
00E20033
00E20041
00E20041
00E20042
00E20043
X'E3......' codes
00E30001
00E30003
00E30004
00E30005
00E30006
00E30008
00E3000A
00E3000B
00E3000C
00E3000D
00E3000E
00E3000F
00E30010
00E30013
00E30014
00E30017
00E3001B
00E3001C
00E3001D
00E3001E
00E30021
00E30034
00E30035
00E30036
00E30037
00E30040
00E30041
00E30063
00E30065
00E30066
00E30067
00E30068
00E30069
00E30070
00E30071
00E30072
00E30073
00E30074
00E30075
00E30076
00E30077
00E30078
00E30079
00E3007A
00E3007B
00E30080
00E30081
00E30082
00E30083
00E30084
00E30085
00E30086
00E30089
00E30090
00E30091
00E30092
00E30095
00E30096
00E30097
00E30099
00E3009A
00E3009B
00E3009E
00E30100
00E30101
00E30104
00E30105
00E30301
00E30302
00E30303
00E30305
00E30306
00E30402
00E30405
00E30406
00E30407
00E30501
00E30502
00E30503
00E30504
00E30505
00E30506
00E30507
00E30508
00E30700
00E30800
00E30802
00E30803
00E30805
00E30806
00E30807
00E30808
00E30809
X'E4......' codes
00E40000
00E40001
00E40002
00E40003
00E40004
00E40005
00E40006
00E40007
00E40009
00E4000A
00E4000C
00E4000D
00E4000E
00E4000F
00E40010
00E40011
00E40012
00E40013
00E40014
00E40015
00E40016
00E40017
00E40018
00E4001A
00E4001B
00E4001C
00E4001D
00E4001E
00E4001F
00E40020
00E40021
00E40022
00E40023
00E40024
00E40025
00E40027
00E40028
00E40029
00E4002A
00E4002B
00E4002D
00E4002E
00E40030
00E40033
00E40034
00E40035
00E40040
00E40045
00E40051
00E40053
00E40070
00E40071
00E40072
00E40073
00E40074
00E40075
00E40076
00E40079
00E40080
00E40081
00E40082
00E40083
00E40085
00E40090
00E40091
00E40096
00E400A0
00E400A1
00E400AF
00E400B0
00E400C0
00E400C1
00E400C2
00E400C3
00E400D0
00E400D5
00E400E0
00E400E1
00E400E2
00E400E3
00E40100
00E40101
00E40102
00E40103
00E40104
00E40105
00E40106
00E40107
00E40108
00E40109
00E4010A
00E4010B
00E4010C
00E4010D
00E4010E
00E4010F
00E40110
00E40111
00E40112
00E40113
00E40114
00E40115
00E40116
00E40117
00E40118
00E40119
00E4011A
00E4011B
00E4011C
00E4011D
00E4011F
00E40120
00E40121
00E40122
00E40123
00E40124
00E40125
00E40126
00E40163
00E40164
00E40165
00E40166
00E40167
00E40168
00E40170
00E40189
00E40190
00E40191
00E40192
00E40193
00E40194
00E40195
00E40196
00E40197
00E40198
00E40201
00E40202
00E40203
00E40204
00E40205
00E40206
00E40207
00E40208
00E40209
00E40210
00E40211
00E40212
00E40213
00E40214
00E40215
00E40216
00E40217
00E40218
00E40220
00E40221
00E40222
00E40223
00E40224
00E40225
00E40226
00E40227
00E40228
00E40229
00E40230
00E40300
00E40301
00E40302
00E40303
00E40304
00E40305
00E40306
00E40307
00E40308
00E40309
00E4030A
00E4030B
00E4030C
00E4030D
00E4030E
00E4030F
00E40310
00E40311
00E40312
00E40313
00E40314
00E40315
00E40316
00E40317
00E40318
00E40319
00E4031A
00E4031B
00E4031C
00E40320
00E40321
00E40322
00E40323
00E40324
00E40325
00E40326
00E40327
00E40333
00E40334
00E40335
00E40336
00E40340
00E40341
00E40343
00E40345
00E40346
00E40347
00E40350
00E40351
00E40353
00E40355
00E40356
00E40401
00E40403
00E40404
00E40405
00E40406
00E40410
00E40411
00E40413
00E40414
00E40415
00E40417
00E40500
00E40517
00E40600
00E40601
00E40609
00E40617
00E40702
00E40703
00E40704
00E40705
00E40706
00E40707
00E40708
00E40709
00E4070A
00E4070D
00E4070F
00E40800
00E40900
00E40901
00E40902
00E40903
00E40904
00E40905
00E40906
00E40907
00E40908
00E41000
00E41002
00E4D5D2
00E4E2D7
X'E5......' codes
00E50001
00E50002
00E50003
00E50004
00E50005
00E50006
00E50007
00E50008
00E50009
00E50012
00E50013
00E50014
00E50015
00E5001A
00E50029
00E50030
00E50031
00E50032
00E50035
00E50036
00E50040
00E50041
00E50042
00E50044
00E50045
00E50046
00E50047
00E50050
00E50051
00E50052
00E50054
00E50055
00E50059
00E50062
00E50063
00E50065
00E50069
00E50070
00E50071
00E50072
00E50073
00E50074
00E50075
00E50076
00E50077
00E50078
00E50079
00E50080
00E50081
00E50094
00E50095
00E50096
00E50097
00E50098
00E50100
00E50101
00E50102
00E50105
00E50106
00E50107
00E501A1
00E502A1
00E503A1
00E504A1
00E50500
00E50501
00E50502
00E50503
00E50504
00E50505
00E505A1
00E506A1
00E50701
00E50702
00E50703
00E50704
00E50705
00E50706
00E50707
00E50708
00E50709
00E50710
00E50711
00E50712
00E50713
00E50715
00E50717
00E50719
00E50725
00E50727
00E50730
00E50731
00E507A1
00E508A1
00E509A1
00E50AA1
00E50BA1
00E50CA1
00E50DA1
00E50EA1
00E50FA1
X'E6......' codes
00E60008
00E60086
00E60087
00E60088
00E60100
00E60101
00E60102
00E60103
00E60104
00E60105
00E60106
00E60107
00E60108
00E60109
00E60110
00E60111
00E60112
00E60113
00E60114
00E60115
00E60116
00E60117
00E60118
00E60119
00E60120
00E60121
00E60122
00E60123
00E60124
00E60125
00E60126
00E60127
00E60128
00E60129
00E60130
00E60131
00E60132
00E60133
00E60134
00E60135
00E60136
00E60137
00E60138
00E60139
00E60140
00E60141
00E60142
00E60143
00E60144
00E60145
00E60146
00E60147
00E60148
00E60149
00E60150
00E60151
00E60152
00E60153
00E60154
00E60155
00E60156
00E60157
00E60158
00E60159
00E60160
00E60161
00E60162
00E60163
00E60164
00E60165
00E60166
00E60167
00E60168
00E60169
00E60170
00E60171
00E60172
00E60173
00E60174
00E60175
00E60176
00E60177
00E60178
00E60179
00E60180
00E60181
00E60182
00E60183
00E60184
00E60185
00E60186
00E60187
00E60188
00E60189
00E60190
00E60191
00E60192
00E60193
00E60194
00E60195
00E60196
00E60197
00E60198
00E60199
00E60800
00E60801
00E60802
00E60803
00E60804
00E60805
00E60806
00E60807
00E60808
00E60809
00E6080A
00E6080B
00E6080C
00E60810
00E60811
00E60812
00E60813
00E60814
00E60815
00E60816
00E60820
00E60821
00E60823
00E60824
00E60825
00E60826
00E60827
00E60828
00E60829
00E60830
00E60831
00E60832
00E60833
00E60834
00E60835
00E60836
00E60837
00E60838
00E60839
00E6083A
00E60840
00E60841
00E60842
00E60843
00E60844
00E60845
00E60846
00E60847
00E60849
00E60850
00E60851
00E60852
00E60853
00E60854
00E60855
00E60856
00E60857
00E60858
00E60859
00E60860
00E60861
00E60863
00E60864
00E60865
00E60866
00E60867
00E60868
00E60869
00E60870
00E60871
00E60872
00E60873
00E60874
00E60875
00E60876
00E60878
00E60886
00E60887
00E60888
00E60889
00E60900
00E60901
00E60902
00E60903
00E60904
00E60A00
00E60A01
00E60A08
00E60A09
00E60A0A
00E60A0B
00E60B01
00E60B02
00E60B03
00E60B04
X'E7......' codes
00E70001
00E70004
00E70005
00E70006
00E70007
00E70009
00E7000A
00E7000C
00E7000E
00E7000F
00E70010
00E70011
00E70012
00E70013
00E70014
00E70015
00E70016
00E70020
00E70021
00E70022
00E70023
00E70024
00E70025
00E70069
00E7006A
00E7006B
00E70081
00E70082
00E7009A
00E7009B
00E7009C
00E7009D
00E7009E
00E7009F
00E700A6
00E700A7
00E70100
00E70105
00E70106
00E70110
00E70115
00E70121
00E70122
00E70123
00E70911
00E70913
00E72008
00E72018
00E72048
00E72058
00E72068
00E72078
00E72088
00E72098
00E72100
00E72200
00E73001
00E73002
00E73003
00E73004
00E73005
00E73006
00E79000
00E79001
00E79002
00E79004
00E79006
00E79007
00E79008
00E7900A
00E7900B
00E7900C
00E7900F
00E79010
00E79100
00E79101
00E79102
00E79106
00E79109
00E7910A
00E79200
00E79201
00E79300
00E7F801
00E7F802
X'E8......' codes
00E80001
00E80002
00E80003
00E80004
00E80005
00E80006
00E8000E
00E8000F
00E80011
00E80012
00E80013
00E8001F
00E8002F
00E80031
00E80032
00E80033
00E8003C
00E8003D
00E8003E
00E8003F
00E80041
00E80042
00E8004F
00E80051
00E80052
00E80053
00E80054
00E80055
00E80056
00E80057
00E80058
00E80059
00E8005A
00E8005F
00E80061
00E8006F
00E8007F
00E80081
00E80084
00E8008F
00E80091
00E8009F
00E800AF
00E800B1
00E800CE
00E800D1
00E800D2
00E800D3
00E800DF
00E80100
00E8011D
00E8011E
00E8011F
00E8012D
00E8012F
00E80130
00E80140
00E80150
00E80151
00E8015F
00E80160
00E80161
00E80162
00E80170
X'E9......' codes
00E90101
00E90201
00E90202
00E90203
00E90403
00E90404
00E90405
X'F1......' codes
00F10100
00F10101
X'F3......' codes
00F30001
00F30002
00F30003
00F30004
00F30005
00F30006
00F30007
00F30008
00F30009
00F30010
00F30011
00F30012
00F30013
00F30014
00F30015
00F30016
00F30017
00F30018
00F30019
00F30020
00F30021
00F30022
00F30023
00F30024
00F30025
00F30026
00F30027
00F30028
00F30029
00F30030
00F30031
00F30032
00F30033
00F30034
00F30035
00F30036
00F30037
00F30038
00F30039
00F30040
00F30042
00F30043
00F30044
00F30045
00F30046
00F30047
00F30048
00F30049
00F30050
00F30051
00F30052
00F30053
00F30054
00F30055
00F30056
00F30057
00F30058
00F30059
00F30060
00F30061
00F30062
00F30063
00F30064
00F30065
00F30066
00F30067
00F30068
00F30069
00F30070
00F30071
00F30072
00F30073
00F30074
00F30075
00F30076
00F30077
00F30078
00F30080
00F30081
00F30082
00F30083
00F30085
00F30086
00F30087
00F30088
00F30089
00F30090
00F30091
00F30092
00F30093
00F30094
00F30095
00F30096
00F30097
00F30098
00F30099
00F3009A
00F3009B
00F3009C
00F3009D
00F3009E
00F3009f
00F300A0
00F300A1
00F300A2
00F300A3
00F300A4
00F300A5
00F300A6
00F300A7
00F300A8
00F300A9
00F300AA
00F300AB
00F300AC
00F300AD
00F300AE
00F30101
00F30102
00F30103
00F30104
00F30105
00F30106
00F30107
00F30111
00F30112
00F30113
00F30114
00F30115
00F30116
00F30120
00F30121
00F30122
00F30123
00F30203
00F30210
00F30211
00F30212
00F30213
00F30214
00F30215
00F30216
00F30217
00F30218
00F30219
00F3021A
00F3021B
00F3021C
00F3021D
00F3021E
00F3021F
00F30220
00F30230
00F30310
00F30311
00F30312
00F30313
00F30400
00F30401
00F30402
00F30405
00F30406
00F30407
00F30408
00F30409
00F3040A
00F3040B
00F3040C
00F3040D
00F3040E
00F3040F
00F30410
00F30411
00F30412
00F30413
00F30414
00F30415
00F30416
00F30417
00F30418
00F30419
00F3041A
00F3041B
00F3041C
00F30420
00F30429
00F30450
00F30451
00F30452
00F30453
00F30454
00F30455
00F30456
00F30457
00F30458
00F30459
00F30460
00F30461
00F30501
00F30502
00F30503
00F30571
00F30572
00F30573
00F30574
00F30580
00F30581
00F30597
00F30598
00F30599
00F30601
00F30610
00F30801
00F30802
00F30803
00F30805
00F30901
00F30902
00F30903
00F30904
00F30905
00F31100
00F31104
00F31105
00F31106
00F31107
00F31108
00F33100
00F3AFFF
X'F7......' codes
00F70001
00F70003
00F70401
00F70402
00F70403
00F70404
00F70405
00F70406
00F70407
00F70408
00F70409
00F7040A
00F70410
00F70600
00F70601
00F70602
00F70603
00F70604
00F70605
00F70606
00F70607
00F70608
00F70609
X'F9......' codes
00F90000
00F90001
00F90002
00F90003
00F90004
00F90005
00F90006
00F90007
00F90008
00F90009
00F9000A
00F9000B
00F9000C
00F9000D
SNA sense codes
080F6051
080F6052
080FFF00
080FFF01
080FFF02
080FFF03
080FFF04
080FFF05
08120000
084B0000
084B6031
08570008
08640000
08640001
08640002
10086011
10086021
10086031
10086034
10086041
800A0000
New, changed, and deleted codes
New reason codes
Deleted reason codes
Updated reason code explanations
New SQL codes
Changed SQL codes
Deleted SQL codes
Updated SQL code explanations
z/OS diagnostic services
SQLSTATE values and common error codes
DB2 abend completion codes (X'04E' and X'04F)
Resource types
ABEND codes associated with DSN1COPY misuse
IRLM messages and codes
DXR messages
DXR100I
DXR101I
DXR102I
DXR103I
DXR104I
DXR105E
DXR106E
DXR107E
DXR108I
DXR109I
DXR110I
DXR116E
DXR117I
DXR121I
DXR122E
DXR123E
DXR124E
DXR131I
DXR132I
DXR133I
DXR134E
DXR135E
DXR136I
DXR137I
DXR138E
DXR139E
DXR140E
DXR141I
DXR142E
DXR143I
DXR144I
DXR145I
DXR146I
DXR147I
DXR148I
DXR149I
DXR150I
DXR151I
DXR152I
DXR153I
DXR154I
DXR155I
DXR156I
DXR157I
DXR158I
DXR159I
DXR160I
DXR161I
DXR162I
DXR163I
DXR164E
DXR165I
DXR166E
DXR167E
DXR168I
DXR169I
DXR170I
DXR171I
DXR172I
DXR173I
DXR174E
DXR175E
DXR176I
DXR177I
DXR179I
DXR180I
DXR181I
DXR182I
&nbs