testing catalog recovery

william giannelli

testing catalog recovery

I am currently testing our v11 to v12 migration in our Sand box. I would like to test a manual catalog recovery. What is a good way to "break" the catalog in order to test recovery scenarios?

thanks

Bill

steen rasmussen

testing catalog recovery
(in response to william giannelli)
IDCAMS delete a catalog Tablespace is one way

Steen

Sent from my iPhone

> On Jul 5, 2019, at 12:04 PM, william giannelli <[login to unmask email]> wrote:
>
> I am currently testing our v11 to v12 migration in our Sand box. I would like to test a manual catalog recovery. What is a good way to "break" the catalog in order to test recovery scenarios?
>
> thanks
>
> Bill
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Philip Sevetson

testing catalog recovery
(in response to steen rasmussen)
… in a test subsystem!!!

Hopefully no one had to be alerted to this qualifier ☺

-phil (sevetson)
Hereafter to be known as Phil the Pessimistic!!

From: steen rasmussen [mailto:[login to unmask email]
Sent: Friday, July 05, 2019 12:06 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: testing catalog recovery

IDCAMS delete a catalog Tablespace is one way

Steen
Sent from my iPhone

On Jul 5, 2019, at 12:04 PM, william giannelli <[login to unmask email]<mailto:[login to unmask email]>> wrote:

I am currently testing our v11 to v12 migration in our Sand box. I would like to test a manual catalog recovery. What is a good way to "break" the catalog in order to test recovery scenarios?

thanks

Bill

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Raymond Bell

testing catalog recovery
(in response to Philip Sevetson)
I think deleting a Catalog cluster will break any subsystem, not just a test one. ;o)

Make it a good one – like SYSTSDBA. In for a pfennig, etc.

Cheers,


Raymond

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 08 July 2019 12:50
To: '[login to unmask email]'
Subject: [DB2-L] - RE: testing catalog recovery


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

… in a test subsystem!!!

Hopefully no one had to be alerted to this qualifier ☺

-phil (sevetson)
Hereafter to be known as Phil the Pessimistic!!

From: steen rasmussen [mailto:[login to unmask email]
Sent: Friday, July 05, 2019 12:06 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: testing catalog recovery

IDCAMS delete a catalog Tablespace is one way

Steen
Sent from my iPhone

On Jul 5, 2019, at 12:04 PM, william giannelli <[login to unmask email]<mailto:[login to unmask email]>> wrote:

I am currently testing our v11 to v12 migration in our Sand box. I would like to test a manual catalog recovery. What is a good way to "break" the catalog in order to test recovery scenarios?

thanks

Bill

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----

Phil Grainger

testing catalog recovery
(in response to Raymond Bell)
Wimp

Why not delete SYSCOPY – and then figure out where your copies all went

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: Bell, Raymond (Hosting Services, Technology) <[login to unmask email]>
Sent: 08 July 2019 13:06
To: '[login to unmask email]' <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: testing catalog recovery

I think deleting a Catalog cluster will break any subsystem, not just a test one. ;o)

Make it a good one – like SYSTSDBA. In for a pfennig, etc.

Cheers,


Raymond

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 08 July 2019 12:50
To: '[login to unmask email]'
Subject: [DB2-L] - RE: testing catalog recovery


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
… in a test subsystem!!!

Hopefully no one had to be alerted to this qualifier ☺

-phil (sevetson)
Hereafter to be known as Phil the Pessimistic!!

From: steen rasmussen [mailto:[login to unmask email]
Sent: Friday, July 05, 2019 12:06 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: testing catalog recovery

IDCAMS delete a catalog Tablespace is one way

Steen
Sent from my iPhone

On Jul 5, 2019, at 12:04 PM, william giannelli <[login to unmask email]<mailto:[login to unmask email]>> wrote:

I am currently testing our v11 to v12 migration in our Sand box. I would like to test a manual catalog recovery. What is a good way to "break" the catalog in order to test recovery scenarios?

thanks

Bill

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----

-----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 (49.7k)
  • image002.png (6.7k)
  • image003.png (3.7k)
  • image004.png (<1k)

Carol Anne Sutfin

testing catalog recovery
(in response to Phil Grainger)
Rename SYSCOPY.  Then you can change it back to the original name.Carol SutfinSent from my Samsung Galaxy , an AT&T LTE smartphone
-------- Original message --------From: "Grainger, Phil" <[login to unmask email]> Date: 7/8/19 07:20 (GMT-06:00) To: [login to unmask email] Subject: [DB2-L] - RE: testing catalog recovery

Wimp
 
Why not delete SYSCOPY – and then figure out where your copies all went
 





Phil Grainger
Principal Enablement Manager








Direct


+44 1189 218 000




Mobile


+44 7808 643 479




Email


[login to unmask email]





E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS






 

 


From: Bell, Raymond (Hosting Services, Technology) <[login to unmask email]>

Sent: 08 July 2019 13:06
To: '[login to unmask email]' <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: testing catalog recovery


 
I think deleting a Catalog cluster will break any subsystem, not just a test one.  ;o)
 
Make it a good one – like SYSTSDBA.  In for a pfennig, etc.
 
Cheers,
 
 
Raymond
 


From: Sevetson, Phil [mailto:[login to unmask email]

Sent: 08 July 2019 12:50
To: '[login to unmask email]'
Subject: [DB2-L] - RE: testing catalog recovery


 

*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
… in a test subsystem!!!

 
Hopefully no one had to be alerted to this qualifier
J
 
-phil (sevetson)

Hereafter to be known as Phil the Pessimistic!!
 


From: steen rasmussen [mailto:[login to unmask email]

Sent: Friday, July 05, 2019 12:06 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: testing catalog recovery


 
IDCAMS delete a catalog Tablespace is one way 

 


Steen

Sent from my iPhone



On Jul 5, 2019, at 12:04 PM, william giannelli <[login to unmask email]> wrote:



I am currently testing our v11 to v12 migration in our Sand box. I would like to test a manual catalog recovery. What is a good way to "break" the catalog in order to test recovery scenarios?
thanks
Bill
 
-----End Original Message-----



 
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized
to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

-----End Original Message-----
 

-----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.
Attachment Links:
image001.jpg (51 k)  
image002.png (7 k)  
image003.png (4 k)  
image004.png (1 k)  

Site Links:
View post online  
View mailing list online  
Start new thread via email  
Unsubscribe from this mailing list  
Manage your subscription  
This email has been sent to: [login to unmask email]

Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
http://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:http://www.idug.org/p/cm/ld/fid=2

Paul Ogborne

testing catalog recovery
(in response to Carol Anne Sutfin)
Hi Bill,

In a real LIVE situation where you are migrating from one version to another then I’m guessing that the most likely scenario is just a recover to the image copies you would take of the catalog and directory prior to starting said migration.

So, why not just do that?

(Unless you really are into histrionics!).

Regards,
Paul Ogborne.



> On 8 Jul 2019, at 15:48, ca.sutfin <[login to unmask email]> wrote:
>
> Rename SYSCOPY. Then you can change it back to the original name.
>
> Carol Sutfin
>
>
>
> Sent from my Samsung Galaxy , an AT&T LTE smartphone
>
> -------- Original message --------
> From: "Grainger, Phil" <[login to unmask email]>
> Date: 7/8/19 07:20 (GMT-06:00)
> To: [login to unmask email]
> Subject: [DB2-L] - RE: testing catalog recovery
>
> Wimp
>
>
>
> Why not delete SYSCOPY – and then figure out where your copies all went
>
>
>
> Phil Grainger
> Principal Enablement Manager
>
> https://www.bmc.com/ami
> Direct
>
> +44 1189 218 000
>
> Mobile
>
> +44 7808 643 479
>
> Email
>
> [login to unmask email]
>
> E2, Eskdale Road
> Winnersh
> Berkshire
> United Kingdom
> RG41 5TS
>
>
>
>
>
>
>
> From: Bell, Raymond (Hosting Services, Technology) <[login to unmask email]>
> Sent: 08 July 2019 13:06
> To: '[login to unmask email]' <[login to unmask email]>
> Subject: [EXTERNAL] [DB2-L] - RE: testing catalog recovery
>
>
>
> I think deleting a Catalog cluster will break any subsystem, not just a test one. ;o)
>
>
>
> Make it a good one – like SYSTSDBA. In for a pfennig, etc.
>
>
>
> Cheers,
>
>
>
>
>
> Raymond
>
>
>
> From: Sevetson, Phil [mailto:[login to unmask email] <mailto:[login to unmask email]>]
> Sent: 08 July 2019 12:50
> To: '[login to unmask email]'
> Subject: [DB2-L] - RE: testing catalog recovery
>
>
>
>
> *********************************************
> " This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
> *********************************************
>
> … in a test subsystem!!!
>
>
>
> Hopefully no one had to be alerted to this qualifier J
>
>
>
> -phil (sevetson)
>
> Hereafter to be known as Phil the Pessimistic!!
>
>
>
> From: steen rasmussen [mailto:[login to unmask email] <mailto:[login to unmask email]>]
> Sent: Friday, July 05, 2019 12:06 PM
> To: [login to unmask email] <mailto:[login to unmask email]>
> Subject: [DB2-L] - RE: testing catalog recovery
>
>
>
> IDCAMS delete a catalog Tablespace is one way
>
>
>
> Steen
>
> Sent from my iPhone
>
>
> On Jul 5, 2019, at 12:04 PM, william giannelli <[login to unmask email] <mailto:[login to unmask email]>> wrote:
>
> I am currently testing our v11 to v12 migration in our Sand box. I would like to test a manual catalog recovery. What is a good way to "break" the catalog in order to test recovery scenarios?
>
> thanks
>
> Bill
>
>
>
> -----End Original Message-----
>
>
>
> -----End Original Message-----
>
> **This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
>
> -----End Original Message-----
>
>
>
> -----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.
> -----End Original Message-----
>
> Site Links: View post online https://www.idug.org/p/fo/st/?post=189563&anc=p189563#p189563 View mailing list online https://www.idug.org/p/fo/si/?topic=19 Start new thread via email <mailto:[login to unmask email]> Unsubscribe from this mailing list <mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://www.idug.org/p/us/to
>
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> http://www.ESAIGroup.com/idug http://www.esaigroup.com/idug
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2 http://www.idug.org/p/cm/ld/fid=2

Isaac Yassin

testing catalog recovery
(in response to steen rasmussen)
Hi,
Db2 works fine without SYSCOPY until you want to access it for
copy/recover/modify/select.
You can stop db2. Rename SYSCOPY TS and start Db2 and it'll work fine.
Try to rename DBD01 :-)

*Isaac Yassin *
*IBM Gold Consultant*
*IBM Champion for Analytics #ibmchampion*
IBM Certified Solution Expert
IBM Certified System Administrator - DB2 for Z/OS 10, 11, 12
IBM Certified Database Administrator - DB2 for Z/OS 9, 10, 11
IBM Certified Database Administrator - DB2 LUW 10.1
IBM Certified Specialist - PureData System for Analytics v7.1
IDUG Israel RUG co-Chair



On Fri, Jul 5, 2019 at 7:06 PM steen rasmussen <[login to unmask email]> wrote:

> IDCAMS delete a catalog Tablespace is one way
>
> Steen
>
> Sent from my iPhone
>
> On Jul 5, 2019, at 12:04 PM, william giannelli <[login to unmask email]>
> wrote:
>
> I am currently testing our v11 to v12 migration in our Sand box. I would
> like to test a manual catalog recovery. What is a good way to "break" the
> catalog in order to test recovery scenarios?
>
> thanks
>
> Bill
>
> -----End Original Message-----
>
>
> -----End Original Message-----
>