IBM Support

IZ24751: AFTER QUIESCE-ING THE DB AND UNQUIESE-ING IN A DIFFERENT SESSION, QUERIES ARE NO LONGER INTERCEPTED BY QP.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After QUIESCE-ing the DB and UNQUIESE-ing in a different
    session, queries are no longer intercepted by QP.
    
    
    Scenario:
    
    DYN_QUERY_MGMT ENABLE
    
    db2 connect to $DB
    db2 quiesce db immediate
    db2 terminate
    
    db2 connect to $DB
    db2 unquiesce db
    db2 -x "select count(*) from syscat.tables"
    
    The above query returns a result instead of
    SQL29007N message.
    

Local fix

  • Run QUIESCE and UNQUIESCE within same connection (session),
    

Problem summary

  • USERS AFFECTED: All using QP.
    
    PROBLEM DESCRIPTION:
    
    After QUIESCE-ing the DB and UNQUIESE-ing in a different
    session, queries are no longer intercepted by QP.
    
    
    Scenario:
    
    DYN_QUERY_MGMT ENABLE
    
    db2 connect to $DB
    db2 quiesce db immediate
    db2 terminate
    
    db2 connect to $DB
    db2 unquiesce db
    db2 -x "select count(*) from syscat.tables"
    
    The above query returns a result instead of
    SQL29007N message.
    
    PROBLEM SUMMARY:
    
    see problem description.
    

Problem conclusion

  • The complete fix for this problem first appears in DB2 UDB
    Version 8.1 FixPak 18.
    

Temporary fix

  • Run QUIESCE and UNQUIESCE within same connection (session).
    

Comments

APAR Information

  • APAR number

    IZ24751

  • Reported component name

    DB2 UDB QP AIX

  • Reported component ID

    5724E2500

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-06-17

  • Closed date

    2009-09-11

  • Last modified date

    2009-09-11

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

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

    IZ24760 IZ24765

Fix information

  • Fixed component name

    DB2 UDB QP AIX

  • Fixed component ID

    5724E2500

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGA","label":"Db2 Query Patroller"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"820","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 September 2009