Saturday, 11 July 2009

Wierdness when creating DB2 Administration Server (DAS) on Red Hat Enterprise Linux 5

I've seen this a few times now, having spent quite a bit of time using DB2 UDB v9.1.0.5. I see warning messages related to /tmp when I attempt to create a DAS or instance using the command: -

[root@voyager tmp]# /opt/ibm/db2/V9.1/instance/dascrt -u dasusr1

which resulted in: -

SQL4406W  The DB2 Administration Server was started successfully.
-bash: /tmp/db2iexec.tmp.32030: Permission denied
/opt/ibm/db2/V9.1/instance/db2iexec: line 84: [: -ne: unary operator expected
DBI1070I Program dascrt completed successfully.  

This seems to relate to the executable (X) permissions of /tmp which, on my system shows as: -

drwxrwxr-x  8 185101 330209  4096 Jul 11 07:43 tmp

Therefore, I hacked the solution by changing the X bit for /tmp for ALL users/groups, using the command: -

chmod 777 /tmp

which then means that /tmp shows as: -

drwxrwxrwx   8 185101 330209  4096 Jul 11 08:38 tmp

Having done this, I was then able to create the DAS: -

[root@voyager tmp]# /opt/ibm/db2/V9.1/instance/dascrt -u dasusr1

resulting in: -

SQL4406W  The DB2 Administration Server was started successfully.
DBI1070I Program dascrt completed successfully.  

and the instance: -

[root@voyager ~]# /opt/ibm/db2/V9.1/instance/db2icrt -a SERVER -u db2fenc1 db2inst1

resulting in: -

DBI1070I Program db2icrt completed successfully.  

No comments:

Grokking grep

A colleague was tinkering with grep  and, thanks to him, I discovered a bit more about the trusty little utility. I had not really explored ...