Sue,
You're backups will be pretty much the same. From the DB2 side it's pretty
straight forward. You just need to incorporate the NetBackup load
libraries into the backup by using the LOAD parm of the BACKUP command.
Example:
db2 -v backup db sample load /usr/openv/netbackup/bin/nbdb2.sl64'
There's more work to be done on with NetBackup. You'll need to work with
your NetBackup admin to get that working. Are you installing the NetBackup
Client on the DB2 server and then sending the backup to the NetBackup Media
Server? (This is OK for smaller databases, but for large databases you'll
want to implement a LAN-Free solution)
If you are, you'll need to set the NetBackup Server and Client parms.
NUMBER_DATA_BUFFERS, set to 128 and SIZE_DATA_BUFFERS set to 262,144
(256KB)
You'll also want to make sure that your NetBackup Media Server has enough
adapters to keep the tape drives busy.
DB2 can serve up data to the tape drives faster than they can write them,
so you want to make sure you're bottlenecked at the maximum write speed of
the tape. If you aren't then theirs some NetBackup or infrastructure
changes to be made. For example a LTO GEN 2 tape can write at 32MB/Sec.
So you want to make sure the backups and the NetBackup Media Server are
driving the tapes to write at 32MB/Sec.
You'll need to work closely with your AIX and NetBackup Sysadmin. The DB2
Backup is pretty straight forward, so if there's a performance issue, then
9 out of 10 times it's a NetBackup issue. I'd also work closely with
Symantics on NetBackup parms. With your back dated version of AIX you may
have problems with updating NetBackup Parms... they won't stick.
Good luck.
Mark Talens
Certified Consulting I/T Specialist
DB2 UDB for Linux, Unix and Windows
DB2 Tools for zSeries and Multiplatform
IBM Data Management Solutions
600 Anton Blvd. Costa Mesa, CA 92626
Voice: (714) 438-6149 Fax: 714-438-6199
IBM Only: T/L 925-6149, Mark Talens/Costa Mesa/[Email Address Removed] Mark,
I have v7.1 (full offline backup) v8.2 ( full online
backup) and they are all single instance without partition.
in v7.1 I have 2 databases in that one single instance all
need to do offline backup.
We are using AIX 5.1 on v7.1 and 5.2 on V8.2.
Now we have 170GB backup dump to disk for (DW) database in
v7.1 and which took too many disk space.
We are trying to change to netbackup and write to tape
directly. I am worry about the restore too, from disk
backup dump I can restore without any issue; but I am not
sure about redirect restore on netbackup?
Sue
"Mark Talens "
<db2udbdba-ezmlms
hield-x57041173.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
06/28/2007 04:07
PM Subject
Re: db2udb with netbackup
Sue,
Are you using DB2 9 or DB2 V8?
What OS and level?
Is this for Online or Offline backup?
Ist this for Single Partition database (non-DPF) or Multiple Partition
database (DPF)?
Are you doing a full Database backup or Tablespace Backup?
What does your backup to disk look like now?
Mark Talens
Certified Consulting I/T Specialist
DB2 UDB for Linux, Unix and Windows
DB2 Tools for zSeries and Multiplatform
IBM Data Management Solutions
600 Anton Blvd. Costa Mesa, CA 92626
Voice: (714) 438-6149 Fax: 714-438-6199
IBM Only: T/L 925-6149, Mark Talens/Costa Mesa/[Email Address Removed] "Sheuehua"
<db2udbdba-ezmlms
hield-x92412975.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
06/28/2007 02:57
PM Subject
Re: db2udb with netbackup
Hi Mark,
There is no issue; our SA just installed netbackup on one
of our test server;
Can you share your scripts with me ( backup/restore); I
have to change our old way ( backup to disk)
to netbackup tape.
Thanks for your help !!
Sue
"Mark Talens " <db2udbdba-ezmlmshield-x90564581.[Email address protected]
06/28/2007 05:14 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Re: db2udb with netbackup
I have worked with DB2 with NetBackup. Is there an issue?
Mark Talens
Certified Consulting I/T Specialist
DB2 UDB for Linux, Unix and Windows
DB2 Tools for zSeries and Multiplatform
IBM Data Management Solutions
600 Anton Blvd. Costa Mesa, CA 92626
Voice: (714) 438-6149 Fax: 714-438-6199
IBM Only: T/L 925-6149, Mark Talens/Costa Mesa/[Email Address Removed] "Sheuehua"
<db2udbdba-ezmlms
hield-x69042221.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
06/28/2007 11:19
AM Subject
db2udb with netbackup
Hi all,
Anyone has his db2udb (AIX) database backup/restore using
netbackup? Please share with me.
Thanks,
Sue
**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
To: "LazyDBA Discussion" <[Email address protected]
cc:
From: "Mark Talens "
<db2udbdba-ezmlmshield-x90564581.[Email address protected]
**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page