IBM Mainframe Forum

Hi,

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

Thanks in advance,
John

NO !
why not simply rerun the CREATE stuff

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

what does it means the CREATE stuff?

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!

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?

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

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.

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

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