Tablespace Problem

[login to unmask email]

Tablespace Problem
Hi List,

We have a tablespace with 16 partitions and seems like there is some
problem with one of the page.


1) We tried to do a FULLY COPY of that tablespace using BMC. It gave the
following error for one of the dataset .....

=> BMC30562E(17) EXPECTING PAGE X'202A08' FOUND PAGE X'200001'

2)
We tried to do an Unload using DSNTIAUL. It gave the following error.

=> IKJ56641I SYSTEM ABEND CODE 0C6 REASON CODE 00000006 PSW
077C300094EE4D9E ASIDS: HOME = 007D PRIMARY = 01CB SECONDARY = 007D

3)
Then we tried to do REORG using BMC . It also gave the same error

=> BMC50251S 2: PAGE 00002A08 IN 'DSNT.DSNDBD.DDBCK01.SDBCK16.I0001.A003'
IS UNRECOGNIZABLE, DATA = X'10760'

4)
We even tried doing a IBM REORG . It gave the following error.

=> DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION
ABENDED, REASON=X'00C6'


5)

Then we ran DSN1PRNT on that partition using the problem page number and
dataset . The output is as follows:

=>

DSN1998I INPUT DSNAME = DSNT.DSNDBD.DDBCK01.SDBCK16.I0001.A003 , VSAM
DSN1984I UNEXPECTED PAGE NUMBER, EXPECTING: 00202A08
PAGE: # 00200001
--------------------------------------------------------------
*** PAGE IN ERROR - NOT FORMATTABLE ***
0000 00000000 00000000 20000110 00002A08 00002A08 00000000 0000FFFF
FFFFF000
.... LINES ARE ALL ZERO.
0FE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
000000C5
DSN1994I DSN1PRNT COMPLETED SUCCESSFULLY, 00000001 PAGES PROCESSED




Can anyone please suggest how to go about in having that page corrected.


regards,
Srini.


********************************************
This electronic mail message is intended solely for the named recipients
and may contain confidential and proprietary business information of eFunds
Corporation and all its subsidiaries. If you are not a named recipient,
please notify the sender immediately. You may not disclose the contents to
any other person; use this electronic mail message or its contents for any
other purpose; or further store or copy its contents in any medium
********************************************



Leslie Pendlebury-Bowe

Re: Tablespace Problem
(in response to Srinivas.Reddy@IN.EFUNDS.COM)
questions first sorry (kind of questions IBM will ask when you call) :

1. What have you done to the pageset recently like (Utilities inc copy,
reorg, etc - i.e destructive ones)?

2. What is the history to the pageset? i.e created every day or once five
million years ago?

re correcting the pageset ... recovery ... you could do a REPAIR on the PAGE
.. but I would be a little worried unless you 100% know what you are
doing....I tend to do this when I and IBM are happy with the repair
statements.

I suggest you look at the page in recent image copies and find a point at
which you were happy with it .. the issues you will face are :

1. Do you recover to current point in time (RBA or LRSN depending on the
type of DB2 you are running) or to the last full image copy you took ...
things only you as a DBA can decide on ... YOU DO HAVE IMAGE COPIES DON'T
YOU?

2. If DB2 caused it when an update was done .. is the log info going to byte
you when you recover ..

bottom line - Talk to IBM, think hard about what you do before you do it,
then do it .....

best regards

LEslie

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, January 03, 2002 12:12 PM
To: [login to unmask email]
Subject: Tablespace Problem


Hi List,

We have a tablespace with 16 partitions and seems like there is some
problem with one of the page.


1) We tried to do a FULLY COPY of that tablespace using BMC. It gave the
following error for one of the dataset .....

=> BMC30562E(17) EXPECTING PAGE X'202A08' FOUND PAGE X'200001'

2)
We tried to do an Unload using DSNTIAUL. It gave the following error.

=> IKJ56641I SYSTEM ABEND CODE 0C6 REASON CODE 00000006 PSW
077C300094EE4D9E ASIDS: HOME = 007D PRIMARY = 01CB SECONDARY = 007D

3)
Then we tried to do REORG using BMC . It also gave the same error

=> BMC50251S 2: PAGE 00002A08 IN 'DSNT.DSNDBD.DDBCK01.SDBCK16.I0001.A003'
IS UNRECOGNIZABLE, DATA = X'10760'

4)
We even tried doing a IBM REORG . It gave the following error.

=> DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION
ABENDED, REASON=X'00C6'


5)

Then we ran DSN1PRNT on that partition using the problem page number and
dataset . The output is as follows:

=>

DSN1998I INPUT DSNAME = DSNT.DSNDBD.DDBCK01.SDBCK16.I0001.A003 , VSAM
DSN1984I UNEXPECTED PAGE NUMBER, EXPECTING: 00202A08
PAGE: # 00200001
--------------------------------------------------------------
*** PAGE IN ERROR - NOT FORMATTABLE ***
0000 00000000 00000000 20000110 00002A08 00002A08 00000000 0000FFFF
FFFFF000
.... LINES ARE ALL ZERO.
0FE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
000000C5
DSN1994I DSN1PRNT COMPLETED SUCCESSFULLY, 00000001 PAGES PROCESSED




Can anyone please suggest how to go about in having that page corrected.


regards,
Srini.


********************************************
This electronic mail message is intended solely for the named recipients
and may contain confidential and proprietary business information of eFunds
Corporation and all its subsidiaries. If you are not a named recipient,
please notify the sender immediately. You may not disclose the contents to
any other person; use this electronic mail message or its contents for any
other purpose; or further store or copy its contents in any medium
********************************************







**********************************************************************
The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only.

This email and any response may be monitored by Sony UK.
(04)
**********************************************************************



A. J. Zobjeck

Re: Tablespace Problem
(in response to Leslie Pendlebury-Bowe)
I would call BMC. They are very good and can help you with this problem. I
think the number is 1-800-537-1813.

-----Original Message-----
From: Pendlebury-Bowe, Leslie
[mailto:[login to unmask email]
Sent: Thursday, January 03, 2002 7:44 AM
To: [login to unmask email]
Subject: Re: Tablespace Problem


questions first sorry (kind of questions IBM will ask when you call) :

1. What have you done to the pageset recently like (Utilities inc copy,
reorg, etc - i.e destructive ones)?

2. What is the history to the pageset? i.e created every day or once five
million years ago?

re correcting the pageset ... recovery ... you could do a REPAIR on the PAGE
.. but I would be a little worried unless you 100% know what you are
doing....I tend to do this when I and IBM are happy with the repair
statements.

I suggest you look at the page in recent image copies and find a point at
which you were happy with it .. the issues you will face are :

1. Do you recover to current point in time (RBA or LRSN depending on the
type of DB2 you are running) or to the last full image copy you took ...
things only you as a DBA can decide on ... YOU DO HAVE IMAGE COPIES DON'T
YOU?

2. If DB2 caused it when an update was done .. is the log info going to byte
you when you recover ..

bottom line - Talk to IBM, think hard about what you do before you do it,
then do it .....

best regards

LEslie

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, January 03, 2002 12:12 PM
To: [login to unmask email]
Subject: Tablespace Problem


Hi List,

We have a tablespace with 16 partitions and seems like there is some
problem with one of the page.


1) We tried to do a FULLY COPY of that tablespace using BMC. It gave the
following error for one of the dataset .....

=> BMC30562E(17) EXPECTING PAGE X'202A08' FOUND PAGE X'200001'

2)
We tried to do an Unload using DSNTIAUL. It gave the following error.

=> IKJ56641I SYSTEM ABEND CODE 0C6 REASON CODE 00000006 PSW
077C300094EE4D9E ASIDS: HOME = 007D PRIMARY = 01CB SECONDARY = 007D

3)
Then we tried to do REORG using BMC . It also gave the same error

=> BMC50251S 2: PAGE 00002A08 IN 'DSNT.DSNDBD.DDBCK01.SDBCK16.I0001.A003'
IS UNRECOGNIZABLE, DATA = X'10760'

4)
We even tried doing a IBM REORG . It gave the following error.

=> DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION
ABENDED, REASON=X'00C6'


5)

Then we ran DSN1PRNT on that partition using the problem page number and
dataset . The output is as follows:

=>

DSN1998I INPUT DSNAME = DSNT.DSNDBD.DDBCK01.SDBCK16.I0001.A003 , VSAM
DSN1984I UNEXPECTED PAGE NUMBER, EXPECTING: 00202A08
PAGE: # 00200001
--------------------------------------------------------------
*** PAGE IN ERROR - NOT FORMATTABLE ***
0000 00000000 00000000 20000110 00002A08 00002A08 00000000 0000FFFF
FFFFF000
.... LINES ARE ALL ZERO.
0FE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
000000C5
DSN1994I DSN1PRNT COMPLETED SUCCESSFULLY, 00000001 PAGES PROCESSED




Can anyone please suggest how to go about in having that page corrected.


regards,
Srini.


********************************************
This electronic mail message is intended solely for the named recipients
and may contain confidential and proprietary business information of eFunds
Corporation and all its subsidiaries. If you are not a named recipient,
please notify the sender immediately. You may not disclose the contents to
any other person; use this electronic mail message or its contents for any
other purpose; or further store or copy its contents in any medium
********************************************







**********************************************************************
The information contained in this message or any of its attachments may be
confidential and is intended for the exclusive use of the addressee(s). Any
disclosure, reproduction, distribution or other dissemination or use of this
communication is strictly prohibited without the express permission of the
sender. The views expressed in this email are those of the individual and
not necessarily those of Sony or Sony affiliated companies. Sony email is
for business use only.

This email and any response may be monitored by Sony UK.
(04)
**********************************************************************








Jeff Faughn

Re: Tablespace Problem
(in response to A. J. Zobjeck)
You try to RECOVER just that page only... : (




[login to unmask email]
EFUNDS.COM To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: Tablespace Problem
List
<[login to unmask email]>


01/03/02 06:12 AM
Please respond to
DB2 Data Base
Discussion List






Hi List,

We have a tablespace with 16 partitions and seems like there is some
problem with one of the page.


1) We tried to do a FULLY COPY of that tablespace using BMC. It gave the
following error for one of the dataset .....

=> BMC30562E(17) EXPECTING PAGE X'202A08' FOUND PAGE X'200001'

2)
We tried to do an Unload using DSNTIAUL. It gave the following error.

=> IKJ56641I SYSTEM ABEND CODE 0C6 REASON CODE 00000006 PSW
077C300094EE4D9E ASIDS: HOME = 007D PRIMARY = 01CB SECONDARY = 007D

3)
Then we tried to do REORG using BMC . It also gave the same error

=> BMC50251S 2: PAGE 00002A08 IN 'DSNT.DSNDBD.DDBCK01.SDBCK16.I0001.A003'
IS UNRECOGNIZABLE, DATA = X'10760'

4)
We even tried doing a IBM REORG . It gave the following error.

=> DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION
ABENDED, REASON=X'00C6'


5)

Then we ran DSN1PRNT on that partition using the problem page number and
dataset . The output is as follows:

=>

DSN1998I INPUT DSNAME = DSNT.DSNDBD.DDBCK01.SDBCK16.I0001.A003 , VSAM
DSN1984I UNEXPECTED PAGE NUMBER, EXPECTING: 00202A08
PAGE: # 00200001
--------------------------------------------------------------
*** PAGE IN ERROR - NOT FORMATTABLE ***
0000 00000000 00000000 20000110 00002A08 00002A08 00000000 0000FFFF
FFFFF000
.... LINES ARE ALL ZERO.
0FE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
000000C5
DSN1994I DSN1PRNT COMPLETED SUCCESSFULLY, 00000001 PAGES PROCESSED




Can anyone please suggest how to go about in having that page corrected.


regards,
Srini.


********************************************
This electronic mail message is intended solely for the named recipients
and may contain confidential and proprietary business information of eFunds
Corporation and all its subsidiaries. If you are not a named recipient,
please notify the sender immediately. You may not disclose the contents to
any other person; use this electronic mail message or its contents for any
other purpose; or further store or copy its contents in any medium
********************************************