Re: Copy a backup

2004-03-31 Thread David E Ehresman 
Noone said anything about wanting to be able to restore.  The stated
requirement was to satisfy the auditors by making a copy of the backup.

>>> [EMAIL PROTECTED] 3/30/2004 1:16:05 PM >>>
DB2 will not be able to restore this data from a BACKUPSET.

You will probably have to backup the DB2 database(s) again under a
different
nodename that is bound to a different management class pointing to
this
storage pool.

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf
Of
David E Ehresman
Sent: Tuesday, March 30, 2004 1:00 PM
To: [EMAIL PROTECTED]
Subject: Re: Copy a backup


GENERATE BACKUPSET

>>> [EMAIL PROTECTED] 3/29/2004 7:06:15 AM >>>
Good Day TSMers,

Please HELP..we do db2 backups to TSM on a daily basis. What I
would
like to do to satify our auditors is make a copy of the backup taken
on
Friday nights to a storage pool that I've called weekly.

I do not want to move the data, but make a copy of that backup set
taken as
at the friday night.

How can I go about doing thisAny Ideas ??


Your assistance will be greatly appreciated.


Lindy Crawford
Information Technology
Nedbank Corporate - Property and Asset Finance

Tel : 031 - 3642185
Fax : 031 - 3642946
Cell: 083 632 5982
Email   : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] >

Re: Copy a backup

2004-03-31 Thread Steven Pemberton 
On Wednesday 31 March 2004 09:22, Steve Harris wrote:
> Time to weigh in here.
>
> 1. DB2 backups are API backups.  Generate backupset will not work.
> 2. DB2 backups are different to other backups.  the db2adutl program is
> used to expire them.  TSM holds indefinitely until db2adutl explicity
> deletes.

It seems I'm confused too! :)

I forgot that DB2 stores it's backups as *uniquely* named objects, not
*consistently* named objects. Since each backup object is uniquely named, the
retention policy needs to be set to keep one copy of each object "forever",
and to immediately expire the data when it is eventually "deleted".

So the DB2 Management Class should look like this:

Backup copy group: VE = 1, VD = 0, RE = 0, RO = 0;
Archive copy group: RD = NoLimit;

The DB2 admin (or a script) then uses the "db2adutl" command to tell TSM which
backups and logs are no longer required (ie. it tells TSM they were
"deleted", and then TSM policy expires the object).

This is described in the Redbook "Backing up DB2 using Tivoli Storage Manager"
sg246247, section 7.4 in particular.

I guess I was thinking of some horrible mix of DB2 and Domino. Sorry for the
disinformation. :)

Regards,
Steven P.

> So what is necessary is to examine your DB2 processes and the way that
> db2adutl is run.  If you are scripting it to do the deletions (there is a
> delete after so many days parameter) then you will need to revisit that for
> your Friday exceptions.
>
> That said, if you want to keep another copy of your DB2 backup, without
> taking another backup, then you can retrieve the Db2 backup from TSM to a
> disk file, again using arguments to db2adutl, and then you can back that up
> to TSM again by the usual backup or archive mechanism.  Now there is a DB2
> control file that holds details of backups. whether you will be able to
> restore 12 months hence and need to also keep a copy of the control
> information is a question for your DB2 DBA.
>
>
> Regards
>
> Steve Harris
> AIX and TSM Admin
> Queensland Health, Brisbane Australia

--
Steven Pemberton
Senior Enterprise Management Consultant
IBK, Senetas Group

Mobile: +61/0 418 335 136 | Phone: +61/3 9820 5811 | Fax: +61/3 9820 9907
Level 1, 11 Queens Road, Melbourne, Victoria, 3004, Australia
http://www.senetas.com.au | http://www.ibk.com.au | http://www.datum.com.au

Re: Copy a backup

2004-03-30 Thread Steve Harris 
Time to weigh in here.

1. DB2 backups are API backups.  Generate backupset will not work.
2. DB2 backups are different to other backups.  the db2adutl program is used to expire 
them.  TSM holds indefinitely until db2adutl explicity deletes.
 
So what is necessary is to examine your DB2 processes and the way that db2adutl is 
run.  If you are scripting it to do the deletions (there is a delete after so many 
days parameter) then you will need to revisit that for your Friday exceptions.

That said, if you want to keep another copy of your DB2 backup, without taking another 
backup, then you can retrieve the Db2 backup from TSM to a disk file, again using 
arguments to db2adutl, and then you can back that up to TSM again by the usual backup 
or archive mechanism.  Now there is a DB2 control file that holds details of 
backups. whether you will be able to restore 12 months hence and need to also keep 
a copy of the control information is a question for your DB2 DBA.


Regards

Steve Harris
AIX and TSM Admin
Queensland Health, Brisbane Australia 


>>> [EMAIL PROTECTED] 31/03/2004 8:18:51 >>>
On Monday 29 March 2004 23:21, Crawford, Lindy wrote:
> Good Day TSMers,
>
> Please HELP..we do db2 backups to TSM on a daily basis. What I would
> like to do to satify our auditors is make a copy of the backup taken on
> Friday nights to a storage pool that I've called weekly.
>
> I do not want to move the data, but make a copy of that backup set taken as
> at the friday night.

You are confused. :)

If I understand you correctly, you want to retain the Friday night's DB2
backups for a period different from that of the DB2 backups produced on other
nights of the week? And, you are already producing "copy pool" tapes to be
sent off-site.

The retention of client backups (including DB2) is separate from the location
of that data on disk/tape, and across storage pools. It is the TSM
Policy/Management Classes that control how the data is retained. Even if the
data is duplicated to multiple storage pools (Primary/Copy) that data is all
retained, and expired, at the same time, as specified by the various
Management Classes.

You can't simply copy the Friday DB2 backups to a differnt storage pool and
retian that media for a different period. TSM doesn't bother about retaining
media - it only retains data - and when the database expires the data from
the database the index of the data on ALL storage pool media is expired.

To retain the Friday night's DB2 backups for a period separate from the
retention of the other night's you will probably need to create a new client
account on the TSM server, and a new Management Class to retain the data.

Then configure the DB2 client to use the special nodename only on a Friday,
and bind the Friday's backup to the new Management Class.

There is no need to create a special "Weekly" storage pool to contain the
data. TSM will happily track the retention of your "normal" DB2 backups, and
"Friday" DB2 backups, in the same storage pool, and even on the same tape/s.

Your system should look _something_ like the following:

NodenameDay of week Mgmt Class  StgPool
--- --  --  
-
NODE_DB2SMTWT-S DB2 DB2POOL
NODE_DB2_FRIFriday  DB2_FRI DB2POOL

This is necessary because (if I remember correctly) DB2 saves it's backups as
a combination of *consistently named* "Backup" objects for data and "Archive"
objects for logs. You can't just change the Management Class used for
Friday's backup without effecting the retention of the "backup" objects saved
from previous DB2 backups (if they belong to the same client account).

You probably also want to ensure the Friday backup is a "full" DB2 backup...

Remember, storage pools "contain" data, Management Classes "retain" data.

Regards,
Steven P.

--
Steven Pemberton
Senior Enterprise Management Consultant
IBK, Senetas Group

Mobile: +61/0 418 335 136 | Phone: +61/3 9820 5811 | Fax: +61/3 9820 9907
Level 1, 11 Queens Road, Melbourne, Victoria, 3004, Australia
http://www.senetas.com.au | http://www.ibk.com.au | http://www.datum.com.au


***
This email, including any attachments sent with it, is confidential and for the sole 
use of the intended recipient(s).  This confidentiality is not waived or lost, if you 
receive it and you are not the intended recipient(s), or if it is transmitted/received 
in error.

Any unauthorised use, alteration, disclosure, distribution or review of this email is 
prohibited.  It may be subject to a statutory duty of confidentiality if it relates to 
health service matters.

If you are not the intended recipient(s), or if you have received this email in error, 
you are asked to immediately notify the sender by telephone or by return email.  You 
should also delete this email an

Re: Copy a backup

2004-03-30 Thread Steven Pemberton 
On Monday 29 March 2004 23:21, Crawford, Lindy wrote:
> Good Day TSMers,
>
> Please HELP..we do db2 backups to TSM on a daily basis. What I would
> like to do to satify our auditors is make a copy of the backup taken on
> Friday nights to a storage pool that I've called weekly.
>
> I do not want to move the data, but make a copy of that backup set taken as
> at the friday night.

You are confused. :)

If I understand you correctly, you want to retain the Friday night's DB2
backups for a period different from that of the DB2 backups produced on other
nights of the week? And, you are already producing "copy pool" tapes to be
sent off-site.

The retention of client backups (including DB2) is separate from the location
of that data on disk/tape, and across storage pools. It is the TSM
Policy/Management Classes that control how the data is retained. Even if the
data is duplicated to multiple storage pools (Primary/Copy) that data is all
retained, and expired, at the same time, as specified by the various
Management Classes.

You can't simply copy the Friday DB2 backups to a differnt storage pool and
retian that media for a different period. TSM doesn't bother about retaining
media - it only retains data - and when the database expires the data from
the database the index of the data on ALL storage pool media is expired.

To retain the Friday night's DB2 backups for a period separate from the
retention of the other night's you will probably need to create a new client
account on the TSM server, and a new Management Class to retain the data.

Then configure the DB2 client to use the special nodename only on a Friday,
and bind the Friday's backup to the new Management Class.

There is no need to create a special "Weekly" storage pool to contain the
data. TSM will happily track the retention of your "normal" DB2 backups, and
"Friday" DB2 backups, in the same storage pool, and even on the same tape/s.

Your system should look _something_ like the following:

NodenameDay of week Mgmt Class  StgPool
--- --  --  
-
NODE_DB2SMTWT-S DB2 DB2POOL
NODE_DB2_FRIFriday  DB2_FRI DB2POOL

This is necessary because (if I remember correctly) DB2 saves it's backups as
a combination of *consistently named* "Backup" objects for data and "Archive"
objects for logs. You can't just change the Management Class used for
Friday's backup without effecting the retention of the "backup" objects saved
from previous DB2 backups (if they belong to the same client account).

You probably also want to ensure the Friday backup is a "full" DB2 backup...

Remember, storage pools "contain" data, Management Classes "retain" data.

Regards,
Steven P.

--
Steven Pemberton
Senior Enterprise Management Consultant
IBK, Senetas Group

Mobile: +61/0 418 335 136 | Phone: +61/3 9820 5811 | Fax: +61/3 9820 9907
Level 1, 11 Queens Road, Melbourne, Victoria, 3004, Australia
http://www.senetas.com.au | http://www.ibk.com.au | http://www.datum.com.au

Re: Copy a backup

2004-03-30 Thread Bill Boyer 
DB2 will not be able to restore this data from a BACKUPSET.

You will probably have to backup the DB2 database(s) again under a different
nodename that is bound to a different management class pointing to this
storage pool.

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
David E Ehresman
Sent: Tuesday, March 30, 2004 1:00 PM
To: [EMAIL PROTECTED]
Subject: Re: Copy a backup


GENERATE BACKUPSET

>>> [EMAIL PROTECTED] 3/29/2004 7:06:15 AM >>>
Good Day TSMers,

Please HELP..we do db2 backups to TSM on a daily basis. What I
would
like to do to satify our auditors is make a copy of the backup taken
on
Friday nights to a storage pool that I've called weekly.

I do not want to move the data, but make a copy of that backup set
taken as
at the friday night.

How can I go about doing thisAny Ideas ??


Your assistance will be greatly appreciated.


Lindy Crawford
Information Technology
Nedbank Corporate - Property and Asset Finance

Tel : 031 - 3642185
Fax : 031 - 3642946
Cell: 083 632 5982
Email   : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] >

Re: Copy a backup

2004-03-30 Thread David E Ehresman 
GENERATE BACKUPSET

>>> [EMAIL PROTECTED] 3/29/2004 7:06:15 AM >>>
Good Day TSMers,

Please HELP..we do db2 backups to TSM on a daily basis. What I
would
like to do to satify our auditors is make a copy of the backup taken
on
Friday nights to a storage pool that I've called weekly.

I do not want to move the data, but make a copy of that backup set
taken as
at the friday night.

How can I go about doing thisAny Ideas ??


Your assistance will be greatly appreciated.


Lindy Crawford
Information Technology
Nedbank Corporate - Property and Asset Finance

Tel : 031 - 3642185
Fax : 031 - 3642946
Cell: 083 632 5982
Email   : [EMAIL PROTECTED]

Copy a backup

2004-03-30 Thread Crawford, Lindy 
Good Day TSMers,

Please HELP..we do db2 backups to TSM on a daily basis. What I would
like to do to satify our auditors is make a copy of the backup taken on
Friday nights to a storage pool that I've called weekly.

I do not want to move the data, but make a copy of that backup set taken as
at the friday night.

How can I go about doing thisAny Ideas ??


Your assistance will be greatly appreciated.


Lindy Crawford
Information Technology
Nedbank Corporate - Property and Asset Finance

Tel : 031 - 3642185
Fax : 031 - 3642946
Cell: 083 632 5982
Email   : [EMAIL PROTECTED]

Re: Copy a backup

2004-03-30 Thread Andrew Raibeck 
Hi LIndy,

The question as asked is rather vague, making it difficult to provide a
more specific answer. As someone else suggested, perhaps GENERATE
BACKUPSET would be the way to go. Otherwise when posing questions like
this, it would help if you would provide more details about the
requirement: what specifically is being asked, and why. The "why" part is
important since at times there may be a disconnect between the mechanical
description and what is actually needed.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



"Crawford, Lindy" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
03/29/2004 23:09
Please respond to
"ADSM: Dist Stor Manager"


To
[EMAIL PROTECTED]
cc

Subject
Re: Copy a backup






Hi Andrew,

We do have copies of our primary pools, i.e Offsite copies. What we are
trying to do is merely satify an audit requirement.

The retention periods are different.

Thanks.

Any Ideas 

-Original Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]
Sent: 29 March 2004 05:46 PM
To: [EMAIL PROTECTED]
Subject: Re: Copy a backup


You should, as a matter of course, be using BACKUP STGPOOL on a daily
basis to make backup copies of your primary storage pools. This will give
you not merely weekly backup copies, but daily backup copies of *all* data
stored in TSM, affording you protection against TSM storage media failure.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



"Crawford, Lindy" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
03/29/2004 06:21
Please respond to
"ADSM: Dist Stor Manager"


To
[EMAIL PROTECTED]
cc

Subject
Copy a backup






Good Day TSMers,

Please HELP..we do db2 backups to TSM on a daily basis. What I would
like to do to satify our auditors is make a copy of the backup taken on
Friday nights to a storage pool that I've called weekly.

I do not want to move the data, but make a copy of that backup set taken
as
at the friday night.

How can I go about doing thisAny Ideas ??


Your assistance will be greatly appreciated.


Lindy Crawford
Information Technology
Nedbank Corporate - Property and Asset Finance

Tel : 031 - 3642185
Fax : 031 - 3642946
Cell: 083 632 5982
Email   : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] >

Re: Copy a backup

2004-03-30 Thread David E Ehresman 
>The retention periods are different.
>
>Thanks.
>
>Any Ideas 
>

Generate Backupset

Re: Copy a backup

2004-03-29 Thread Crawford, Lindy 
Hi Andrew,

We do have copies of our primary pools, i.e Offsite copies. What we are
trying to do is merely satify an audit requirement.

The retention periods are different.

Thanks.

Any Ideas 

-Original Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]
Sent: 29 March 2004 05:46 PM
To: [EMAIL PROTECTED]
Subject: Re: Copy a backup


You should, as a matter of course, be using BACKUP STGPOOL on a daily
basis to make backup copies of your primary storage pools. This will give
you not merely weekly backup copies, but daily backup copies of *all* data
stored in TSM, affording you protection against TSM storage media failure.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



"Crawford, Lindy" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
03/29/2004 06:21
Please respond to
"ADSM: Dist Stor Manager"


To
[EMAIL PROTECTED]
cc

Subject
Copy a backup






Good Day TSMers,

Please HELP..we do db2 backups to TSM on a daily basis. What I would
like to do to satify our auditors is make a copy of the backup taken on
Friday nights to a storage pool that I've called weekly.

I do not want to move the data, but make a copy of that backup set taken
as
at the friday night.

How can I go about doing thisAny Ideas ??


Your assistance will be greatly appreciated.


Lindy Crawford
Information Technology
Nedbank Corporate - Property and Asset Finance

Tel : 031 - 3642185
Fax : 031 - 3642946
Cell: 083 632 5982
Email   : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] >







This email and any accompanying attachments may contain confidential and
proprietary information.  This information is private and protected by law
and accordingly if you are not the intended recipient you are requested to
delete this entire communication immediately and are notified that any
disclosure copying or distribution of or taking any action based on this
information is prohibited.

Emails cannot be guaranteed to be secure or free of errors or viruses. The
sender does not accept any liability or responsibility for any
interception
corruption destruction loss late arrival or incompleteness of or tampering
or interference with any of the information contained in this email or for
its incorrect delivery or non-delivery for whatsoever reason or for its
effect on any electronic device of the recipient.

If verification of this email or any attachment is required please request
a
hard-copy version


This email and any accompanying attachments may contain confidential and
proprietary information.  This information is private and protected by law
and accordingly if you are not the intended recipient you are requested to
delete this entire communication immediately and are notified that any
disclosure copying or distribution of or taking any action based on this
information is prohibited.

Emails cannot be guaranteed to be secure or free of errors or viruses. The
sender does not accept any liability or responsibility for any interception
corruption destruction loss late arrival or incompleteness of or tampering
or interference with any of the information contained in this email or for
its incorrect delivery or non-delivery for whatsoever reason or for its
effect on any electronic device of the recipient.

If verification of this email or any attachment is required please request a
hard-copy version

Re: Copy a backup

2004-03-29 Thread Andrew Raibeck 
You should, as a matter of course, be using BACKUP STGPOOL on a daily
basis to make backup copies of your primary storage pools. This will give
you not merely weekly backup copies, but daily backup copies of *all* data
stored in TSM, affording you protection against TSM storage media failure.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



"Crawford, Lindy" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
03/29/2004 06:21
Please respond to
"ADSM: Dist Stor Manager"


To
[EMAIL PROTECTED]
cc

Subject
Copy a backup






Good Day TSMers,

Please HELP..we do db2 backups to TSM on a daily basis. What I would
like to do to satify our auditors is make a copy of the backup taken on
Friday nights to a storage pool that I've called weekly.

I do not want to move the data, but make a copy of that backup set taken
as
at the friday night.

How can I go about doing thisAny Ideas ??


Your assistance will be greatly appreciated.


Lindy Crawford
Information Technology
Nedbank Corporate - Property and Asset Finance

Tel : 031 - 3642185
Fax : 031 - 3642946
Cell: 083 632 5982
Email   : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] >







This email and any accompanying attachments may contain confidential and
proprietary information.  This information is private and protected by law
and accordingly if you are not the intended recipient you are requested to
delete this entire communication immediately and are notified that any
disclosure copying or distribution of or taking any action based on this
information is prohibited.

Emails cannot be guaranteed to be secure or free of errors or viruses. The
sender does not accept any liability or responsibility for any
interception
corruption destruction loss late arrival or incompleteness of or tampering
or interference with any of the information contained in this email or for
its incorrect delivery or non-delivery for whatsoever reason or for its
effect on any electronic device of the recipient.

If verification of this email or any attachment is required please request
a
hard-copy version

Copy a backup

2004-03-29 Thread Crawford, Lindy 
Good Day TSMers,

Please HELP..we do db2 backups to TSM on a daily basis. What I would
like to do to satify our auditors is make a copy of the backup taken on
Friday nights to a storage pool that I've called weekly.

I do not want to move the data, but make a copy of that backup set taken as
at the friday night.

How can I go about doing thisAny Ideas ??


Your assistance will be greatly appreciated.


Lindy Crawford
Information Technology
Nedbank Corporate - Property and Asset Finance

Tel : 031 - 3642185
Fax : 031 - 3642946
Cell: 083 632 5982
Email   : [EMAIL PROTECTED] 







This email and any accompanying attachments may contain confidential and
proprietary information.  This information is private and protected by law
and accordingly if you are not the intended recipient you are requested to
delete this entire communication immediately and are notified that any
disclosure copying or distribution of or taking any action based on this
information is prohibited.

Emails cannot be guaranteed to be secure or free of errors or viruses. The
sender does not accept any liability or responsibility for any interception
corruption destruction loss late arrival or incompleteness of or tampering
or interference with any of the information contained in this email or for
its incorrect delivery or non-delivery for whatsoever reason or for its
effect on any electronic device of the recipient.

If verification of this email or any attachment is required please request a
hard-copy version