ca.portal.admin

T5B0169 testing. Rollforward results.

Discussion created by ca.portal.admin on Oct 7, 2008
Latest reply on Oct 8, 2008 by ca.portal.admin
I found the results quite interesting. Page requests were down about
52.5K, reads down, writes down, calc on target just a tad better, via on
target 2.5K better, less fragments stored, index activity just a wee bit
behind the only down side.

Rollforward of day one following load with fix:

29 SEP 08 12:24 EZ-REORG CATCH UP PHASE 3
DMCL: DMPCV006 SUBSCHEMA: SSPPCSLD=20
TOTAL DML PROCESSED : 8,182,863 =20
TOTAL COMMITS ISSUED : 0 =20
DBEXCUP3 DATABASE STATISTICS REPORT
=20
PAGES READ 1,370,414 =20
PAGES WRITTEN 1,268,135 =20
PAGES REQUESTED 13,532,582 =20
TIMES CALC RECORD FITS 24,463 =20
TIMES CALC REC OVERFLOW 5,874 =20
TIMES VIA RECORD FITS 1,018,663 =20
TIMES VIA RECORD OVERFLOW 131,390 =20
RECORDS REQUESTED 20,291,107 =20
RECORDS CURRENT OF R/U 5,606,919 =20
CALLS TO IDMS 9,362,171 =20
FRAGMENTS STORED 1,651 =20
SR8 SPLITS 947 =20
SR8 SPAWNS 15 =20
SR8S STORED 1,327 =20
B-TREE LEVELS SEARCHED 2,485,259

Rollforward of day one following load without fix:

5 OCT 08 22:36 EZ-REORG CATCH UP PHASE 3
DMCL: DMPCV006 SUBSCHEMA: SSPPCSLD=20
TOTAL DML PROCESSED : 8,182,863 =20
TOTAL COMMITS ISSUED : 0 =20
DBEXCUP3 DATABASE STATISTICS REPORT
=20
PAGES READ 1,376,679 =20
PAGES WRITTEN 1,271,893 =20
PAGES REQUESTED 13,585,095 =20
TIMES CALC RECORD FITS 24,460 =20
TIMES CALC REC OVERFLOW 5,877 =20
TIMES VIA RECORD FITS 1,016,179 =20
TIMES VIA RECORD OVERFLOW 133,872 =20
RECORDS REQUESTED 20,291,630 =20
RECORDS CURRENT OF R/U 5,606,919 =20
CALLS TO IDMS 9,362,171 =20
FRAGMENTS STORED 1,742 =20
SR8 SPLITS 946 =20
SR8 SPAWNS 14 =20
SR8S STORED 1,325 =20
B-TREE LEVELS SEARCHED 2,485,258

Day 2 saw similar results in most categories but did store 10 more
fragments in the fix loaded image, still staying ahead in fragmentation.
Again about 50K less page requests. Day 3 page requests were down 80K,
fragments down again. Day 4 I saw writes up 2K for the first time in
the fix-loaded image, but again page requests were down, the time about
76K. Day 5 was a light weekend day with little differences, 26K less
page requests in the fix-loaded image. Day 6 a large batch purge job
was run and the results are quite interesting.

Rollforward of day six following load with fix:

30 SEP 08 10:09 EZ-REORG CATCH UP PHASE 3
DMCL: DMPCV006 SUBSCHEMA: SSPPCSLD=20
TOTAL DML PROCESSED : 14,878,412 =20
TOTAL COMMITS ISSUED : 0 =20
DBEXCUP3 DATABASE STATISTICS REPORT
=20
PAGES READ 3,600,991 =20
PAGES WRITTEN 3,606,391 =20
PAGES REQUESTED 25,332,483 =20
TIMES CALC RECORD FITS 1,560 =20
TIMES CALC REC OVERFLOW 1,359 =20
TIMES VIA RECORD FITS 55,894 =20
TIMES VIA RECORD OVERFLOW 6,571 =20
RECORDS REQUESTED 40,738,622 =20
RECORDS CURRENT OF R/U 7,513,148 =20
CALLS TO IDMS 14,943,739 =20
FRAGMENTS STORED 224 =20

Rollforward of day six following load without fix:

6 OCT 08 17:01 EZ-REORG CATCH UP PHASE 3
DMCL: DMPCV006 SUBSCHEMA: SSPPCSLD=20
TOTAL DML PROCESSED : 14,878,412 =20
TOTAL COMMITS ISSUED : 0 =20
DBEXCUP3 DATABASE STATISTICS REPORT
=20
PAGES READ 3,838,959 =20
PAGES WRITTEN 3,844,843 =20
PAGES REQUESTED 29,662,932 =20
TIMES CALC RECORD FITS 1,566 =20
TIMES CALC REC OVERFLOW 1,353 =20
TIMES VIA RECORD FITS 56,374 =20
TIMES VIA RECORD OVERFLOW 6,091 =20
RECORDS REQUESTED 40,738,664 =20
RECORDS CURRENT OF R/U 7,513,148 =20
CALLS TO IDMS 14,943,739 =20
FRAGMENTS STORED 233 =20

I pulled all the index stats because they were identical, but I'd say
4.3 Million less page requests says it all. 200K+ less reads and writes
also. I guess this fix may be a keeper. Day 7 was the last day rolled
on both images. Again I'm seeing 80K less page requests and better via
on target, with other differences relatively insignificant.

John


P Please consider the environment before printing this e-mail

Cleveland Clinic is ranked one of the top hospitals in America by U.S.
News & World Report (2008). =20
Visit us online at http://www.clevelandclinic.org for a complete listing
of our services, staff and locations.


Confidentiality Note: This message is intended for use only by the
individual or entity to which it is addressed and may contain
information that is privileged, confidential, and exempt from disclosure
under applicable law. If the reader of this message is not the intended
recipient or the employee or agent responsible for delivering the
message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please
contact the sender immediately and destroy the material in its entirety,
whether electronic or hard copy. Thank you.
-------------------------------------------------------------------------=

My e-mail address has been harmonized into @dexia.com !
Please remember to update your contact list.
Veuillez noter que mon adresse e-mail est harmonis=E9e en @dexia.com !
N'oubliez pas de mettre =E0 jour votre liste de contacts.
Meine E-Mailadresse wurde harmonisiert zu @dexia.com
Vergessen Sie nicht Ihre Kontaktadresse anzupassen.
Mijn e-mailadres is geharmoniseerd naar @dexia.com.
Vergeet niet uw contactenlijst aan te passen.
-------------------------------------------------------------------------=

Dexia disclaimer:
http://www.dexia.com/maildisclaimer.htm
-------------------------------------------------------------------------=
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: T5B0169 testing. Rollforward results.
"Hi Rabat,

John volunteered to do some testing on a very early version of the next release of EZ-Reorg. This release produces the database statistics in DBEZCUP3.

No date for general realise yet.

Pete

Outcomes