Hello Team,

We are using the server -OS - AIX 5.2 and DB2levelV81.FP16.Application team is running the batchjob which loads data from one db to the other in the same server. While running the job,the batch job has aborted with the following reasons:

SQL0444N Routine "SQLTABLES"(specifc name"Tables") is implemented with code in library or path "../sqllib/function/unfenced/db2schema",function,"sqltables" which cannot be accessed.Reason code "9".SQLSTATE=42724.
SQLTables:Error retrieving system catalog information for required tables(s).

and in the db2diag.log , i could see the following error:

2008-10-08-14.39.22.190600+060 E232475C1090 LEVEL: Error (OS)
PID : 3023058 TID : 1 PROC : db2agent (MAI05P1) 0
INSTANCE: dumap15 NODE : 000 DB : MAI05P1
APPHDL : 0-1230 APPID: *LOCAL.dumap15.081008133922
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:140
CALLED : OS, -, dlopen
OSERR : ENOEXEC (8) "Cannot run a file that does not have a valid format."
MESSAGE : Attempt to load specified library augmented with object name failed.
DATA #1 : Library name or path, 55 bytes
/home/dumap15/sqllib/function/unfenced/db2schema(shr.o)
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
262146
DATA #3 : String, 368 bytes
0509-026 System error: Cannot run a file that does not have a valid format.
0509-022 Cannot load module /home/dumap15/sqllib/function/unfenced/db2schema(shr.o).
0509-153 File /home/dumap15/sqllib/function/unfenced/db2schema is not an archive or
the file could not be read properly.
0509-026 System error: Cannot run a file that does not have a valid format.

2008-10-08-14.39.22.194180+060 E233566C712 LEVEL: Error (OS)
PID : 3023058 TID : 1 PROC : db2agent (MAI05P1) 0
INSTANCE: dumap15 NODE : 000 DB : MAI05P1
APPHDL : 0-1230 APPID: *LOCAL.dumap15.081008133922
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:130
CALLED : OS, -, dlopen
OSERR : ENOMEM (12) "There is not enough memory available now."
MESSAGE : Attempt to load specified library failed.
DATA #1 : Library name or path, 48 bytes
/home/dumap15/sqllib/function/unfenced/db2schema
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
2
DATA #3 : String, 41 bytes
There is not enough memory available now.

Could any one suggest on this.

Thanks for your help in advance.

Regards
Meena.s

Hi,
can you please post commands you have executed.
Regards

We are not executing the commands, Application team is running the batch from their end.

Many Thanks
Meena.s