IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    LI73180

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-02-26

  • Closed date

    2009-10-07

  • Last modified date

    2009-10-07

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021