Dear All,


We use Database server = DB2/AIX64 9.1.4

on AIX

System Model: IBM,9117-570
Machine Serial Number: 6526A6D
Processor Type: PowerPC_POWER5
Number Of Processors: 1
Processor Clock Speed: 1900 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 7 s96arkhr
Memory Size: 8192 MB
Good Memory Size: 8192 MB
Platform Firmware level: Not Available
Firmware Version: IBM,SF240_332
Console Login: enable
Auto Restart: false
Full Core: false


in the db2diag.log , The Following pattern is repeated




2011-11-21-03.45.58.380627-180 I31516964A376 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-405 APPID: *LOCAL.db2PPA.111121044150
AUTHID : SAPR3
FUNCTION: DB2 UDB, common communication, sqlccFreeIPCs, probe:50
RETCODE : ZRC=0xFFFFFFFF=-1
2011-11-21-03.45.58.380913-180 I31517341A475 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-405 APPID: *LOCAL.db2PPA.111121044150
AUTHID : SAPR3
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : IPC Semaphore Set ID
DATA #1 : Hexdump, 8 bytes
0x078000000026B6BC : FFFF FFFF 0000 0000 ........
2011-11-21-03.45.58.381113-180 I31517817A475 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-405 APPID: *LOCAL.db2PPA.111121044150
AUTHID : SAPR3
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : Receive Semaphore ID
DATA #1 : Hexdump, 8 bytes
0x078000000026B6D4 : 0000 0000 0000 0000 ........
2011-11-21-03.45.58.381326-180 I31518293A376 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-405 APPID: *LOCAL.db2PPA.111121044150
AUTHID : SAPR3
FUNCTION: DB2 UDB, common communication, sqlccFreeIPCs, probe:70
RETCODE : ZRC=0xFFFFFFFF=-1
2011-11-21-03.45.58.381577-180 I31518670A475 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-405 APPID: *LOCAL.db2PPA.111121044150
AUTHID : SAPR3
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : IPC Semaphore Set ID
DATA #1 : Hexdump, 8 bytes
0x078000000026B6BC : FFFF FFFF 0000 0000 ........
2011-11-21-03.45.58.381788-180 I31519146A472 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-405 APPID: *LOCAL.db2PPA.111121044150
AUTHID : SAPR3
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : Send Semaphore ID
DATA #1 : Hexdump, 8 bytes




is there should be concern for the above errors,

How to eliminate the above

Please suggest


Thanks and Regards

there was a local connection LOCAL.db2PPA.111121044150
this session has been closed (putty ?) without resetting the connection

Dear Przytula ,

Thanks For the Reply

How to identify who is Running the Application ID ,111121044150

I did not understand

"this session has been closed (putty ?) without resetting the connection"

Also , again we are getting the Following pattern in the db2 diaglog


Check result has been limited to 16384 characters
Found 303 records since 2011-11-21 10:10:15 in /db2/PPA/db2dump/db2diag.log

All record(s) matching Critical condition:

2011-11-21-06.45.57.273017-180 I32988969A376 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-274 APPID: *LOCAL.db2PPA.111121064630
AUTHID : SAPR3
FUNCTION: DB2 UDB, common communication, sqlccFreeIPCs, probe:50
RETCODE : ZRC=0xFFFFFFFF=-1
2011-11-21-06.45.57.273340-180 I32989346A475 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-274 APPID: *LOCAL.db2PPA.111121064630
AUTHID : SAPR3
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : IPC Semaphore Set ID
DATA #1 : Hexdump, 8 bytes
0x078000000026B6BC : FFFF FFFF 0000 0000 ........
2011-11-21-06.45.57.273557-180 I32989822A475 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-274 APPID: *LOCAL.db2PPA.111121064630
AUTHID : SAPR3
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : Receive Semaphore ID
DATA #1 : Hexdump, 8 bytes
0x078000000026B6D4 : 0000 0000 0000 0000 ........
2011-11-21-06.45.57.273780-180 I32990298A376 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-274 APPID: *LOCAL.db2PPA.111121064630
AUTHID : SAPR3
FUNCTION: DB2 UDB, common communication, sqlccFreeIPCs, probe:70
RETCODE : ZRC=0xFFFFFFFF=-1
2011-11-21-06.45.57.274061-180 I32990675A475 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA
APPHDL : 0-274 APPID: *LOCAL.db2PPA.111121064630
AUTHID : SAPR3
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : IPC Semaphore Set ID
DATA #1 : Hexdump, 8 bytes
0x078000000026B6BC : FFFF FFFF 0000 0000 ........
2011-11-21-06.45.57.274282-180 I32991151A472 LEVEL: Severe
PID : 1425480 TID : 1 PROC : db2agent (PPA) 0
INSTANCE: db2PPA NODE : 000 DB : PPA



Also I checked


db2PPA 3> db2diag -rc 0xFFFFFFFF

Input ECF string '0xFFFFFFFF' parsed as 0xFFFFFFFF (-1).
NOTE: ../sqz/sqlzwhatisrc.C:
V7 input ZRC 0xFFFFFFFF (-1) may translate to V8 ZRC value of 0x83000FFF (-2097147905)

ZRC value to map: 0x83000FFF (-2097147905)
V7 Equivalent ZRC value: 0xFFFFBFFF (-16385)

ZRC class :
Unexpected Operating System error (Class Index: 3)
Component:
Unknown component (Component Index: 0)
Undefined as of DB2 v9.1.0.4; s071028
Operating system reason code (errno):
0x00000FFF (4095) = Error 4095 occurred.
NOTE: Errno value 4095 is excessively large.
It is possible that this error code is not a ZRC value.



Attempting to lookup value 0xFFFFFFFF (-1) as a sqlcode
Sqlcode -1
SQL0001N Binding or precompilation did not complete successfully.


Regards

this user is logon in the instance owner and connected as sapr3
he has a problem with implicit bind
try to connect to db with sysadm and bind db2ubind.lst db2cli.lst db2schema.bnd

Dear Przytula,

The user which connected as sapsr3 is a schema owner For the database.

The application is SAP,

So sapsr3 is the schema owner in SAP Application.

I think this SAPSR3 should be having all the binding specified by you

i e db2ubind.lst db2cli.lst db2schema.bnd

also , can u tell me , how to check , whether the above are binded to user SAPSR3

By which command ?

Thanks in advance

Regards

as these packages are used by public -
db2 bind .... grant public ...
see infocenter for details on bind command