ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 53553


Updated On:


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 Fast Load for DB2 for z/OS Rapid Reorg for DB2 for z/OS



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?


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.


Component: CIDB