LI73180: FP5: DB2 CONTROL CENTER DOES NOT DISPLAY THE BIORS WRAPPER.

DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• After successfully creating the BioRS wrapper from the DB2
  command window, customer is unable to see the wrapper from
  within Control Center.
  
  The commands customer used to create the wrapper are as follows:
  
  -- Drop the existing BioRS wrapper.
  drop wrapper biors;
  
  -- Create the BioRS wrapper.
  create wrapper biors library 'libdb2lsbiors.so';
  
  -- Drop the BioRS server.
  drop server biors;
  
  -- Create the BioRS server.
  create server biors type biors version 5.2 wrapper biors
  options (node 'nabriclu.nafta.syngenta.org', port '6666');
  
  -- Create the user mappings.
  create user mapping for user server biors
  options (guest 'N', remote_authid 'gbpuser', remote_password
  'gbpdwr2');
  
  -----
  Customer can see the wrapper was created via the cmd-line:
  
  -bash-3.00$ db2 "select wrapname from syscat.wrappers"
  
  WRAPNAME
  ------------------------------------------------
  BIORS
  ENTREZ
  MSSQLODBC3
  NET8
  WEBSERVICES
  
    5 record(s) selected.
  -----
  
  To view this wrapper from within Control Center, customer would
  (from the left pane of the GUI), click All Databases -> my
  database -> Federated Database Objects .  Customer cannot see
  "BIORS" as an available wrapper.  Customer can, however, see his
  NET8, WEBSERVICES, and MSSQLODBC3 wrappers.  Also, as soon as
  customer click the "Federated Database Objects" item the
  following errors are spooled to the xterm console from where
  customer invoked "db2cc":
  
  fatal parse error:
  line number: 8
  column number: 117
  message: Open quote is expected for attribute "hpux" associated
  with an
  element type  "libraries".
  fatal parse error:
  line number: 8
  column number: 121
  message: Element type "libraries" must be followed by either
  attribute
  specifications, ">" or "/>".
  fatal parse error:
  line number: 7
  column number: 118
  message: Open quote is expected for attribute "hpux" associated
  with an
  element type  "libraries".
  

Local fix

• The problem is due to the biors.xml file which was not the well
  formed one. In the biors.xml file one line is there like this:
  
  <libraries aix="libdb2lsbiors.a" windows="db2lsbiors.dll"
  solaris="libdb2lsbiors.so" linux="libdb2lsbiors.so"
  hpux=libdb2lsbiors.so" />
  
  We can see the missing " after hpux= . So that the fatal error
  was coming and could not able to parse the document. This place
  should be like this hpux="libdb2lsbiors.so"
  
  This biors.xml file is in the installation directories as
  follows /sqllib/cfg/biors.xml .
  

Problem summary

• Users affected:
     Users of the DB2 for LUW Homogeneous Federation Feature or
  InfoSphere Federation Server
  Problem description and summary:
     See error description.
  

Problem conclusion

• Problem was first fixed in Version 9.1 FixPak 8 (s090823). This
  fix should be applied on the federation server.
  

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:

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSN

     UP