How to verify the integrity of an Application Dictionary?

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

Question: 

How do I set up jobs to IDMSDBAN against my DDLDML and DDLDCLOD Areas for my Applications?  Specifically what subschema and dbname should I use to verify the integrity of an application dictonary?

Envinronment:

z/OS

Answer:

The DBNAME should be your application dictionary name. The Subschema should be IDMSNWKU because it contains all the areas of a dictionary DDLDML, DDLDCLOD, DDLDCMSG, DDLCAT and DDLCATX .

For example: 

======================================== 

======================================== 
//DBN1 EXEC PGM=IDMSDBN1,REGION=1024K
<< ... jcl ... >> 
//SYSIDMS DD * 
DMCL=DMCL1900 
DICTNAME=SYSTEM
/* 
//SYSIPT DD * 
PROCESS SUBSCHEMA IDMSNWKU DBNAME APPLDICT UNLOCKED AREA DDLDML AREA DDLDCLOD SETS ALL /* //DBN2 EXEC PGM=IDMSDBN2,REGION=4096K,TIME=1440 << ... jcl ... >>  //SYSIDMS DD * DMCL=DMCL1900 DICTNAME=SYSTEM
======================================== 

Please Note:
IDMSNWKU is the SS to use when running against DDLDML, DDLDCMSG and DDLDCLOD
IDMSCATZ is the SS to use when running against DDLCAT and DDLCATX.
IDMSCATL is the SS to use when running against DDLCATLOD. 

Additional Information:
CA IDMS Utilities, IDMSDBAN
https://docops.ca.com/ca-idms-ref/19/en/utilities/utility-programs-1/idmsdban