DB13001E - UNEXPECTED RETURN CODE 89 (151) INSUFFICIENT MEMORY in DBUTILITY or DQBATCH

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB

Issue/Introduction

Executing Dataquery in batch with DQBATCH or running DBUTLTY gets error:

DB13001E - UNEXPECTED RETURN CODE 89 (151) INSUFFICIENT MEMORY 

Increasing the region size in the batch  JCL does not resolve the problem.

 

Resolution

The problem is with the  size of the Datacom MUF region not in  the batch job. 

You can try specifying a bigger region for the MUF. If you currently have REGION=0M try specifying a region larger than 32M say 64M to increase the size of memory allocated above the line. Also check with your systems programmers that there is no upper site limit on the region size. 

A MUF restart is required to implement the new REGION  size.

Check for any PTFs which deal with memory problems  in the MUF.

If using Datacom Server which uses SQL it is possible if you are running a lot of large SQL queries at the same time this could cause all memory to be used up. 

In the Datacom Server startup parameters add the following to release SQL memory: 

SQLMEM=FREE