IDMS: How to re-create VIEWDDL

Products

• IDMS
• IDMS - Database

Issue/Introduction

Re-creating the VIEWDDL definitions for a CA-IDMS SQL catalog can be a sensitive operation, particularly if CA IDMS Visual/DBA is installed.
This is due to the fact that the some of the database entities created for Visual/DBA are created in schema SYSCA, which VIEWDDL creates.
In order to re-run VIEWDDL, you would have to first DROP SCHEMA SYSCA; which means you also need to include the Visual/DBA database entities in the DROP/CREATE operation.

Environment

Release : 19.0

Component : CA IDMS/DB SQL Option

Resolution

Use the following as input to an IDMSBCF batch job:

//SYSIPT   DD *
SET OPTIONS AUTOCOMMIT COMMAND;
CONNECT TO APPLDICT;                                       <== change to appropriate dictionary name
//         DD DISP=SHR,DSN=your.idms.srclib(VDB5UN18)      <== uploaded from vdb5un18.sql in Visual/DBA
//         DD *
DROP SCHEMA SYSCA CASCADE;
DROP SCHEMA SYSDICT;
//         DD DISP=SHR,DSN=your.idms.CAGJSRC(VIEWDDL) 
//         DD DISP=SHR,DSN=your.idms.srclib(VDB5V18X)      <== uploaded from vdb5v18x.sql in Visual/DBA

Additional Information

Defining New Catalog Components
Installing CA IDMS Visual DBA