IBM Support

JR23641: VERSION 8 VE IS NOT HANDLING NON-ORDINARY IDENTIFIERS FOR OBJECT NAMES CORRECTLY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you have an object name with non-ordinary identifiers Visual
    Explain does not handle them correctly.
    
    For example. A Schema name with a period in it. test.admin. When
    using Visual Explain and logged in as test.admin the tables for
    VE will be created correctly via the script but when in VE and
    it goes to select from the VE tables it will get errors.
    
    SQL0204N "TEST.ADMIN.EXPLAIN_STATEMENT" is an undefined name.
    

Local fix

  • Don't use non-ordinary object names.
    

Problem summary

  • VERSION 8 VE IS NOT HANDLING NON-ORDINARY IDENTIFIERS FOR OBJECT
    NAMES CORRECTLY
    
    Users Affected: Visual Explain users in V8 with user ids that
    have non-ordinary identifiers.
    
    Problem Description:
    
    If you have an object name with non-ordinary identifiers Visual
    Explain does not handle them correctly.
    
    For example. A Schema name with a period in it. test.admin. When
    using Visual Explain and logged in as test.admin the tables for
    VE will be created correctly via the script but when in VE and
    it goes to select from the VE tables it will get errors.
    
    SQL0204N "TEST.ADMIN.EXPLAIN_STATEMENT" is an undefined name.
    

Problem conclusion

  • Problem was first fixed in Version 8 Fixpak 13 (s060801).
    At a minimum, this fix should be applied on the client.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR23641

  • Reported component name

    DB2 UDB EXE WIN

  • Reported component ID

    5724E4901

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-04-06

  • Closed date

    2006-10-03

  • Last modified date

    2006-10-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    JR24493

Fix information

  • Fixed component name

    DB2 UDB EXE WIN

  • Fixed component ID

    5724E4901

Applicable component levels

  • R820 PSY

       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:
06 October 2021