Helpful CA-IDMS/DB Database commands available for use in CA Dispatch for displaying database information.

Document ID : KB000028216
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

CA-Dispatch utilizes a CA-IDMS/DB Database to store user and report information vital to system processing and report distribution. Customers who are familiar with CA-IDMS/DB are already aware of a variety of display commands that can be used to list CA-Dispatch information from the database. Because these commands are CA-IDMS/DB commands, they are not listed in the CA-Dispatch documentation and may go unnoticed by the average CA-Dispatch administrator.

 

Instructions:

Here are a few display commands that may be useful to know:

    • To display CA-IDMS/DB database parameters defined to the database dictionary for a specific system:

      At the ENTER NEXT TASK CODE prompt type:

      SYSGEN {enter} - Start CA-IDMS/DB SYSGEN session
      DIS SYSTEM 1{enter}- Displays the parameters for SYSTEM 1

      To exit CA-IDMS/DB SYSGEN, press the cursor home key and type END {enter}.




    • To display the ADSO resources:

      At the ENTER NEXT TASK CODE prompt type:

      SYSGEN {enter} - Start CA-IDMS/DB SYSGEN session
      DIS ADS {enter} - Displays the ADSO resources

      To exit CA-IDMS/DB SYSGEN, press the cursor home key and type END {enter}.




    • To display CA-IDMS/DB database profile information and statistics:

      At the ENTER NEXT TASK CODE prompt type:

      DCPROFILE {enter} - This will provide important information regarding the active CA-IDMS/DB Database region, including startup options, SVC and CV numbers, fixes applied and RCE usage, just to name a few.




  • Other display commands worth noting are:

    At the ENTER NEXT TASK CODE prompt type:

    DCMT DISPLAY ACTIVE STORAGE - Displays the high-water marks for storage and page utilization that can be used to monitor the HWM percentage and determine when or if an increase in the storage pool may be required.

    DCMT DISPLAY STAT SYSTEM - Displays system storage utilization statistics, and can be used to determine when or if the RCE, RLE or region values need to be modified.

    For more information on storage and performance related questions, refer to the sections entitled "Performance Problems" and "Region Management" in the CA-Dispatch System Programmers Guide

     

  • Informational reports can be produced through a variety of batch runs that are provided with CA-Dispatch. The following sample reports can be found in your CA-Dispatch CADSOPTN library.

    To produce these reports, customize the sample JCL member DSEXCULP found in your CADSJCL library. To produce a specific report from the list below, modify the 'MEMBER=' symbolic setting to pull in the desired report instructions from the CADSOPTN library samples listed below:

    MEMBER=DSREPT01 - DC System Generation Report Listing

    MEMBER=DSREPT02 - DC Source Report Listing of Lines/Terminals

    MEMBER=DSREPT03 - Data Dictionary Report - User Summary Listing

    MEMBER=DSREPT04 - System Generation Report - Users/System Listing

 

Additional Information:

- For more information on the reports listed above, refer to the chapter entitled "Reporting on Report Production" in the CA-Dispatch Reference Guide.