ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 212720

calendar_today

Updated On:

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

Cause

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

Environment

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

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.