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
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
Descriptions of new and changed columns in PLAN_TABLE in Version 9
Format of DSN_STATEMNT_TABLE in Version 9
Descriptions of new and changed columns in DSN_STATEMNT_TABLE in Version 9
Format of DSN_FUNCTION_TABLE in Version 9
Descriptions of new and changed columns in 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
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)
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
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
Recommendations for page size
Recommendations for LOB page size
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
Recommendations for index page size
Index versions
Compressing indexes
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
Saving space with data compression
Calculating the space that is required for a dictionary
Calculating disk requirements for a dictionary
Calculating virtual storage requirements for a dictionary
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
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
Types of DB2 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
Point-in-time recovery with system-level backups
Point-in-time recovery using the RECOVER utility
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 your DB2 system to a given point in time by using the RESTORE SYSTEM utility
Options for restoring data to a prior point in time
Plans for point-in-time recovery
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
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
Connecting to a data sharing group
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 attachment names and subgroup attachment names
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 and failure recovery
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
Truncating the log 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
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
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
Improving concurrency
Global transaction locking
Locking optimizations
Explicit hierarchical locking
Relationship between L-locks and P-locks
A locking scenario
Traces that indicate whether locks have been propagated
Tuning your use of locks
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
How partition locks affect concurrency
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
Using the DB2 statistics trace
Calculating global contention percentages
Lock monitoring with the DB2 statistics 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
Tuning the group buffer pool checkpoint interval
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