IBM CICS Transaction Server for OS/390 SC33-1686-02 User Manual

Page 84

Advertising
background image

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:

Twait

If 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

Advertising