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
 

 

DB2 backup and migration

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

New User


Joined: 02 Nov 2006
Posts: 43
Location: London

PostPosted: Sat Jul 10, 2010 12:21 am    Post subject: DB2 backup and migration
Reply with quote

Hi,

I am currently working on a migration project with DB2 where I have tables, views, SPs and batch programs that need to be migrated to SQL server.

How do I take backup of all these and work out this migration? Can someone help me with the UNLOAD statement too icon_question.gif

Thanks,
Arien
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Jul 10, 2010 12:36 am    Post subject:
Reply with quote

honestly do not have any experience here,
but, (I will post my ideas anyway)

when you migrate to something,
often the something will have suggestions on how to migrate from other systems to the new.
Since the sellers of the new system want your firm to buy their stuff,
they will provide support (documentation at least)
to enable the customer to 'get off' that old stuff and
migrate to the new stuff with as little problem as possible.

I would not rely on the old stuff to be prolific about how you can easily migrate to other stuff
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Jul 10, 2010 1:19 am    Post subject:
Reply with quote

google provided:

a link to a microsoft pdf download for migrating from db2 to sql server
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jul 10, 2010 1:47 am    Post subject:
Reply with quote

Hello,

Moving the data and the meta-data should be rather straightforward - as long as the data is extracted properly on the sending system (for many years my primary involvement has been moving data and the supporting application inventory and batch processes between the 3 main platforms - IBM mainframe, UNIX, and Win-based systems).

The biggest challange that i've encountered is the movement of the application inventory (which includes utility functions that have been incorporated) and the batch processes. On many systems there are thousands of batch processes that run multiple times a day, daily, weekly, etc. These need to be re-implemented on the target platform.

If the application code is to be replaced with purchased code, a major effort is avoided, but the purchased code will not have exactly the same "rules" as the existing system. So some customization will be needed or someone will have to change the way they work (often not acceptable and not determined by the IT people).

If the existing code is to be re-implemented on the target, compatability may become an issue. While COBOL is COBOL, it is not exactly the same cross-platform. Collating sequence differences will also play a part.

Before this is a "go" hopefully, there will be or has been an investment if a "proof of concept" that would bring a few tables, that data, and some of the associated code to determine how big a task it will be.

The topic is rather too much to deal with as a forum topic. . . icon_smile.gif
Back to top
View user's profile Send private message
arien

New User


Joined: 02 Nov 2006
Posts: 43
Location: London

PostPosted: Sat Jul 10, 2010 2:02 am    Post subject:
Reply with quote

Thanks all for the pointers and your inputs.

Can we UNLOAD a table into a pipe-delimited flat file ? I think this will solve some part of my migration related query. Or do I need to write a program in order to do so ?

Also, I am working on the data type mapping between DB2 to SQL, so that I can migrate the table structure first.

Hope I am moving in the right direction..

cheers
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jul 10, 2010 2:27 am    Post subject:
Reply with quote

Hello,

Creating a delimited file is the way to go (imho).

You need to make sure the data fields are all text fields. No packed-decimal, no signed zoned-decimal, no binary numbers, no bit-switches, etc. Also, it works best if you download punctuated quantity/amount/rate/etc fields (i.e. 12,456.00-).

Something i've done quite a few times is to take the CREATE sql from the sending system and simply try it on the target. Depending on what happens, go from there. Once you've done a few, the kinds of definitions that need to be changed will be identified.

Quote:
Hope I am moving in the right direction..
So far so good i believe icon_smile.gif
Back to top
View user's profile Send private message
arien

New User


Joined: 02 Nov 2006
Posts: 43
Location: London

PostPosted: Sat Jul 10, 2010 2:43 am    Post subject:
Reply with quote

icon_smile.gif Thanks d. sch.
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
No new posts Db2 migration from V4/6 to V8/10 Venkatesh G DB2 1 Thu Jul 14, 2016 8:54 am
No new posts Data Migration from Fujitsu AIM/DB to... umakalikiri DB2 2 Fri Apr 15, 2016 12:26 pm
No new posts Fujitsu Cobol 85 to IBM Cobol (Any ve... umakalikiri COBOL Programming 4 Fri Apr 15, 2016 7:40 am
No new posts Need help on FDRABR incremental backu... sanpedro All Other Mainframe Topics 6 Wed Apr 06, 2016 3:24 am


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