Sample program to delete IDMS queue records

Products

• IDMS

Issue/Introduction

Deleting a QUEUE with a very large amount of records can be problematic.

DCMT VARY QUEUE xxx DELETE will attempt to delete every record in the queue, but will do so without any ability to COMMIT and so may cause excessive locking resulting in DC040107 messages and potential short-on-storage conditions.

DMLO, as it does with normal database commands, offers the functionality to interactively execute any valid scratch or queue command, so it can be used to delete queue records one at a time. However, it would not be practical to delete a queue with thousands of records in that manner.

Environment

Releases: All supported releases.

Resolution

The attached file contains the source and JCL of a sample generic DC BATCH program which can be used to delete all the records of a queue one at a time. It uses COMMITs to restrict locking and is restartable.