Why am I encountering the following error running the Post-install 0001 Create Required Objects task on a brand new subsystem: BPA0037E: LOG SYSTEM 'ssid' FAILED ON SQL ERROR: -0904

book

Article ID: 7233

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

The CA DB2 post-install 0001 Create Required Objects task fails with the error: BPA0037E: LOG SYSTEM 'ssid' FAILED ON SQL ERROR: -0904

Cause

In this particular case, the cause of the BPA0037E: LOG SYSTEM 'ssid' FAILED ON SQL ERROR: -0904 error was due to the Batch Processor Log Tablespaces not having underlying VSAM files defined.  This was caused by the SSDEFINE (NO) parameter being set in the SETUPxx parmlib member being referenced.

 

 

 

Environment

Release:
Component: INS

Resolution

Changing the SSDEFINE parameter to SSDEFINE (YES) in the referenced SETUPxx parmlib member, and then dropping the PTDB and regenerating and running the post-install 0000 Compare job allowed the BP Tablespaces to be defined with the underlying VSAM files.  The subsequent 0001 Create Required Objects job ran successfully, and created the CA DB2 Tools' objects.