IBM Mainframe Forum

[aqswde]

Hi,

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

Thanks in advance,
John

[enrico-sorichetti]

NO !
why not simply rerun the CREATE stuff

[aqswde]

but I didn't save the create statement of this tablespace.
It's save automaticly?

[aqswde]

what does it means the CREATE stuff?

[enrico-sorichetti]

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!

[aqswde]

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?

[enrico-sorichetti]

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

(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

[dick scherrer]

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.

[aqswde]

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

[dick scherrer]

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