PM64560: SA Dictionary Update can be unreasonably slow in large databases

APAR status

• Closed as program error.

Error description

• It may take a dictionary update days or weeks to run in a 12GB
  database.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The interaction between Dictionary Update and SQL Server
  works well with small encyclopedias but begins to bog down
  as encyclopedias get larger and larger.
  

Problem conclusion

• The interaction between Dictionary Update and SQL Server was
  rewritten so to process smaller subsets of data at one time,
  and to do that iteratively until the entire encyclopedia has
  bee processed.
  

Temporary fix

Comments

APAR Information

• 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

  TLOGIC SYS ARCH

• Fixed component ID

  5724V68SA

Applicable component levels

• RB31 PSN

     UP