IBM Support

JR54304: DATABASE ATTRIBUTES ARE NOT POPULATED WHILE IMPORTING DATABASES FROM DB2 Z/OS USING IMAM/DB2CONNECTOR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Connector Access Service(CAS) enhancement done for JR53615 does
    not populate database attribute values such as DBMS if
      DB2 Connector describes the metadata with the following
    integrity issues:
    
      a) DataCollections (tables/views) are referenced by
    ForeignKeys or Aliases but have not been described.
      b) DataCollections (tables/views) are referenced by other
    objects such as DataFields(columns) but have not been described.
      c) DataFields are referenced by other objects but have not
    been described.
      d) CandidateKeys are referenced by other objects but have not
    been described.
      e) ForeignKeys are referenced by key components but have not
    been described.
      f) Indexes are referenced by index members but have not been
    described.
    
    
    
      Database attribute values should be populated even though
    connetor returns metadata with integrity issues.
    

Local fix

Problem summary

  • Connector Access Service(CAS) enhancement done for JR53615 does
    not populate database attribute values such as DBMS if
      DB2 Connector describes the metadata with the integrity
    issues. Database attribute values should be populated even
    though connector returns metadata with integrity issues.
    
    As default behavior, CAS bulk metadata import implementation
    ignores above integrity issues and continues to import with
    warning messages.
      This default behavior can be changed by invoking the following
    command on the domain tier.
      As result, metadata import will be failed if connector returns
    metadata that contains integrity issues.
    
      <InformationServer> /ASBServer/bin/PropertyAdmin -set -key
    cas.import.failonunresolved -value true
    

Problem conclusion

  • Fixed domain tier code of Connector Access Service to populate
    database attributes properly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR54304

  • Reported component name

    INFO SRVR PLATF

  • Reported component ID

    5724Q3612

  • Reported release

    B30

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-09-21

  • Closed date

    2015-09-27

  • Last modified date

    2015-09-27

  • 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

    INFO SRVR PLATF

  • Fixed component ID

    5724Q3612

Applicable component levels

  • RB31 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"InfoSphere Information Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.3","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 October 2021