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.

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.