search cancel

DT913W NOT ALL ROWS DISPLAYED

book

Article ID: 8655

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

When viewing Detector Dynamic SQL display message DT913W NOT ALL ROWS DISPLAYED is displayed, indicating a shortage of storage with partial result. What is the cause and how to resolve it?

Environment

Release:
Component: PDT

Resolution

The lack of storage is in the TSO address space of the user and not the Xmanager address space. Increasing the User TSO Region Size parm when logging into TSO should resolve this problem.