IBM Support

JR47700: DB2LOOK GENERATES INCORRECT HIGH2KEY/LOW2KEY FOR CHAR/VARCHAR WHEN VARCHAR CAPATIBILITY IS ON

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When db2 cfg Varchar2 compatibility  is ON,the statement
    generated by db2look with HIGH2KEY/LOW2KEY=<space of 1
    byte>,when issue this statement ,it presents following error:
    'SQL0104N An unexpected token "," was found following
    "ENCHAR=-1, HIGH2KEY=".Expected tokens may
    include:"<update_source>".
    
    Error statement in db2look:
    UPDATE SYSSTAT.COLUMNS
    SET COLCARD=208,
        NUMNULLS=-1,
        SUB_COUNT=-1,
        SUB_DELIM_LENGTH=-1,
        AVGCOLLENCHAR=-1,
        HIGH2KEY= ,
        LOW2KEY= ,
        AVGCOLLEN=-1
    WHERE COLNAME = 'C1' AND TABNAME = 'sample1nk12' AND TABSCHEMA =
    'DB2INST8';
    
    [Repro steps]:
    1>Create db with Varchar2 compatibility ON.
    
    2>Create nickname against the remote Oracle table .
    
    3>Execute the procedure DBMS_STATS.SET_COLUMN_STATS() to modify
    the value of NUM_DISTINCT,the value of NUM_DISTINCT should be
    more than 4.
    
    SQL> begin
      2  DBMS_STATS.SET_COLUMN_STATS(ownname => 'JEFF',tabname =>
    'T100',colname=>'C1',distcnt=>'2.08000000000000E+002');
      3 end;
      4  /
    
    4>Check the value of num_distinct
    db2 =>  select num_distinct from sys.all_tab_columns where owner
    = '<OWN_NAME>' and table_name='<TABLE_NAME>' and
    column_name='<COLUMN_NAME>'
    NUM_DISTINCT
    ------------------------
      +2.08000000000000E+002
    
      1 record(s) selected.
    
    5> Drop old nickname
    
    6> Recreate the same nickname
    
    7>Issue db2look command:
     db2look -d sample -e -m -o db2look.sql -fedonly
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v97fp9                                            *
    ****************************************************************
    

Problem conclusion

  • First fixed in v97fp9
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR47700

  • Reported component name

    WS FA UTILITIES

  • Reported component ID

    5724N9716

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-08

  • Closed date

    2014-06-17

  • Last modified date

    2014-06-17

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

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

    JR47702 JR47705 JR47711

Fix information

  • Fixed component name

    WS FA UTILITIES

  • Fixed component ID

    5724N9716

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2014