Dropped table DDL

dick scherrer · Posted: Tue Oct 04, 2011 10:08 pm

Hello and welcome to the forum,

We do have some grumpy old men around here - i too am one

As you have seen, sometimes we get more involved with how the question was asked rather than the question itself. Unfortunate. However, if this helps teach people how to become better are getting informatoin, it is probably worth a few scrapes and bruises . . .

If one pay attention to the lessons, it gets better rather quickly.

sushanth bobby · Posted: Tue Oct 04, 2011 10:12 pm

db2sysdba.zos,

Since you are just looking for the structure, can't you find it in Development/UAT/Model/Acceptance/(whatever that is below production).

Regards,
Sushanth

don.leahy · Posted: Tue Oct 04, 2011 10:27 pm

Recover the DB2 catalog? Not recommended as it might be a bit disruptive to other users.

Check your source libraries for an old DCLGEN that corresponds with the table. That might be enough to get you started.

Otherwise, as others have pointed out, you are SOL.

IMO production DDL should be under the control of a source management system.

db2sysdba.zos · New User Joined: 04 Oct 2011 Posts: 25 Location: INDIA

@ sushanth bobby

Thanks for your idea.

But if everywhere it dropped .

(Just a knowledge purpose I want to learn)

db2sysdba.zos · New User Joined: 04 Oct 2011 Posts: 25 Location: INDIA

dbzTHEdinosauer

thanks dbzTHEdinosauer. I didn't think in this point of view.

I will look into this.

If I have any further doubts I will ask you.

Once again thanks for new idea.
[/b]

enrico-sorichetti · Posted: Wed Oct 05, 2011 12:00 pm

what is that You do not understand in the replies that You were given ?
if everything was dropped, the <sources> that You used were lost, if nada de nada is around
You will have to start from scratch(*) period, amen, rip
in the hope that even your neurons were not dropped

but as pointed out in the duplicate post on the other forum,
You will be much better off there!

Bill Woodger · Posted: Wed Oct 05, 2011 12:18 pm

db2sysdba.zos · New User Joined: 04 Oct 2011 Posts: 25 Location: INDIA

Dear Bill,

Correct me If I am wrong.

If that situation occurs we should ready to solve it .

For that we should know the solution.

It's just way to learn new things.

I hope by this forum beginners (even for experts) will learn new things, new way to thing about db2.

I don't want to waste anyone's time.
whenever they have free time that time only they will reply to this.

More over I won't test this solution on production LPAR.

I will test the same on testing Lpar.

enrico-sorichetti · Posted: Wed Oct 05, 2011 12:37 pm

On this side of the forum we expect reasonable questions,
and You get answers according to our experience and best practices
You also should be aware that many of us started consulting ( most probably ) before You were born
and we have faced lots of different situations

and the common expectation is that the TS should agree on reasonable replies

You should be able to accept the replies You were given,
not stubbornly refute them because they were not those You expected

if You do not do that the chances of getting help are pretty slim
( not just here, but on any forum )
did You care to read the suggestions on hoe to ask good questions,
seems not

I strongly recommend You to do so before asking further questions or keep commenting on the current ones

db2sysdba.zos · New User Joined: 04 Oct 2011 Posts: 25 Location: INDIA

I admit my mistakes.

I will read how to ask good questions,

Sorry for the mistakes.

I won't do those thing henceforth.

enrico-sorichetti · Posted: Wed Oct 05, 2011 12:55 pm

a couple more points..

in general there are not bad/stupid questions

there are bad/stupid ways of asking/wording questions
and there is the right/wrong place where ask for

and a distinction should be made between HELP forum and GENERAL forums

this forum is more aimed at HELP , the other forum will <tolerate>a broader range of questions

for example ...
what is a COBOL copybook will certainly be bad mouthed OTSOF ,
will get a reply on the other forum
( bad/stupid question here, inline with the forum objective/mission there )

I got the message XYZ... what should I do ...
I did that and it did not work, help me please
will justify some flames

also You should distinguish between
requests for help and requests for info, clarifications
a request for help expects a real situation and people replying will ask lost of clarification and real data

on the other side info,clarifications are more loose on style and content

rahul1586 · New User Joined: 04 Nov 2008 Posts: 28 Location: Mumbai

db2sysdba.zos,

After going through all the posts in this topic, you should have got the solution by now.

db2sysdba.zos · New User Joined: 04 Oct 2011 Posts: 25 Location: INDIA

@ enrico-sorichetti

Thanks . I will do the same.

@ rahul1586

No. I am still working on this.

If u got te soln. share with me.

dbzTHEdinosauer · Posted: Wed Oct 05, 2011 1:56 pm

like talking to a liberal....

enrico-sorichetti · Posted: Wed Oct 05, 2011 2:01 pm

db2sysdba.zos · New User Joined: 04 Oct 2011 Posts: 25 Location: INDIA

everything is cleared.

thanks

enrico-sorichetti · Posted: Wed Oct 05, 2011 2:20 pm

do You realize i hope the importance of posting properly ..
this post is an example of lots of patience used by people answering
and too much stubborness, unwillingness to understand on the side of the TS (You)

the issue should have been cleared after 2/4 posts not after 35