Hi

I am getting following error while inserting/updating the DB2 tables.

Error: DB2 SQL error: SQLCODE: -955, SQLSTATE:, SQLERRMC: 2

We have a batch that does insert/update on multiple tables and we observed above errror and job abends..

We bumped the sortheap, sortheap threshold and sorthead shared memory but no luck..

We also observed same issue with online application/txns.

Any idea why it is causing issue..

Thanks

Can you just put more light. What u getting in db2diag log. Is it always insert or delete . what is ur sortheap and sortheaptheresold parameter value

I do not see any entry for -955 in db2diag.log. Here are the dbm/db paramerrs;

Sort heap threshold (4KB) (SHEAPTHRES) = 100000

Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)
Sort list heap (4KB) (SORTHEAP) = 16000
SQL statement heap (4KB) (STMTHEAP) = 40000
Default application heap (4KB) (APPLHEAPSZ) = 50000
Package cache size (4KB) (PCKCACHESZ) = 10240
Statistics heap size (4KB) (STAT_HEAP_SZ) = 22000

thanks

initially we had SHEAPTHRES=35000 before memory upgrade. now we have 32GB RAM and8 CPUs.

system person changed=SORTHEAP=40K and we had same issue. Later we reduced SORTHEAP to 16000.

Can you reduce a bit more and try. you can take advantage of Configuration advisor also. But i think u decrease both the parameter and try. Do u have space in temp table sapce . sometimes the sort overflows and goes into ur temporay tablespace .