Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2007
    Posts
    21

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

    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

  2. #2
    Join Date
    Jan 2008
    Posts
    88
    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

  3. #3
    Join Date
    Jun 2007
    Posts
    21
    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

  4. #4
    Join Date
    Jun 2007
    Posts
    21
    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.

  5. #5
    Join Date
    Jan 2008
    Posts
    88
    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 .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •