CEMT INQUIRE DB2CONN
SET DB2CONN. See SECURITY(REBUILD) on
page170.
Standbymode
returns the action to be taken by the CICS DB2
attachment if DB2 is not active when an attempt is made
to start the connection from CICS to DB2. The values
are:
Noconnect
The CICS DB2 attachment terminates.
Connect
The CICS DB2 attachment goes into 'standby
mode' to wait for DB2.
Reconnect
The CICS DB2 attachment goes into 'standby
mode' and waits for DB2. Having connected to
DB2, if DB2 subsequently fails the CICS DB2
attachment reverts again to standby mode and
subsequently reconnects to DB2 when it comes up
again.
Statsqueue
returns the transient data destination for CICS DB2
attachment statistics produced when the CICS DB2
attachment is shutdown.
Tcbs
returns the current number of subtask TCBs attached to
service command, pool, and DB2ENTRY threads.
Tcblimit
returns the current maximum number of subtasks that
can be identified to DB2.
Threaderror
returns the processing that is to occur following a create
thread error. The values are:
Abend
| For a second or subsequent SQL error the
transaction abends with abend code AD2S, AD2T
or AD2U, dependent on the type of error that
occurred. The transaction must be terminated and
reinitialized before it is allowed to issue another
SQL request.
N906D
A transaction dump is taken and the DSNCSQL
RMI associated with the transaction is
not
to be
disabled. The transaction receives a -906
SQLCODE if another SQL is issued, unless the
transaction issues SYNCPOINT ROLLBACK.
SYNCPOINT without the ROLLBACK option
results in an ASP3 or ASP7 abend. The
transaction dump records an abend of AD2S,
AD2T or AD2U.
N906 The DSNCSQL RMI associated with the
transaction is
not
to be disabled. The transaction
receives a -906 SQLCODE if another SQL request
is issued, unless the transaction issues a
SYNCPOINT ROLLBACK. SYNCPOINT without
the ROLLBACK option results in an ASP3 or
ASP7 abend.
Threadlimit
returns the current maximum number of pool threads the
CICS DB2 attachment allows active before requests are
made to wait or are rejected (see THREADWait).
Threads
returns the current number of active pool threads.
Threadwait
returns a value showing whether transactions should
wait for a pool thread or be abended if the number of
active pool threads reaches the threadlimit number. The
values are:
TwaitIf all threads are busy, a transaction waits until
one becomes available.
Notwait
If all threads are busy, a transaction is terminated
with an abend code AD3T.
66 CICS Supplied Transactions