The Dependency base tables are defined in the database objects. You can write your own SQL applications to query the tables; these applications must use native SQL queries.
“Which CICS resources are used by this transaction?”
“If I change this CICS resource, which programs and transactions are affected?”
Column | Type | Description |
---|---|---|
COLLECTION_ID | CHAR(16) | Collection ID. |
ARCHIVE_DATE | TIMESTAMP | Time of archiving. |
APPLID | CHAR(8) | CICS region APPLID. |
HOMESYSID | CHAR(4) | SYSID of local region. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
TRANSID | CHAR(4) | CICS transaction ID |
PROGRAM | CHAR(8) | Currently active CICS program. |
FUNCTION | CHAR(24) | EXEC CICS command name, such as READ, WRITEQ.¹ ⁴ |
TYPE | CHAR(16) | Resource type, such as TS, program.¹ ⁴ |
OBJECT | CHAR(255) | Resource name.² |
OBJLENGTH | INTEGER | Length of resource name in OBJECT field. |
RMTSYSID | CHAR(4) | Remote SYSID, if relevant.³ |
RMTNAME | CHAR(8) | Name by which the resource is known in the remote region. |
TERMTRAN | CHAR(1) | Whether a terminal is associated with the transaction:
|
TCBMODE | CHAR(2) | CICS TCB in which the application is running; for example, QR or L8. |
AFFINITY | CHAR(1) | Whether the EXEC CICS command might cause an
affinity:
|
OFFSET | CHAR(8) | The offset of the command from the start of the program. |
PROGLEN | CHAR(8) | Length of CICS program. Used for program versioning. |
COMMAREA | CHAR(1) | Whether a commarea is associated with the transaction:
|
CHANNEL | CHAR(1) | Whether a channel is associated with the transaction:
|
USECOUNT | INTEGER | Number of occurrences. |
FIRST_RUN | TIMESTAMP | Time of first occurrence, in the local time format. |
LAST_RUN | TIMESTAMP | Time of latest observation, in the local time format. |
USER_DATA1 | CHAR(48) | Reserved. |
USER_DATA2 | CHAR(48) | Reserved. |
USER_DATA3 | CHAR(48) | Reserved. |
“Which DB2 resources are used by this transaction?”
“If I change this DB2 resource, which programs and transactions are affected?”
Column | Type | Description |
---|---|---|
COLLECTION_ID | CHAR(16) | Collection ID. |
ARCHIVE_DATE | TIMESTAMP | Time of archiving. |
APPLID | CHAR(8) | CICS region APPLID. |
HOMESYSID | CHAR(4) | SYSID of local region. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
DB2ID | CHAR(4) | DB2 subsystem ID. |
TRANSID | CHAR(4) | CICS transaction ID. |
PROGRAM | CHAR(8) | CICS program name. |
PLAN | CHAR(8) | DB2 plan ID. |
RESTYPE | CHAR(16) | DB2 resource type.¹ |
RESNAME | CHAR(40) | DB2 resource name. |
FUNCTION | CHAR(24) | EXEC SQL command name, such as CREATE, UPDATE.¹ ² |
SECTION | SMALL INT | The section number, in the source code of the CICS program, at which the DB2 command is issued. |
STATEMENT | SMALL INT | The precompiler statement number, in the source code of the CICS program, at which the DB2 command is issued. |
TERMTRAN | CHAR(1) | Whether a terminal is associated with the transaction:
|
TCBMODE | CHAR(2) | CICS TCB in which the application is running; for example, QR or L8. |
OFFSET | CHAR(8) | The offset of the command from the start of the program. |
PROGLEN | CHAR(8) | Length of CICS program. Used for program versioning. |
USECOUNT | INTEGER | Number of occurrences. |
FIRST_RUN | TIMESTAMP | Time of first occurrence, in the local time format. |
LAST_RUN | TIMESTAMP | Time of latest observation, in the local time format. |
USER_DATA1 | CHAR(48) | Reserved. |
USER_DATA2 | CHAR(48) | Reserved. |
USER_DATA3 | CHAR(48) | Reserved. |
“Which IMS resources are used by this transaction?”
“If I change this IMS resource, which programs and transactions are affected?”
Column | Type | Description |
---|---|---|
COLLECTION_ID | CHAR(16) | Collection ID. |
ARCHIVE_DATE | TIMESTAMP | Time of archiving. |
APPLID | CHAR(8) | CICS region APPLID. |
HOMESYSID | CHAR(4) | SYSID of local region. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
TRANSID | CHAR(4) | CICS transaction ID. |
PROGRAM | CHAR(8) | Currently active CICS program. |
CALLTYPE | CHAR(4) | EXEC for EXEC DLI calls. |
FUNCTION | CHAR(24) | DLI command.¹ |
TYPE | CHAR(16) | PSB or PCB.¹ |
OBJECT | CHAR(8) | PSB name or PCB name. |
TERMTRAN | CHAR(1) | Whether a terminal is associated with the transaction:
|
TCBMODE | CHAR(2) | CICS TCB in which the application is running; for example, QR or L8. |
OFFSET | CHAR(8) | The offset of the command from the start of the program. |
PROGLEN | CHAR(8) | Length of CICS program. Used for program versioning. |
USECOUNT | INTEGER | Number of occurrences. |
FIRST_RUN | TIMESTAMP | Time of first occurrence, in the local time format. |
LAST_RUN | TIMESTAMP | Time of last occurrence, in the local time format. |
USER_DATA1 | CHAR(48) | Reserved. |
USER_DATA2 | CHAR(48) | Reserved. |
USER_DATA3 | CHAR(48) | Reserved. |
“Which WebSphere MQ resources are used by this transaction?”
“If I change this WebSphere MQ resource, which programs and transactions are affected?”
Column | Type | Description |
---|---|---|
COLLECTION_ID | CHAR(16) | Collection ID. |
ARCHIVE_DATE | TIMESTAMP | Time of archiving. |
APPLID | CHAR(8) | CICS region APPLID. |
HOMESYSID | CHAR(4) | SYSID of local region. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
TRANSID | CHAR(4) | CICS transaction ID. |
PROGRAM | CHAR(8) | CICS program name. |
FUNCTION | CHAR(24) | MQ command name, such as MQGET, MQPUT¹ ². |
TYPE | CHAR(16) | Resource type.¹ ² |
OBJECT | CHAR(48) | Resource name.³ |
QMGRNAME | CHAR(48) | Name of the queue manager. |
TERMTRAN | CHAR(1) | Whether a terminal is associated with the transaction:
|
TCBMODE | CHAR(2) | CICS TCB in which the application is running; for example, QR or L8. |
OFFSET | CHAR(8) | The offset of the command from the start of the program. |
PROGLEN | CHAR(8) | Length of CICS program. Used for program versioning. |
MQFIQ | CHAR(1) | Whether the MQOO_FAIL_IF_QUIESCING option is
set for the FUNCTION:
|
MQBOO | CHAR(1) | Whether the MQOO_BIND_ON_OPEN option is set
for the FUNCTION:
|
USECOUNT | INTEGER | Number of occurrences. |
FIRST_RUN | TIMESTAMP | Time of first occurrence,in the local time format. |
LAST_RUN | TIMESTAMP | Time of latest observation, in the local time format. |
USER_DATA1 | CHAR(48) | Reserved. |
USER_DATA2 | CHAR(48) | Reserved. |
USER_DATA3 | CHAR(48) | Reserved. |
Column | Type | Description |
---|---|---|
COLLECTION_ID | CHAR(16) | Collection ID. |
ARCHIVE_DATE | TIMESTAMP | Time of archiving. |
APPLID | CHAR(8) | CICS region APPLID. |
HOMESYSID | CHAR(4) | SYSID of local region. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
TRANSID | CHAR(4) | CICS transaction ID. |
PROGRAM | CHAR(8) | Current program name. |
FUNCTION | CHAR(8) | Natural command name, such as CALL. |
TYPE | CHAR(8) | Natural command type, such as ADABAS, PROGRAM. |
OBJECT | CHAR(32) | Database type code (for CALL ADABAS) or calling program name (for CALL PROGRAM). |
COMMAND_CODE | CHAR(4) | Database command code (for CALL ADABAS), such as OP, L1, CL. |
COMMAND_ID | CHAR(8) | Database command identifier (for CALL ADABAS). |
COMMAND_DESC | CHAR(36) | Database command descriptor (for CALL ADABAS). |
PROGRAM_TYPE | CHAR(16) | Calling program type (for CALL PROGRAM), such as FETCH PROGRAM, MAP, CALLNAT SUBPROG, VIEW. |
PROGRAM_MODE | CHAR(16) | Calling program mode (for CALL PROGRAM), such as STATIC, DYNAMIC. |
PROGRAM_CALL | CHAR(16) | Calling program parameter call type (for CALL PROGRAM), such as BY VALUE, BY REFERENCE. |
LOCATION | CHAR(8) | Calling program location (for CALL PROGRAM), such as a library name, LIBRARY (load program library), NUCLEUS (Natural shared nucleus). |
DATABASE_ID | INTEGER | Database identifier (for CALL ADABAS) or system file database identifier (for CALL PROGRAM). |
FILE_NUMBER | INTEGER | File number (for CALL ADABAS) or system file number (for CALL PROGRAM). |
TERMTRAN | CHAR(1) | Whether a terminal is associated with the transaction:
|
TCBMODE | CHAR(2) | CICS TCB in which the application is running; for example, QR or L8. |
LEVEL | INTEGER | Current program level. |
LINE | CHAR(4) | Current statement number. |
OFFSET | CHAR(8) | The offset of the command from the start of the program. |
PROGLEN | CHAR(8) | Length of the program (Natural nucleus). |
USECOUNT | INTEGER | Number of occurrences. |
FIRST_RUN | TIMESTAMP | Time of first occurrence, in the local time format. |
LAST_RUN | TIMESTAMP | Time of latest observation, in the local time format. |
USER_DATA1 | CHAR(48) | Reserved. |
USER_DATA2 | CHAR(48) | Reserved. |
USER_DATA3 | CHAR(48) | Reserved. |