IDMS: DC027002 in IDMSHLDB at or near offset x'8DC4'

Products

• IDMS

Issue/Introduction

A task which uses SQL and invokes a table procedure or any other SQL-invoked external routine abends due to a program check in IDMSHLDB.

A message similar to this will be seen on the dc-log (OLP):

IDMS DC027002 V98 T178 SYSTEM MODULE PROGRAM CHECKED NEAR IDMSHLDB AT OFFSET 8DC4

Environment

Release : All supported releases.
Component : CA IDMS/DB

Cause

The user program implementing the table procedure is issuing a FINISH TASK.

Resolution

The only TASK-level DML verb allowed in an SQL-invoked external routine is COMMIT TASK.
Any others (e.g. FINISH TASK, COMMIT TASK ALL) will cause the session or transaction to end and the LTERM will be lost.
This causes the program check in IDMSHLDB.

Suggested action is to use a normal FINISH for the network database rununit and a COMMIT TASK for freeing of scratch and queue related locks.

Additional Information

COMMIT in the DML Reference manual.
FINISH in the DML Reference manual.