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
 

 

Dropped table DDL
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Tue Oct 04, 2011 7:26 pm    Post subject: Dropped table DDL
Reply with quote

Hi All,

I didn't face this situation.
But I would like to know is there any way/method to get the DDL for the dropped table without using any tool on DB2 on z O/S.

Thanks in advance.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Oct 04, 2011 7:40 pm    Post subject:
Reply with quote

Dear DBA ON zO/S,

what will you give me for an answer?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Oct 04, 2011 7:42 pm    Post subject:
Reply with quote

no, there isn't. And even with most of the tools (I know). you're still f*cked.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Oct 04, 2011 7:45 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
Dear DBA ON zO/S,

what will you give me for an answer?

It is indeed funny that a user called sysdba.zos asks such a question.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Oct 04, 2011 7:52 pm    Post subject:
Reply with quote

Quote:
Currently, <company> employs 120,000 employees (March 31, 2011). The company recorded total revenue of $6.98 billion (IT revenues stood at $ 5.2 billion) for the year ended March 31, 2011 while net income for the same year was $1.19 billion. We believe in sustained growth by being a partner to industry leaders, attracting the best leaders, offering industry-leading expertise and continue our steadfast global presence.
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Tue Oct 04, 2011 7:53 pm    Post subject: @ dbzTHEdinosauer
Reply with quote

Cool icon_biggrin.gif .
learning is good thing
But sharing the knowledge is the best thing.
I will give you treat when we meet. icon_smile.gif
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Tue Oct 04, 2011 7:56 pm    Post subject: @ GuyC
Reply with quote

I am a beginner in DB2 on z O/S.
I have tried some naming convention for creation of userid for this website.
All the combinations went in vain.
That'sy I chossed db2sysdba.zos.

If you know the answer Kindly let me know.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Oct 04, 2011 8:02 pm    Post subject: Re: @ GuyC
Reply with quote

db2sysdba.zos wrote:
If you know the answer Kindly let me know.
Already did
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Tue Oct 04, 2011 8:10 pm    Post subject: @ GuyC
Reply with quote

ok.

I think dbzTHEdinosauer knew the answer.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Oct 04, 2011 8:11 pm    Post subject: Reply to: Dropped table DDL
Reply with quote

Quote:
I have tried some naming convention for creation of userid for this website.

are You ashamed of using Your name ?

...or your name is prone to duplicates as
German Schmidt ( the second in rank , the first had a german special char )
English Smith, Johnson, Williams
Italian Rossi, Bianchi
French Martin, Bernard
.....
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Tue Oct 04, 2011 8:15 pm    Post subject:
Reply with quote

Sorry If I am wrong

what is there in username?

I am here to learn new things about db2 on z o/s.

Kindly let me know if you guys realy about concern on my username.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Oct 04, 2011 8:19 pm    Post subject: Reply to: Dropped table DDL
Reply with quote

we really do not give a shit about it, but if You do not want to be the object of picky comments

from Your profile
Quote:
Mainframe Skills: DB2

but You agree on ...
Quote:
I am a beginner in DB2 on z O/S.

and then Your signature
Quote:
DBA ON zO/S

do not claim skills that You do not have

and since You are completely anonymous why do You care about our comments !

You will have to bear them if You want help icon_evil.gif
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Tue Oct 04, 2011 8:25 pm    Post subject:
Reply with quote

Now check my profile.

Changed to "Beginner in DB2"

Hope the person who are all concern with my profile is now happy.

Now Kindly let me know the answer of this Question DB2 experts.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Oct 04, 2011 8:27 pm    Post subject: Reply to: Dropped table DDL
Reply with quote

Quote:
Hope the person who are all concern with my profile is now happy.

the profile tells the people willing to reply what kind of reply to give You
if You claim a certain knowledge the responder usually assumes that You know the basics
and the reply will not insist on smaller details

Quote:
Now Kindly let me know the answer of this Question DB2 experts.

did You read the one You already received ...
after You drop a table, it is gone, vaporized, not there any longer, ...
You will have to rewrite the DDL from scratch amen icon_evil.gif

to make the most out of the questions You ask and to forecast the comments You might receive
it would be wise for You to read and meditate on
how to ask questions the smart way
here http://catb.org/~esr/faqs/smart-questions.html
or .. for a more PC language
here http://support.microsoft.com/kb/555375
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Tue Oct 04, 2011 8:29 pm    Post subject: Reply to: Dropped table DDL
Reply with quote

GuyC has already answered your question twice.
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Tue Oct 04, 2011 8:34 pm    Post subject:
Reply with quote

Hi all

Check this soln.

say yesterday we took dump of whole Prod. database( we used to do)

today morning we dropped the table.

Can't we get the ddl by restoring the dump?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Oct 04, 2011 8:37 pm    Post subject: Reply to: Dropped table DDL
Reply with quote

take the dump is a bit generic...
You will find/recover the data You have lost only and only by restoring everything
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Tue Oct 04, 2011 8:39 pm    Post subject:
Reply with quote

that's what I am asking is there any optimised way to find out without restoring the whole dump?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Oct 04, 2011 8:44 pm    Post subject:
Reply with quote

It might be possible to restore part of the catalog in catalog-lookalikes or unload from catalog imagecopies in sequential files.
and based on the info there retrieve the information to (manually) generate the DDL.
But this is not something you would accomplish in 30minutes.

thus my first answer => F*cked
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Oct 04, 2011 9:13 pm    Post subject:
Reply with quote

if there was a dclgen run on the table
to create a copybook to used as an include member for host variables,
you can start there.

but, you will not have any index info, restrainsts, triggers,
in short you will only have the ddl to describe the columns.
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
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
No new posts Getting soc4 on internal table in cobol abdulrafi COBOL Programming 13 Fri May 06, 2016 3:39 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm


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