Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: Error while selecting records through client

    Hello all forum members,

    I am using Db2 10.1 on RHEL 5

    While accessing any table/view data of my DB through client ( i.e Toad 4.2 for Db2) i am getting below error message. However all the queries are running file through CLI.



    ERROR [42724] [IBM][DB2/LINUX] SQL0444N Routine "SYSFUN.CHR" (specific name "CHR") is implemented with code in library or path ".../sqllib/bin/routine/db2clifn.a", function "CLI_udfCHAR" which cannot be accessed. Reason code: "5". SQLSTATE=42724


    Diag records as follows:

    2014-02-18-12.37.34.731491+330 E124689629G772 LEVEL: Error (OS)
    PID : 17792 TID : 572517232 PROC : db2sysc
    INSTANCE: db2insts NODE : 000 DB : DBMSTC
    APPHDL : 0-12123 APPID: 10.1.3.126.2107.140218070118
    AUTHID : DB2INSTS HOSTNAME: mstcho
    EDUID : 471 EDUNAME: db2agent (DBMSTC)
    FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
    CALLED : OS, -, dlopen OSERR: EINTR (4)
    DATA #1 : Library name or path, 48 bytes
    /datahome/db2insts/sqllib/bin/routine/db2clifn.a
    DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
    0
    DATA #3 : String, 77 bytes
    libdb2.so.1: failed to map segment from shared object: Cannot allocate memory


    Do anybody has some idea about this ?

    Thanks in advance.

    regards
    ssumit

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as the message indicates
    external function and not available in specific directory
    or read the entry in idug forum, that you also created
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    But i have did nothing in conf. / permissions.. few minutes back it was working OK.

    Any way, How to correct it now ? any suggestions please.

    thanks in advance.

    sumit
    ssumit

  4. #4
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Thanks przytula_guy.
    ssumit

Posting Permissions

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