View previous topic :: View next topic
|
Author |
Message |
Delip
New User
Joined: 13 Sep 2007 Posts: 46 Location: Bangalore
|
|
|
|
Hi,
I have an existing database A which has 100 Tablespaces with one table in each Tablespace.
My requirement is to create a new database B with same number of tablespaces and tables.
Is there any way we can do with few commands instead of running 100 DDL statements.
Thank you,
Delip |
|
Back to top |
|
|
satyender
New User
Joined: 05 Jan 2008 Posts: 50 Location: Olympia, WA, USA
|
|
|
|
I think you can do it in DB2 LUW. Right click on existing database and selecting Create database.. then select the option "From Backup"..
About mainframes no idea. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Delip,
Ask you DBA for the DDL dump which might being taken every week or month. After that you have to do a bit of EDIT works.
OR
Platinum tools --> Compare Strategy
Thank You,
Sushanth |
|
Back to top |
|
|
|