IBM Support

JR22281: DB2 CONNECT V8 AGAINST DB2 Z/OS V7 RETURNS SQL0204, WHEN ACCESSING SYNONYMS ON HOST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Starting with DB2 V8, a host synonym is returned in the form
    schemaname.synonymname. When using this retuned value to access
    the host synonym, SQL0204 is returned. Host synonyms can be
    accessed with the synonym name only. This worked correctly in
    DB2 V7, as host synonym names are returned without a schema
    name.
    

Local fix

Problem summary

  • Starting with DB2 V8, a host synonym is returned in the form
    schemaname.synonymname. When using this retuned value to access
    the host synonym, SQL0204 is returned. Host synonyms can be
    accessed with the synonym name only. This worked correctly in
    DB2 V7, as host synonym names are returned without a schema
    name.
    

Problem conclusion

  • Problem was first fixed in Version 8.1 FixPak 12 (s060429)
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR22281

  • Reported component name

    DB2 CPE WINDOWS

  • Reported component ID

    5724B5601

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-01-16

  • Closed date

    2006-05-19

  • Last modified date

    2006-05-19

  • 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 CPE WINDOWS

  • Fixed component ID

    5724B5601

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"820"}]

Document Information

Modified date:
07 October 2021