SQL query abends with DB001031 DB error 0308

book

Article ID: 124983

calendar_today

Updated On:

Products

CA IDMS CA IDMS - Database CA IDMS - ADS

Issue/Introduction

An SQL query may abend with a database error-status of 0308 error if the access path chosen involves keyed index or calc retrieval and a warning, such as string truncation, is issued while processing the key.
This abend may occur after the apar associated with IDMS/5398 - RO98682 (18.5) or RO98684 (19.0) is applied.       

Cause

Internal error.

Environment

CA IDMS, r18.5 or r19.0.

Resolution

This is a bug currently resolved by test APAR ST06884 (r18.5) or ST06860 (r19.0).
If either of these APARs are required prior to them being published, please open a support issue.

Additional Information

RO98682
RO98684