It's DB2 zOS V12. topic - you should look via SDSF in the MSTR STC / adressspace for more information.
It could be a space problem - we have SMS managed objects - and sometimes the Space Admin must add new volumes to the STOGROUP
------------------------------
Jürgen Jost
DB2 DBA (LUW / zOS)
------------------------------
Original Message:
Sent: Thu June 27, 2024 01:17 PM
From: Anand Seth
Subject: CATMAINT -904 on upgrade to Db2 12
Darius,
Looks like you are running DSNTIJTC under your own ID, which is not INSTALL SYSADM. DSNTIJTC and CATMAINT jobs should be run using the INSTALL SYSADM ID. And STOGROUP "00000001" is used by Db2 for system managed (Db2 managed) objects. Hope this helps.
Anand
------------------------------
Anand Seth
Original Message:
Sent: Wed June 26, 2024 09:44 AM
From: Darius Panahy
Subject: CATMAINT -904 on upgrade to Db2 12
I am trying to run DSNTIJTC to upgrade the catalog and get this error. I am assuming that the problem is in creating the VSAM file for the index, but not sure why it is failing. The use of USING STOGROUP "00000001" seems strange since this is not a valid stogroup. Does anyone have any ideas of what is going wrong?
Thanks...
DSNU778I -DSN1 178 13:24:55.31 DSNUEXDL - ERROR PROCESSING SQL STATEMENT -
SQL CODE IS: -904
SQLERRP: DSNXICX2
SQLERRD: 00000082 00000000 00000000 FFFFFFFF 00000000 00000000
SQL MESSAGE TEXT: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE
RESOURCE 00000220, AND RESOURCE NAME DSNIET.DSNDBC.DSNDB06.DSNDCX06.I0001.A001
SQL STATEMENT:
CREATE INDEX SYSIBM.DSNDCX06 ON SYSIBM.SYSCOLUMNS (TBCREATOR, TBNAME,
COLNO) USING STOGROUP "00000001" FREEPAGE 0 PCTFREE 10 BUFFERPOOL BP0
NOT PADDED CLOSE NO
DSNU017I 178 13:24:58.47 DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTI
CAUSE=X'21ED6CB4'
------------------------------
Darius Panahy
------------------------------