On Wed, 26 Mar 2008 16:08:13 +0100, Fabio D'Alfonso <[EMAIL PROTECTED]> wrote:
>Hi, >I would know if moving from DB2 7 to DB2 8 changes the way SMF records are >created when running DB2 / CICS|BATCH|TSO commands. > >Thanks >Fabio D'Alfonso > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html Yes, it is possible that you will notice SMF 101 data volume / content changes, if you implement the new DB2 V8 option ACCUMACC. IBM did not add a "number of times package allocated" count (IFCID 0239) until DB2 v9, necessary with ACCUMACC and thread-reuse, in order to more accurately derive average statistics. Aside from DB2 V8, thread reuse can also contribute to SMF 101 data volume reduction, and presents some challenges with accurately counting thread- executions (field QWACPCNT) and packages-allocated (?) with a given SMF 101 record. Scott Barry SBBWorks, Inc. ________________________ DB2 Version 9.1 for z/OS - link to "New and Changed IFCIDs" documentation reference (mind any broken URL): http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc .relg/db2z_changedifcids.htm TDS DB2 Package/DBRM table info (a pkgs allocated column will be needed): http://publib.boulder.ibm.com/tividd/td/TDS390/SH19-6819- 08/en_US/HTML/DRLS9MST70.htm ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
