How to return more than the default 100 row scroll limit within Sysview for Db2 requests
search cancel

How to return more than the default 100 row scroll limit within Sysview for Db2 requests

book

Article ID: 53553

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

On the Sysview for Db2 for z/OS (IDB2) thread history selection screen the specified selection criteria is only returning 100 rows of thread information before the 'scroll limit reached' message is issued.
There are many more threads to view. What is necessary to view the complete result set?

Resolution

By setting the HIST-DISPLAY-COUNT=1000 in the IDDCPRMS being used by the Data Collector (DC), and then cycling the DC,
you will be able to view the amount stated in the HIST-DISPLAY-COUNT parameter.