Time out of RC / Update plan RCUUPL20
search cancel

Time out of RC / Update plan RCUUPL20

book

Article ID: 144540

calendar_today

Updated On:

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


It was noticed that one of the users using the “ RC Update “ in Browse mode, 
to browse a table  was holding a lock that caused customer transactions to timeout
The plan is RCUUPL20     
The question is, this plan is bound with Isolcation CS, can it be changed to Isolation UR ?
Or is there any other solution to avoid this timeout ?


Environment

Release : 20.0

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

Resolution

Go into

EP Edit Parmlib Members

Then
RCEDIT RC/Update

there is an option in there
RC/Browse isolation level........> UR (CS or UR)