search cancel

IDMS: SQL statement gets DB001031 with 0371

book

Article ID: 189442

calendar_today

Updated On:

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.

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.

Environment

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

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).