By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

Unable to list tablespaces from Control Center

P: n/a
Environment:
AIX 4.3.3
DB2 UDB WSE version 8.1 fixpack 9a

When I access a database residing on this server from my workstation (Windows xp, servicepack2 - db2 udb ESE fixpack 10) and in Control Center try to list the tablespaces (click on Tablespaces in the left part of the GUI) I get this error message:

"SQL0444N Routine "*GET_TBSP" (specific name "SNAP_GET_TBSP") is implemented with code in library or path "...ib/bin/routine/db2dbroutext", function "snap_get_tbsp" whicj cannot be accessed. Reason code: "5". SQLSTATE=42724."

In the db2diag.log is this:

2005-10-19-10.34.32.019473+120 E17478C561 LEVEL: Error (OS)
PID : 131146 TID : 772 PROC : db2fmp (C)
INSTANCE: db2bpu1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:130
CALLED : OS, -, dlopen
OSERR : ENOEXEC (8) "Exec format error"
MESSAGE : Attempt to load specified library failed.
DATA #1 : Library name or path, 44 bytes
/bpufs/files/sqllib/bin/routine/db2dbroutext
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
2
DATA #3 : String, 17 bytes
Exec format error

2005-10-19-10.34.32.020190+120 E18040C770 LEVEL: Error (OS)
PID : 131146 TID : 772 PROC : db2fmp (C)
INSTANCE: db2bpu1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:140
CALLED : OS, -, dlopen
OSERR : ENOEXEC (8) "Exec format error"
MESSAGE : Attempt to load specified library augmented with object name failed.
DATA #1 : Library name or path, 51 bytes
/bpufs/files/sqllib/bin/routine/db2dbroutext(shr.o)
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
262146
DATA #3 : String, 186 bytes
Could not load module /bpufs/files/sqllib/bin/routine/db2dbroutext(shr.o).
File /bpufs/files/sqllib/bin/routine/db2dbroutext is not an
archive or the file could not be read properly.

I have tried to search the documentation abd other sources I could think of but cannot find anything useful to what causes this message or how to fix the problem. Has anyone seen something like this ?
Regards
Odd B Andersen
ErgoGroup AS
Oslo, Norway

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Did you check the explanation of the error message? Reason code "5" is
caused by insufficient memory or an unresolved reference.

Check the FP10 instructions and seed if they state that the packages
need to be rebound to all databases. If this is true; then you will need
to rebind them to the AIX database if you didn't do this.
Phil Sherman

Odd Bjørn Andersen wrote:
Environment:
AIX 4.3.3
DB2 UDB WSE version 8.1 fixpack 9a

When I access a database residing on this server from my workstation
(Windows xp, servicepack2 - db2 udb ESE fixpack 10) and in Control
Center try to list the tablespaces (click on Tablespaces in the left
part of the GUI) I get this error message:

"SQL0444N Routine "*GET_TBSP" (specific name "SNAP_GET_TBSP") is
implemented with code in library or path
"...ib/bin/routine/db2dbroutext", function "snap_get_tbsp" whicj cannot
be accessed. Reason code: "5". SQLSTATE=42724."

In the db2diag.log is this:

2005-10-19-10.34.32.019473+120 E17478C561 LEVEL: Error (OS)
PID : 131146 TID : 772 PROC : db2fmp (C)
INSTANCE: db2bpu1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:130
CALLED : OS, -, dlopen
OSERR : ENOEXEC (8) "Exec format error"
MESSAGE : Attempt to load specified library failed.
DATA #1 : Library name or path, 44 bytes
/bpufs/files/sqllib/bin/routine/db2dbroutext
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
2
DATA #3 : String, 17 bytes
Exec format error

2005-10-19-10.34.32.020190+120 E18040C770 LEVEL: Error (OS)
PID : 131146 TID : 772 PROC : db2fmp (C)
INSTANCE: db2bpu1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:140
CALLED : OS, -, dlopen
OSERR : ENOEXEC (8) "Exec format error"
MESSAGE : Attempt to load specified library augmented with object name
failed.
DATA #1 : Library name or path, 51 bytes
/bpufs/files/sqllib/bin/routine/db2dbroutext(shr.o)
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
262146
DATA #3 : String, 186 bytes
Could not load module /bpufs/files/sqllib/bin/routine/db2dbroutext(shr.o).
File /bpufs/files/sqllib/bin/routine/db2dbroutext is not an
archive or the file could not be read properly.

I have tried to search the documentation abd other sources I could think
of but cannot find anything useful to what causes this message or how to
fix the problem. Has anyone seen something like this ?

Regards
Odd B Andersen
ErgoGroup AS
Oslo, Norway


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.