High CPU usage when browsing tables in RC/Query

Products

• 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

Issue/Introduction

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.

 

 

 

 

Environment

Release : 20.0

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

Resolution

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.