PostgreSQL and DB2 use different styles of conventions to represent NULL. In PostgreSQL, the convention is to have “N” in the data to be loaded with the COPY command. In DB2, the LOAD command can be set to consider and … Continue reading
After a fresh install of DB2 Express C (free download from IBM) 9.5.2 on Linux AMD 64bit, I got the following error trying to load some tables for testing: SQL3500W The utility is beginning the “LOAD” phase at time “01/22/2009 … Continue reading
To retrieve to list of tables in DB2, you need to use the system tables, and then a little bit of sed. Here is how it goes: db2 “SELECT tabschema || ‘.’ || tabname FROM syscat.tables” | sed -e ‘/ … Continue reading
The New York Times is running an interesting article how Siceworks has become a hub for IT professionals. Spiceworks combines Software inventory, network inventory, PC inventory. Inventory every IT thing you manage. Network monitoring, Exchange monitoring, license monitoring and more. … Continue reading
Ever ran into the issue of a developer making a change in the code with ripple effects? Once that happens, you have to institute more comprehensive regression tests throughout the system, hoping to avoid such ripple effects in the future. … Continue reading