Filter
Top Products
CEMT INQUIRE DB2CONN
Tern The terminal identification (four characters padded
to eight) is used as an authorization ID. An
authorization ID cannot be obtained in this manner
if a terminal is not connected with the transaction.
If a transaction is started (using a CICS command)
and has no terminal associated with it,
AUTHTYPE(TERM) should not be used.
Tx The transaction identification (four characters
padded to eight) is used as the authorization ID.
Opid
The user operator identification associated with
the userid, associated with the CICS transaction,
is used as the authorization ID (three characters
padded to eight).
Userid
The 8-character USERID associated with the
CICS transaction is used as the authorization ID.
When the DB2 sample sign-on exit DSN3@SGN
is used with AUTHTYPE(USERID), the exit sends
the USERID to DB2 as the primary authorization
ID and the RACF group ID to DB2 as the
secondary ID. When the sample sign-on exit is
used, there is no difference between
AUTHTYPE(USERID) and AUTHTYPE(GROUP).
Comauthid
returns an ID to be used for security checking when
using command threads. If COMAUTHType is returned,
COMAUTHid is not applicable.
Comauthtype
returns the type of ID to be used for security checking
when using command threads. If COMAUTHType is
returned, COMAUTHid is blank. The values are:
Cgroup
The 8-character USERID and the connected group
name are used as the authorization ID. The
following table shows how these two values are
interpreted by DB2.
If no RACF group ID is available for this USERID,
an 8-character field of blanks is passed to DB2 as
the group ID.
Csign
The SIGNID parameter of the DB2CONN is used
as the resource authorization ID.
Cterm
The terminal identification (four characters padded
to eight) is used as an authorization ID. An
authorization ID cannot be obtained in this manner
if a terminal is not connected with the transaction.
If a transaction is started (using a CICS command)
and has no terminal associated with it,
COMAUTHTYPE(CTERM) should not be used.
Ctx The transaction identification (four characters
padded to eight) is used as the authorization ID.
Copid
The operator identification associated with the
userid that is associated with the CICS transaction
is used as the authorization ID (three characters
padded to eight).
Cuserid
The 8-character USERID associated with the
CICS transaction is used as the authorization ID.
When the DB2 sample sign-on exit DSN3@SGN
is used with COMAUTHTYPE(CUSERID), the exit
sends the USERID to DB2 as the primary
authorization ID and the RACF group ID to DB2
as the secondary ID. When the sample sign-on
exit is used, there is no difference between
COMAUTHTYPE(CUSERID) and
COMAUTHTYPE(CGROUP).
Comthreads
returns the current number of active command threads.
Comthreadlim
returns the current maximum number of command
threads the CICS DB2 attachment allows active before
requests overflow to the pool.
Connecterror
returns a value when CICS is not connected to DB2
because the adapter is in 'standby mode'. The value
shows how this information is to be passed back to an
application that has issued a SQL request. The values
are:
Abend
The application is abended with abend AEY9.
Sqlcode
The application receives a -923 SQLCODE.
IDs passed to DB2 How DB2 interprets values
CICS sign-on user ID
(USERID)
Represents the primary DB2
authorization ID.
RACF connected
group name
If the RACF list of group options
is not active, DB2 uses the
connected group name supplied
by the CICS attachment facility
as the secondary DB2
authorization ID. If the RACF list
of group options is active, DB2
ignores the connected group
name supplied by the CICS
attachment facility, but the value
appears in the DB2 list of
secondary DB2 authorization
IDs.
64 CICS Supplied Transactions