Author Archives: Iqbal

DBAs – who needs ‘em?!

A cautionary tale of why not investing in skilled DBAs can have terrible consequences for the business. We received a frantic call one evening from a customer asking for immediate help. DB2 had “hung” and no activity could be performed … Continue reading

Share
Posted in Remote DBA | Tagged , , , , | 1 Comment

Beware of ‘over-federating’

During a recent DB2-LDAP configuration at a client site, I stumbled upon a bizarre security exposure. Using any DB2 client tool, it was possible to connect to the database as any user without having to get the password right! Once … Continue reading

Share
Posted in Techie Tips | Tagged , , , , | 1 Comment

Day 3 at IDUG EMEA

Today was a jam packed day of presentations. Similar to yesterday being a “pureScale day” for me, today was a “performance day.” I am sure this was not by accident and the IDUG EMEA 2010 conference/program committee have to be … Continue reading

Share
Posted in IDUG EMEA 2010 | Tagged , , , | Comments Off on Day 3 at IDUG EMEA

Day 2 at IDUG EMEA

Today was basically a DB2 pureScale day for me and many midrange folks. Matt Huras and Aamer Sachedina gave excellent presentations giving an overview of pureScale and a deep dive into cluster services and monitoring and a walk-through hardware and … Continue reading

Share
Posted in pureScale | Tagged , , , , , | Comments Off on Day 2 at IDUG EMEA

A Welcome Return To IDUG

The feeling at this year’s IDUG EMEA conference in Vienna is almost nostalgic.  Gosh, has it really been 6 years since I last attended an IDUG conference?  I was frequently reminded of how long it’s been by my colleagues from … Continue reading

Share
Posted in Iqbal Goralwalla | Tagged , , | Comments Off on A Welcome Return To IDUG

Append only DB2 diagnostic log and administration notification log files? No more in DB2 9.7!

How many times have I asked customers for the DB2 diagnostic log file (db2diag.log) only to be told “it’s too large to send” or “it’s taking too long to open.” This is because the DB2 diagnostic files have been append … Continue reading

Share
Posted in Techie Tips | Tagged , , , | Comments Off on Append only DB2 diagnostic log and administration notification log files? No more in DB2 9.7!

Migration issues from DB2 V8.2 to DB2 9.5 on Sun Solaris 64-bit

1.      During a recent migration exercise at a customer site the following error was encountered whilst migrating one of the databases: 2009-04-08-14.21.06.625141+060 E61438A838         LEVEL: Error (OS) PID     : 18892                TID  : 164         PROC : db2sysc 0 INSTANCE: db2inst1             NODE : 000 … Continue reading

Share
Posted in Techie Tips | Tagged , , , , | Comments Off on Migration issues from DB2 V8.2 to DB2 9.5 on Sun Solaris 64-bit

DB2 9.5 not available for Linux on IA64

For those of you using Linux on the Itanium-64 bit (IA64) platform, note that DB2 9.5 is not available for Linux on IA64. The last supported DB2 version for Linux on IA64 is DB2 9. This is because Linux on … Continue reading

Share
Posted in Techie Tips | Tagged , , , , | Comments Off on DB2 9.5 not available for Linux on IA64