DT913W not all rows displayed due to lack of storage
search cancel

DT913W not all rows displayed due to lack of storage

book

Article ID: 8655

calendar_today

Updated On:

Products

Detector for DB2 for z/OS

Issue/Introduction

When viewing Detector for Db2 for z/OS (PDT) 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?

Resolution

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.