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  [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-126.96.36.1991491+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
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
DATA #3 : String, 77 bytes
libdb2.so.1: failed to map segment from shared object: Cannot allocate memory
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