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

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 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