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

book

Article ID: 104966

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

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.