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

Products

• Dispatch Output Mgmt

Issue/Introduction

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

Resolution

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

• To display 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 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 IDMS/DB SYSGEN, press the cursor home key and type END {enter}.

 

• To display 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 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 Dispatch. The following sample reports can be found in your 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.