QI006E for TSALT step -204 storage group undefined

Products

• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The Post Installation Compare task, ssid0000, fails with QI006E in the TSALT step.

QI006E - UNABLE TO CHECK EXTENDED ADDRESSABILITY FOR PTDB OBJECTS

SQLCODE = -204,ERROR: storage-group-name IS AN UNDEFINED NAME

Cause

The TSALT step in the ssid0000 Compare job, performs a verify test to check the availability of Extended Addressability (EA) for the PTDB objects. It does this by executing the following SQL:

CREATE TABLESPACE PTIEADM#
IN PTDB 
MAXPARTITIONS 1
DSSIZE 64G    
SEGSIZE 4      
DEFINE YES;
ROLLBACK;

This SQL will try to create the Tablespace in the PTDB database and Db2 uses the default Storage Group defined to the Database.

This fails with the -204 SQL error if that Storage Group does not exist.

Resolution

Use an ALTER to alter the default storage group in the PTDB database to match the storage group name defined in the STOGROUP parameter in the SETUP00 Parmlib member.

For example:

ALTER DATABASE PTDB STOGROUP PTSG;

The Db2 SQL Reference Guide confirms that this alter does not impact table spaces and indexes that already exist within the database.

Once you have successfully altered the database storage group, then you can rerun the ssid0000 compare job.