DB347030 accessing a new dictionary that has a different page group
search cancel

DB347030 accessing a new dictionary that has a different page group

book

Article ID: 14535

calendar_today

Updated On:

Products

IDMS IDMS - Database

Issue/Introduction

A new segment was created for a new dictionary (DDLDML and DDLDCLOD) in a non-zero PAGE GROUP. A new DBNAME was defined that includes the new segment and SYSMSG. Any use of subschema IDMSNWKA, such as in the IDD compilers, causes DB347030 error.

DB347030 Vnn Tnnnn non unique page groups binding IDMSNWKA subschema

Environment

Release: All supported releases.

Resolution

Dictionaries cannot utilize Mixed Page Groups.

Subschema IDMSNWKA, used by the IDD compilers contains three areas: DDLDML, DDLDCLOD and DDLDCMSG.

The dictionary DBNAME set must have all three areas in the same page group.

If it is necessary to define a new dictionary which cannot be defined in PAGE GROUP 0, do the following unorthodox definition method to allow IDMSNWKA access to the new dictionary which shares the SYSMSG.DDLDCMSG area.  

To share the DDLDCMSG area under different page groups:

For this example, say that the new dictionary segment (areas DDLDML and DDLDCLOD) is defined in page group 10:

  • Either create a new segment or include the DDLDCMSG area in the same segment as the page group 10 DDLDML and DDLDCLOD areas.
  • The page range for this DDLDCMSG must be the same as the SYSMSG area.
  • In the FILE definition, the ASSIGN TO name for the file must be UNIQUE.
  • Do not code a DSNAME for the file.
  • When including the segment into the DMCL, be certain to code an override for the DDLDCMSG area ON STARTUP SET STATUS TO RETRIEVAL.
  • Add a ddname to startup using the unique ASSIGN TO name from file definition mentioned above but point to the same dataset as SYSMSG.DDLDCMSG.
  • If a separate segment was created for this area, include that segment in the DBNAME that describes the PAGE GROUP 10 dictionary.

Additional Information