How to return more than the default 100 row scroll limit?

book

Article ID: 53553

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS 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 Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

On the 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?

Solution:

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.

Environment

Release:
Component: CIDB