Ian_Hill

CA Tuesday Tip: (CA IDMS) Finding all Symbolics in a DMCL

Discussion created by Ian_Hill Employee on Mar 5, 2013
CA IDMS Tuesday Tip by Yves Anthoons, Principal Support Engineer for March 5, 2013.

Within a non-SQL SCHEMA, you can define SUBAREA, SYMBOLIC DISPLACEMENTS and SYMBOLIC INDEX symbolics.
- a SUBAREA symbolic : represents a sub (page) range of an area.
- a SYMBOLIC DISPLACEMENT symbolic : represents the displacement of member records that participate in a VIA set from the owner record of the set.
- a SYMBOLIC INDEX symbolic : represents index characteristics.

At runtime, all of these symbolics must be 'resolved' through the runtime DMCL in order to allow IDMSDBMS to find the physical attributes involved. If one is not found, your program/utility will abend with a 1493 error-status.

Question : How to find out what symbolics are defined in a DMCL ?
Answer : Use the LOOK command (or IDMSLOOK batch utility) with parameter DMCL ALL
Note : the ‘ALL’ subparameter is required !

Example (Extract from its output) :

CRDNSEG.CINDX-REGION 0 1,710,001 1,710,600 18,452 CRNDINDX
NETWORK area
On STARTUP go Update On WARMSTART use current status
Definition date last critical change=2012-10-12 06.17.57
Page Reserve size 0 Space Management Page Interval 9,210
Page Range Symbolic is CINDX-REGION Value is 1,710,001--->1,710,600
Page Range Symbolic is IX-CL-NATION-SUB Value is 1,710,001--->1,710,300
Page Range Symbolic is IX-RELATION-CL-SUB Value is 1,710,301--->1,710,600
Block Contains Symbolic is IDX-SET1-BLOC 125 keys
40 SR8 displacement pages

Outcomes