IBM Support

IC95866: SQL0104N IS RETURNED WHEN UPDATING SYSSTAT.COLDIST.COLVALUE VIA DB2LOOK MIMIC MODE

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

  • The update of statistics of SYSSTAT.COLDIST.COLVALUE generated
    via db2look -m (mimic mode) may fail with SQL0104N error.
    
    The same output looks as follows:
    
    UPDATE SYSSTAT.COLDIST
    SET COLVALUE=''<value>  '',
          VALCOUNT=<value>
    WHERE COLNAME = '<value>' AND TABNAME =
    '<value>' AND TABSCHEMA = '<SCHEMA>    ' AND TYPE      =
    '<value>' AND SEQNO     =  <value>
    DB21034E  The command was processed as an SQL statement because
    it was not a valid Command Line Processor command.  During SQL
    processing it
    returned:
    SQL0104N  An unexpected token "<value>" was found following
    "DIST SET
    COLVALUE=''".  Expected tokens may include:  "CONCAT".
    SQLSTATE=42601
    
    This occurs because of character wrapping for COLVALUE: db2look
    -m adds
    two single quotes instead of one single quote.
    

Local fix

  • As a temporary workaround:
    
    
    Remove one single quote for the COLVALUE literal in
    the update statement, then run the statement again:
    
    UPDATE SYSSTAT.COLDIST SET COLVALUE='<value>  ',
    VALCOUNT=<value> WHERE COLNAME = '<value>' AND TABNAME =
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users on DB2 v10.1 FP2 and lower                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v10.1 FP4                                     *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 V10.1 FP4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95866

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-09-10

  • Closed date

    2017-10-10

  • Last modified date

    2017-10-10

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

    IC95710

  • 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

  • RA10 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
10 October 2017