IBM Support

PI85615: MULTI-ROW INSERTS INTO ACCELERATOR-ONLY TABLES FAIL WITH SQL0904N

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If a column contains a newline character, chr(10) or chr(13),
    the insert statement fails with the following error:
    
    <TASK_47843056297728-WRITER_1_*_1> SEVERE: [WRT_8229] Database
    errors occurred:
    [IBM][CLI Driver][DB2] SQL0904N  Unsuccessful execution caused
    by an unavailable resource.
    Reason code: "  External Table : count of bad input rows reached
     maxerrors limit" ,
    type of resource: "", and resource name: "".
    SQLSTATE=57011
    {Row=1} sqlstate = 57011
    Database driver error...
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the                             *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 5.1 using the multi-row insert       *
    *                 function                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: If a column contains a new line         *
    *                      character, chr(10) or chr(13), the      *
    *                      insert statement fails with the         *
    *                      following error:                        *
    *                      <TASK_..-WRITER_1_*_> SEVERE:           *
    *                       WRT_8229  Database errors occurred:    *
    *                       IBM  CLI Driver  DB2  SQL0904N         *
    *                      Unsuccessful execution caused by an     *
    *                      unavailable resource.  Reason code:     *
    *                      "  External Table : count of bad input  *
    *                      rows reached maxerrors limit", type of  *
    *                      resource: "", and resource name: "".    *
    *                      SQLSTATE=57011                          *
    *                      {Row=1} sqlstate = 57011                *
    *                      Database driver error...                *
    ****************************************************************
    * RECOMMENDATION: Install the PTF.                             *
    ****************************************************************
    The PTF contains a fix for the problem.
    

Problem conclusion

  • The problem has been fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI85615

  • Reported component name

    IDAA FOR ZOS

  • Reported component ID

    5697AQT00

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-08

  • Closed date

    2017-08-17

  • Last modified date

    2017-09-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  •    AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10
    AQTDBDBI AQTDBDYN AQTDBQIT AQTDBTRC AQTDBTRN AQTDBUNL AQTDBZPR
    AQTDEFTR AQTENV   AQTHFSCL AQTNILIC AQTNOTE  AQTPKAP1 AQTPKAP2
    AQTPKCFG AQTSCALL AQTSCI01 AQTSCI02 AQTSJI00 AQTSJI01 AQTSJI02
    AQTSJI03 AQTSJI04 AQTSJI05 AQTSSCHK AQTSSCPY AQTSXADD AQTSXALT
    AQTSXCN0 AQTSXCN1 AQTSXCN2 AQTSXCN3 AQTSXCN4 AQTSXIM0 AQTSXQHI
    AQTSXSD1 AQTSXTCO AQTSXTSL AQTSXTSU AQTSXTS0 AQTTIJSP AQTTRIN
    AQT02AAC AQT02ALT AQT02ART AQT02ATB AQT02CAC AQT02CDC AQT02CRT
    AQT02ENQ AQT02FGV AQT02FRF AQT02GQD AQT02GQR AQT02GTC AQT02GTI
    AQT02GTR AQT02ISP AQT02LTB AQT02MIG AQT02PSD AQT02RAC AQT02RAT
    AQT02RRT AQT02RTB AQT02RTR AQT02STA AQT02SYN AQT02TCO AQT02UCR
    AQT02USW
    

Fix information

  • Fixed component name

    IDAA FOR ZOS

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R510 PSY UI49630

       UP17/08/22 P F708

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Document information

More support for: z/OS family

Software version: 510

Operating system(s): z/OS

Reference #: PI85615

Modified date: 02 September 2017


Translate this page: