KO2O1965I Number of threads displayed truncated, LROWS limit value of nnnn exceeded (source)
Explanation
The number of threads running in Db2 is larger than the LROWs value (nnnn) used. source is the source module returning this message.
System action
The number of Db2 threads is truncated by the collector to adhere to the requested LROWs limit and to avoid long response times. The threads being displayed are in random order as received by the Db2 IFI READS call that is issued by the OMEGAMON® Collector PE Server subtask.
User response
Use appropriate filtering to limit the data in the thread summary displays. For example, by specifying a specific plan name (PLAN) or authorization ID (AUTHID) in panel ZFILT, the thread data is filtered in Db2 and only the qualifying threads are shown.
You can retain filter specifications in a user profile, or use an existing profile at logon time by using the "data(user=xx)" logon option, where xx is the profile name. For example, the command logon applid(ipomd2c) data(user=MT,LROWS=500) opens a session that shows up to 500 threads (LROWS=500) and use the user profile "MT" (user=MT). For more information, see the ZFILT panel help.