Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to take a backup of a db2 table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
pankajupadhyay
Warnings : 1

New User


Joined: 04 May 2007
Posts: 13
Location: pune

PostPosted: Wed Jun 27, 2007 8:31 pm    Post subject: How to take a backup of a db2 table
Reply with quote

HI ,
how can i take a back-up of db2 table and its reverse?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 28, 2007 12:04 am    Post subject:
Reply with quote

Hello,

I'd suggest you talk with your dbas or storage management people - they can tell how this is done on your system.

If you merely want a copy of the data from a table, you can use UNLOAD if you have permission.
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Thu Jun 28, 2007 9:44 am    Post subject:
Reply with quote

Are u guys talking about Image copy..?. If am right the term back up is on LUW, right ..?. (similar to Image copy)
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 28, 2007 11:46 am    Post subject:
Reply with quote

Hello,

Quote:
Are u guys talking about Image copy..?. If am right the term back up is on LUW, right ..?.


Image copy may or may not be what TS is asking about. . . Different systems/organizations have different backup/restore strategies. When one is looking for "the way" to do this, the best bet is to talk with the people already responsible for this. It is a bad practice to have every person with an interest create their own backup/restore procedure. If, however, one wants a copy of a set of data for repeated testing (for example) having an unloaded set of data to work with should not be a problem.

Do you mean Logical Unit of Work for LUW? Most database systems i've supported use LUW as part of the checkpoint/restart scheme, but not as a major part of the system-wide backups. Typically, there would be no way to take a backup for each LUW.
Back to top
View user's profile Send private message
ch_lalitha

New User


Joined: 11 Jan 2007
Posts: 2
Location: chennai

PostPosted: Thu Jun 28, 2007 12:02 pm    Post subject:
Reply with quote

HI,

My question is

How to get the details of employees whose age is greater than 35 through a query in DB2.
suppose emp-table contains the fileds given below
eno, eid, date-of-birth, sal, address, date-of-join
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 28, 2007 12:04 pm    Post subject:
Reply with quote

Hello,

Is there some reason this question did not start a new topic?

Please start a new topic as this one will be deleted.
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Thu Jun 28, 2007 4:35 pm    Post subject:
Reply with quote

Hi d.sch.

I mean to say DB2 UDB(LUW --> Linux, Unix, Windows). If am right they refer to the term BACK UP (I believe there is a command too) as we refer to image copy. I understand back up does makes sense on Z/os.

I agree with you that it makes no sense to talk about the back up of Logical Unit of work -icon_smile.gif)
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 28, 2007 6:30 pm    Post subject:
Reply with quote

Hello,

I've seen DB2 UDB, but i believe this is the first i've heard it called LUW. Thanks for the clarification..

Learn something new every day icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us