IBM Support

JR24152: FEDERATED QUERIES FAIL WITH SQL1101N WHEN DB2_FENCED=Y AND NO US ER MAPS EXIST.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Some federated queries fail with SQL1101N when db2_fenced=Y and
    no user maps exist.
    

Local fix

Problem summary

  • Users affected:
    Federated queries using version 8 fixpak 11 and 12 under the
    following conditions:
    - ESE/DPF environment
    - Wrapper DB2_FENCED = 'Y'
    - No user mapping is defined for connecting DB2 user
    - Federated parallel plan is enabled, i.e., fetching data from
    nickname is happening in a DB2 subagent.
    
    Problem Description:
    Federated query receives the following sql error message:
    SQL1101N  Remote database "<dbname>" on node "" could not be
    accessed with
    the specified authorization id and password.  SQLSTATE=08004
    
    Problem Summary:
    The db2 subagent receives a null string instead of a password
    

Problem conclusion

  • Only impacts federated query under the special conditions above
    First fixed in DB2 UDB Version 8, FixPak 11
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR24152

  • Reported component name

    WS II DRDA WRAP

  • Reported component ID

    5724C7406

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-06-09

  • Closed date

    2006-11-28

  • Last modified date

    2006-11-28

  • 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

    WS II DRDA WRAP

  • Fixed component ID

    5724C7406

Applicable component levels

  • R810 PSY

       UP

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

Document Information

Modified date:
08 January 2022