Administering with CICS DB2
This information discusses operating the CICS® DB2® attachment facility.
- Starting the CICS DB2 attachment facility
The CICS DB2 attachment facility can be started automatically at initialization, or manually. - Stopping the CICS DB2 attachment facility
The CICS DB2 attachment facility, and hence the CICS-DB2 connection, can be quiesce stopped or force stopped. A quiesce stop waits for all CICS transactions currently using DB2 to complete. A force stop causes all CICS transactions currently using DB2 to be forcepurged. - Resolving indoubt units of work (UOWs)
Indoubt units of work (UOWs) can occur when CICS, DB2, or the whole system fails while a transaction is carrying out syncpoint processing, that is, during processing of an EXEC CICS SYNCPOINT or EXEC CICS RETURN command. Indoubt UOWs are typically resolved when the connection between CICS and DB2 is reestablished. - Managing the CICS DB2 attachment facility
You can manage the status of the connection between CICS and DB2 using CEMT commands and commands provided by the CICS DB2 attachment facility. The same function provided by CEMT is also available via EXEC CICS INQUIRE and SET commands. - Entering DB2 commands
Once the connection between CICS and DB2 has been established, terminal users authorized by CICS can use the DSNC transaction to route commands to the DB2 subsystem. - Purging CICS DB2 transactions
Take care when purging CICS DB2 transactions to ensure that DB2 requests are not cancelled during "must complete" activity. - Starting SMF for DB2 accounting, statistics, and tuning
Through its instrumentation facility, DB2 produces a system management facility (SMF) type 101 accounting record at each CICS DB2 thread termination and at each CICS DB2 signon. DB2 also produces an SMF type 100 record to hold DB2 statistics on a DB2 sub system basis. Performance and global trace records are produced as SMF type 102 records. - Starting GTF for DB2 accounting, statistics and tuning
Instead of, or in addition to, recording accounting, statistics, and performance data to SMF, you can use DB2 to send this data to a generalized trace facility (GTF). DB2 provides -START TRACE and -STOP TRACE commands which you can issue from a CICS terminal using the DSNC transaction. - CICS-supplied transactions for CICS DB2
CICS provides a number of transactions that you can use to manage the interface with DB2.
dfhtk0h.html |
Last updated: Sunday, 4 June 2017