IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Dropped table DDL


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10838
Location: italy

PostPosted: Wed Oct 05, 2011 12:00 pm
Reply with quote

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!
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Oct 05, 2011 12:18 pm
Reply with quote

Quote:
I didn't face this situation.


Quote:
(Just a knowledge purpose I want to learn)


Are you saying this is just a question you happen to have thought of so that you can learn a bit? No other practical application?

What if someone gives you an answer (and many have spent time on this). Do you have a way to test/validate the answer for your (non) situation? No? So any answer, other than the "don't do this/make sure you have something to recover from it you do" is wasted effort. If the situation arises, you'll have a number of untried solutions to a problem which will not be identical to that which you have (badly) stated.

Who learns anything that way?

Stay with the other forum for questions. Try to think of something more useful than "If I set fire to my own house, will I be able to put the fire out"?
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Wed Oct 05, 2011 12:25 pm
Reply with quote

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.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10838
Location: italy

PostPosted: Wed Oct 05, 2011 12:37 pm
Reply with quote

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

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

as already suggested beginners should hang around the <other> forum,
were people who answer will certainly more prone to explain the basics
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Wed Oct 05, 2011 12:41 pm
Reply with quote

I admit my mistakes.

I will read how to ask good questions,

Sorry for the mistakes.

I won't do those thing henceforth.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10838
Location: italy

PostPosted: Wed Oct 05, 2011 12:55 pm
Reply with quote

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
Back to top
View user's profile Send private message
rahul1586

New User


Joined: 04 Nov 2008
Posts: 28
Location: Mumbai

PostPosted: Wed Oct 05, 2011 1:11 pm
Reply with quote

db2sysdba.zos,

After going through all the posts in this topic, you should have got the solution by now.
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Wed Oct 05, 2011 1:40 pm
Reply with quote

@ enrico-sorichetti

Thanks . I will do the same.

@ rahul1586

No. I am still working on this.

If u got te soln. share with me.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Wed Oct 05, 2011 1:56 pm
Reply with quote

like talking to a liberal....
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10838
Location: italy

PostPosted: Wed Oct 05, 2011 2:01 pm
Reply with quote

Quote:
No. I am still working on this.
icon_eek.gif icon_eek.gif icon_eek.gif

we have been very patient until now icon_biggrin.gif

please please explain
what kind of solution do You want...

I' ll resume things once for all

case 1)
You lost/dropped the table the but the <sources> are available ( primary/backup )
just rerun the proper <sources> ( primary or after a restore )

case 2)
You lost all the <sources> ( no backup available )
DB2 is <available> table not dropped
Query the catalog tables to find out the definitions to rebuild the sources
You can do it automatically with a few rexx scripts
BTDTGTTS ( been there done that got the t shirt )

things get murky now
case 3)
You lost all the <sources> ( no backup available )
You do not have a proper DB2 <backup> YOU ARE FUCKED icon_biggrin.gif

case 4)
You lost all the <sources> ( no backup available )
keep <restore>ing at least the DB2 catalog tables
keep searching and if found the <thing> proceed as in case 2

case 4a)
You went thru all the DB2 backups and the <thing> is not there
see case 3

nuff said, time to lock the topic

as i said ... we have been very patient up to now

and there are idiots/morons around here who flame me for my rudeness and unwillingness to help icon_cool.gif
Back to top
View user's profile Send private message
db2sysdba.zos

New User


Joined: 04 Oct 2011
Posts: 25
Location: INDIA

PostPosted: Wed Oct 05, 2011 2:16 pm
Reply with quote

everything is cleared.

thanks
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10838
Location: italy

PostPosted: Wed Oct 05, 2011 2:20 pm
Reply with quote

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 icon_evil.gif

Quote:
If u got te soln. share with me.

nothing to share because there is no solution !
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2 Goto page Previous  1, 2

 


Similar Topics
Topic Forum Replies
No new posts Read a flat file and update DB2 table JCL & VSAM 2
No new posts Search substring in internal table of... COBOL Programming 2
This topic is locked: you cannot edit posts or make replies. Write from flat file to db2 table Mainframe Interview Questions 5
No new posts Table Information - DB2 DB2 1
No new posts Converting S9(18) value to a decimal ... DFSORT/ICETOOL 6
Search our Forums:

Back to Top