CIUSPAP1 Stored Procedure
When you use the CIUSPAP1 stored procedure you can view or delete resource information for a CICS® TS application definition.
What is the CIUSPAP1 Stored Procedure?
- List CICS TS Applications for which you have collected data.
- Retrieve or delete resources that are used by a specific TS application or operations that are associated with that application.
Syntax
EXEC SQL
CALL CIUSPAP1 (calltype, platform, appname, version1, version2, version3, operation, message, return-code);
Procedure parameters
There are several input parameters that help you to manage CIUSPAP1 processing and several output parameters that inform about the process completion and errors, if any.
Parameter name | Input/Output | Type | Description |
---|---|---|---|
calltype | INPUT | CHAR(4) | Type of call. |
platform | INPUT | CHAR(64) | Specifies the platform name (this parameter is used for all calltypes other than LIST). |
appname | INPUT | CHAR(64) | Specifies the application name (this parameter is used for all calltypes other than LIST). |
version 1 | INPUT | INTEGER | Specifies a Major Version of Application (this parameter is used for all calltypes other than LIST). |
version 2 | INPUT | INTEGER | Specifies a Minor Version of Application (this parameter is used for all calltypes other than LIST). |
version 3 | INPUT | INTEGER | Specifies a Micro Version of Application (this parameter is used for all calltypes other than LIST). |
operation | INPUT | CHAR(64) | Specifies the operation name (this parameter is optional and can be used for all calltypes other than LIST). |
message | OUTPUT | CHAR(300) | Specifies a message buffer that contains error information for a List call type, or the result of procedure execution for a Delete call type. |
return-code | OUTPUT | INTEGER | Return code. |
CIUSPAP1 INPUT parameters (calltype, appname)
calltype |
Description |
---|---|
LIST | List of Applications for which CICS IA has collected data. |
DEL | Deletes all resources that are associated with the Application. |
RES | Lists all resources that are associated with the Application. |
CICS | Lists all CICS resources that are associated with the Application. |
DB2 | Lists all DB2 resources that are associated with the Application. |
IMS™ | Lists all IMS resources that are associated with the Application. |
MQ | Lists all WebSphere® MQ resources that are associated with the Application. |
NAT | Lists all Natural resources that are associated with the Application. |
CIUSPAP1 OUTPUT parameters (error-message, return-code)
Return code | Description |
---|---|
0 | CIUSPAP1 procedure has completed successfully. |
4 | Any SQL Exception or SQL Warning occurred, in this case ERROR-MESSAGE contains the message with explanation of exception/warning. |
8 | One of the following conditions
exists:
|
- For return-code=4, it provides either the relevant SQL warning, or the "Invalid call type" message, depending on the error cause.
- For return-code=8, it provides the following message: "Application name must be specified".
Listing all CICS TS applications
CALLTYPE='LIST'
Set all other input parameters to null values.
This call returns one OPEN cursor which you use to FETCH the returned data by running an SQL ASSOCIATE LOCATORS, followed by an SQL ALLOCATE cursor, and then the SQL FETCH loop as shown in the COBOL example for CIUSPAPP Stored Procedure.
Resources used by applications
- calltype ='RES'
- Set the applname and version fields as required.
This call returns one 5 OPEN cursor which you use to FETCH the returned data by running an SQL ASSOCIATE LOCATORS, followed by an SQL ALLOCATE cursor, and the SQL FETCH loop as shown in the COBOL example for CIUSPAPP Stored Procedure.