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.
# posted by Dave Hay : 08:42
Subscribe to Posts [Atom]
