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 recover table which i already drop?

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

New User


Joined: 04 Jul 2007
Posts: 3
Location: bangalore

PostPosted: Wed Dec 03, 2008 12:34 am    Post subject: how to recover table which i already drop?
Reply with quote

How to recover table or tablespace which i accidentaaly dropped.plz ans,thanks in advance
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: Wed Dec 03, 2008 12:41 am    Post subject:
Reply with quote

Hello and welcome to the forum,

You recreate and reload the table from a backup. Both the source to create the table, any permissions granted to that table, and the data that was in the table should have a backup.

If there is no backup, it will have to be re-entered.
Back to top
View user's profile Send private message
anil.csk

New User


Joined: 22 Oct 2007
Posts: 16
Location: Noida

PostPosted: Wed Dec 03, 2008 4:23 pm    Post subject: Reply to: how to recover table which i already drop?
Reply with quote

you can not recover the data if you have not backup of data.
Back to top
View user's profile Send private message
amitcvrce

New User


Joined: 04 Jul 2007
Posts: 3
Location: bangalore

PostPosted: Wed Dec 03, 2008 8:16 pm    Post subject: Reply to: how to recover table which i already drop?
Reply with quote

thanks for repling...but i dont have the structure of the table,,i have deleted it,
from back up how can i reload,
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2238
Location: @my desk

PostPosted: Wed Dec 03, 2008 9:12 pm    Post subject:
Reply with quote

amitcvrce

Dont you have the DCLGEN of the table in some library?
Back to top
View user's profile Send private message
amitcvrce

New User


Joined: 04 Jul 2007
Posts: 3
Location: bangalore

PostPosted: Thu Dec 04, 2008 4:15 pm    Post subject: Reply to: how to recover table which i already drop?
Reply with quote

Ya dclgen is there..but what about the index?3 indexes were there for the table.
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 Dec 04, 2008 8:31 pm    Post subject:
Reply with quote

Hello,

You will need to re-create them (and anything else that was dropped - like permissions).

Is the sql source for administration not kept in some pds or other library? If not, it should be - now icon_exclaim.gif

All of your administrative sql should be stored outside the database. This not only provides a backup but also provides an easier way to clone entities as the majority of the source is already available and is (should be) known to work.
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 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
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 4 Wed Jan 11, 2017 6:18 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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