High CPU usage when browsing tables in RC/Query
search cancel

High CPU usage when browsing tables in RC/Query


Article ID: 145499


Updated On:


RC Compare for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Endevor Interface for Db2 for z/OS Endevor Interface for Remote Db2 for z/OS RC/Extract for DB2 for z/OS RC/Migrator for DB2 for z/OS RC/Merger for DB2 for z/OS RC/Query for DB2 for z/OS RC/Secure for DB2 for z/OS RC/Update for DB2 for z/OS


Noticed a very high CPU usage when browsing 'larger' tables in RC/Query.
In Detector it shows that RCUUPLAN and the package RUAEDBF2 are the causer.


Release : 20.0

Component : CA RC/Query for DB2 for z/OS


All the Edit/Browse requests from RC/Query goes to RC/Edit.

Check if the following options are set.

Asynchronous background fetch options
Enable background fetching ==> Y Y or N
Run in CONTINUOUS or PAUSE mode ==> C C - Continuous mode
P - Pause mode

These option can be found under the RC/Edit Profile Variables.
Since it is a large table and with the above option set,
RC/QUERY tries to get all the records in the background this would cause a spike in CPU usage.

Set the PAUSE option to see if this resolves the High CPU.