Fixes are available
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:
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