CICS

CICS

CICS

The world's leading application server software for IBM Z

 View Only

Deleting Command Flow Data from Db2 Tables using Command Flow ID

By Aman Sahni posted Fri February 21, 2025 07:42 AM

  

This blog describes the procedure for deleting command flow data from Db2 tables using the command flow ID on both the host and client sides. 

Host Side 

This blog will cover deleting command flow data collected in Db2 tables. We will begin by explaining how to collect command flow data and then explore how to delete the data from the command flow Db2 tables. 

Process of command flow collection: 

  1. Run the CINC transaction to collect command flow data.
  2. The data gets stored in log stream journals from the command flow collector.
  3. Run the CIUJLCPY job to offload the data from log stream journals to the GDG data set.
  4. Run the CIUUPDB5 job to update CIU_CMDFLOW_DATA & CIU_CMDFLOW_INDEX DB2 tables from GDG data set. 

How Can Command Flow Data Be Deleted from Db2 Tables? 

Command flow data collected and stored in the CIU_CMDFLOW_DATA and CIU_CMDFLOW_INDEX Db2 tables can be deleted using the CIUDELSP job with the CFL parameter. The CIUDELSP job calls the Db2 stored procedure CIUSPCFL, which removes the data from these tables.  

Follow the steps below to collect and delete command flow data from DB2 tables: 

  1. Run the command flow collector (CINC) in the region with a specific command flow ID that you intend to store and delete.  
    Example: In this case, the collector was run with command flow ID TEST2222 in the region C61C1C03.
    Figure 1: Command Flow Collector

  2. Run the CIUJLCPY job to copy data from log stream journals to the GDG data set.
  3. Next, run the CIUUPDB5 job, which transfers data from the GDG data set to the Db2 tables CIU_CMDFLOW_DATA and CIU_CMDFLOW_INDEX. The images below illustrate that the data has been successfully populated in the Db2 tables.
    Figure 2: CIU_CMDFLOW_DATA Db2 table

    Figure 3: CIU_CMDFLOW_INDEX Db2 table

  4. Run the CIUDELSP job to delete the command flow data from the CIU_CMDFLOW_DATA and CIU_CMDFLOW_INDEX Db2 tables based on the specified command flow ID.
  5. In the CIUDELSP job, update the command flow ID and set PARMS to CFL, as shown in the following images.
    Figure 4:  Command flow ID in CIUDELSP job

    Figure 5: PARMS in CIUDELSP job

  6. After successfully executing the CIUDELSP job, the records associated with the command flow ID "TEST2222" have been removed from the CIU_CMDFLOW_DATA and CIU_CMDFLOW_INDEX tables.
    Figure 6:  CIUDELSP JOB OUTPUT

    Figure 7: CIU_CMDFLOW_DATA Db2 table

    Figure 8: CIU_CMDFLOW_INDEX Db2 table

 

Client Side 

Users can delete the CICS IA command flow data from the Db2 tables using the "Delete associated data" menu available in the User Command Flow tree. 

To delete data using the CICS IA plug-in, follow these steps: 

  1. In the IA Navigation window, navigate to the User Command Flow tree.
  2. Right-click the command flow ID for which you want to delete data.
  3. Click Delete associated data to remove the relevant records.
    A screenshot of a computer AI-generated content may be incorrect. Figure 9: IA Navigation view 
  4. The confirmation pop-up appears.
    A screenshot of a computer error Description automatically generated Figure 10: Confirmation pop-up

  5. Click Yes to proceed further with the deletion of data.
  6. An information dialog will appear, summarizing the data removed from different tables, as shown below.
    A screenshot of a computer Description automatically generated    Figure 11: Information pop-up 

 

0 comments
38 views

Permalink

https://community.ibm.com/community/user/blogs/aman-sahni/2025/02/21/deleting-command-flow-data-from-db2-tables-using-c