CA DB2 tools Post Install job ssid0001 receiving error SQL-904 00D70025
search cancel

CA DB2 tools Post Install job ssid0001 receiving error SQL-904 00D70025

book

Article ID: 104966

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

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

Environment

Release:
Component: INS

Resolution

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.