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.
CA DB2 tools Post Install job ssid0001 receiving error SQL-904 00D70025
Article ID: 104966
RC Compare for DB2 for z/OSDatabase Analyzer for DB2 for z/OSFast Unload for DB2 for z/OSFast Check for DB2 for z/OSFast Index for DB2 for z/OSFast Load for DB2 for z/OSRapid Reorg for DB2 for z/OS
CA DB2 tools Post Install job, ssid0001, is failing with a RC 16 and messages:
BPA0080I: BATCH PROCESSOR EXECUTION BPA0037E: LOG SYSTEM ssid FAILED ON SQL ERROR: -0904. BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED. RETCODE = 16
Also see the following in the ssidMSTR joblog:
DSNP009I =ssid THE FOLLOWING ERROR MESSAGES WERE RECEIVED FOR DEFINE CLUSTER ON vcat.DSNDBC.dbname.tsname.I0001.A001 IDC3186I INVALID VOLUME SERIAL SPECIFIED IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12
DSNP016I =ssid DSNPCPS0 - CREATE FAILED FOR dbname.tsname.I0001. RC=00D70025
Release: Component: INS
IDC3186I INVALID VOLUME SERIAL SPECIFIED
Explanation: An attempt was made to define a non-SMS-managed data set with a volume serial of '*'. A volume serial of '*' is only permitted for SMS-managed data sets.
User response: Correct the volume serial and run the job again.
Depending on site requirements the volume in the stogroup may need to be altered to specify a specific volume.