Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to create a new Database from an existing database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Delip

New User


Joined: 13 Sep 2007
Posts: 45
Location: Bangalore

PostPosted: Thu May 07, 2009 9:07 pm    Post subject: How to create a new Database from an existing database
Reply with quote

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
View user's profile Send private message

satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Fri May 08, 2009 5:08 am    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri May 08, 2009 10:48 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm
No new posts How can we create a flat file in JAVA... rakesh.v18 Java & MQSeries 7 Fri Sep 23, 2016 10:46 pm
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Need to create file with Dynamic Name... kapil27 JCL & VSAM 4 Wed May 25, 2016 9:45 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us