Filter
Top Products
CEMT INQUIRE DB2CONN
Connectst
returns the status of the CICS DB2 connection. The
values are:
Connected
CICS is connected to DB2.
Notconnected
CICS is not connected to DB2.
Connecting
CICS is currently attempting to connect to DB2.
Disconning
CICS is currently disconnecting from DB2.
DB2id
returns the name of the DB2 subsystem that the CICS
DB2 attachment is connected to or is to connect to.
DB2release
returns a four-character value indicating the version and
release level of the DB2 susbsytem CICS is connected
to. When CICS is not connected to DB2, blanks are
returned.
Drollback
returns a value showing whether the CICS DB2
attachment is to initiate a SYNCPOINT ROLLBACK if a
transaction is selected as victim of a deadlock resolution.
The values are:
Rollback
the attachment facility issues a sync point rollback
before returning control to the application. An SQL
return code of -911 is returned to the program.
Norollback
the attachment facility does not initiate a rollback
for a transaction. An SQL return code of -913 is
returned to the application.
Msgqueue1
returns the name of the first transient data destination to
which unsolicited messages from the CICS DB2
attachment are sent.
Msgqueue2
returns the name of the second transient data
destination to which unsolicited messages from the CICS
DB2 attachment are sent.
Msgqueue3
returns the name of the third transient data destination to
which unsolicited messages from the CICS DB2
attachment are sent.
Nontermrel
returns a value showing whether non-terminal
transactions are to release threads for reuse at
intermediate syncpoints. CVDA values are:
Release
non-terminal transactions release threads for
reuse at intermediate syncpoints.
Norelease
non-terminal transactions do not release threads
for reuse at intermediate syncpoints.
Plan
returns the name of the plan used for the pool. If a plan
name is returned, PLANEXITNAME is blank,
Planexitname
returns the name of the dynamic plan exit used for pool
threads. If a PLANEXITNAME is returned, PLAN is
blank,
Priority
returns the priority of the pool thread subtasks relative to
the CICS main task (QR TCB). CVDA values are:
High subtasks attain a higher priority than the CICS
main task from which the subtask was generated.
Equal
subtasks have equal priority with the CICS main
task.
Low subtasks have a lower priority than the CICS main
task.
Purgecyclem
returns in minutes the length of the protected thread
purge cycle. The range for PURGECYCLEM is 0-59.
A protected thread is not terminated immediately when it
is released. It is terminated only after two completed
purge cycles, if it has not been reused in the meantime.
Hence if the purge cycle is set to 30 seconds after it is
released, a protected thread will be purged 30 - 60
seconds after it is released. An unprotected thread is
terminated when it is released (at syncpoint or end of
task) if there are no other transactions waiting for a
thread on that DB2ENTRY.
Purgecycles
returns in seconds the length of the protected thread
purge cycle. The range for PUrgecycles is 30-59.
A protected thread is not terminated immediately when it
is released. It is terminated only after two completed
purge cycles, if it has not been reused in the meantime.
Hence if the purge cycle is set to 30 seconds after it is
released, a protected thread will be purged 30 - 60
seconds after it is released. An unprotected thread is
terminated when it is released (at syncpoint or end of
task) if there are no other transactions waiting for a
thread on that DB2ENTRY.
Signid
returns the authorization ID to be used by the CICS DB2
attachment when signing on to DB2 for pool and DB2
entry threads specifying AUTHTYPE(SIGNID) and
command threads specifying COMAUTHTYPE(CSIGN).
Security
has no meaning for INQUIRE. It is supplied to allow
overtyping with the REBUILD option, to initiate a CEMT
Chapter 11. Master terminal CEMT 65