CIUSPDEL Stored Procedure
You can delete the interdependency data from the CICS® IA interdependency Db2® tables using the CIUSPDEL stored procedure.
The CIUSPDEL stored procedure works with the following CICS® IA interdependency Db2® tables:
- CIU_REGION_INFO
- CIU_CICS_DATA
- CIU_DB2_DATA
- CIU_MQ_DATA
- CIU_IMS_DATA
- CIU_PROGRAM_DETAIL
- CIU_TRANSID_DETAIL
- CIU_TSQUEUE_DETAIL
- CIU_TDQUEUE_DETAIL
- CIU_WEBSERV_DETAIL
- CIU_EVENT_DETAIL
- CIU_FILE_DETAIL
- CIU_EXIT_INFO
- CIU_NATURAL_DATA
- CIU_RESOURCE
- CIU_CICS_CHAINP
What is the CIUSPDEL Stored Procedure?
The CIUSPDEL stored procedure is used to delete interdependency data collected in the CICS® IA interdependency Db2® tables.
Syntax
You can call the CIUSPDEL stored procedure using the following SQL call statement:
EXEC SQL
CALL CIUSPDEL (calltype, collection id, cics count, db2 count, mq count, ims count, program count, transid count, tsqueue count, tdqueue count, webserv count, file count, exit count, event count, region count, natural count, resource count, chain count, rc, errmsg)Procedure parameters
The CIUSPDEL stored procedure includes multiple input parameters that control its processing and several output parameters that provide information about the process completion or any errors encountered.
The following table lists all the CIUSPDEL parameters.
| Parameter name | input/output | Type | Description |
|---|---|---|---|
| calltype | INPUT | CHAR(01) | Call type |
| collection id | INPUT | CHAR(16) | CICS® IA collection identifier |
| cics count | OUTPUT | INTEGER |
Count of records to be deleted from CIU_CICS_DATA table |
| db2 count | OUTPUT | INTEGER | Count of records to be deleted from CIU_DB2_DATA table |
| mq count | OUTPUT | INTEGER | Count of records to be deleted from CIU_MQ_DATA table |
| ims count | OUTPUT | INTEGER | Count of records to be deleted from CIU_IMS_DATA table |
| program count | OUTPUT | INTEGER | Count of records to be deleted from CIU_PROGRAM_DETAIL table |
| transid count | OUTPUT | INTEGER | Count of records to be deleted from CIU_TRANSID_DETAIL table |
| tsqueue count | OUTPUT | INTEGER | Count of records to be deleted from CIU_TSQUEUE_DETAIL table |
| tdqueue count | OUTPUT | INTEGER | Count of records to be deleted from CIU_TDQUEUE_DETAIL table |
| webserv count | OUTPUT | INTEGER | Count of records to be deleted from CIU_WEBSERV_DETAIL table |
| file count | OUTPUT | INTEGER | Count of records to be deleted from CIU_FILE_DETAIL table |
| exit count | OUTPUT | INTEGER | Count of records to be deleted from CIU_EXIT_INFO table |
| event count | OUTPUT | INTEGER | Count of records to be deleted from CIU_EVENT_DETAIL table |
| region count | OUTPUT | INTEGER | Count of records to be deleted from CIU_REGION_INFO table |
| natural count | OUTPUT | INTEGER | Count of records to be deleted from CIU_NATURAL_DATA table |
| resource count | OUTPUT | INTEGER | Count of records to be deleted from CIU_RESOURCE table |
| chain count | OUTPUT | INTEGER | Count of records to be deleted from CIU_CICS_CHAINP table |
| rc | OUTPUT | INTEGER | Return code |
| errmsg | OUTPUT | VARCHAR(300) | Error message text |
CIUSPDEL INPUT parameters (calltype, collection id)
| Parameter | Description |
|---|---|
| Calltype |
Mandatory Parameter. The parameter defines the type of collected data intended to be deleted. Values: D- For Dependency related data |
| collection id | Mandatory parameter. The collection ID parameter specifies the collection ID under which the data was collected. |
CIUSPDEL OUTPUT parameters (cics count, db2 count, mq count, ims count, program count, transid count, tsqueue count, tdqueue count, webserv count, file count, exit count, event count, region count, natural count, resource count, chain count, rc, errmsg)
The cics count parameter contains the count of records to be deleted from the CIU_CICS_DATA table for the mentioned collection ID.
The db2 count parameter contains the count of records to be deleted from the CIU_DB2_DATA table for the mentioned collection ID.
The mq count parameter contains the count of records to be deleted from the CIU_MQ_DATA table for the mentioned collection ID.
The ims count parameter contains the count of records to be deleted from the CIU_IMS_DATA table for the mentioned collection ID.
The program count parameter contains the count of records to be deleted from the CIU_PROGRAM_DETAIL table for the mentioned collection ID.
The transid count parameter contains the count of records to be deleted from the CIU_TRANSID_DETAIL table for the mentioned collection id.
The tsqueue count parameter contains the count of records to be deleted from the CIU_TSQUEUE_DETAIL table for the mentioned collection ID.
The tdqueue count parameter contains the count of records to be deleted from the CIU_TDQUEUE_DETAIL table for the mentioned collection ID.
The webserv count parameter contains the count of records to be deleted from the CIU_WEBSERV_DETAIL table for the mentioned collection ID.
The file count parameter contains the count of records to be deleted from the CIU_FILE_DETAIL table for the mentioned collection ID.
The exit count parameter contains the count of records to be deleted from the CIU_EXIT_INFO table for the mentioned collection ID.
The event count parameter contains the count of records to be deleted from the CIU_EVENT_DETAIL table for the mentioned collection ID.
The region count parameter contains the count of records to be deleted from the CIU_REGION_INFO table for the mentioned collection ID.
The natural count parameter contains the count of records to be deleted from the CIU_NATURAL_DATA table for the mentioned collection ID.
The resource count parameter contains the count of records to be deleted from the CIU_RESOURCE table for the mentioned collection ID.
The chain count parameter contains the count of records to be deleted from the CIU_CICS_CHAINP table for the mentioned collection ID.
The rc parameter value of the CIUSPDEL return code. Possible rc values are listed in the following table.
| Return code | Description |
|---|---|
| 0 | CIUSPDEL procedure completed successfully. |
| 4 | CIUSPDEL procedure completed successfully, but one or more SQL warning conditions were received or there are no records in the tables for the collection id provided. |
| 8 | CIUSPDEL procedure failed either because of the invalid call type or invalid collection id. |
| 12 | CIUSPDEL has failed because of the SQL Exception conditions during SQL statement execution. |
- For RC = 4, it contains the SQL message of the last SQL statement that caused the warning condition or contains that no records are present for the provided collection id
- For RC = 8, it provides the invalid parameter value that caused the error.
- For RC = 12, it provides the SQL error message for the failed SQL statement.