Contents
Preface
What this book is about
What you need to know to understand this book
Notes on terminology
Summary of changes
Changes for CICS Transaction Server for z/OS, Version 3 Release 1
Changes for CICS Transaction Server for z/OS, Version 2 Release 3
Changes for CICS Transaction Server for z/OS, Version 2 Release 2
Changes for CICS Transaction Server for z/OS, Version 2 Release 1
Earlier releases
Figures
Tables
Overview of the CICS DB2 interface
Overview: How CICS connects to DB2
The DB2 address spaces
Overview: How threads work
Thread TCBs in a non-open transaction environment
Thread TCBs in the open transaction environment
Overview: How you can define the CICS DB2 connection
Overview: Enabling CICS application programs to access DB2
Preparing a CICS application program that accesses DB2
The bind process
Plans, packages and dynamic plan exits
Installation and migration notes for CICS DB2
CICS startup JCL requirements for connection to DB2
Supported releases of DB2
Migrating to a different release of DB2
Migrating from a CICS release that used RCT definitions for CICS DB2 resources
If you have not used CICS resource definition online (RDO) before
Effect of migration to RDO on CICS DB2 attachment facility operations
Effect of migration to RDO on application programs
Effect of migration to RDO on the INITPARM system initialization parameter
Effect of migration to RDO on defaults for resource definition parameters
Migrating to RDO for DB2 resource definition
Operations with CICS DB2
Starting the CICS DB2 attachment facility
Automatic connection at CICS initialization
Manual connection
Stopping the CICS DB2 attachment facility
Automatic disconnection at CICS termination
Manual disconnection
Resolving indoubt units of work (UOWs)
Resolving indoubt UOWs when using group attach
Resolving indoubt units of work using DB2 restart-light
Recovery of resynchronization information for indoubt UOWs
Managing the CICS DB2 attachment facility
Entering DB2 commands
Purging CICS DB2 transactions
Starting SMF for DB2 accounting, statistics and tuning
Starting GTF for DB2 accounting, statistics and tuning
CICS-supplied transactions for CICS DB2
Issuing commands to DB2 using DSNC
Environment
Syntax
Abbreviation
Authorization
Parameter description
Usage note
Example
DSNC DISCONNECT
Environment
Syntax
Abbreviation
Authorization
Parameter description
Usage notes
Example
DSNC DISPLAY
Environment
Syntax
Abbreviation
Authorization
Parameter description
Parameter description
Parameter description
Usage notes
DISPLAY PLAN or TRAN
DISPLAY STATISTICS output
DSNC MODIFY
Environment
Syntax
Abbreviation
Authorization
Parameter description
Usage notes
Examples
DSNC STOP
Environment
Syntax
Abbreviation
Authorization
Parameter description
Usage notes
Examples
DSNC STRT
Environment
Syntax
Abbreviation
Authorization
Parameter description
Usage notes
Examples
Defining the CICS DB2 connection
Using the DB2 group attach facility
The MAXOPENTCBS system initialization parameter and TCBLIMIT
What happens during SQL processing
Thread creation
SQL processing
Commit processing
Thread release
Thread termination
How threads are created, used, and terminated
Protected entry threads
Unprotected entry threads for critical transactions
Unprotected entry threads for background transactions
Pool threads
Selecting thread types for optimum performance
Selecting BIND options for optimum performance
Coordinating your DB2CONN, DB2ENTRY, and BIND options
Security in a CICS DB2 environment
Controlling access to DB2 resources in CICS
Controlling access to DB2CONN, DB2TRAN, and DB2ENTRY resources
Using resource security to control access to DB2ENTRY and DB2TRAN resources
Using command security to control using SPI commands for DB2 resources
Using surrogate security and AUTHTYPE security to control access to authorization IDs
Controlling access to DB2 CICS transactions
Providing authorization IDs to DB2 for the CICS region and for CICS transactions
Providing authorization IDs to DB2 for a CICS region
Providing a primary authorization ID for a CICS region
Providing secondary authorization IDs for a CICS region
Providing authorization IDs to DB2 for CICS transactions
Providing a primary authorization ID for CICS transactions
Providing secondary authorization IDs for CICS transactions
Authorizing users to access resources within DB2
Controlling access to DB2 commands
Controlling access to plans
Multilevel security and row-level security
Application design and development considerations for CICS DB2
Designing the relationship between CICS applications and DB2 plans and packages
A sample application
Using packages
Using one large plan for all transactions
Using many small plans
Using plans based on transaction grouping
Dynamic plan exits
If you need to create plans for an application that has already been developed
If you need to switch plans within a transaction
Dynamic plan switching
Switching transaction IDs in order to switch plans
Developing a locking strategy in the CICS DB2 environment
SQL, threadsafe and other programming considerations for CICS DB2 applications
Enabling CICS DB2 applications to exploit the open transaction environment (OTE) through threadsafe programming
SQL language
Using qualified and unqualified SQL
Views
Updating index columns
Dependency of unique indexes
Commit processing
Serializing transactions
Page contention
CICS and CURSOR WITH HOLD option
EXEC CICS RETURN IMMEDIATE command
Avoiding AEY9 abends
Using JDBC and SQLJ to access DB2 data from Java programs and enterprise beans written for CICS
Making JDBC and SQLJ work in the CICS DB2 environment
Requirements to support Java programs in the CICS DB2 environment
Programming with JDBC and SQLJ in the CICS DB2 environment
Acquiring a connection to a database
How many connections can you have?
Acquiring a connection using the JDBC DriverManager interface
Acquiring a connection using the DataSource interface
Setting up the sample applications to publish, look up and retract a DataSource
Publishing a DataSource using CICSDataSourcePublish.java
Looking up a DataSource using CICSjdbcDataSource.java
Retracting a DataSource using CICSDataSourceRetract.java
Committing a unit of work
Autocommit
Syncpoint issues for explicit and default URLs
CICS abends during JDBC or SQLJ requests
Using JDBC and SQLJ in enterprise beans: special considerations
Preparing CICS DB2 programs for execution and production
The CICS DB2 test environment
CICS DB2 program preparation steps
CICS SQLCA formatting routine
What to bind after a program change
Bind options and considerations for programs
RETAIN
Isolation level
Plan validation time
ACQUIRE and RELEASE
CICS DB2 program testing and debugging
Going into production: checklist for CICS DB2 applications
Tuning a CICS application that accesses DB2
Accounting and monitoring in a CICS DB2 environment
CICS-supplied accounting and monitoring information
DB2-supplied accounting and monitoring information
Monitoring a CICS DB2 environment: Overview
Monitoring the CICS DB2 attachment facility
Monitoring the CICS DB2 attachment facility using CICS DB2 attachment facility commands
Monitoring the CICS DB2 attachment facility using DB2 commands
Monitoring the CICS DB2 attachment facility using CICS DB2 statistics
Monitoring CICS transactions that access DB2 resources
Monitoring DB2 when used with CICS
Monitoring DB2 using the DB2 statistics facility
Monitoring DB2 using the DB2 accounting facility
Monitoring DB2 using the DB2 performance facility
Monitoring the CICS system in a CICS DB2 environment
Accounting in a CICS DB2 environment: Overview
Accounting information provided by the DB2 accounting facility
Data types in DB2 accounting records
DB2 accounting reports
Relating DB2 accounting records to CICS performance class records
What are the issues when matching DB2 accounting records and CICS performance records?
Controlling the relationship between DB2 accounting records and CICS performance class records
Using data in the DB2 accounting record to identify the corresponding CICS performance class records
Matching DB2 accounting records and CICS performance class records to the end user
Accounting for processor usage in a CICS DB2 environment
Accounting CLASS 1 processor time
Accounting CLASS 2 processor time
Calculating CICS and DB2 processor times for DB2 Version 5 or earlier
Calculating CICS and DB2 processor times for DB2 Version 6 or later
Problem determination for CICS DB2
Thread TCBs (task control blocks)
Wait types for CICS DB2
Messages for CICS DB2
Trace for CICS DB2
CSUB trace
Dump for CICS DB2
DB2 thread identification
Transaction abend codes for CICS DB2
Execution Diagnostic Facility (EDF) for CICS DB2
Handling deadlocks in the CICS DB2 environment
Two deadlock types
Deadlock detection
Finding the resources involved
Finding the SQL statements involved
Finding the access path used
Determining why the deadlock occurred
Making changes
Bibliography
The CICS Transaction Server for z/OS library
The entitlement set
PDF-only books
Other CICS books
Books from related libraries
DB2
DB2 Performance Monitor (DB2 PM)
Resource Management Facility (RMF)
Accessibility
Index
Notices
Programming interface information
Trademarks
[[
Contents
Previous Page
|
Next Page
Index
]]