Posted on Thursday, 26th March 2009 by Balazs
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 empty field as NULL. Thus, to convert from DB2 to POstgreSQL style [...]
Tags: DB2, IBM, PostgreSQL
Posted in DB2 | Comments (Comments)
Posted on Wednesday, 18th March 2009 by Balazs
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
07:40:27.557594″.
SQL0958C The maximum number of open files has been reached. SQLSTATE=57009
After some investigation, I [...]
Tags: DB2, IBM
Posted in DB2 | Comments (Comments)
Posted on Tuesday, 17th March 2009 by Balazs
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 ‘/ //g’
You can redirect this into a file, and you may need to cut off the first [...]
Tags: DB2, IBM
Posted in DB2 | Comments (Comments)
Posted on Friday, 6th March 2009 by Balazs
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. Stay alert!
Asset reporting, inventory reporting… share a report. Report to your heart’s content!
Helpdesk & IT [...]
Tags: asset reporting, exchange monitoring, helpdesk, inventory reporting, it portal, license monitoring, network inventory, network monitoring, pc inventory, software inventory
Posted in Technology | Comments (Comments)
Posted on Friday, 6th March 2009 by Balazs
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. The Software Devotional is running a great article about loose coupling. This is not the [...]
Tags: loose coupling, object oriented design, software architecture, software development
Posted in Technology | Comments (Comments)