If you can handle a slower "backup" use db2move with a the schema you want
to back up. Its slower and does it a table at a time like an export.
Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]
"Himes Cliff "
<db2udbdba-ezmlms
hield-x83550559.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
06/25/2004 08:57
AM Subject
RE: Schema level backup in DB2 UDB
V8.1 UNIX,WINDOWS
You can not take a "schema" level backup.
You can backup databases and tablespaces. If you want to take a backup for
the entire schema, either have one schema per database or do not share
tablespaces across schemas and backup those tablespaces.
Cliff.
-----Original Message-----
From: Thirumaran
[mailto:db2udbdba-ezmlmshield-x15717517.[Email address protected]
Sent: Friday, June 25, 2004 8:57 AM
To: LazyDBA Discussion
Subject: Schema level backup in DB2 UDB V8.1 UNIX,WINDOWS
hi,
How do i take a schema level backup in DB2 UDB V8.1 [ UNIX,WINDOWS,AIX]
Thanks
Thiru
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]
*************************************************************
This message, including any attachments, may contain
confidential information intended for a specific individual
and purpose, and may be protected by law. If you are not
the intended recipient, please notify the sender by e-mail
or telephone immediately, and then immediately delete this
message. Any disclosure, copying or distribution of this
message, or the taking of any action based on it, by any
unintended recipient is strictly prohibited.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]
DB2 & UDB email list listserv db2-l LazyDBA home page