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.

Getting -904 error in Create DB2 objects step (SSID0001) during R20 upgrade

book

Article ID: 186649

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

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.

 

Cause

There was an outstanding utility that was holding PTITSBP2 database which has caused -904 sql error

Environment

Release : 20.0

Component : General Services for DB2

Resolution

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.