Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: Batch Aborted with the db2 error

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    can you please post commands you have executed.
    Regards

  3. #3
    Join Date
    Sep 2006
    Posts
    105
    We are not executing the commands, Application team is running the batch from their end.

    Many Thanks
    Meena.s

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •