RPM for IBM_DB2 Extension for PHP

If you are planning to use PHP with DB2 Express-C on Linux, you will need PHP extension for the DB2. The same extension will also work for IBM Cloudscape or Apache Derby databases. [Note: The instructions here are for the Redhat Linux and you will need slight...

Where is DB2 9 installed on Linux?

Few things have changed in DB2 9. For example, IBM does not use RPM to install the software any more on Linux platforms. This change might upset many who rely upon rpm-qa to query about DB2 software. If some one has installed DB2 9 for you on Linux, how would know the...

RegEx DB2 Java UDF with CLOB

1. How to implement Java UDF using CLOB for DB2GENERAL parameter passing? When you use DB2GENERAL parameter passing in the declaration of the SQL UDF, DB2 will use the legacy driver to map the data types between Java and DB2. If you need to pass CLOB as a parameter in...

PHP, Eclipse and DB2 on Windows Platform

This is How I did: Eclipse, PHP and DB2 on Windows Platform After working in Microsoft .Net technologies for few years, I made up my mind to explore PHP world. In fact, this site is hosted using Drupal framework which is in PHP and I did not know anything about PHP to...

Update statistics

Did you know that you can run DB2 REORGCHK command to update the statistics on the tables? Normally, you would run RUNSTATS command against each table to update the statistics. Consider using REORGCHK as shown below: To update all the user and system tables use:...