How to convert the SYSTEM catalog from network to SQL

Products

• IDMS
• IDMS - Database

Issue/Introduction

In a non-SQL IDMS CV, the SYSTEM dictionary has a catalog segment but it is defined differently than if it were a true SQL catalog.

This document describes how to change it from network to SQL defined.

It assumes that the entity names are unchanged from what is provided at installation, i.e. the segment name is CATSYS and the dbname is SYSTEM.

 

Environment

Release : All supported releases

Component : CA IDMS/DB

Resolution

The CATSYS segment has to be DROPped and re-CREATEd with different attributes.

This process will also sever the link between CATSYS and any DMCLs it was previously connected to, so they must be re-established. Typically this will only be the CV's global DMCL.

It is a good idea to backup the segment before performing this change.

Specific instructions:

Go into OCF and run the following:

CONNECT TO SYSTEM;

DISPLAY SEGMENT CATSYS AS SYNTAX;

Make the following changes to the work file with which OCF responds:

Change the DISPLAY SEGMENT CATSYS AS SYNTAX; in the first line to DROP SEGMENT CATSYS;.

In the segment definition, change FOR NONSQL to FOR SQL.

Add STAMP BY AREA to physical areas CATSYS.DDLCAT and CATSYS.DDLCATLOD.

Add STAMP BY TABLE to physical area CATSYS.DDLCATX.

Hit ENTER to carry out the DROP and re-CREATE of the CATSYS segment.

Add CATSYS back to any DMCLs it was in with this source:

ALTER DMCL dmclname INCLUDE SEGMENT CATSYS;

Run the standard batch job to generate, punch and link the DMCL(s) affected by this change.

Run standard IDMSBCF batch jobs against SYSTEM to add the contents of TABLEDDL and VIEWDDL from the .CAGJSRC install library.

Additional Information

Dictionaries and Runtime Environments: https://docops.ca.com/ca-idms/19/en/administrating/administrating-ca-idms-database/dictionaries-and-runtime-environments