Re: Taking Image Copy of base tablespace,LOB Tablespace and all the indexspaces in DB2V8
Hi Kevin thanks. I am not a DBA . Sabarish On Sat, Sep 20, 2008 at 10:28 PM, Kenneth E Tomiak [EMAIL PROTECTED] wrote: And take advantage of search engines like GOOGLE and ASK. A search of the message id and COPY YES turned up this hit which explains why you received the message. If you are aDBA then from there you should know what to do or get a DBA to fix it. There are DBa consultants available if you are still stuck. http://www.redbooks.ibm.com/redbooks/pdfs/sg246289.pdf P.Sabarish Kannan You should post on the DB2 List [EMAIL PROTECTED] -- 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 -- 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
Re: Taking Image Copy of base tablespace,LOB Tablespace and all the indexspaces in DB2V8
Hi I tried to access the site www.idugdb2-l.org for posting my message. But it gives this error: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Any inputs? Sabarish On Mon, Sep 22, 2008 at 11:54 AM, sabarish kannan [EMAIL PROTECTED] wrote: Hi Kevin thanks. I am not a DBA . Sabarish On Sat, Sep 20, 2008 at 10:28 PM, Kenneth E Tomiak [EMAIL PROTECTED] wrote: And take advantage of search engines like GOOGLE and ASK. A search of the message id and COPY YES turned up this hit which explains why you received the message. If you are aDBA then from there you should know what to do or get a DBA to fix it. There are DBa consultants available if you are still stuck. http://www.redbooks.ibm.com/redbooks/pdfs/sg246289.pdf P.Sabarish Kannan You should post on the DB2 List [EMAIL PROTECTED] -- 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 -- 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
Re: Taking Image Copy of base tablespace,LOB Tablespace and all the indexspaces in DB2V8
And take advantage of search engines like GOOGLE and ASK. A search of the message id and COPY YES turned up this hit which explains why you received the message. If you are aDBA then from there you should know what to do or get a DBA to fix it. There are DBa consultants available if you are still stuck. http://www.redbooks.ibm.com/redbooks/pdfs/sg246289.pdf P.Sabarish Kannan You should post on the DB2 List [EMAIL PROTECTED] -- 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
Taking Image Copy of base tablespace,LOB Tablespace and all the indexspaces in DB2V8
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
Re: Taking Image Copy of base tablespace,LOB Tablespace and all the indexspaces in DB2V8
P.Sabarish Kannan You should post on the DB2 List [EMAIL PROTECTED] Kevin -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of P.Sabarish Kannan Sent: Friday, September 19, 2008 2:56 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Taking Image Copy of base tablespace,LOB Tablespace and all the indexspaces in DB2V8 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. SNIP 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 -- 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
