by Vikram Khatri | Mar 28, 2008
You have installed DB2 on your database server and now you need to setup your IBM PHP client to connect to DB2. Do you require a full ~500 MB client install? Mostly, system administrator or DBAs grind their teeth when they find out that for a simple connect from PHP,...
by Vikram Khatri | Mar 27, 2008
You are trying to figure out the best approach to do the case in-sensitive search in DB2. You must first read these 3 excellent articles written on this topic by 3 IBMers. Blair Adamache Doug Doole Knut Stolze In a nutshell, you can take one of the approach as...
by Vikram Khatri | Mar 27, 2008
You are new to ibm_db2 or db2 and PHP driver available with thin ODBC-CLI client do not match with your version of PHP. The following steps take drudgery out of complex compilation process for those DBAs or system administrator who are averse to compilation process....
by Vikram Khatri | Mar 18, 2008
Yes, db2 has a top like utility called db2top written by 2 IBMers Subho Chatterjee and Jacques Milman. It uses DB2 snapshot APIs to extract information from DB2 engine and shows in a format that you are familiar with top utility on Unix systems. Click at...
by Vikram Khatri | Mar 6, 2008
Use following SQL to find out the ISOLATION LEVEL used by DB2 packages. SELECT ‘SHOW_RSETS’ “STORED PROCEDURE”, SUBSTR(PKGNAME,1,18) PACKAGE, “ISOLATION” FROM syscat.packages WHERE pkgname = (SELECT deps.bname PACKAGE FROM...
by Vikram Khatri | Mar 6, 2008
If you have been using UNIQUE_IDENTIFIER as a data type and use newguid as a default in your SQL Server table definition, you can use a UDF called from a trigger to simulate same behavior in DB2. This work around is due to the fact that DB2 does not yet support...
by Vikram Khatri | Mar 4, 2008
There are several ways one can do DB2 JDBC tracing and it all really depends how creative you are. Check version of JCC Driver $ java com.ibm.db2.jcc.DB2Jcc -version Simple nonsense solution to use JCC Tracing import java.sql.Connection; import java.sql.DriverManager;...
by Vikram Khatri | Mar 4, 2008
You can put this script as a cron job so that you get DB2 severe messages through email or to your pager. #!/bin/bash # To display severe errors logged for the last 1 day: db2diag -gi “level=severe” -H 1d | /bin/mail -s “DB2DIAG severe messages in...
by Vikram Khatri | Mar 1, 2008
In Oracle world, DBAs generally say that Oracle can do static and dynamic SQL. When they say this, it amuses a DB2 DBA since Oracle way of static and dynamic SQL as perceived by an Oracle DBA is no way near to what is meant by static and dynamic SQL in DB2. In Oracle,...
