Before I became an expert on DB2 LUW I was a DB2 for z/OS Database Administrator and DB2 systems programmer. I see lots of questions lately from current DB2 for z/OS DBAs picking up responsibility for a DB2 LUW installation and they ask where they should start, that because it is on LUW they must do something different. Well it is really quite simple, all the things that are important on the mainframe DB2 are as important on DB2 LUW. Things like reorgs, backups, monitoring, SQL tuning, support of application developers, etc are the same, just how you do it on DB2 LUW might be different. So it is easy to learn how to do a reorg, how to determine if a reorg is required, what type of backup to use, and how to monitor SQL, just the interfaces are different but all the things that must be done on z/OS must be done on LUW. After you learn the way to do these things on LUW then and only then start to learn about the LUW Operating Systems and the various scripting languages you might need. Lots of folks get a mental block about UNIX or Linux and can’t see the forest because of the trees…..So, in closing, learn how to do all the DB2 important things on DB2 LUW then worry about learning UNIX or Linux.
I’ve been seeing a lot of questions in various forums regarding the operations of HADR. The best source for info is the HADR wiki on Developer works at https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/DB2HADR/page/HADR%20Tutorial
This is good news for the DB2 9.7 install base which is extensive….See the details at
Phone apps using microphone to track whereabouts for ad targeting….
Interesting article on use of partial prints and how researchers have been able to develop a print that works by analyzing thousands of fingerprints and then through analysis develop one that works…..Check it out here: http://www.crossroadstoday.com/story/35119693/so-you-think-you-can-secure-your-mobile-phone-with-a-fingerprint
Prior to DB2 11.1, if running HADR, the standby database was required to be reinitialized with a backup from the primary after the upgrade was done on the primary. With installations running many HADR standby databases this represented a significant outage for the upgrade and unavailability of the standby for a period of time. This was especially troublesome if the standby was being used for ROS. The folks at the lab have done a great job in making the upgrade of the standby as part of the upgrade process in DB2 11.1 and onward. So once on DB2 11.1 you will not need to reinitialize the standby — it will be upgraded as part of the upgrade process! Read more about this at https://www.ibmdatamangement.co and visit the DB2 LUW support page at https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html
There are a lot, I’d say majority of DB2 installations running DB2 9.7. The requirement to upgrade due to end of service has been out for about a year. Many clients have not yet planned to upgrade. Time to get moving as a good upgrade plan can take 1-3 months to plan and implement. Get moving!
