RE: db2 backup db size >2TB in ESE multipartioning db env.

RE: db2 backup db size >2TB in ESE multipartioning db env.

 

  

Do something like the following....... The following statement backs
up one DB to 10 mountpoints, but on a recovery, DB2 will handle them all
as one....

BACKUP DB PRD ONLINE TO /backup/PRD/bkup0, /backup/PRD/bkup1,
/backup/PRD/bkup2, /backup/PRD/bkup3, /backup/PRD/bkup4,
/backup/PRD/bkup5, /backup/PRD/bkup6, /backup/PRD/bkup7,
/backup/PRD/bkup8, /backup/PRD/bkup9 WITH 2 BUFFERS BUFFER 1024
PARALLELISM 12

Matt M. Kramer
Manager, SAP Basis Team
Great-West Life & Annuity
Phone: (303) 737-3284
Cell: (303) 324-7345
matt.[Email Address Removed] Message-----
From: ighiurea [mailto:[Email Address Removed]
Sent: Wednesday, February 25, 2004 10:06 AM
To: [Email Address Removed] db2 backup db size >2TB in ESE multipartioning db env.

Hi there, did anybody knows how can you backup a db2 db size >2.5TB of
data , if the largest NFS/Unix files we can build is 1.6Tb , is a way to
make the underlying NFS mount point made from extra 2, 3Unix files and
still look one file for DB2...?
How you foloks backup a db2 db with this size >>... 2-3Tb in DB2 UDB ESE
multipartioning db ?
( tools, tips, sugestions)


Isabella



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page