IIR installation job IIRINS2 fails with verify errors DDRTVC0043 and DDRTVC0044.

Products

• CA Distributed Database Management
• CA Database Analyzer for DB2 for Oracle

Issue/Introduction

Installing the IMS Information Repository (IIR) on release r19, the IIRINS2 job is failing with verify errors.

*** VERIFY ERROR MESSAGES *** 
DDRTVC0043 NEW FILE HAS BEEN ADDED 
OCCURRENCE = ITKREPDB-DBA_BASIC 
DDRTVC0044 NEW RECORD HAS BEEN ADDED 
OCCURRENCE = ITKREPDB-DBA_BASIC 
DDRTVC0043 NEW FILE HAS BEEN ADDED 
OCCURRENCE = ITKREPDB-DBA_DEDB 
DDRTVC0044 NEW RECORD HAS BEEN ADDED 
OCCURRENCE = ITKREPDB-DBA_DEDB 
DDRTVC0043 NEW FILE HAS BEEN ADDED 
OCCURRENCE = ITKREPDB-DBA_HDAM 
DDRTVC0044 NEW RECORD HAS BEEN ADDED 
OCCURRENCE = ITKREPDB-DBA_HDAM

The first install job, IIRINS1, completed successfully.

Environment

Release r19 with PTFs RO91387 and RO93340 applied.

Cause

If IIR was previously installed before applying PTFs RO91387 and RO93340 then the IIR must be migrated to create the new IIR structure introduced with these PTFs.

Otherwise a mismatch will occur between the IIR BTG definitions and the ITKREPDB module version.

Resolution

The correct procedure to follow when these PTFs are applied into an environment where IIR has already been installed is to execute the following sample jobs to migrate the IIR to its new structure:

• IIRMIG1 - Backup the existing data and reformat it for later use.
• IIRDEPR - Drop the existing database schema and underlying data.
• IIRINS1, IIRINS2, IIRINS3 - Redefine the IIR schema with the new changes
• IIRMIG2 - Reload the data created by IIRMIG1

As IIRINS2 has already been executed and failed, then IIRMIG1 can now no longer be run as it will fail.

If the existing IIR data is not required then the above migration process can be achieved by starting with IIRDEPR, then IIRINS1, IIRINS2 and IIRINS3, omitting IIRMIG1 and IIRMIG2.

This should enable you to complete the IIR installation. 
 

Additional Information

For further details on the installation and migration of IIR please refer to the migration processes documented in the wiki: 

Migrate IIR for PTFs or From a Previous Version

Please refer to the flow diagram illustrating the IIR upgrade and migration process in full.

Note, migration job IIRMIG1, is not a replacement for Back up the CA Datacom/AD Environment. We strongly recommend that you follow both backup processes.