Restore DDL definitions of deleted Tableaspace



IBM's flagship relational database management system

Restore DDL definitions of deleted Tableaspace

Postby aqswde » Sat May 22, 2010 5:21 pm

Hi,

There is any way to restore the ddl definitions of table space which drooped mistakenly.

Thanks in advance,
John
aqswde
 
Posts: 8
Joined: Sat May 22, 2010 5:08 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Restore DDL definitions of deleted Tableaspace

 

Re: Restore DDL definitions of deleted Tableaspace

Postby enrico-sorichetti » Sat May 22, 2010 5:33 pm

NO !
why not simply rerun the CREATE stuff
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Restore DDL definitions of deleted Tableaspace

Postby aqswde » Sat May 22, 2010 5:38 pm

but I didn't save the create statement of this tablespace.
It's save automaticly?
aqswde
 
Posts: 8
Joined: Sat May 22, 2010 5:08 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Restore DDL definitions of deleted Tableaspace

Postby aqswde » Sat May 22, 2010 6:00 pm

what does it means the CREATE stuff? :(
aqswde
 
Posts: 8
Joined: Sat May 22, 2010 5:08 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Restore DDL definitions of deleted Tableaspace

Postby enrico-sorichetti » Sat May 22, 2010 8:18 pm

what did You use to create the table initially ??

if You lost everything.... reread the application specifications
and maybe look for the source of some program processing the table!
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Restore DDL definitions of deleted Tableaspace

Postby aqswde » Sat May 22, 2010 9:02 pm

I use ddl statements bu I didnwt save the created job.

what can I lool in the source? their is a chance for the data on the tablespace definitions?
aqswde
 
Posts: 8
Joined: Sat May 22, 2010 5:08 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Restore DDL definitions of deleted Tableaspace

Postby enrico-sorichetti » Sat May 22, 2010 9:34 pm

You/somebody did not save the <DDL>
You/somebody dropped the table
You do not have available the specs
when I tell You to look at some program You/somebody should have written
to process the <dead> table You ask what I mean... (PS)

well, the only thing that I can say is ... GOOD LUCK 8-)

(PS) if You have some program(s) processing the table You might have some
copybooks hinting the <column names> and the format of the same
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Restore DDL definitions of deleted Tableaspace

Postby dick scherrer » Sat May 22, 2010 9:39 pm

Hello,

No - either copy from some program that has most of the info or re-type.

Most places (every one that i've ever worked with) have a library (ds, Librarian Master File, etc where all ddl is stored.

If your organization does not insist on using a common place to store this, you need to create your own. Anything you run should be saved as it will probably be needed again - if only for the promotion to production should this become real someday.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Restore DDL definitions of deleted Tableaspace

Postby aqswde » Sat May 22, 2010 10:40 pm

Thanks a lot for your replies!

enrico, Sorry if I Nagged..

I think you missunderstood me..
I have the DDL statement of the table but the the DDL of the tablespace needed... :)
aqswde
 
Posts: 8
Joined: Sat May 22, 2010 5:08 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Restore DDL definitions of deleted Tableaspace

Postby dick scherrer » Sun May 23, 2010 12:15 am

Hello,

I have the DDL statement of the table but the the DDL of the tablespace needed...
Then it will need to be re-created. . .

ALL off the ddl should be saved in the ddl library. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post