PUT0309E SYSTABLEPART update failed SQLCODE -551 during PRA#LOAD execution.
search cancel

PUT0309E SYSTABLEPART update failed SQLCODE -551 during PRA#LOAD execution.

book

Article ID: 261523

calendar_today

Updated On:

Products

Fast Load for DB2 for z/OS Recovery Analyzer for DB2 for z/OS

Issue/Introduction

Activated Recovery Analyzer for Db2 for z/OS (PRA) and receiving the following error during the Fast Load for Db2 for z/OS (PFL) execution within the PRA#LOAD job:

PUT0309E - SYSTABLEPART update failed with SQLCODE: -551

Resolution

PFL is updating SYSIBM.SYSTABLEPART columns EPOCH and REORG_LR_TS from package UTA$UCV via Dynamic SQL. 

Package UTA$UCV utilizes the DYNAMICRULES ( BIND    ) option which utilizes the bind OWNER authorization to process the Dynamic SQL UPDATE statements.

Verify that package UTA$UCV is utilizing DYNAMICRULES(BIND) in the Db2 environment and the bind owner has the required authorization to UPDATE SYSIBM.SYSTABLEPART.