Getting -904 error in Create DB2 objects step (SSID0001) during R20 upgrade or initial install
search cancel

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

book

Article ID: 186649

calendar_today

Updated On: 04-07-2025

Products

RC Compare for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

Upgrading or initially installing the Database Management for DB2 for Z/OS toolset to R20.
While running Create Required DB2 Objects step

Job fails with
BPA0037E: LOG SYSTEM ssid FAILED ON SQL ERROR: -0904.

 

Environment

Release : 20.0

Component : General Services for DB2

Cause

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

Another possible cause during initial install: This same -904 error can be seen if there is a lack of available storage to create the log system objects during the Post Install jobs. 

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.

Additionally, if lack of storage to create log system objects, check messages found in DB2MSTR log to find the error messages, obtain additional storage and redo the Post Install.