SHRLEVEL Change - Inline copies

Srirengan Venkatesh Kumar

SHRLEVEL Change - Inline copies
Hi,

I have two questions

1. I was trying to dsn1copy from an image copy taken during a shrlevel
change reorg and I hit the following problem

DSN1989I DSN1COPY IS PROCESSED WITH THE FOLLOWING OPTIONS:
CHECK/NO PRINT/ 4K/FULLCOPY /NON-SEGMENT/NUMPARTS = 0/ OBIDX
DSN1998I INPUT DSNAME = TINLWA2X.INLWA1R1.$BUSDET.REORG , SEQ
DSN1997I OUTPUT DSNAME = TINLWA2X.DSNDBC.INLWA1R1.$TEST.I0001.A001 , VSAM
DSN1984I UNEXPECTED PAGE NUMBER, EXPECTING: 000012..
0000 1003956F B2C38F00 00000130 01AC0004 01A80005 00000011 00000000 00000002
0020 0014C0FF FF000000 03001480 FFFF0000 00040014 80FFFF00 00000000 1480FFFF
.... LINES ARE ALL ZERO.
0F20 00000000 00000000 40000000 00000000 00000000 00000000 00000000 00000000
.... LINES ARE ALL ZERO.
0FE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 000000D5
DSN1993I DSN1COPY TERMINATED, 00000018 PAGES PROCESSED


2. Why does Db2 Not allow you to rename columns or allow default values for
columns to be changed. Ofcourse the implication is programs have to changed
or the valid has to turned to "N", but why the flexibility is not there or
is there an apar to get this feature. If a mistake is made in either
scenario, is the only way to drop table and recreate and load back or
dsn1copy back.

Please keep me updated.

Thanks



James Campbell

Re: SHRLEVEL Change - Inline copies
(in response to Srirengan Venkatesh Kumar)
1) try INLCOPY instead of FULLCOPY
2) ah, the ways of DB2 are mysterious indeed. You could try shouting,
screaming and submitting a change request to IBM. But it will probably be
met with "yes, it's a pity that you can't change these, but there are ways
[such as you mentioned] to handle this situation, it should only happen in
test, our resources are limited, we have more important (as measured by
customer feedback) things to do - we'll put in our 'to do someday' list."


Now if O***** or S** S***** gets the facility ...

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]

-----Original Message-----
From: Srirengan Venkatesh Kumar
[mailto:[login to unmask email]
Sent: Friday, December 22, 2000 1:35 PM
To: [login to unmask email]
Subject: [DB2-L] SHRLEVEL Change - Inline copies


Hi,

I have two questions

1. I was trying to dsn1copy from an image copy taken during a shrlevel
change reorg and I hit the following problem

DSN1989I DSN1COPY IS PROCESSED WITH THE FOLLOWING OPTIONS:
CHECK/NO PRINT/ 4K/FULLCOPY /NON-SEGMENT/NUMPARTS = 0/
OBIDX
DSN1998I INPUT DSNAME = TINLWA2X.INLWA1R1.$BUSDET.REORG , SEQ
DSN1997I OUTPUT DSNAME = TINLWA2X.DSNDBC.INLWA1R1.$TEST.I0001.A001 , VSAM
DSN1984I UNEXPECTED PAGE NUMBER, EXPECTING: 000012..
0000 1003956F B2C38F00 00000130 01AC0004 01A80005 00000011 00000000
00000002
0020 0014C0FF FF000000 03001480 FFFF0000 00040014 80FFFF00 00000000
1480FFFF
.... LINES ARE ALL ZERO.
0F20 00000000 00000000 40000000 00000000 00000000 00000000 00000000
00000000
.... LINES ARE ALL ZERO.
0FE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
000000D5
DSN1993I DSN1COPY TERMINATED, 00000018 PAGES PROCESSED


2. Why does Db2 Not allow you to rename columns or allow default values for
columns to be changed. Ofcourse the implication is programs have to changed
or the valid has to turned to "N", but why the flexibility is not there or
is there an apar to get this feature. If a mistake is made in either
scenario, is the only way to drop table and recreate and load back or
dsn1copy back.

Please keep me updated.

Thanks







**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************