Monday, May 31, 2010

Issues with installing DB2 8.1 Development Client on Linux

When running the most obvious command db2setup, it shows the following then nothing happens:

DBI1190I db2setup is preparing the DB2 Setup wizard which will guide you through the program setup process. Please wait.  

Perhaps it is because I am not running X as GUI, but strange it didn't complain about the DISPLAY message.

It can be installed by using db2_install

Post-install is unusual compare to other database installs, you need to run this to create an "instance" with an userid already exist on the system.
However, I get the following error on Red Hat Enterprise Linux Server release 5.4 (Tikanga)

/opt/IBM/db2/V8.1/instance/db2iutil/db2icrt -a SERVER -s client appuser
DBI1069E Unexpected error. Function = chk_fsystype, Return code = 
          22.  

It seems to be the version of tail issue, you need to change this script:
/opt/IBM/db2/V8.1/instance/db2iutil/db2iutil
global search for "tail +2", change it to "tail -n +2"

[root@hostname]# ./db2icrt -a SERVER -s client appuser
DBI1070I Program db2icrt completed successfully.  


Reference
http://oss.sgi.com/LDP/HOWTO/DB2-HOWTO/db2instance.html