Using ActiveState Perl For Windows to Parse 3

[pmking]

Hello All,

I have a parsing question. I have a formated report that I need to parse through and extract certain pieces of the text file.

Firsl of all, I am new to Perl, and I am not sure where to begin.

What I would like to do is:

1. Create a GUI interface so users can input where their text file that needs parsing is located on their pc.

2. Have a perl script (created via ActiveState Perl for windows) run against the text file and extract only what is needed, and output it to an excel spreadsheet. Not sure if this can be, the output to an excel spreadsheet.

I am not sure where to begin with the perl script, since the text file that I need to parse is formatted already. There are tabs, spaces, colons, dashes throughout this text file.

Am I on the right track by using perl? And if so, can somebody please, please help me get a start?

Thanks.

 

[pmking]

Here is a copy and paste of the report, and what I need is in [red]red[/red]. Pleae keep in mind that the actual report looks a lot better than this cut and paste effort of mine, but this is the meat of it:



[red]LOCATION: HODHD0A[/red] DB2 PERFORMANCE EXPERT (V2) PAGE: 1-1
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD2A TO: NOT SPECIFIED
[red]SUBSYSTEM: HD2A[/red] ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:38:04.68
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:38:04.68

[red]PRIMAUTH: DNCS PLANNAME: PUOJLK[/red]

ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL |==> 5% CPU |=====================> 42%
DB2 |=========================> 51% NOTACC |======> 12%
SUSP |======================> 44% SUSP |=======================> 46%

[red]AVERAGE APPL(CL.1) DB2 (CL.2)[/red] IFI (CL.5) CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT HIGHLIGHTS
------------ ---------- ---------- ---------- -------------------- ------------ -------- --------------------------
[red]ELAPSED TIME 2.148450 2.034667[/red] N/P LOCK/LATCH(DB2+IRLM) 0.000004 1.00 [red]#OCCURRENCES : 1[red]
NONNESTED 2.148450 2.034667 N/A SYNCHRON. I/O 0.469795 186.00 #ALLIEDS : 1
STORED PROC 0.000000 0.000000 N/A DATABASE I/O 0.469795 186.00 #ALLIEDS DISTRIB: 0
UDF 0.000000 0.000000 N/A LOG WRITE I/O 0.000000 0.00 #DBATS : 0
TRIGGER 0.000000 0.000000 N/A OTHER READ I/O 0.029127 4.00 #DBATS DISTRIB. : 0
OTHER WRTE I/O 0.000000 0.00 #NO PROGRAM DATA: 0
[red]CPU TIME 0.877399 0.852685[/red] N/P SER.TASK SWTCH 0.438192 13.00 #NORMAL TERMINAT: 1
AGENT 0.877399 0.852685 N/A UPDATE COMMIT 0.000000 0.00 #ABNORMAL TERMIN: 0
NONNESTED 0.877399 0.852685 N/P OPEN/CLOSE 0.344680 6.00 #CP/X PARALLEL. : 0
STORED PRC 0.000000 0.000000 N/A SYSLGRNG REC 0.023699 3.00 #IO PARALLELISM : 0
UDF 0.000000 0.000000 N/A EXT/DEL/DEF 0.069813 4.00 #INCREMENT. BIND: 0
TRIGGER 0.000000 0.000000 N/A OTHER SERVICE 0.000000 0.00 [red]#COMMITS : 1[/red]
PAR.TASKS 0.000000 0.000000 N/A ARC.LOG(QUIES) 0.000000 0.00 #ROLLBACKS : 0
ARC.LOG READ 0.000000 0.00 #SVPT REQUESTS : 0
SUSPEND TIME 0.000000 0.937118 N/A DRAIN LOCK 0.000000 0.00 #SVPT RELEASE : 0
AGENT N/A 0.937118 N/A CLAIM RELEASE 0.000000 0.00 #SVPT ROLLBACK : 0
PAR.TASKS N/A 0.000000 N/A PAGE LATCH 0.000000 0.00 MAX SQL CASC LVL: 0
STORED PROC 0.000000 N/A N/A NOTIFY MSGS 0.000000 0.00 UPDATE/COMMIT : 0.00
UDF 0.000000 N/A N/A GLOBAL CONTENTION 0.000000 0.00 SYNCH I/O AVG. : 0.002526
COMMIT PH1 WRITE I/O 0.000000 0.00
NOT ACCOUNT. N/A 0.244864 N/A ASYNCH CF REQUESTS 0.000000 0.00
DB2 ENT/EXIT N/A 184.00 N/A TOTAL CLASS 3 0.937118 204.00
EN/EX-STPROC N/A 0.00 N/A
EN/EX-UDF N/A 0.00 N/A
DCAPT.DESCR. N/A N/A N/P
LOG EXTRACT. N/A N/A N/P

GLOBAL CONTENTION L-LOCKS AVERAGE TIME AV.EVENT GLOBAL CONTENTION P-LOCKS AVERAGE TIME AV.EVENT
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0.00 P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-2
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD2A TO: NOT SPECIFIED
SUBSYSTEM: HD2A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:38:04.68
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:38:04.68

PRIMAUTH: DNCS PLANNAME: PUOJLK

SQL DML AVERAGE TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER LOCKING AVERAGE TOTAL
-------- -------- -------- -------------- -------- ---------- ------ ------ ------ ---------------------- -------- --------
SELECT 63.00 63 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0.00 0
INSERT 0.00 0 GRANT 0 CRT TTABLE 0 N/A N/A [red]DEADLOCKS 0.00 0[/red]
UPDATE 0.00 0 REVOKE 0 DCL TTABLE 0 N/A N/A ESCAL.(SHARED) 0.00 0

 

[pmking]

Correction from pmking....

I neglected to mark the 'From time' and the 'To time'. Sorry I forgot to mark that in red..

 

[KevinADC]

if you are still using the code you posted on 15 Sep 06 14:07 this section needs to be corrected:

my ($location, $subsystem, $fromtime, $totime,
    $primauth, $planname, $average, $applcl1,
    $db2cl2, $cputime, $occurrences, $commits,
    $rollbbacks, $deadlocks) =

the '=' on the end needs to be a semi-colon ';' see below:

my ($location, $subsystem, $fromtime, $totime,
    $primauth, $planname, $average, $applcl1,
    $db2cl2, $cputime, $occurrences, $commits,
    $rollbbacks, $deadlocks);

 

[KevinADC]

going by the data you posted and your code above, the regexp's needed to be tweaked quite a lot. You have some patterns tied to the beginning of the lines with ^ but the patterns are elsewhere in the lines. Some the capture pattern was not correct. Some have leading spaces you did not account for. I came up with this quickly, it's not meant to be a complete solution but you can see where the regexp's were changed to match the data:

my $file = $ARGV[0]; # 1st command line argument
open(REPORT, $file) or die "Can't open file $file, $!\n";

my ($location, $subsystem, $fromtime, $totime,
    $primauth, $planname, $average, $applcl1,
    $db2cl2, $cputime, $occurrences, $commits,
    $rollbbacks, $deadlocks);

while (<DATA>) {
   chomp;
   if (/^\s*LOCATION:\s*(\w+)/) {
      $location = "LOCATION: $1";
   }
    elsif (/^\s*SUBSYSTEM:\s*(\w+)/) {
      $location = "SUBSYSTEM: $1";
   }
    elsif (/^\s*PRIMAUTH:\s*(\S+)\s*PLANNAME:\s*(\S+)/) {
      $location = "PRIMAUTH: $1 PLANNAME: $2";
   }
    elsif (/^\s*INTERVAL\sFROM:\s*(\w+)/) {
      $location = "INTERVAL\sFROM:: $1";
   }
    elsif (/\s*TO:\s*([\w\s\/:]+)/) {  
      $location = "TO: $1";
   }
    elsif (/\s*#OCCURRENCES\s*:\s*(\S+)/) {
      $location = "OCCURRENCES: $1";
   }
    elsif (/^\s*ELAPSED\sTIME\s*([\d.]+)/) {
      $location = "ELAPSED TIME: $1";
   }
    elsif (/^\s*CPU\sTIME\s*(\S+)/) {
      $location = "CPU TIME: $1";
   }
    elsif (/\s*DEADLOCKS\s*(\d+\s\d+)/) {
      $location = "DEADLOCKS: $1";
   }
    else {
      next;
   }
   print "$location\n";
}
close(REPORT);

with the data you posted the output is:

LOCATION: HODHD0A
TO: NOT SPECIFIED
SUBSYSTEM: HD2A
TO: 12/01/05 01:38:04
PRIMAUTH: DNCS PLANNAME: PUOJLK
OCCURRENCES: 1
CPU TIME: 0.877399
LOCATION: HODHD0A
TO: NOT SPECIFIED
SUBSYSTEM: HD2A
TO: 12/01/05 01:38:04
PRIMAUTH: DNCS PLANNAME: PUOJLK

 

[KevinADC]

this line:

while (<DATA>) {

should be:

while (<REPORT>) {

 

[pmking]

Thank so much KebinADC!!

Question: is there some other perl technique I should use so I can be prompted for the file I want to parse?

Quick note:

1. We have to run some Mainframe JCL to create the report, and this JCL is not allowed to be changed, thus resulting in a pre-formated report which we FTP to our pc. Since we FTP the formatted report to our pc, not all of us save the report in the same place on our pc. That is why I am asking if there is a way for me to have perl prompt me what file do I want to parse?

Thanks.

 

[KevinADC]

print "Enter the file you want to parse: ";
chomp($filename = <STDIN>);

 

[stevexff]

Don't ask for a file at all. Perl will automatically open and catenate a list of files on its command line.

use warnings;
use strict;

while (<>) {
   # your code here
}

To execute it

perl reportRipper.pl db2report.txt

or even

perl reportRipper.pl db2report.txt db2report2.txt

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[pmking]

KevinADC and Stevexff,

Stevexff, I am not sure how to piece your code in. I am running the code but I am not getting any output through my komodo output window, which also means, I assume no errors. I am thinking that now I have to come up with some code to output to an excel spreadsheet or something, right?. Note I am new to komodo

KevinADC,
To try your suggestion, I need to put the following at the top of the code, right?

[red]print "Enter the file you want to parse: ";
chomp($filename = <STDIN>);[/red]

If so, then do need to give an "explicit package name, to $filename", right?

Thanks to the both of you so much!!

 

[KevinADC]

Where you put the lines depends on the script, but obviously it has to be before the inputed data is needed by the script to continue. And yes, you need to package the variable if using strint, which I should have shown in my first example:

print "Enter the file you want to parse: ";
chomp([b]my[/b] $filename = <STDIN>);

 

[pmking]

Hello KevinADC,

Again thanks..

So I am running this script with your suggestions, and I am prompted for a file.

I put the entire windows path of where the file I want to parse is located.

And it just runs and runs without printing any output.

Here is the code in its entirety:

print "Enter the file you want to parse: ";
chomp(my $filename = <STDIN>);

my ($location, $subsystem, $fromtime, $totime,
$primauth, $planname, $average, $applcl1,
$db2cl2, $cputime, $occurrences, $commits,
$rollbbacks, $deadlocks);

while (<>) {
chomp;
if (/^\s*LOCATION:\s*(\w+)/) {
$location = "LOCATION: $1";
}
elsif (/^\s*SUBSYSTEM:\s*(\w+)/) {
$location = "SUBSYSTEM: $1";
}
elsif (/^\s*PRIMAUTH:\s*(\S+)\s*PLANNAME:\s*(\S+)/) {
$location = "PRIMAUTH: $1 PLANNAME: $2";
}
elsif (/\s*INTERVAL:\sFROM:\s*(\w+)/) {
$location = "FROM: $1";
}
elsif (/^\s*TO:\s*([\w\s\/:]+)/) {
$location = "TO: $1";
}
elsif (/\s*#OCCURRENCES\s*:\s*(\S+)/) {
$location = "OCCURRENCES: $1";
}
elsif (/^\s*ELAPSED\sTIME\s*([\d.]+)/) {
$location = "ELAPSED TIME: $1";
}
elsif (/^\s*CPU\sTIME\s*(\S+)/) {
$location = "CPU TIME: $1";
}
elsif (/\s*DEADLOCKS\s*(\d+\s\d+)/) {
$location = "DEADLOCKS: $1";
}
else {
next;
}
print "$location\n"; #how come location isn't printing?
}
close($filename);

 

[KevinADC]

print "Enter the file you want to parse: ";
chomp(my $filename = <STDIN>);

my ($location, $subsystem, $fromtime, $totime,
    $primauth, $planname, $average, $applcl1,
    $db2cl2, $cputime, $occurrences, $commits,
    $rollbbacks, $deadlocks);

open(FH,"<$filename") or die "Can't open $filename: $!";
while(<FH>){
   chomp;
   if (/^\s*LOCATION:\s*(\w+)/) {
      $location = "LOCATION: $1";
   }
    elsif (/^\s*SUBSYSTEM:\s*(\w+)/) {
      $location = "SUBSYSTEM: $1";
   }
    elsif (/^\s*PRIMAUTH:\s*(\S+)\s*PLANNAME:\s*(\S+)/) {
      $location = "PRIMAUTH: $1 PLANNAME: $2";
   }
    elsif (/\s*INTERVAL:\sFROM:\s*(\w+)/) {
      $location = "FROM: $1";
   }
    elsif (/^\s*TO:\s*([\w\s\/:]+)/) {  
      $location = "TO: $1";
   }
    elsif (/\s*#OCCURRENCES\s*:\s*(\S+)/) {
      $location = "OCCURRENCES: $1";
   }
    elsif (/^\s*ELAPSED\sTIME\s*([\d.]+)/) {
      $location = "ELAPSED TIME: $1";
   }
    elsif (/^\s*CPU\sTIME\s*(\S+)/) {
      $location = "CPU TIME: $1";
   }
    elsif (/\s*DEADLOCKS\s*(\d+\s\d+)/) {
      $location = "DEADLOCKS: $1";
   }
    else {
      next;
   }
   print "$location\n"; #how come location isn't printing?
}
close(FH);

 

[pmking]

Thank you for the input KevinADC,

Can I open up "Windows file path directory" using this code?

The reason I am asking is that the output message via my komodo is giving me the message below:

------start of output message from script---------------
Enter the file you want to parse: C:\Mainframe Reports\DB2 Report\dnds8945.txt
Can't open Enter the file you want to parse: C:\Mainframe Reports\DB2 Report\dnds8945.txt: Invalid argument at C:\Program Files\ActiveState Komodo 3.5\Parse-DB2 Accounting.txt line 22, <STDIN> line 1.
------end of output message from script-----------------

I have been trying to debug all weekend and yesterday and decided to comeback to this great forum for help..

Thanks.

 

[pmking]

Okay, I figured out what was wrong "I must admit, it is a good feeling when you are learning something and you figure out the problem..

The problem was the input statement, I did not have \n at the end to end the carriage return..

Another question though:

I have a varible labled "CPU TIME", what if there are multiple "CPU TIMES"? How do I tell it to capture one time?

BUT, yes there is a BUT. The report will have multiple "CPU TIMES" per DB2 Auth-ID. So for every auth-id you will have a sections in the report that will display performance information per auth-id, which means, each section has the same format including a summary. Hope this makes sense.

Here is a an example of I am talking about:

Note that the variables I have in the code are in the report multiple times, meaning that I have to continue the parse to meet certain 'strickt' criteris. I will color code each part of one report that has multiple auth-id's in one report.

----------start of sample report---------------------

[red]LOCATION: HODHD0A[/red] DB2 PERFORMANCE EXPERT (V2) PAGE: 1-1
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
[red]SUBSYSTEM: HD1A[/red] ORDER: PRIMAUTH-PLANNAME INTERVAL [red]FROM: 12/01/05 01:32:52.88[/red]
DB2 VERSION: V8 SCOPE: MEMBER [red]TO: 12/01/05 01:32:55.84[/red]

[red]PRIMAUTH: DNCS PLANNAME: PUOF0K[/red]

ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL |===> 7% CPU |==========================================> 84%
DB2 |============================================> 89% NOTACC |======> 12%
SUSP |==> 4% SUSP |==> 4%

AVERAGE APPL(CL.1) DB2 (CL.2) IFI (CL.5) CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT HIGHLIGHTS
------------ ---------- ---------- ---------- -------------------- ------------ -------- --------------------------
[red]ELAPSED TIME 1:36.67624 1:29.82381[/red] N/P LOCK/LATCH(DB2+IRLM) 0.100177 54.00 [red]#OCCURRENCES : 1[/red]
NONNESTED 1:36.67624 1:29.82381 N/A SYNCHRON. I/O 1.329731 694.00 #ALLIEDS : 1
STORED PROC 0.000000 0.000000 N/A DATABASE I/O 1.329731 694.00 #ALLIEDS DISTRIB: 0
UDF 0.000000 0.000000 N/A LOG WRITE I/O 0.000000 0.00 #DBATS : 0
TRIGGER 0.000000 0.000000 N/A OTHER READ I/O 0.308740 24.00 #DBATS DISTRIB. : 0
OTHER WRTE I/O 0.000000 0.00 #NO PROGRAM DATA: 0
[red]CPU TIME 1:21.08887 1:15.62152[/red] N/P SER.TASK SWTCH 1.705546 48.00 #NORMAL TERMINAT: 1
AGENT 1:21.08887 1:15.62152 N/A UPDATE COMMIT 0.000000 0.00 #ABNORMAL TERMIN: 0
NONNESTED 1:21.08887 1:15.62152 N/P OPEN/CLOSE 1.311954 20.00 #CP/X PARALLEL. : 0
STORED PRC 0.000000 0.000000 N/A SYSLGRNG REC 0.084820 8.00 #IO PARALLELISM : 0
UDF 0.000000 0.000000 N/A EXT/DEL/DEF 0.308772 20.00 #INCREMENT. BIND: 0
TRIGGER 0.000000 0.000000 N/A OTHER SERVICE 0.000000 0.00 [red]#COMMITS : 1[/red]
PAR.TASKS 0.000000 0.000000 N/A ARC.LOG(QUIES) 0.000000 0.00 [red]#ROLLBACKS : 0[/red]
ARC.LOG READ 0.000000 0.00 #SVPT REQUESTS : 0
SUSPEND TIME 0.000000 3.444193 N/A DRAIN LOCK 0.000000 0.00 #SVPT RELEASE : 0
AGENT N/A 3.444193 N/A CLAIM RELEASE 0.000000 0.00 #SVPT [red]ROLLBACK : 0[/red]
PAR.TASKS N/A 0.000000 N/A PAGE LATCH 0.000000 0.00 MAX SQL CASC LVL: 0
STORED PROC 0.000000 N/A N/A NOTIFY MSGS 0.000000 0.00 UPDATE/COMMIT : 0.00
UDF 0.000000 N/A N/A GLOBAL CONTENTION 0.000000 0.00 SYNCH I/O AVG. : 0.001916
COMMIT PH1 WRITE I/O 0.000000 0.00
NOT ACCOUNT. N/A 10.758099 N/A ASYNCH CF REQUESTS 0.000000 0.00
DB2 ENT/EXIT N/A 2802020.00 N/A TOTAL CLASS 3 3.444193 820.00
EN/EX-STPROC N/A 0.00 N/A
EN/EX-UDF N/A 0.00 N/A
DCAPT.DESCR. N/A N/A N/P
LOG EXTRACT. N/A N/A N/P

GLOBAL CONTENTION L-LOCKS AVERAGE TIME AV.EVENT GLOBAL CONTENTION P-LOCKS AVERAGE TIME AV.EVENT
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0.00 P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-2
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF0K

SQL DML AVERAGE TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER LOCKING AVERAGE TOTAL
-------- -------- -------- -------------- -------- ---------- ------ ------ ------ ---------------------- -------- --------
SELECT 1038.1K 1038085 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0.00 0
INSERT 0.00 0 GRANT 0 CRT TTABLE 0 N/A N/A [red]DEADLOCKS 0.00 0[/red]
UPDATE 0.00 0 REVOKE 0 DCL TTABLE 0 N/A N/A ESCAL.(SHARED) 0.00 0
DELETE 0.00 0 SET CURR.SQLID 0 AUX TABLE 0 N/A N/A ESCAL.(EXCLUS) 0.00 0
SET HOST VAR. 0 INDEX 0 0 0 MAX PG/ROW LOCKS HELD 0.00 0
DESCRIBE 0.00 0 SET CUR.DEGREE 0 TABLESPACE 0 0 0 LOCK REQUEST 54182.00 54182
DESC.TBL 0.00 0 SET RULES 0 DATABASE 0 0 0 UNLOCK REQUEST 124.00 124
PREPARE 0.00 0 SET CURR.PATH 0 STOGROUP 0 0 0 QUERY REQUEST 0.00 0
OPEN 54036.00 54036 SET CURR.PREC. 0 SYNONYM 0 0 N/A CHANGE REQUEST 2.00 2
FETCH 254.9K 254851 CONNECT TYPE 1 0 VIEW 0 0 N/A OTHER REQUEST 0.00 0
CLOSE 54036.00 54036 CONNECT TYPE 2 0 ALIAS 0 0 N/A LOCK SUSPENSIONS 0.00 0
SET CONNECTION 0 PACKAGE N/A 0 N/A IRLM LATCH SUSPENSIONS 19.00 19
RELEASE 0 PROCEDURE 0 0 0 OTHER SUSPENSIONS 0.00 0
DML-ALL 1401.0K 1401008 CALL 0 FUNCTION 0 0 0 TOTAL SUSPENSIONS 19.00 19
ASSOC LOCATORS 0 TRIGGER 0 0 N/A
ALLOC CURSOR 0 DIST TYPE 0 0 N/A
HOLD LOCATOR 0 SEQUENCE 0 0 0
FREE LOCATOR 0
DCL-ALL 0 TOTAL 0 0 0
RENAME TBL 0
COMMENT ON 0
LABEL ON 0

NORMAL TERM. AVERAGE TOTAL ABNORMAL TERM. TOTAL IN DOUBT TOTAL DRAIN/CLAIM AVERAGE TOTAL
--------------- -------- -------- ----------------- -------- -------------- -------- -------------- -------- --------
NEW USER 0.00 0 APPL.PROGR. ABEND 0 APPL.PGM ABEND 0 DRAIN REQUESTS 0.00 0
DEALLOCATION 1.00 1 END OF MEMORY 0 END OF MEMORY 0 DRAIN FAILED 0.00 0
APPL.PROGR. END 0.00 0 RESOL.IN DOUBT 0 END OF TASK 0 CLAIM REQUESTS 21.00 21
RESIGNON 0.00 0 CANCEL FORCE 0 CANCEL FORCE 0 CLAIM FAILED 0.00 0
DBAT INACTIVE 0.00 0
TYPE2 INACTIVE 0.00 0
RRS COMMIT 0.00 0
END USER THRESH 0.00 0
BLOCK STOR THR 0.00 0
STALENESS THR 0.00 0
NOTICE HOW LOCATION IS IN THE SAME REPORT AGAIN, BUT I DON'T NEED THIS PART, MY OTHER VARIABLEs ARE IN THE REPORT NUMEROUS TIMES, BUT IS ONLY NEEDED DEPENDING ON HOW MANY AUTH ID'S ARE PRESENT..
LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-3
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF0K

DATA CAPTURE AVERAGE TOTAL DATA SHARING AVERAGE TOTAL QUERY PARALLELISM AVERAGE TOTAL
----------------- -------- -------- ------------------- -------- -------- ---------------------------- -------- --------
IFI CALLS MADE N/P N/P L-LOCKS XES RATE(%) 0.15 N/A MAXIMUM MEMBERS USED N/A 0
RECORDS CAPTURED N/P N/P LOCK REQ - PLOCKS 31.00 31 MAXIMUM DEGREE N/A 0
LOG RECORDS READ N/P N/P UNLOCK REQ - PLOCKS 0.00 0 GROUPS EXECUTED 0.00 0
ROWS RETURNED N/P N/P CHANGE REQ - PLOCKS 0.00 0 RAN AS PLANNED 0.00 0
RECORDS RETURNED N/P N/P LOCK REQ - XES 112.00 112 RAN REDUCED 0.00 0
DATA DESC. RETURN N/P N/P UNLOCK REQ - XES 61.00 61 ONE DB2-COORDINATOR = NO 0.00 0
TABLES RETURNED N/P N/P CHANGE REQ - XES 0.00 0 ONE DB2-ISOLATION LEVEL 0.00 0
DESCRIBES N/P N/P SUSPENDS - IRLM 0.00 0 ONE DB2-DCL TEMPORARY TABLE 0.00 0
SUSPENDS - XES 0.00 0 SEQUENTIAL-CURSOR 0.00 0
SUSPENDS - FALSE N/A N/A SEQUENTIAL-NO ESA SORT 0.00 0
INCOMPATIBLE LOCKS 0.00 0 SEQUENTIAL-NO BUFFER 0.00 0
NOTIFY MSGS SENT 0.00 0 SEQUENTIAL-ENCLAVE SERVICES 0.00 0
MEMBER SKIPPED (%) N/C N/A
DISABLED BY RLF 0.00 0
REFORM PARAL-CONFIG 0.00 0
REFORM PARAL-NO BUF 0.00 0

STORED PROCEDURES AVERAGE TOTAL UDF AVERAGE TOTAL TRIGGERS AVERAGE TOTAL
----------------- -------- -------- --------- -------- -------- ----------------- -------- --------
CALL STATEMENTS 0.00 0 EXECUTED 0.00 0 STATEMENT TRIGGER 0.00 0
ABENDED 0.00 0 ABENDED 0.00 0 ROW TRIGGER 0.00 0
TIMED OUT 0.00 0 TIMED OUT 0.00 0 SQL ERROR OCCUR 0.00 0
REJECTED 0.00 0 REJECTED 0.00 0

LOGGING AVERAGE TOTAL ROWID AVERAGE TOTAL RID LIST AVERAGE TOTAL
------------------- -------- -------- ------------- -------- -------- ------------------- -------- --------
LOG RECORDS WRITTEN 0.00 0 DIRECT ACCESS 0.00 0 USED 1.00 1
TOT BYTES WRITTEN 0.00 0 INDEX USED 0.00 0 FAIL-NO STORAGE 0.00 0
LOG RECORD SIZE N/C N/A TS SCAN USED 0.00 0 FAIL-LIMIT EXCEEDED 0.00 0

AVERAGE SU CLASS 1 CLASS 2 DYNAMIC SQL STMT AVERAGE TOTAL MISCELLANEOUS AVERAGE TOTAL
------------ -------------- -------------- -------------------- -------- -------- ------------------- -------- --------
CPU 1323899.00 1234637.00 REOPTIMIZATION 0.00 0 MAX STOR LOB VALUES 0.00 0
AGENT 1323899.00 1234637.00 NOT FOUND IN CACHE 0.00 0
NONNESTED 1323899.00 1234637.00 FOUND IN CACHE 0.00 0
STORED PRC 0.00 0.00 IMPLICIT PREPARES 0.00 0
UDF 0.00 0.00 PREPARES AVOIDED 0.00 0
TRIGGER 0.00 0.00 CACHE_LIMIT_EXCEEDED 0.00 0
PAR.TASKS 0.00 0.00 PREP_STMT_PURGED 0.00 0

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-4
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF0K

BP1 BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 100.00 N/A
GETPAGES 324.2K 324210
GETPAGES-FAILED 0.00 0
BUFFER UPDATES 216.1K 216140
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.00 0
SEQ. PREFETCH REQS 53960.00 53960
LIST PREFETCH REQS 0.00 0
DYN. PREFETCH REQS 0.00 0
PAGES READ ASYNCHR. 0.00 0

BP12 BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 61.30 N/A
GETPAGES 85763.00 85763
GETPAGES-FAILED 0.00 0
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 360.00 360
SEQ. PREFETCH REQS 8.00 8
LIST PREFETCH REQS 0.00 0
DYN. PREFETCH REQS 1540.00 1540
PAGES READ ASYNCHR. 32834.00 32834

BP13 BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 93.37 N/A
GETPAGES 618.8K 618752
GETPAGES-FAILED 0.00 0
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 334.00 334
SEQ. PREFETCH REQS 0.00 0
LIST PREFETCH REQS 265.00 265
DYN. PREFETCH REQS 1650.00 1650
PAGES READ ASYNCHR. 40681.00 40681

TOT4K BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 92.79 N/A
GETPAGES 1028.7K 1028725
GETPAGES-FAILED 0.00 0
BUFFER UPDATES 216.1K 216140
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 694.00 694
SEQ. PREFETCH REQS 53968.00 53968
LIST PREFETCH REQS 265.00 265
DYN. PREFETCH REQS 3190.00 3190
PAGES READ ASYNCHR. 73515.00 73515
AGAIN NOTICE HOW "LOCATION", AND THE "FROM" AND "TO" ARE IN THIS AREA BUT IS NOT NEEDED
LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-5
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF0K

GROUP BP12 AVERAGE TOTAL GROUP BP13 AVERAGE TOTAL GROUP TOT4K AVERAGE TOTAL
--------------------- -------- -------- --------------------- -------- -------- --------------------- -------- --------
GBP-DEPEND GETPAGES 0.00 0 GBP-DEPEND GETPAGES 0.00 0 GBP-DEPEND GETPAGES 0.00 0
READ(XI)-DATA RETUR 0.00 0 READ(XI)-DATA RETUR 0.00 0 READ(XI)-DATA RETUR 0.00 0
READ(XI)-NO DATA RT 0.00 0 READ(XI)-NO DATA RT 0.00 0 READ(XI)-NO DATA RT 0.00 0
READ(NF)-DATA RETUR 0.00 0 READ(NF)-DATA RETUR 0.00 0 READ(NF)-DATA RETUR 0.00 0
READ(NF)-NO DATA RT 0.00 0 READ(NF)-NO DATA RT 0.00 0 READ(NF)-NO DATA RT 0.00 0
PREFETCH PAGES READ 0.00 0 PREFETCH PAGES READ 0.00 0 PREFETCH PAGES READ 0.00 0
CLEAN PAGES WRITTEN 0.00 0 CLEAN PAGES WRITTEN 0.00 0 CLEAN PAGES WRITTEN 0.00 0
UNREGISTER PAGE 48.00 48 UNREGISTER PAGE 70.00 70 UNREGISTER PAGE 118.00 118
ASYNCH GBP REQUESTS 0.00 0 ASYNCH GBP REQUESTS 0.00 0 ASYNCH GBP REQUESTS 0.00 0
EXPLICIT X-INVALID 0.00 0 EXPLICIT X-INVALID 0.00 0 EXPLICIT X-INVALID 0.00 0
ASYNCH SEC-GBP REQ 0.00 0 ASYNCH SEC-GBP REQ 0.00 0 ASYNCH SEC-GBP REQ 0.00 0
PG P-LOCK LOCK REQ 0.00 0 PG P-LOCK LOCK REQ 0.00 0 PG P-LOCK LOCK REQ 0.00 0
SPACE MAP PAGES 0.00 0 SPACE MAP PAGES 0.00 0 SPACE MAP PAGES 0.00 0
DATA PAGES 0.00 0 DATA PAGES 0.00 0 DATA PAGES 0.00 0
INDEX LEAF PAGES 0.00 0 INDEX LEAF PAGES 0.00 0 INDEX LEAF PAGES 0.00 0
PG P-LOCK UNLOCK REQ 0.00 0 PG P-LOCK UNLOCK REQ 0.00 0 PG P-LOCK UNLOCK REQ 0.00 0
PG P-LOCK LOCK SUSP 0.00 0 PG P-LOCK LOCK SUSP 0.00 0 PG P-LOCK LOCK SUSP 0.00 0
SPACE MAP PAGES 0.00 0 SPACE MAP PAGES 0.00 0 SPACE MAP PAGES 0.00 0
DATA PAGES 0.00 0 DATA PAGES 0.00 0 DATA PAGES 0.00 0
INDEX LEAF PAGES 0.00 0 INDEX LEAF PAGES 0.00 0 INDEX LEAF PAGES 0.00 0
WRITE AND REGISTER 0.00 0 WRITE AND REGISTER 0.00 0 WRITE AND REGISTER 0.00 0
WRITE & REGISTER MULT 0.00 0 WRITE & REGISTER MULT 0.00 0 WRITE & REGISTER MULT 0.00 0
CHANGED PAGES WRITTEN 0.00 0 CHANGED PAGES WRITTEN 0.00 0 CHANGED PAGES WRITTEN 0.00 0
WRITE TO SEC-GBP N/A N/A WRITE TO SEC-GBP N/A N/A WRITE TO SEC-GBP N/A N/A

-------------------------------------------------------------------------------
|PROGRAM NAME CLASS 7 CONSUMERS |
|M2HWZA01 |========> 16% |
|M2HZYA04 |====================> 41% |
|M3F91A00 |=====================> 43% |
-------------------------------------------------------------------------------

M2HWZA01 VALUE M2HWZA01 TIMES M2HWZA01 AVERAGE TIME AVG.EV TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAP-CL7 TIME-AVG 14.335698 LOCK/LATCH 0.000000 0.00 N/C
[/B]NOTICE "CPU TIME IN THIS SECTION, BUT IT IS NOT NEEDED..[/B] CPU TIME 11.602889 SYNCHRONOUS I/O 0.373942 83.00 0.004505
LOCATION HODHD0A AGENT 11.602889 OTHER READ I/O 0.069578 4.00 0.017395
COLLECTION ID HRDBKU PAR.TASKS 0.000000 OTHER WRITE I/O 0.000000 0.00 N/C
PROGRAM NAME M2HWZA01 SUSPENSION-CL8 0.766033 SERV.TASK SWITCH 0.322513 9.00 0.035835
AGENT 0.766033 ARCH.LOG(QUIESCE) 0.000000 0.00 N/C
ACTIVITY TYPE NONNESTED PAR.TASKS 0.000000 ARCHIVE LOG READ 0.000000 0.00 N/C
ACTIVITY NAME 'BLANK' NOT ACCOUNTED 1.966776 DRAIN LOCK 0.000000 0.00 N/C
SCHEMA NAME 'BLANK' AVG.DB2 ENTRY/EXIT N/P CLAIM RELEASE 0.000000 0.00 N/C
OCCURRENCES 1 DB2 ENTRY/EXIT N/P PAGE LATCH 0.000000 0.00 N/C
SQL STMT - AVERAGE 242515.00 NOTIFY MESSAGES 0.000000 0.00 N/C
SQL STMT - TOTAL 242515 CPU SERVICE UNITS 189434.00 GLOBAL CONTENTION 0.000000 0.00 N/C
SUCC AUTH CHECK 0 AGENT 189434.00 TOTAL CL8 SUSPENS. 0.766033 96.00 0.007980
PAR.TASKS 0.00

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-6
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF0K

M2HZYA04 VALUE M2HZYA04 TIMES M2HZYA04 AVERAGE TIME AVG.EV TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAP-CL7 TIME-AVG 37.021645 LOCK/LATCH 0.000008 2.00 0.000004
CPU TIME 31.048185 SYNCHRONOUS I/O 0.670550 449.00 0.001493
LOCATION HODHD0A AGENT 31.048185 OTHER READ I/O 0.183047 13.00 0.014081
COLLECTION ID HRDBKU PAR.TASKS 0.000000 OTHER WRITE I/O 0.000000 0.00 N/C
PROGRAM NAME M2HZYA04 SUSPENSION-CL8 1.932230 SERV.TASK SWITCH 1.078625 30.00 0.035954
AGENT 1.932230 ARCH.LOG(QUIESCE) 0.000000 0.00 N/C
ACTIVITY TYPE NONNESTED PAR.TASKS 0.000000 ARCHIVE LOG READ 0.000000 0.00 N/C
ACTIVITY NAME 'BLANK' NOT ACCOUNTED 4.041231 DRAIN LOCK 0.000000 0.00 N/C
SCHEMA NAME 'BLANK' AVG.DB2 ENTRY/EXIT N/P CLAIM RELEASE 0.000000 0.00 N/C
OCCURRENCES 1 DB2 ENTRY/EXIT N/P PAGE LATCH 0.000000 0.00 N/C
SQL STMT - AVERAGE 716013.00 NOTIFY MESSAGES 0.000000 0.00 N/C
SQL STMT - TOTAL 716013 CPU SERVICE UNITS 506909.00 GLOBAL CONTENTION 0.000000 0.00 N/C
SUCC AUTH CHECK 0 AGENT 506909.00 TOTAL CL8 SUSPENS. 1.932230 494.00 0.003911
PAR.TASKS 0.00

M3F91A00 VALUE M3F91A00 TIMES M3F91A00 AVERAGE TIME AVG.EV TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAP-CL7 TIME-AVG 38.466462 LOCK/LATCH 0.100169 52.00 0.001926
CPU TIME 32.970440 SYNCHRONOUS I/O 0.285239 162.00 0.001761
LOCATION HODHD0A AGENT 32.970440 OTHER READ I/O 0.056115 7.00 0.008016
COLLECTION ID HRDBKU PAR.TASKS 0.000000 OTHER WRITE I/O 0.000000 0.00 N/C
PROGRAM NAME M3F91A00 SUSPENSION-CL8 0.745931 SERV.TASK SWITCH 0.304407 9.00 0.033823
AGENT 0.745931 ARCH.LOG(QUIESCE) 0.000000 0.00 N/C
ACTIVITY TYPE NONNESTED PAR.TASKS 0.000000 ARCHIVE LOG READ 0.000000 0.00 N/C
ACTIVITY NAME 'BLANK' NOT ACCOUNTED 4.750092 DRAIN LOCK 0.000000 0.00 N/C
SCHEMA NAME 'BLANK' AVG.DB2 ENTRY/EXIT N/P CLAIM RELEASE 0.000000 0.00 N/C
OCCURRENCES 1 DB2 ENTRY/EXIT N/P PAGE LATCH 0.000000 0.00 N/C
SQL STMT - AVERAGE 442480.00 NOTIFY MESSAGES 0.000000 0.00 N/C
SQL STMT - TOTAL 442480 CPU SERVICE UNITS 538292.00 GLOBAL CONTENTION 0.000000 0.00 N/C
SUCC AUTH CHECK 0 AGENT 538292.00 TOTAL CL8 SUSPENS. 0.745931 230.00 0.003243
PAR.TASKS 0.00

M2HWZA01 AVERAGE TIME AV.EVENT M2HWZA01 AVERAGE TIME AV.EVENT
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0.00 GLOBAL CONTENTION P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00

M2HZYA04 AVERAGE TIME AV.EVENT M2HZYA04 AVERAGE TIME AV.EVENT
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0.00 GLOBAL CONTENTION P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00
AGAIN, MY PARSE CRITERIA IS IN THE SAME REPORT AGAIN, BUT I DON'T NEED THIS PART EITHER
LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-7
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF0K

M3F91A00 AVERAGE TIME AV.EVENT M3F91A00 AVERAGE TIME AV.EVENT
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0.00 GLOBAL CONTENTION P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00

M2HWZA01 AVERAGE TOTAL M2HZYA04 AVERAGE TOTAL M3F91A00 AVERAGE TOTAL
------------------- -------- -------- ------------------- -------- -------- ------------------- -------- --------
BPOOL HIT RATIO (%) 15.19 N/A BPOOL HIT RATIO (%) 56.51 N/A BPOOL HIT RATIO (%) 96.84 N/A
GETPAGES 14999.00 14999 GETPAGES 73046.00 73046 GETPAGES 940.7K 940680
GETPAGES-FAILED 0.00 0 GETPAGES-FAILED 0.00 0 GETPAGES-FAILED 0.00 0
BUFFER UPDATES 0.00 0 BUFFER UPDATES 0.00 0 BUFFER UPDATES 216.1K 216140
SYNCHRONOUS WRITE 0.00 0 SYNCHRONOUS WRITE 0.00 0 SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 83.00 83 SYNCHRONOUS READ 449.00 449 SYNCHRONOUS READ 162.00 162
SEQ. PREFETCH REQS 0.00 0 SEQ. PREFETCH REQS 0.00 0 SEQ. PREFETCH REQS 53968.00 53968
LIST PREFETCH REQS 0.00 0 LIST PREFETCH REQS 0.00 0 LIST PREFETCH REQS 265.00 265
DYN. PREFETCH REQS 353.00 353 DYN. PREFETCH REQS 1577.00 1577 DYN. PREFETCH REQS 1260.00 1260
PAGES READ ASYNCHR. 12637.00 12637 PAGES READ ASYNCHR. 31322.00 31322 PAGES READ ASYNCHR. 29556.00 29556
WE ARE AT THE END OF ONE SECTION OF THE REPORT NOW

NOW WITHIN THE SAME REPORT, WE ARE IN A NEW SECTION AND THE ITEMS I NEED ARE THE SAME AS THE ITEMS THAT ARE IN RED ABOVE, THE ITEMS I NEED IN THIS SECTION ARE IN BLUE.. THEY ARE THE SAME ITEMS THAT MY VARIABLES POINT TO, BASICALLY, WHAT WAS IN RED ABOVE IS WHAT IS IN BLUE BELOW IN THE NEW SECTION OF THE SAME REPORT

[BLUE]LOCATION: HODHD0A[/BLUE] DB2 PERFORMANCE EXPERT (V2) PAGE: 1-8
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
[BLUE]SUBSYSTEM: HD1A[/BLUE] ORDER: PRIMAUTH-PLANNAME INTERVAL [BLUE]FROM: 12/01/05 01:32:52.88[/BLUE]
DB2 VERSION: V8 SCOPE: MEMBER [BLUE]TO: 12/01/05 01:32:55.84[/BLUE]

[BLUE]PRIMAUTH: DNCS PLANNAME: PUOF1K[/BLUE]

ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL |==> 4% CPU |========================================> 81%
DB2 |============================================> 89% NOTACC |=====> 11%
SUSP |====> 8% SUSP |====> 8%

AVERAGE APPL(CL.1) DB2 (CL.2) IFI (CL.5) CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT HIGHLIGHTS
------------ ---------- ---------- ---------- -------------------- ------------ -------- --------------------------
[BLUE]ELAPSED TIME 0.500365 0.482628[/BLUE] N/P LOCK/LATCH(DB2+IRLM) 0.000000 0.00 [BLUE]#OCCURRENCES : 1[/BLUE]
NONNESTED 0.500365 0.482628 N/A SYNCHRON. I/O 0.013610 6.00 #ALLIEDS : 1
STORED PROC 0.000000 0.000000 N/A DATABASE I/O 0.013610 6.00 #ALLIEDS DISTRIB: 0
UDF 0.000000 0.000000 N/A LOG WRITE I/O 0.000000 0.00 #DBATS : 0
TRIGGER 0.000000 0.000000 N/A OTHER READ I/O 0.026006 5.00 #DBATS DISTRIB. : 0
OTHER WRTE I/O 0.000000 0.00 #NO PROGRAM DATA: 0
[BLUE]CPU TIME 0.397069 0.392083[/BLUE] N/P SER.TASK SWTCH 0.000000 0.00 #NORMAL TERMINAT: 1
AGENT 0.397069 0.392083 N/A UPDATE COMMIT 0.000000 0.00 #ABNORMAL TERMIN: 0
NONNESTED 0.397069 0.392083 N/P OPEN/CLOSE 0.000000 0.00 #CP/X PARALLEL. : 0
STORED PRC 0.000000 0.000000 N/A SYSLGRNG REC 0.000000 0.00 #IO PARALLELISM : 0
UDF 0.000000 0.000000 N/A EXT/DEL/DEF 0.000000 0.00 #INCREMENT. BIND: 0
TRIGGER 0.000000 0.000000 N/A OTHER SERVICE 0.000000 0.00 [BLUE]#COMMITS : 1[/BLUE]
PAR.TASKS 0.000000 0.000000 N/A ARC.LOG(QUIES) 0.000000 0.00 [BLUE]#ROLLBACKS : 0[/BLUE]
ARC.LOG READ 0.000000 0.00 #SVPT REQUESTS : 0
SUSPEND TIME 0.000000 0.039616 N/A DRAIN LOCK 0.000000 0.00 #SVPT RELEASE : 0
AGENT N/A 0.039616 N/A CLAIM RELEASE 0.000000 0.00 #SVPT ROLLBACK : 0
PAR.TASKS N/A 0.000000 N/A PAGE LATCH 0.000000 0.00 MAX SQL CASC LVL: 0
STORED PROC 0.000000 N/A N/A NOTIFY MSGS 0.000000 0.00 UPDATE/COMMIT : 0.00
UDF 0.000000 N/A N/A GLOBAL CONTENTION 0.000000 0.00 SYNCH I/O AVG. : 0.002268
COMMIT PH1 WRITE I/O 0.000000 0.00
NOT ACCOUNT. N/A 0.050928 N/A ASYNCH CF REQUESTS 0.000000 0.00
DB2 ENT/EXIT N/A 34.00 N/A TOTAL CLASS 3 0.039616 11.00
EN/EX-STPROC N/A 0.00 N/A
EN/EX-UDF N/A 0.00 N/A
DCAPT.DESCR. N/A N/A N/P
LOG EXTRACT. N/A N/A N/P

GLOBAL CONTENTION L-LOCKS AVERAGE TIME AV.EVENT GLOBAL CONTENTION P-LOCKS AVERAGE TIME AV.EVENT
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0.00 P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00
[BLUE]NOTE THAT LOCATION AMONG OTHER ITEMS ARE IN THE SAME REPORT AGAIN[/BLUE]
LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-9
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF1K

SQL DML AVERAGE TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER LOCKING AVERAGE TOTAL
-------- -------- -------- -------------- -------- ---------- ------ ------ ------ ---------------------- -------- --------
SELECT 3.00 3 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0.00 0
INSERT 0.00 0 GRANT 0 CRT TTABLE 0 N/A N/A DEADLOCKS 0.00 0
UPDATE 0.00 0 REVOKE 0 DCL TTABLE 0 N/A N/A ESCAL.(SHARED) 0.00 0
DELETE 0.00 0 SET CURR.SQLID 0 AUX TABLE 0 N/A N/A ESCAL.(EXCLUS) 0.00 0
SET HOST VAR. 0 INDEX 0 0 0 MAX PG/ROW LOCKS HELD 0.00 0
DESCRIBE 0.00 0 SET CUR.DEGREE 0 TABLESPACE 0 0 0 LOCK REQUEST 8.00 8
DESC.TBL 0.00 0 SET RULES 0 DATABASE 0 0 0 UNLOCK REQUEST 4.00 4
PREPARE 0.00 0 SET CURR.PATH 0 STOGROUP 0 0 0 QUERY REQUEST 0.00 0
OPEN 3.00 3 SET CURR.PREC. 0 SYNONYM 0 0 N/A CHANGE REQUEST 1.00 1
FETCH 6.00 6 CONNECT TYPE 1 0 VIEW 0 0 N/A OTHER REQUEST 0.00 0
CLOSE 3.00 3 CONNECT TYPE 2 0 ALIAS 0 0 N/A LOCK SUSPENSIONS 0.00 0
SET CONNECTION 0 PACKAGE N/A 0 N/A IRLM LATCH SUSPENSIONS 0.00 0
RELEASE 0 PROCEDURE 0 0 0 OTHER SUSPENSIONS 0.00 0
DML-ALL 15.00 15 CALL 0 FUNCTION 0 0 0 TOTAL SUSPENSIONS 0.00 0
ASSOC LOCATORS 0 TRIGGER 0 0 N/A
ALLOC CURSOR 0 DIST TYPE 0 0 N/A
HOLD LOCATOR 0 SEQUENCE 0 0 0
FREE LOCATOR 0
DCL-ALL 0 TOTAL 0 0 0
RENAME TBL 0
COMMENT ON 0
LABEL ON 0

NORMAL TERM. AVERAGE TOTAL ABNORMAL TERM. TOTAL IN DOUBT TOTAL DRAIN/CLAIM AVERAGE TOTAL
--------------- -------- -------- ----------------- -------- -------------- -------- -------------- -------- --------
NEW USER 0.00 0 APPL.PROGR. ABEND 0 APPL.PGM ABEND 0 DRAIN REQUESTS 0.00 0
DEALLOCATION 1.00 1 END OF MEMORY 0 END OF MEMORY 0 DRAIN FAILED 0.00 0
APPL.PROGR. END 0.00 0 RESOL.IN DOUBT 0 END OF TASK 0 CLAIM REQUESTS 5.00 5
RESIGNON 0.00 0 CANCEL FORCE 0 CANCEL FORCE 0 CLAIM FAILED 0.00 0
DBAT INACTIVE 0.00 0
TYPE2 INACTIVE 0.00 0
RRS COMMIT 0.00 0
END USER THRESH 0.00 0
BLOCK STOR THR 0.00 0
STALENESS THR 0.00 0

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-10
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF1K

DATA CAPTURE AVERAGE TOTAL DATA SHARING AVERAGE TOTAL QUERY PARALLELISM AVERAGE TOTAL
----------------- -------- -------- ------------------- -------- -------- ---------------------------- -------- --------
IFI CALLS MADE N/P N/P L-LOCKS XES RATE(%) 62.50 N/A MAXIMUM MEMBERS USED N/A 0
RECORDS CAPTURED N/P N/P LOCK REQ - PLOCKS 0.00 0 MAXIMUM DEGREE N/A 0
LOG RECORDS READ N/P N/P UNLOCK REQ - PLOCKS 0.00 0 GROUPS EXECUTED 0.00 0
ROWS RETURNED N/P N/P CHANGE REQ - PLOCKS 0.00 0 RAN AS PLANNED 0.00 0
RECORDS RETURNED N/P N/P LOCK REQ - XES 5.00 5 RAN REDUCED 0.00 0
DATA DESC. RETURN N/P N/P UNLOCK REQ - XES 1.00 1 ONE DB2-COORDINATOR = NO 0.00 0
TABLES RETURNED N/P N/P CHANGE REQ - XES 0.00 0 ONE DB2-ISOLATION LEVEL 0.00 0
DESCRIBES N/P N/P SUSPENDS - IRLM 0.00 0 ONE DB2-DCL TEMPORARY TABLE 0.00 0
SUSPENDS - XES 0.00 0 SEQUENTIAL-CURSOR 0.00 0
SUSPENDS - FALSE N/A N/A SEQUENTIAL-NO ESA SORT 0.00 0
INCOMPATIBLE LOCKS 0.00 0 SEQUENTIAL-NO BUFFER 0.00 0
NOTIFY MSGS SENT 0.00 0 SEQUENTIAL-ENCLAVE SERVICES 0.00 0
MEMBER SKIPPED (%) N/C N/A
DISABLED BY RLF 0.00 0
REFORM PARAL-CONFIG 0.00 0
REFORM PARAL-NO BUF 0.00 0

STORED PROCEDURES AVERAGE TOTAL UDF AVERAGE TOTAL TRIGGERS AVERAGE TOTAL
----------------- -------- -------- --------- -------- -------- ----------------- -------- --------
CALL STATEMENTS 0.00 0 EXECUTED 0.00 0 STATEMENT TRIGGER 0.00 0
ABENDED 0.00 0 ABENDED 0.00 0 ROW TRIGGER 0.00 0
TIMED OUT 0.00 0 TIMED OUT 0.00 0 SQL ERROR OCCUR 0.00 0
REJECTED 0.00 0 REJECTED 0.00 0

LOGGING AVERAGE TOTAL ROWID AVERAGE TOTAL RID LIST AVERAGE TOTAL
------------------- -------- -------- ------------- -------- -------- ------------------- -------- --------
LOG RECORDS WRITTEN 0.00 0 DIRECT ACCESS 0.00 0 USED 1.00 1
TOT BYTES WRITTEN 0.00 0 INDEX USED 0.00 0 FAIL-NO STORAGE 0.00 0
LOG RECORD SIZE N/C N/A TS SCAN USED 0.00 0 FAIL-LIMIT EXCEEDED 0.00 0

AVERAGE SU CLASS 1 CLASS 2 DYNAMIC SQL STMT AVERAGE TOTAL MISCELLANEOUS AVERAGE TOTAL
------------ -------------- -------------- -------------------- -------- -------- ------------------- -------- --------
CPU 6482.00 6401.00 REOPTIMIZATION 0.00 0 MAX STOR LOB VALUES 0.00 0
AGENT 6482.00 6401.00 NOT FOUND IN CACHE 0.00 0
NONNESTED 6482.00 6401.00 FOUND IN CACHE 0.00 0
STORED PRC 0.00 0.00 IMPLICIT PREPARES 0.00 0
UDF 0.00 0.00 PREPARES AVOIDED 0.00 0
TRIGGER 0.00 0.00 CACHE_LIMIT_EXCEEDED 0.00 0
PAR.TASKS 0.00 0.00 PREP_STMT_PURGED 0.00 0

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-11
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF1K

BP12 BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 40.99 N/A
GETPAGES 222.00 222
GETPAGES-FAILED 0.00 0
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 6.00 6
SEQ. PREFETCH REQS 5.00 5
LIST PREFETCH REQS 0.00 0
DYN. PREFETCH REQS 2.00 2
PAGES READ ASYNCHR. 125.00 125

BP13 BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 99.68 N/A
GETPAGES 8488.00 8488
GETPAGES-FAILED 0.00 0
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 0.00 0
SEQ. PREFETCH REQS 0.00 0
LIST PREFETCH REQS 265.00 265
DYN. PREFETCH REQS 0.00 0
PAGES READ ASYNCHR. 27.00 27

TOT4K BPOOL ACTIVITY AVERAGE TOTAL
--------------------- -------- --------
BPOOL HIT RATIO (%) 98.19 N/A
GETPAGES 8710.00 8710
GETPAGES-FAILED 0.00 0
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 6.00 6
SEQ. PREFETCH REQS 5.00 5
LIST PREFETCH REQS 265.00 265
DYN. PREFETCH REQS 2.00 2
PAGES READ ASYNCHR. 152.00 152

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-12
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF1K

GROUP BP12 AVERAGE TOTAL
--------------------- -------- --------
GBP-DEPEND GETPAGES 0.00 0
READ(XI)-DATA RETUR 0.00 0
READ(XI)-NO DATA RT 0.00 0
READ(NF)-DATA RETUR 0.00 0
READ(NF)-NO DATA RT 0.00 0
PREFETCH PAGES READ 0.00 0
CLEAN PAGES WRITTEN 0.00 0
UNREGISTER PAGE 1.00 1
ASYNCH GBP REQUESTS 0.00 0
EXPLICIT X-INVALID 0.00 0
ASYNCH SEC-GBP REQ 0.00 0
PG P-LOCK LOCK REQ 0.00 0
SPACE MAP PAGES 0.00 0
DATA PAGES 0.00 0
INDEX LEAF PAGES 0.00 0
PG P-LOCK UNLOCK REQ 0.00 0
PG P-LOCK LOCK SUSP 0.00 0
SPACE MAP PAGES 0.00 0
DATA PAGES 0.00 0
INDEX LEAF PAGES 0.00 0
WRITE AND REGISTER 0.00 0
WRITE & REGISTER MULT 0.00 0
CHANGED PAGES WRITTEN 0.00 0
WRITE TO SEC-GBP N/A N/A

M3F92A00 VALUE M3F92A00 TIMES M3F92A00 AVERAGE TIME AVG.EV TIME/EVENT
------------------ ------------------ ------------------ ------------ ------------------ ------------ ------ ------------
TYPE PACKAGE ELAP-CL7 TIME-AVG 0.482622 LOCK/LATCH 0.000000 0.00 N/C
CPU TIME 0.392078 SYNCHRONOUS I/O 0.013610 6.00 0.002268
LOCATION HODHD0A AGENT 0.392078 OTHER READ I/O 0.026006 5.00 0.005201
COLLECTION ID HRDBKU PAR.TASKS 0.000000 OTHER WRITE I/O 0.000000 0.00 N/C
PROGRAM NAME M3F92A00 SUSPENSION-CL8 0.039616 SERV.TASK SWITCH 0.000000 0.00 N/C
AGENT 0.039616 ARCH.LOG(QUIESCE) 0.000000 0.00 N/C
ACTIVITY TYPE NONNESTED PAR.TASKS 0.000000 ARCHIVE LOG READ 0.000000 0.00 N/C
ACTIVITY NAME 'BLANK' NOT ACCOUNTED 0.050927 DRAIN LOCK 0.000000 0.00 N/C
SCHEMA NAME 'BLANK' AVG.DB2 ENTRY/EXIT N/P CLAIM RELEASE 0.000000 0.00 N/C
OCCURRENCES 1 DB2 ENTRY/EXIT N/P PAGE LATCH 0.000000 0.00 N/C
SQL STMT - AVERAGE 15.00 NOTIFY MESSAGES 0.000000 0.00 N/C
SQL STMT - TOTAL 15 CPU SERVICE UNITS 6401.00 GLOBAL CONTENTION 0.000000 0.00 N/C
SUCC AUTH CHECK 0 AGENT 6401.00 TOTAL CL8 SUSPENS. 0.039616 11.00 0.003601
PAR.TASKS 0.00

M3F92A00 AVERAGE TIME AV.EVENT M3F92A00 AVERAGE TIME AV.EVENT
------------------------- ------------ -------- ------------------------- ------------ --------
GLOBAL CONTENTION L-LOCKS 0.000000 0.00 GLOBAL CONTENTION P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-13
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF1K

M3F92A00 AVERAGE TOTAL
------------------- -------- --------
BPOOL HIT RATIO (%) 98.19 N/A
GETPAGES 8710.00 8710
GETPAGES-FAILED 0.00 0
BUFFER UPDATES 0.00 0
SYNCHRONOUS WRITE 0.00 0
SYNCHRONOUS READ 6.00 6
SEQ. PREFETCH REQS 5.00 5
LIST PREFETCH REQS 265.00 265
DYN. PREFETCH REQS 2.00 2
PAGES READ ASYNCHR. 152.00 152

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-14
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF2K

ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL |> 1% CPU |=========================================> 82%
DB2 |=============================================> 91% NOTACC |=====> 10%
SUSP |====> 8% SUSP |====> 8%

AVERAGE APPL(CL.1) DB2 (CL.2) IFI (CL.5) CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT HIGHLIGHTS
------------ ---------- ---------- ---------- -------------------- ------------ -------- --------------------------
ELAPSED TIME 1.910386 1.896395 N/P LOCK/LATCH(DB2+IRLM) 0.000010 2.00 #OCCURRENCES : 1
NONNESTED 1.910386 1.896395 N/A SYNCHRON. I/O 0.017030 29.00 #ALLIEDS : 1
STORED PROC 0.000000 0.000000 N/A DATABASE I/O 0.017030 29.00 #ALLIEDS DISTRIB: 0
UDF 0.000000 0.000000 N/A LOG WRITE I/O 0.000000 0.00 #DBATS : 0
TRIGGER 0.000000 0.000000 N/A OTHER READ I/O 0.136103 23.00 #DBATS DISTRIB. : 0
OTHER WRTE I/O 0.000000 0.00 #NO PROGRAM DATA: 0
CPU TIME 1.557999 1.552290 N/P SER.TASK SWTCH 0.000000 0.00 #NORMAL TERMINAT: 1
AGENT 1.557999 1.552290 N/A UPDATE COMMIT 0.000000 0.00 #ABNORMAL TERMIN: 0
NONNESTED 1.557999 1.552290 N/P OPEN/CLOSE 0.000000 0.00 #CP/X PARALLEL. : 0
STORED PRC 0.000000 0.000000 N/A SYSLGRNG REC 0.000000 0.00 #IO PARALLELISM : 0
UDF 0.000000 0.000000 N/A EXT/DEL/DEF 0.000000 0.00 #INCREMENT. BIND: 0
TRIGGER 0.000000 0.000000 N/A OTHER SERVICE 0.000000 0.00 #COMMITS : 1
PAR.TASKS 0.000000 0.000000 N/A ARC.LOG(QUIES) 0.000000 0.00 #ROLLBACKS : 0
ARC.LOG READ 0.000000 0.00 #SVPT REQUESTS : 0
SUSPEND TIME 0.000000 0.153143 N/A DRAIN LOCK 0.000000 0.00 #SVPT RELEASE : 0
AGENT N/A 0.153143 N/A CLAIM RELEASE 0.000000 0.00 #SVPT ROLLBACK : 0
PAR.TASKS N/A 0.000000 N/A PAGE LATCH 0.000000 0.00 MAX SQL CASC LVL: 0
STORED PROC 0.000000 N/A N/A NOTIFY MSGS 0.000000 0.00 UPDATE/COMMIT : 0.00
UDF 0.000000 N/A N/A GLOBAL CONTENTION 0.000000 0.00 SYNCH I/O AVG. : 0.000587
COMMIT PH1 WRITE I/O 0.000000 0.00
NOT ACCOUNT. N/A 0.190962 N/A ASYNCH CF REQUESTS 0.000000 0.00
DB2 ENT/EXIT N/A 128.00 N/A TOTAL CLASS 3 0.153143 54.00
EN/EX-STPROC N/A 0.00 N/A
EN/EX-UDF N/A 0.00 N/A
DCAPT.DESCR. N/A N/A N/P
LOG EXTRACT. N/A N/A N/P

GLOBAL CONTENTION L-LOCKS AVERAGE TIME AV.EVENT GLOBAL CONTENTION P-LOCKS AVERAGE TIME AV.EVENT
------------------------------------- ------------ -------- ------------------------------------- ------------ --------
L-LOCKS 0.000000 0.00 P-LOCKS 0.000000 0.00
PARENT (DB,TS,TAB,PART) 0.000000 0.00 PAGESET/PARTITION 0.000000 0.00
CHILD (PAGE,ROW) 0.000000 0.00 PAGE 0.000000 0.00
OTHER 0.000000 0.00 OTHER 0.000000 0.00

LOCATION: HODHD0A DB2 PERFORMANCE EXPERT (V2) PAGE: 1-15
GROUP: DSNHD0A ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: HD1A TO: NOT SPECIFIED
SUBSYSTEM: HD1A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/01/05 01:32:52.88
DB2 VERSION: V8 SCOPE: MEMBER TO: 12/01/05 01:32:55.84

PRIMAUTH: DNCS PLANNAME: PUOF2K

SQL DML AVERAGE TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER LOCKING AVERAGE TOTAL
-------- -------- -------- -------------- -------- ---------- ------ ------ ------ ---------------------- -------- --------
SELECT 41.00 41 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0.00 0
INSERT 0.00 0 GRANT 0 CRT TTABLE 0 N/A N/A DEADLOCKS 0.00 0
UPDATE 0.00 0 REVOKE 0 DCL TTABLE 0 N/A N/A ESCAL.(SHARED) 0.00 0
DELETE 0.00 0 SET CURR.SQLID 0 AUX TABLE 0 N/A N/A ESCAL.(EXCLUS) 0.00 0
SET HOST VAR. 0 INDEX 0 0 0 MAX PG/ROW LOCKS HELD 0.00 0
DESCRIBE 0.00 0 SET CUR.DEGREE 0 TABLESPACE 0 0 0 LOCK REQUEST 29.00 29
DESC.TBL 0.00 0 SET RULES 0 DATABASE 0 0 0 UNLOCK REQUEST 4.00 4
PREPARE 0.00 0 SET CURR.PATH 0 STOGROUP 0 0 0 QUERY REQUEST

 

[KevinADC]

You need to start using a more complex data structure if thats the case. A hash or a hash of hashes maybe.

 

[stevexff]

Where does DB2 Performance Expert get its data from? Is it a log or SMF analyser? Most DB2 tools use tables of some sort or another (they tend to be a bit incestuous like that). Are the data you want available by running a query against the DB2 PE tables? If so, could you get around all these parsing problems by going direct to the source with DBI?

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[pmking]

Hey Stevexff,

We are not allowed to modify the extraction programs or even access the raw data tables. Yes, I have thought about that and the systems people do not want anybody breathing on this stuff

I accept the policy and I am trying to create something that my entire team can use.

Now with that in mind, I am reading on hashing and it kind of makes sense, but wondering how I incorporate hashing into the script that I have now.

Thanks.

 

[pmking]

Since we are talking about -hashing- can somebody send me a link where there are good examples of hashing? I have searched and can't find any good examples; maybe I am not using the right search criteria.

Would I be able to incorporate -hashing- with the current code I have (my current code is above the most recent post above this thread).

Thanks so much for all the help..

 

[pmking]

Hey gang,

I found a good site that can help with my hashing issues...

http://www.tizag.com/perlT/perlhashes.php

I just wanted to share this with you all.

I think because of this site, I have a better visual. I will givie it a try and I am sure I will be back to ask more questions if I get errors Once I am done with the code, I will paste it here for example purposes, just incase sombody may need it..

Thanks.

And you can still input your hashing ideas and I can compare it to what I come up with.

 

[stevexff]

You can think of a (perl) hash as a dictionary. You look up a word in the dictionary, and it returns a value. That value can be a string, a number, or even a reference to an array or another hash. The 'word' you look up is a key, i.e. it must be unique.

my %hash;
$hash{'pmking'} = 42;
$hash{'steve'} = "xyzzy";

foreach (sort keys %hash) {
   print "Key: ", $_, "\t-->\t", $hash{$_}, "\n";
}

The name hash comes from the way the key gets stored and looked up in memory. The key gets run through a hashing algorithm to produce a number. This is used as an index to a 'bucket', basically an array of all the key-value pairs whose keys 'hash' to the same value. Even for very large hashes, relatively few of them will hash to the same bucket (known as a collision), so looking up a value in the hash is a very quick operation compared to iterating over a set of values in a large array.

Obviously, the real perl hash implementation is considerably slicker than the crude example outlined above, with dynamic resizing, lazy initialisation, and memory management, but the underlying principle is the same.

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]