Hi All
I have a requirement to take image copy of a base tablespace,its associated
LOB tablespaces(auxiliary tablespaces) and its indexspaces at the same time
in DB2V8?I am not using any third party tools.
Because if i take separately, during recovery it gives problem like base table
doesn't have these orphan LOB rows etc.Then i have to repair and proceed
Can you please let me know how to do it.
When i try using COPY as follows:
COPY TABLESPACE D0011077.H1077000 COPYDDN(LOCALDDN)
TABLESPACE D0011077.LZHBZK6V COPYDDN(COPYTA1)
INDEXSPACE D0011077.SREV13SZ COPYDDN(COPYIS1)
INDEXSPACE D0011077.SREV1XUZ COPYDDN(COPYIS2)
INDEXSPACE D0011077.SREV1FVZ COPYDDN(COPYIS3)
INDEXSPACE D0011077.SREVTRMA COPYDDN(COPYIS4)
INDEXSPACE D0011077.ISREVTEM COPYDDN(COPYIS5)
where LZHBZK6V is a LOB tablespace. Before this statement i had given the
corresponding TEMPLATE statements as follows:
TEMPLATE LOCALDDN UNIT SYSDA
DSN(SKANNON.SRFB80.IC.D0011077.H1077000)
SPACE(15,1) CYL DISP(NEW,CATLG,CATLG)
TEMPLATE COPYTA1 UNIT SYSDA
DSN(SKANNON.SRFB80.IC.D0011077.LZHBZK6V)
SPACE(15,1) CYL DISP(NEW,CATLG,CATLG)
TEMPLATE COPYIS1 UNIT SYSDA
DSN(SKANNON.SRFB80.IC.D0011077.SREV13SZ)
SPACE(15,1) CYL DISP(NEW,CATLG,CATLG)
TEMPLATE COPYIS2 UNIT SYSDA
DSN(SKANNON.SRFB80.IC.D0011077.SREV1XUZ)
SPACE(15,1) CYL DISP(NEW,CATLG,CATLG)
Then when i try to do the image copy i get an error saying like below:
DSNUBAII - INDEXSPACE D0010510.SRAU1Z4E DOES NOT HAVE THE COPY
YES ATTRIBUTE
What may be the reason for this error and how to take all the image copies
together for the related tablespaces(base,LOB and the indexspaces)?
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
