IBMDatabaseMagazine.com Blogs

This Saturday marks 30 years to the “Unix Millennium Bug” which is where it has been 2^31 seconds since UNIX epoch. This is when the standard signed int overflows its time representation. 0111 1111 1111 1111 1111 1111 1111 1110 changes to 1000 0000 0000 0000 0000 0000 0000 0000 which is negative, as a integer uses the last bit for positive/negative. So why should we start to caring about it now?

Continue reading " Y2K38 and DB2, Is Your Application Safe?..."

Comment on this blog entry


SQL Injection and Stored Procedures

In doing numerous reviews of stored procedures, we see many customers with SQL injection issues. SQL injection is one of the most basic and common security issues in database applications.

Continue reading "SQL Injection and Stored Procedures..."

Comments(1)


Windows Vista: Where is db2diag.log location?

So, we want to post a sample for this blog from the db2diag.log. That's great; it's nice to have samples. The problem is finding the location if you took the default.

First, you must set view hidden files and folder to on. From my C: drive in Windows Explorer, I pressed the Alt key to see the menu bar. On the Tools Menu, choose Folder Options, select the view tab and choose the radio button halfway down "show hidden files and folders".

Then, you'll be able to see diag information in :

C:\ProgramData\IBM\DB2\DB2COPY1\DB2

Martin Hubel and Rob Williams
www.mhubel.com

Comment on this blog entry


DB2_CAPTURE_LOCKTIMEOUT

In the past when a lock time occurred, there was no easy way to diagnose it. Now, in DB2 9.5 and DB2 9.1 FP4 there is a new registry variable called DB2_CAPTURE_LOCKTIMEOUT to capture detailed lock timeout information. Read on to find out how to use it:

Continue reading " DB2_CAPTURE_LOCKTIMEOUT..."

Comments(1)