PQ61004: OPTIMIZE PERFORMANCE OF REPOSITORY LOAD JOB IN MODULE AUO#TAUL AND REPOSITORY BUILD DDL MEMBER AUO#DDL.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR provides a fix to reduce CPU usage while running the
  AUO#LOAD job.  Module AUO#TAUL was modified to reduce the
  instruction path, and member AUO#DDL has been modified to
  include the following indexes:
  
  CREATE TYPE 2 INDEX RS.SYSTABAUTH_IX2
    ON RS.SYSTABAUTH
    (GRANTOR         ASC
    ,GRANTEE         ASC
    ,SCREATOR       ASC
    ,STNAME           ASC
    ,TCREATOR       ASC
    ,TTNAME           ASC
    ,TB_CREATEDT ASC)
    USING STOGROUP MYSTOGROUP
       PRIQTY 100
       SECQTY 100
       ERASE  NO
      BUFFERPOOL BP0
    CLOSE      NO;
  
  CREATE TYPE 2 INDEX RS.SYSTABAUTH_IX3
    ON RS.SYSTABAUTH
    (GRANTEE         ASC
    ,SCREATOR       ASC
    ,STNAME           ASC
    ,TCREATOR       ASC
    ,TTNAME           ASC)
    USING STOGROUP MYSTOGROUP
       PRIQTY 100
       SECQTY 100
       ERASE  NO
      BUFFERPOOL BP0
  CLOSE      NO;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 Object Restore Users                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides a fix to reduce CPU  *
  *                      usage while running the AUO#LOAD job.   *
  *                      Module AUO#TAUL was modified to reduce  *
  *                      the instruction path, and member        *
  *                      AUO#DLL  has been modified to include   *
  *                      the following indexes:                  *
  *                                                              *
  *                      CREATE TYPE 2 INDEX RS.SYSTABAUTH_IX2   *
  *                                                              *
  *                        ON RS.SYSTABAUTH                      *
  *                        (GRANTOR    ASC                       *
  *                        ,GRANTEE    ASC                       *
  *                        ,SCREATOR   ASC                       *
  *                        ,STNAME     ASC                       *
  *                        ,TCREATOR   ASC                       *
  *                        ,TTNAME     ASC                       *
  *                        ,TB_CREATEDT ASC)                     *
  *                        USING STOGROUP MYSTOGROUP             *
  *                         PRIQTY 100                           *
  *                        SECQTY 100                            *
  *                        ERASE  NO                             *
  *                       BUFFERPOOL BP0                         *
  *                      CLOSE      NO;                          *
  *                                                              *
  *                      CREATE TYPE 2 INDEX RS.SYSTABAUTH_IX3   *
  *                        ON RS.SYSTABAUTH                      *
  *                       (GRANTEE        ASC                    *
  *                       ,SCREATOR       ASC                    *
  *                       ,STNAME         ASC                    *
  *                       ,TCREATOR       ASC                    *
  *                       ,TTNAME       ASC)                     *
  *                      USING STOGROUP MYSTOGROUP               *
  *                        PRIQTY 100                            *
  *                        SECQTY 100                            *
  *                        ERASE  NO                             *
  *                       BUFFERPOOL BP0                         *
  *                      CLOSE   NO;                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A code change has been made to correct this problem.
  

Problem conclusion

Temporary fix

Comments

• APPLY PTF
  

APAR Information

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

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

  UQ66745

Modules/Macros

•    AUO#DDL  AUO#TAUL H23L120J
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R120 PSY UQ66745

     UP02/07/11 P F207

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.