IBM Support

IZ19582: POTENTIAL ERROR IN QP MANAGED QUERY IF A USER HAS GROUP IDS THAT ARE LARGER THAN 8 BYTES AND HAVE A LENGTH NOT DIVISIBLE BY 8.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • There is a potential to receive syntax errors in queries managed
    by QP if the user has group ids that are larger than 8 bytes in
    length and those group id lengths are not divisible by 8.
    
    The syntax errors can vary and change between executions.
    
    
    There is also the potential that the group ids will not be
    identified by QP as part of the user profile.
    

Local fix

Problem summary

  • There is a potential to receive syntax errors in queries managed
    by QP if the user has group ids that are larger than 8 bytes in
    length and those group id lengths are not divisible by 8.
    
    The syntax errors can vary and change between executions.
    
    
    There is also the potential that the group ids will not be
    identified by QP as part of the user profile.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 6 (s081007).
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ19582

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-08

  • Closed date

    2008-11-03

  • Last modified date

    2008-11-03

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

    IZ19160

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

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

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

Document Information

Modified date:
03 November 2008