CA IDMS CONVERT CATALOG DB002005 Undefined Table:SYSTEM.COLUMN  

book

Article ID: 198073

calendar_today

Updated On:

Products

CA IDMS CA IDMS - Database CA IDMS - ADS

Issue/Introduction

Performing a CA IDMS uprade and running CONVERT CATALOG fails with error message:

Status = -4       SQLSTATE = 42500        Messages follow:  
DB002005 T21 C-4M6038: Undefined Table:SYSTEM.COLUMN

 

Environment

Release : 19.0

Component : CA IDMS/DB

Resolution

The DB002005 error indicates that the CONVERT CATALOG is being run against a system where the SQL option is not installed. To verify this, issue the following in OCF:

CONNECT TO SYSTEM;
DISPLAY SEGMENT CATSYS;

If the segment is defined FOR NONSQL then the SQL option is not installed so the CONVERT CATALOG is not required.

 

Additional Information

See article 59066 - When is the CONVERT CATALOG utility required?

See documentation section CONVERT CATALOG