Platform Soalris 5.8 Ç(Solaris 8 2/02 s28s_u7wos_08a SPARC)
UDBDB2 8.1.0.56

Hi guys ,

I have an interesting question:

a) When I executes db2 list history backup command (user: user01), I receives de following error :

DB21016E The Command Line Processor encountered a system error while sending the command to the backend process.

b) db2diag.log shows the following stuff

PID:17928(db2) TID:1 Appid:none
command line process clp_send_bpreq Probe:2

Error returned from SQLORQUE:
0xFFBEE5A0 : 0x870F003F ...?

PID:27634(db2agent (ES880FP3) 0) TID:1 Appid:GBFE0A66.P90F.016140150027
catalog services sqlrl_create_index Probe:310
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x80090057".

PID:21371(db2) TID:1 Appid:none
command line process clp_send_bpreq Probe:2

Error returned from SQLORQUE:
0xFFBEE550 : 0x870F003F ...?

PID:22009(db2) TID:1 Appid:none
command line process clp_send_bpreq Probe:2

Error returned from SQLORQUE:
0xFFBEE300 : 0x870F003F ...?

================================================

3) I have dbadm authority

================================================
4) The error seems to be related with messages queue ( it is too large) :

ipcs -q


T ID KEY MODE OWNER GROUP
Message Queues:
q 57222149 0x18f28a1f -Rrw------- usr01 db2adm
q 78865 0xf9ccd571 -Rrw-rw--w- usr02 db2adm
q 64530 0xf9ccd572 -Rrw-rw--w- usr02 db2adm
q 559123 0xf9ccd577 --rw-rw-r-- usr02 db2adm
q 107556 0x47055571 -Rrw-rw--w- usr02 db2adm
q 107557 0x47055572 -Rrw-rw--w- usr02 db2adm
q 107558 0x47055577 --rw-rw-r-- usr02 db2adm

================================================

5) Executes /opt/IBM/db2/V8.1/bin64/ipclean -a


/opt/IBM/db2/V8.1/bin/ipclean: Removing all IPC resources for usr01.
================================================


6) re- executing db2 list history backup command and I receive the same error.

I have equal Operating system limits to instance's owner but he
can executes the command without problem. Also, I can execute other db2 commands like attach, connect, select ......

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 4096
vmemory(kbytes) unlimited

================================================

Do you have a better idea?

I appreciate so much your help.
Thanks in advance