Settle a "discussion"

Catherine McBride

Settle a "discussion"
Hi, DB2 people,

Please help me settle a "discussion". We are DB2 UDB 8.1 running under AIX
5.2. I am of the belief that in order to restore an individual table from
backups, we first need to restore the database to another disk area and then
grab the table from there. We do not use individual table spaces for each
table, and we do not back up at the table space level. We back up at the
database level. Someone won't believe me. Am I at least marginally
correct?


Kind regards,

Cathy McBride
Manager, Mainframe, AS400, RS6000 Support
Kable News Company, Inc
(815) 734-5905

"A player who makes a TEAM great .... is more valuable than a 'great
player' .... Losing yourself in the group for the good of the group ....
that's teamwork." John Wooden, Head Basketball Coach Emeritus, UCLA



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tim Brumfield

Re: Settle a "discussion"
(in response to Craig Owens)
I'm running DB2 8.1 under AIX 5.1 and am using "circular logging" as I think you are. You are entirely correct that in order to restore a single table from such a backup you have to restore the entire database and then grab that table from there. I've had to do it myself.

-tim

>>> [login to unmask email] 01/05/06 9:32 AM >>>
Hi, DB2 people,

Please help me settle a "discussion". We are DB2 UDB 8.1 running under AIX
5.2. I am of the belief that in order to restore an individual table from
backups, we first need to restore the database to another disk area and then
grab the table from there. We do not use individual table spaces for each
table, and we do not back up at the table space level. We back up at the
database level. Someone won't believe me. Am I at least marginally
correct?


Kind regards,

Cathy McBride
Manager, Mainframe, AS400, RS6000 Support
Kable News Company, Inc
(815) 734-5905

"A player who makes a TEAM great .... is more valuable than a 'great
player' .... Losing yourself in the group for the good of the group ....
that's teamwork." John Wooden, Head Basketball Coach Emeritus, UCLA



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

John Lendman

Re: Settle a "discussion"
(in response to Catherine McBride)
You have two options when restoring. Database or Tablespace


John C. Lendman
IBM Certified Solutions Expert
IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS
Office 561-357-7523
Cell 772-485-1592
Email [login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of McBride, Catherine
Sent: Thursday, January 05, 2006 10:32 AM
To: [login to unmask email]
Subject: [DB2-L] Settle a "discussion"



Hi, DB2 people,

Please help me settle a "discussion". We are DB2 UDB 8.1 running under AIX 5.2. I am of the belief that in order to restore an individual table from backups, we first need to restore the database to another disk area and then grab the table from there. We do not use individual table spaces for each table, and we do not back up at the table space level. We back up at the database level. Someone won't believe me. Am I at least marginally correct?


Kind regards,

Cathy McBride
Manager, Mainframe, AS400, RS6000 Support
Kable News Company, Inc
(815) 734-5905

"A player who makes a TEAM great .... is more valuable than a 'great
player' .... Losing yourself in the group for the good of the group ....
that's teamwork." John Wooden, Head Basketball Coach Emeritus, UCLA


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Craig Owens

Re: Settle a "discussion"
(in response to John Lendman)
Cathy,

Yes, you are correct.

I'm sure you're aware that export could be used on the individual table
for restores.

Regards,
Craig Owens.


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of McBride, Catherine
Sent: Thursday, January 05, 2006 8:32 AM
To: [login to unmask email]
Subject: [DB2-L] Settle a "discussion"



Hi, DB2 people,

Please help me settle a "discussion". We are DB2 UDB 8.1
running under AIX 5.2. I am of the belief that in order to restore an
individual table from backups, we first need to restore the database to
another disk area and then grab the table from there. We do not use
individual table spaces for each table, and we do not back up at the
table space level. We back up at the database level. Someone won't
believe me. Am I at least marginally correct?


Kind regards,

Cathy McBride
Manager, Mainframe, AS400, RS6000 Support
Kable News Company, Inc
(815) 734-5905

"A player who makes a TEAM great .... is more valuable than a
'great
player' .... Losing yourself in the group for the good of the
group ....
that's teamwork." John Wooden, Head Basketball Coach Emeritus,
UCLA



------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm