Load Module Scanner base tables

This section describes the Load Module Scanner base tables defined in the database. You can write your own SQL applications to query the tables; these applications must use native SQL queries to do this.

CIU_SCAN_SUMMARY

This table stores summary information about every module in the load libraries that have been scanned.

Table 1. The CIU_SCAN_SUMMARY table

Column	Type	Description
DSNAME	CHAR(44)	Data set name
PROGRAM	CHAR(8)	Module name
LANGUAGE	CHAR(10)	Programming language detected
REENTERABLE	CHAR(1)	Whether this program is reentrant, where Y indicates yes, and blank indicates no.
LE	CHAR(7)	IBM®Language Environment® (LE) detected
CICS_OR_BATCH	CHAR(5)	CICS® transaction or batch
AFFINITY_COUNT	INTEGER	Number of commands with potential to create affinities
MVS_POST_COUNT	INTEGER	Number of MVS POST commands
DEPENDENCY_COUNT	INTEGER	Number of commands with potential to create dependencies

CIU_SCAN_DETAIL

This table records detailed information about every command, in specified modules of the load libraries that have been scanned, that has the potential to create a resource dependency or a transaction affinity.

Table 2. The CIU_SCAN_DETAIL table

Column	Type	Description
DSNAME	CHAR(44)	Data set name
PROGRAM	CHAR(8)	Module name
OFFSET	INTEGER	Offset, from the start of the program, at which this command occurs
COMMAND	CHAR(24)	EXEC CICS command or MVS POST
RESOURCE_TYPE	CHAR(16)	Resource type; for example, program
AFFINITY	CHAR(1)	Whether this command has the potential to create an affinity: Y Yes N No
AFFINITY_TYPE	CHAR(2)	The type of affinity: IT Inter-transaction TS Transaction-system
DEPENDENCY	CHAR(1)	Whether this command has the potential to create a dependency: Y Yes N No
MVS_POST	CHAR(1)	Whether this command is a possible MVS POST: Y Yes N No
COMMAND_HEX	CHAR(50)	Data at the command offset, shown in hexadecimal

V_CIU_SCAN_TRDSAFE

This view is a simple join between the CIU_SCAN_DETAIL table and the CIU_THREADSAFE_CMD table using the COMMAND and RESOURCE_TYPE fields from each table. This table is used to query, by CICS® TS release, which commands in the CIU_SCAN_DETAIL table are threadsafe, non-threadsafe, or indeterminate-threadsafe.

Table 3. The V_CIU_SCAN_TRDSAFE table

Column	Type	Description
DSNAME	CHAR(44)	Data set name
PROGRAM	CHAR(8)	Module name
LANGUAGE	CHAR(10)	Programming language detected
LE	CHAR(7)	Language Environment® (LE) detected
CICS_OR_BATCH	CHAR(5)	CICS® transaction or batch
AFFINITY_COUNT	INTEGER	Resource type; for example, program
MVS_POST_COUNT	INTEGER	Number of MVS POST commands
DEPENDENCY_COUNT	INTEGER	Number of commands with potential to create dependencies
CICS_TS23	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 2.3. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS31	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 3.1. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS32	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 3.2. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS41	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 4.1. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS42	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 4.2. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS51	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 5.1. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS52	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 5.2. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS53	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 5.3. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS54	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 5.4. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS55	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 5.5. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS56	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 5.6. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS61	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 6.1. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS62	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 6.2. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe
CICS_TS63	CHAR(1)	Indicates the threadsafe status if the command is for CICS® TS 6.3. Values are: Y command is threadsafe N command is not threadsafe I command is indeterminate threadsafe