The performance improvements that are made to the DB2 DAILY processing can substantially reduce the elapsed time that is used in the package/transaction sort/merge process that adds observations to the DB2DPP file.
This performance improvement is noticeable when DB2 SMF data contains more than one DB2 SMF type 101 subtype 1 package record for a SMF 101 subtype 0 transaction record. Previously, these records were written to work files that were subsequently sorted and merged. This product change expands the number of internal package arrays and saves multiple package records in storage, eliminating the need to write the records to work files hence eliminating the need for subsequent sort and merge.
|
Copyright © 2014 CA.
All rights reserved.
|
|