IBM Support

IT32994: SELECT WITH "DB2GSE.ST_CONTAINS(DB2GSE.ST_POLYGON('POLYGO..." CAUSING ERROR SQL0901N "EXTRA COLUMNS REQUIRED FROM INPUT STREAM"

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • a select with "db2gse.ST_Contains(db2gse.ST_Polygon('POLYGO..."
    returns SQL0901N - Reason "Error: extra columns required from
    input stream."
    
    The -901 error in sqlno_post_pass happened while processing a
    HSJOIN because the columns it expected from one of its inputs
    did not match the columns provided. This is because the input
    plan contained an NLJOIN that did not apply some optional
    extender transform and index extension join predicates (these
    predicates sometimes get removed during NLJOIN construction) but
    the NLJOIN's join_preds_LS argument was not updated to reflect
    this. Later, during post-pass, this incorrect argument was used
    to detect which predicates had been applied and therefore which
    columns could be removed from the data flow (since they were no
    longer needed for any other purpose) and as a result some
    columns were removed too early.
    
    
    2019-11-13-06.50.02.031143-360 I3598E924             LEVEL:
    Severe
    PID     : 106429               TID : 140384671885056 PROC :
    db2sysc 0
    INSTANCE: ******              NODE : 000            DB   :
    ******
    APPHDL  : 0-2025               APPID: ******
    AUTHID  : *****              HOSTNAME:  ******
    EDUID   : 32335                EDUNAME: db2agent ( ******) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:250
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 48
    sqlerrmc: Error: extra columns required from input stream.
    sqlerrp : SQLNO11B
    sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0xFFFFFEB6      (6)
    0x00000000
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 11.1 MOD 4 Fix Pack 6                 *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 11.1 MOD 4 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32994

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-27

  • Closed date

    2021-03-16

  • Last modified date

    2021-03-16

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5"}]

Document Information

Modified date:
18 March 2021