SMS, System Backup/Restore, Cloning Tool question

George Palko

SMS, System Backup/Restore, Cloning Tool question
Hello List,
We are in the process of converting our DB2 9 catalogs and directories to SMS to prepare for DB2 10. We also want to begin using DB2 System Backup/Restore along with the DB2 Cloning Tool. Currently, our DB2 environments all share the same user catalog and we are using single level aliases, with each subsystem having a unique high-level qualifier. After reading white papers on backup/restore and the DB2 9 Storage Management Redbook, I’m aware that we would have to create at least two separate user catalogs per subsystem. One for the logs/bsds, the other for the catalog/directory and application data. Since we are using single level aliases, would we have to have different high-level qualifiers for the log/bsds per subsystem separate from the catalog and application data?

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Carol Broyles

Re: SMS, System Backup/Restore, Cloning Tool question
(in response to George Palko)
Hi George,

I didn't see a reply to this, but here is what we are doing. We have 2 ICF catalogs, one for the logs and bsds and another one for all the other datasets. The ICF catalogs are on a non-sms MOD1 volume with nothing else on the volume to simplify cloning. The logs and BSDS have a two-level alias, and they are in an SMS group that keeps them separate from everything else. The catalog and directory datasets are in an SMS group with its own volume(s), and the rest of the user datasets go into their own SMS group and do not mix in with the catalog and directory datasets.

Carol Broyles
Affiliated Computer Services, Inc.
A Xerox Company
937-495-4003
[login to unmask email] <mailto:[login to unmask email]>

________________________________

From: IDUG DB2-L on behalf of George Palko
Sent: Wed 11/3/2010 1:40 PM
To: [login to unmask email]
Subject: [DB2-L] SMS, System Backup/Restore, Cloning Tool question



Hello List,
We are in the process of converting our DB2 9 catalogs and directories to SMS to prepare for DB2 10. We also want to begin using DB2 System Backup/Restore along with the DB2 Cloning Tool. Currently, our DB2 environments all share the same user catalog and we are using single level aliases, with each subsystem having a unique high-level qualifier. After reading white papers on backup/restore and the DB2 9 Storage Management Redbook, I'm aware that we would have to create at least two separate user catalogs per subsystem. One for the logs/bsds, the other for the catalog/directory and application data. Since we are using single level aliases, would we have to have different high-level qualifiers for the log/bsds per subsystem separate from the catalog and application data?

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv



_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Jay Bruce

Re: SMS, System Backup/Restore, Cloning Tool question
(in response to Carol Broyles)
The answer is yes: They need different ICF catalog aliases for logs/BSDS and data. However, it is standard DB2 BACKUP SYSTEM procedures. The Log and BSDS share the same SMS copypool and the data is in another.

That is because the BSDS is an inventory of the logs. They have to be restored together.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv