Re-creating VIEWDDL

Products

• IDMS
• IDMS - Database

Issue/Introduction

Re-creating the VIEWDDL definitions for an IDMS SQL catalog can be a sensitive operation, particularly if 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, first DROP SCHEMA SYSCA; which means the Visual/DBA database entities also must be included in the DROP/CREATE operation.

Environment

Release: All supported releases.

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 IDMS Visual DBA