IBM Support

JR37502: PERCENT SIGN (%) IN DATA PATH OF THE DATA STORE WITH DB2CONNECTOR. CAUSES FAILURE DURING COLUMN ANALYSIS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a DB2Connector data store is created, a percent sign (%)
    is populated in the data path section of the data store.
    Everything works ok.  Meta data import is successful.  No errors
    at this point.
    When column analysis is run, the process aborts.  The following
    is found in the SystemOut.log
    Exit:AgentImpl.getResponse [more=false, responseTime=34390000,
    exception=false,
    data=[<Database><Value version="09.05.0003" DBMS="DB2" path="%"
    server="
    ServerName"
    host="ServerName">DB Name</Value></Database>]]
    

Local fix

  • During table meta data import, the connector attempts to set the
    Database / Path field to an empty string.  Unfortunately under
    certain circumstances the memory in which that empty string is
    stored can become corrupted with a percent sign.  Once that
    corruption occurs, any future imports of table meta data will
    have a percent sign in the Database / Path field.  The
    corruption on future imports will continue until the ASB Agent
    process is restarted.  In order to work around the problem, you
    must first restart the ASB Agent process to clear the
    corruption.  Then during meta data import, you must always type
    something in the "Name search filter" field.  If you ever leave
    that field blank and continue to the next screen, the corruption
    will occur and you must again restart the ASB Agent to clear the
    corruption.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    On AIX, the DB2 Connector meta data import puts a percent in
    the path so IA Column Analysis fails
    ****************************************************************
    PROBLEM DESCRIPTION:
    During table meta data import, the DB2 Connector attempts to
    set the Path field to an empty string. But under certain
    circumstances the memory in which that empty string is stored
    can become corrupted with a percent sign.  Once that corruption
    occurs, any future imports of table meta data will have a
    percent sign in the Path field which causes Information Analyzer
    Column Analysis to fail with an error such as the following:
    
    pxbridge,0: [IIS-CONN-DB2-000004] DB2 function SQLExecute
    failed: SQLSTATE = 42601: Native Error Code = -104: Msg =
    [IBM][CLI Driver][DB2] SQL0104N  An unexpected token "%" was
    found following "".  Expected tokens may include:  "( TABLE
    FINAL <IDENTIFIER> XMLTABLE". SQLSTATE=42601
    (CC_DB2DBStatement::executeSelect, file CC_DB2DBStatement.cpp,
    line 1,421)
    
    The corruption on future imports will continue until the ASB
    Agent process is restarted.  In order to work around the
    problem, you must first restart the ASB Agent process to clear
    the corruption.  Then during meta data import, you must always
    type something in the "Name search filter" field.  If you ever
    leave that field blank and continue to the next screen, the
    corruption will occur and you must again restart the ASB Agent
    to clear the corruption.
    
    ****************************************************************
    RECOMMENDATION:
    Install the patch for JR37502 which has a prerequisite that the
    patch for JR36020 is already installed.
    ****************************************************************
    

Problem conclusion

  • The connector now imports correctly and leaves the Path field
    blank.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR37502

  • Reported component name

    WIS INFORM ANAL

  • Reported component ID

    5724Q36IA

  • Reported release

    812

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-16

  • Closed date

    2010-09-02

  • Last modified date

    2010-09-02

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

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

Modules/Macros

  • ENGINE
    

Fix information

  • Fixed component name

    WIS INFORM ANAL

  • Fixed component ID

    5724Q36IA

Applicable component levels

  • R812 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1.2","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 September 2010