IDMS: SQL statement gets DB001031 with 0371

Products

• IDMS
• IDMS - Database

Issue/Introduction

An IDMS SQL statement is failing with DB001031 and an error-status of 0371.
Errors may also indicate the the problem record/table is S-010 and the problem area is DDLDML.

Environment

Release : All supported releases.
Component : CA IDMS SQL Option

Cause

The most likely cause of this error is that this is SQL being issued against a network-defined database, and the SQL engine is unable to access the required network schema.

Resolution

IDMS cannot access the network schema.
Check for the following:

1. Does the network schema exist?
2. Check that it has been VALIDATEd.
3. Make sure the DBNAME in use includes the required dictionary segment (the one containing the network schema).