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

Oleg Dayneko

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

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

...

Any help would be appreciated!

Edited By:
Oleg Dayneko[Organization Members] @ May 10, 2018 - 05:11 PM (GMT+3)

Phil Grainger

DB2v10.1 for zOS. Strange behavior tablespace with params "MEMBER CLUSTER"
(in response to Oleg Dayneko)
Is this data sharing or non data sharing?

00E30100 says

A parallel task running on a DB2® terminates abnormally.
An assisting DB2 terminates abnormally.

Are all your Db2s running OK and where they should be?

From the message manual “Enter DISPLAY GROUP from an active DB2 to see if a DB2 subsystem is down. Restart the failed DB2 subsystem.”

________________________________

Phil Grainger

Enablement Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[cid:[login to unmask email]






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


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-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (8k)
  • image002.png (5.9k)