Getting -904 error in Create DB2 objects step (SSID0001) during R20 upgrade
Article ID: 186649
RC Compare for DB2 for z/OSDatabase Management for DB2 for z/OS - Administration SuiteEndevor Interface for DB2 for z/OSEndevor Interface for Remote Db2 for z/OSRC/Extract for DB2 for z/OSRC/Migrator for DB2 for z/OSRC/Merger for DB2 for z/OSRC/Query for DB2 for z/OSRC/Secure for DB2 for z/OSRC/Update for DB2 for z/OS
Upgrading the CA Database Management Solution tool from R19 to R20. While running Create Required DB2 Objects step
Job fails with BPA0037E: LOG SYSTEM D2T1 FAILED ON SQL ERROR: -0904.
Release : 20.0
Component : General Services for DB2
There was an outstanding utility that was holding PTITSBP2 database which has caused -904 sql error
There was an outstanding utility that was holding PTITSBP2 database which had caused -904 sql error. Cleared the utility and could the run the job. There is no issue with CA tool.