Executing Dataquery in batch with DQBATCH or running DBUTLTY gets error DB13001E - UNEXPECTED RETURN CODE 89 (151) INSUFFICIENT MEMORY
search cancel

Executing Dataquery in batch with DQBATCH or running DBUTLTY gets error DB13001E - UNEXPECTED RETURN CODE 89 (151) INSUFFICIENT MEMORY

book

Article ID: 45887

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC Easytrieve Report Generator for Common Services INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction

Problem: 

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

Environment

Release: DATABB00200-14-Datacom/AD
Component: