Published February 4th, 2015 - by Iqbal Goralwalla
db2look is a great utility which is commonly used by DB2 DBAs to extracts the DDL statements from a source database that can then be used recreate the database objects in a target database. Now, I have always wished for two features in db2look that would make it a “complete” utility. The ability to generate: Continue Reading
Published January 20th, 2015 - by Iqbal Goralwalla
How much does your business suffer if you cannot get to your data within a certain time? Loss of data access can significantly impact your business resulting in losses in revenue, customer confidence, market share, and more. Database High Availability is about making sure the database system remains operational during both during planned and unplanned outages, Continue Reading
Published December 24th, 2014 - by DB2 Geek
Well, it’s been another busy year for the DB2 Geeks. We take a look at some of our favourite DB2 experiences and blogs over the past 12 months. Merry Christmas and a Happy New Year from us all! January – March A Sysprog’s Perspective – DB2 11 – In this podcast series we looked Continue Reading
Published December 1st, 2014 - by Julian Stuhler
As a follow-up to my “DB2 10 upgrade – 23 Things to think about now” blog I’ve created a version for DB2 11. Once again this is intended for organisations who are planning an upgrade to DB2 11 and would like some guidance on what needs to be done prior to the upgrade. This checklist Continue Reading
Published November 27th, 2014 - by James Gill
Introduction Every site has this challenge and we all find different ways around the problem: How can I generate a list of DB2 subsystems defined to my current LPAR and whether they are active or not? It may be that you want to know exactly that but more commonly this is the sort of thing that Continue Reading