View previous topic :: View next topic
|
Author |
Message |
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi All ,
I have dropped the table . i dont have DDL of that table . I have only the image copy of the tablespace which contain that table . I get to know that we can able to extarct the DDL from the Image copy of the tablespace .
Could you please pass some light on this to extract DDL .
-----------------------
Note :
I am using Db2 V8 on z/os
------------------------
Thanks and Regards
Senthil |
|
Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
|
|
As far as I know, in V7, neither imagecopy nor the LDS dataset store any info about the table DDL. So you are probably out of luck here.
Anyway, are you related in anyway to SSG group in TCS? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Somewhere, there should be a backup of the data dictionary. You might be able to restore that to a test environment and retrieve the meta-data you need. |
|
Back to top |
|
|
|