x002548's Blog

Not Just a Number - Brett Kaiser
posts - 89, comments - 586, trackbacks - 39

December 2009 Blog Posts

DB2 OS/390 Database COPY and RESTORE

Hey there!!!!! In the SQL Server world, if you want to create a database on a same server instance,  from an existing database, all you have to do  is something like: RESTORE DATABASE <db_name>    FROM DISK = '\\<file path>\<file name>'    WITH   MOVE '<logical data file name>_data' TO '\\<file path>\<file name>.MDF'         , MOVE '<logical log file name>_log'  TO '\\<file path>\<file name>.LDF'     , REPLACE GO In DB2?  OH NO!!!   SORRY!!! I guess you could use Platinum or some other tool, but that's like a mainframe wizard, and they always (wizards in general) are never 100% bullet proof. At least not for my liking. Anyway....first thing you gotta do...

posted @ Thursday, December 03, 2009 1:32 PM | Feedback (0) | Filed Under [ DB2 ]

Powered by:
Powered By Subtext Powered By ASP.NET