Continuous availibility is the concept that enables 24/7 access to IT-enabled business functions, processes and applications.
I would like to give an idea in this blog for those kinds of cases which had been already proven and done from a very clever customer’s real migration project.
Typically, we use 'db2 upgrade' command or ‘export/import’ for the database migration. And once the database starts to operate in new system and version, it’s really hard and tricky to make a decision for reverting to previous system when there are some problems in new environment.
1. Configure the uni-directional mapping of all tables for both current system to new system and new system to current system.
If you feel like checking the row count of all tables, you may need to take additional time depending on the elapsed time for counting the rows of the biggest tables.
As we can see, this way provides the effective way to save the typical downtime with DB2 migration and easy way to get back to old system as well. Of course, you can continue to use the new system and remove the old system once all relevant departments give the confirmation that the new system runs normally.
JunGuo 270006BN0K Visits (246)
JunGuo 270006BN0K Visits (217)
JunGuo 270006BN0K Visits (191)
wilhap 0600007F3T Visits (292)
Andrew wanted to let you know about some new information that has been
posted to iiug2014.org about this year's conference.
Sessions are now available at iiug
Hands on Labs are now available at iiug
Tutorials are now available at iiug
Keynote Speakers this year will be Beth Smith, General Manager IBM
Information Management and good friend of the IIUG Jerry Keesee, Director of
IBM Informix Development. You can find out more about the keynote speakers
Late Registration for IIUG2014 runs until April 20, 2014 and can be found at
If you have any questions, you can email the CPC at conf
Slakshmi 060001JD9S Visits (586)
Here are some of the interesting DB2 on LUW resources:
Hope they are helpful to you.
If you have useful links and resources, please do share with us.
MaryKKassey 2700055CKK Visits (348)
Here is a quick way to find the enhancements included in Fix Packs for DB2 For Linux, Unix and Windows for different versions:
DB2 Version 10.5 for Linux, UNIX, and Windows fix pack summary
DB2 Version 10.1 for Linux, UNIX, and Windows fix pack summary
DB2 Version 9.7 for Linux, UNIX, and Windows fix pack summary
DB2 Version 9.5 for Linux, UNIX, and Windows fix pack summary
DB2 Version 9.1 for Linux, UNIX, and Windows fix pack summary
Note: DB2 Version 9.1, End of Support April 30, 2012.
MaryKKassey 2700055CKK Visits (263)
Hello DB2 Readers!
Looking for useful tips to solve some DB2 for Linux, Unix and Windows common problems. Here is a knowledge Collection of new DB2 Technotes published in Q1 2014 organized under different categories. Please review.
JunGuo 270006BN0K Visits (564)
wilhap 0600007F3T Visits (220)
Why not extend your conference stay another day and attend one of several tutorials to be offered on Thursday May 2nd? This years tutorials are again included as part of your PAID conference registration.
Take a minute to check out this year's tutorials and don't miss this fantastic opportunity to get in-depth training in one or more of the following topics:
If you still haven't registered, please visit the Conference Website to learn more about what this year's Conference.
JunGuo 270006BN0K Visits (296)
Informix Chat with the Lab -"IBM Informix Enterprise Data Management for the Internet-of-Things" (Mar 25 10:30 CDT)
wilhap 0600007F3T Visits (275)
Informix Chat with the Lab -"IBM Informix Enterprise Data Management for the Internet-of-Things"
Event Date: Mar 25, 2014
Event Time: 10:30 AM - 12:00 PM (Central Time)
Hosted By: Anita McKeithen (IBM)
Presented By: Jerry Keesee - Director, IBM Informix Database Development (IBM), Pradeep Muthalpuredathe - Sr. Manager - CTE Informix Competitive Technical Enablement (IBM)
Why IBM Informix is best suited for the Internet-of-Things. From its embed capabilities with its small footprint and ease of use and administration, to its use in the cloud as a fully operational database with warehouse and analytic capabilities. IBM Informix is a single database that provides solutions from end to end in the Inte
Join the Event
Before you join the event, test your system at:
Join the event at:
If clicking a link above does not work, please copy the entire link and paste it into your Web browser.
Join the Voice Conference
Teleconference Access Number 1:North America dial: USA : 866-803-2143 ;UK 0800-279-3953 ; France : 080-510-0831 ;BANGALORE: 91-80-61275198 ISRAEL : 1-80-9214815 ; ARGENTINA :0800-777-0476 ; AUSTRALIA; 1-800-204-161 ; AUSTRIA :0800-677-989 ;CHI
Teleconference Access Number 2:International dial: BELGIUM 0800-4-8574;BRAZIL 0800
Teleconference ID:032014 (Enter this value when prompted)
For technical questions, contact support at supp
For questions about this event, contact the host at: mcke
JunGuo 270006BN0K Visits (259)
JunGuo 270006BN0K Visits (259)
Resource Info: ODBC DSN configuration with db2cfexp and db2cfimp utilities on Windows Operating System
MaryKKassey 2700055CKK Visits (466)
Export from 64-bit windows - machine 1, import to 64-bit Windows- machine 2:
- db2cfexp with template/backup option on machine1
When using the Configuration Assistant on Windows 64-bit platforms, ODBC Data Sources can be configured only for 64-bit applications.
- db2cli32.exe is part of DB2 64-bit products, it is used to register 32-bit ODBC DSN's on 64-bit Windows.
- 32-bit DB2 products come with only db2cli.exe which is used to register 32-bit ODBC DSN.