DB001042 TABLE:LOADTEXT-157, AREA:DDLCATLOD SPACE EXHAUSTED when creating new DMCL

Products

• IDMS
• IDMS - Database

Issue/Introduction

When trying to modify and generate a new DMCL, the following message is issued:

DB001042 T929 C-4M6001: TABLE:LOADTEXT-157, AREA:DDLCATLOD SPACE EXHAUSTED

Can CATSYS.DDLCATLOD page range be expanded using the UNLOAD and RELOAD utilities? 

Running the CLOD task to delete logically deleted records in the DDLCATLOD area will allow the DMCL that originally failed to be generated, but a longer-term solution is desired, so CATSYS.DDLCATLOD must be enlarged.

 

Environment

Release: All supported releases.

Resolution

Yes. CATSYS.DDLCATLOD can be expanded using UNLOAD and RELOAD utilities just as any other database area can. Use subschema IDMSCATL.

However, in many cases an UNLOAD/RELOAD is not necessary for the SYSTEM CATALOG load area CATSYS.DDLCATLOD in order to expand the page range.

If the SYSTEM CATALOG is being used only for physical database definitions as recommended, then the only load modules in DDLCATLOD will be ones generated from the DMCL and DBTABLE source definitions that have been added to the catalog using OCF or IDMSBCF. The source definitions reside in areas CATSYS.DDLCAT and CATSYS.DDLCATX.

In most cases, clients will have very few DMCL and DBTABLE definitions. Rather than going through the process of unloading and reloading all of the records that make up these load modules in CATSYS.DDLCATLOD, an easier and faster method of increasing the page range would be as follows:

1. Increase the page range in the area definition for CATSYS.DDLCATLOD to the desired size.
   
   
2. Generate, punch and link the DMCL that contains the new page range for area CATSYS.DDLCATLOD.
   
   
3. Allocate the new larger file for the area.
   
   
4. FORMAT the new file using the updated DMCL (since this is a new larger area/file it must be formatted by FILE and since it is an SQL area, an INSTALL STAMPS must also be run before using it). 
   
   
5. Rename files such that the new larger file will be accessed by the CV (if not using dynamic file allocation, be sure the new file is defined by a DD in the CV startup JCL)
   
   
6. Bring CV up with the updated DMCL.
   
   
7. In OCF or IDMSBCF, GENERATE each DMCL and DBTABLE for which there are source definitions, thus recreating the DMCL and DBTABLE load modules in CATSYS.DDLCATLOD.

NOTE: If the SYSTEM catalog is being used for application SCHEMA and TABLE definitions and create ACCESS MODULES this method may not be practical as there may be many more load modules that will need to be recreated.

Typically, clients will have a separate application catalog such as SYSSQL for application Schemas, Tables and Access Modules. The SYSTEM Catalog CATSYS is typically used only to contain the physical database definitions that are used to create DMCLs and DBTABLEs.

Additional Information

Reporting on the contents of IDMS catalog load area