We recently creted a new Database instance in AIX

and whn we create a store procedure we the error

ND;
[IBM][CLI Driver][DB2/6000] SQL0035N The file "P7472187.msg" cannot be opened.

*** SCRIPT END : Connection: 10.80.10.36-TMSADMIN-OBDEV9II (tpeomdev) Oct-14-2003 17:40:30 ***

what could be the reason...

When we execure a sample procedure from the db2 command
we get the wrror

db2 => create procedure peter begin end
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0035N The file "P8461366.msg" cannot be opened


our db2set gives this

DB2_SQLROUTINE_COMPILER_PATH=/home/tmsadmin/sqllib/function/routine/sr_cpath
DB2_ENABLE_LDAP=YES
DB2COMM=TCPIP
DB2AUTOSTART=YES


Also the contents of sr_cpath is

#!/bin/sh
PATH=$PATH:/usr/vacpp/bin
PATH=$PATH:/usr/ibmcxx/bin
PATH=$PATH:/usr/lpp/xlC/bin
export PATH

I believe this is something to do with the C++ compiler resides on the DB2 server.