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.

High CPU usage when browsing tables in RC/Query

book

Article ID: 145499

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Endevor SCM Interface for DB2 for z/OS Endevor SCM 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.