DB2v10.1 for zOS. Strange behavior tablespace with parms "MEMBER CLUSTER"

Larry Jardine

DB2v10.1 for zOS. Strange behavior tablespace with parms "MEMBER CLUSTER"
I think your table was in RW,AREO* (advisory reorg pending). But the table is available.

The error (REASON 00E30100) is unrelated and coincidental. Perhaps you have a failing member of the datasharing group?

You can resolve the RW,AREO* by running a reorg.
Larry Jardine
Aetna

From: Oleg Dayneko [mailto:[login to unmask email]
Sent: Thursday, May 10, 2018 10:05 AM
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - DB2v10.1 for zOS. Strange behavior tablespace with params "MEMBER CLUSTER"

**** External Email - Use Caution ****

Hi!

Today the programmer send me sql-scripts, that add 1 columns.

ALTER TABLE XXXX.MYTABLE1 ADD COLUMN mycolumn1 INTEGER;

I apply this script.

After this table space shows as RW,AREO.

DDL tablespace:

CREATE TABLESPACE "TSXXX"
IN DBXXX
USING STOGROUP SGIS23DW
PRIQTY 500000 SECQTY 50000 ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
COMPRESS NO
DEFINE YES
LOGGED
MEMBER CLUSTER
BUFFERPOOL BP22
CCSID ASCII
CLOSE NO
LOCKMAX SYSTEM
LOCKSIZE ANY
MAXROWS 255;



All SQL query that worked with this table get error:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00E30100, TYPE OF RESOURCE 00000906, AND
RESOURCE NAME

I try to restore this table space usage DB2 utility: RECOVER TABLESPACE. The tablespace resored. JCL ended with rc=0. But tablespace remain unavailable for all SQL-s.

I recreate TS exclude param(DB2 work not in cluster environment): MEMBER CLUSTER

and load date from other db2 subsystem. I don't understand: Why TS is crashed after add 1 column and why RECOVER TABLESPACE really don't restored tablespace?

SYSPRINT for restore tablespace:

ARC1801I FAST REPLICATION DATA SET RECOVERY IS 309
ARC1801I (CONT.) STARTING FOR DATA SET
ARC1801I (CONT.) IBDP.DSNDBC.IS23DW.DWM#DOC.I0001.A001, AT 14:22:30 ON
ARC1801I (CONT.) 2018/05/10
ARC1861I THE FOLLOWING 0001 DATA SET(S) WERE 313
ARC1861I (CONT.) SUCCESSFULLY PROCESSED DURING FAST REPLICATION DATA
ARC1861I (CONT.) SET RECOVERY:
ARC1861I (CONT.) IBDP.DSNDBC.IS23DW.DWM#DOC.I0001.A001, COPYPOOL=DSN$IBD
P$DB, DEVTYPE=DASD
ARC1802I FAST REPLICATION DATA SET RECOVERY HAS 315
ARC1802I (CONT.) COMPLETED FOR DATA SET
ARC1802I (CONT.) IBDP.DSNDBC.IS23DW.DWM#DOC.I0001.A001, AT 14:23:02 ON
ARC1802I (CONT.) 2018/05/10, FUNCTION RC=0000, MAXIMUM DATA SET RC=0000
ARC1801I FAST REPLICATION DATA SET RECOVERY IS 316
ARC1801I (CONT.) STARTING FOR DATA SET
ARC1801I (CONT.) IBDP.DSNDBC.IS23DW.DWM#DOC.I0001.A002, AT 14:23:02 ON
ARC1801I (CONT.) 2018/05/10
ARC1860I THE FOLLOWING 0001 DATA SET(S) FAILED DURING 317
ARC1860I (CONT.) FAST REPLICATION DATA SET RECOVERY:
ARC1860I (CONT.) IBDP.DSNDBC.IS23DW.DWM#DOC.I0001.A002, COPYPOOL=DSN$IBDP$DB, DEVTYPE=DASD, VOLUME=******, ARC1866, RC=06
ARC1802I FAST REPLICATION DATA SET RECOVERY HAS 319
ARC1802I (CONT.) COMPLETED FOR DATA SET
ARC1802I (CONT.) IBDP.DSNDBC.IS23DW.DWM#DOC.I0001.A002, AT 14:23:02 ON
ARC1802I (CONT.) 2018/05/10, FUNCTION RC=0008, MAXIMUM DATA SET RC=0066

...

-----End Original Message-----

This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna