Tag Archives: db2

Database System Views – A quick comparison

One of the best friends of Database Administrators , irrespective of race(read engine) and religion (read edition)  are the System Views.  System Views have simplified troubleshooting and performance tuning a lot in the past few years. Couple of versions ago … Continue reading

Posted in database, db2, how to, Oracle, sql server | Tagged , , , , , , , , , , | Leave a comment

A glance at DB2 Audit

The buzz word for IT security is now audit.  They want to audit activities in database for various compliance reason.  HIPPA, PCI, FDA, SOX , SAS70 and so on requires various levels of audit.  Most of the database software vendors … Continue reading

Posted in database, db2, how to | Tagged , , , , , , , , , , , , , | Leave a comment

Fun with Dates

Don’t get your hopes up, this has nothing to with date nights !!   😉  Now we know how to find number of days between two dates, add days and so on.  Few days ago I needed to list out … Continue reading

Posted in db2, how to | Tagged , , , , , , , , , | Leave a comment

Receiving SQL5043n and SPM0438 ?

What you gonna do when you recieve SQL5043n ?  If you see the error on the diaglog or get this when you initiate a connection to DB2,  it means DB2 hasn’t started the communication protocols.  According to IBM’s manual : … Continue reading

Posted in db2 | Tagged , , , , , , , | Leave a comment