Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: DB2 Crashes on insert - URGENT

    DB2 v8.1.0.80 - FP8 on Linux

    DB2 crashes on the below insert statement:

    Table definition:

    Column Type Type
    name schema name Length Scale Nulls
    ------------------------------ --------- ------------------ -------- ----- ------
    PICKLIST_ID SYSIBM INTEGER 4 0 No
    ITEMCODE SYSIBM VARGRAPHIC 30 0 No
    LOCALECODE SYSIBM GRAPHIC 5 0 No
    LITERAL SYSIBM VARGRAPHIC 255 0 Yes
    DOWNLOADSEQ SYSIBM INTEGER 4 0 Yes

    INSERT INTO metass.plliteral (picklist_id, itemcode, localecode, literal, downloadseq)
    VALUES (461,'_000001601_','en_US','[1601]Enter the description for the row indicated below and select the Rate Type from the list. The Rate Type will define if the rate for each row will be a Floating or Fixed Rate. <CRLF><CRLF> Click on the ""Add/Update Row"" button to enter the value',95);

    db2diag1.txt file attached...................Please help.
    Last edited by mdx34; 01-11-08 at 17:35.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You are experiencing a trap inside DB2. This should never happen. Your only chance is to contact IBM support and open a PMR.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2003
    Posts
    113
    Quote Originally Posted by stolze
    You are experiencing a trap inside DB2. This should never happen. Your only chance is to contact IBM support and open a PMR.
    Not to disagree with stolze, but contact IBM support is not the fastest way to resolve your problem. Sometimes it takes months for a meaningful solution come back to you.

    To identify the problem and find your own bypass should be faster. I suspect that the source string of the 'graphic' columns. To identify which one, you can replace the source values with NULL(if allowed) or 'A' (if not NULLable) for all grapihc columns. Then put in real data one by one. So that you can identify which string(or even which character of that string) cause trouble.

    A wild guess, your system may be not set up for graphic-string ccsid conversion, or not setup correctly.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    IBM will tell you to install a newer fixpack. FP8 is ancient. The latest is FP15.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Oct 2004
    Posts
    268
    Yes. I install FP14 and it seems to resolve the issue...........Thanks to all.....

Posting Permissions

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