1.) Are you using the native driver or the toolkit? There are marked
performance differences between the two when the database is remote.
I am using DB2 UDB for iSeries (Toolbox XA) driver
2.) I would expect a decent impact when you are connecting to a remote
database vs. a local database. Not knowing what your comparison differences
are it's hard to tell if it is in that 'acceptable' range. When connecting
remotely how are you connecting.
My WAS is deployed on a PC based server, which is then connected to AS400 using
DB2 UDB for iSeries (Toolbox XA) driver.
When I use AS400 Operations Navigator and run a query it takes approximately
120 seconds compare to 5 seconds when the same query is run on a PC based
server with DB2 residing on the local / remote machine for a heavy query.
Furthermore I had run the query on the Green Screen of Client Access the same
query took about 150 seconds. Likewise I had also executed the query from the
dump terminal (AS400) I was astonished to know that it took approximately 240
seconds.
3.) I'm drawing a fuzzy right now on the exact details but I would also
check on your prestart jobs (numbers, run criteria for those jobs, etc.)
No idea about pre-start jobs and how to retrieve the information and its
configuration.
I can send you the screen shots of WRKACTJOB if you like.
4.) When you indicated that you have optimized the queries did this
include running the database monitor on the System i and looking at it's
results?
The result of SQL Performance Monitor using operation navigator is attached.
I also have attached a screen shoot of WRKSYSSTS.JPG, WRKACTJOB00.JPG and
performanceAnalyserResult.txt files
With regards
Muhammad Owais Bilal Awan,
+923002171163
----- Original Message ----
From: "Crump, Mike" <Mike.Crump@xxxxxxxxxxxxxxxx>
To: Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx>
Sent: Wednesday, April 4, 2007 6:04:46 PM
Subject: RE: Performance Issue
1.) Are you using the native driver or the toolkit? There are marked
performance differences between the two when the database is remote.
2.) I would expect a decent impact when you are connecting to a remote
database vs. a local database. Not knowing what your comparison
differences are it's hard to tell if it is in that 'acceptable' range.
When connecting remotely how are you connecting.
3.) I'm drawing a fuzzy right now on the exact details but I would also
check on your prestart jobs (numbers, run criteria for those jobs, etc.)
4.) When you indicated that you have optimized the queries did this
include running the database monitor on the System i and looking at it's
results?
Michael Crump
Manager, Computing Services
Saint-Gobain Containers, Inc.
1509 S. Macedonia Ave.
Muncie, IN 47302
765.741.7696
765.741.7012 f
"A slipping gear could let your M203 grenade launcher fire when you
least expect it. That would make you quite unpopular in what's left of
your unit."
In the August 1993 issue, page 9, of PS magazine, the Army's magazine of
preventive maintenance.
This email and its attachments may be confidential and are intended
solely for the use of the individual to whom it is addressed. Any views
or opinions expressed are solely those of the author and do not
necessarily represent those of Saint-Gobain. If it did, it would be
folded, mutilated, watered down, politically corrected, and would show
up a week later if at all. If you are not the intended recipient of
this email and its attachments, you must take no action based upon them,
nor must you copy or show them to anyone.
Please contact the sender if you believe you have received this email in
error.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[
mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Muhammad Owais
Sent: Wednesday, April 04, 2007 4:34 AM
To: java400-l@xxxxxxxxxxxx
Cc: java400-l-bounces@xxxxxxxxxxxx
Subject: Performance Issue
Hello;
I have migtated my EJB1.1 application from WebSphere 3.5 to WebSphere
5.1. When I deployed the application on a PC based server that uses
database from AS400, it is very slow. Additionally before migration we
have optimized the queries. Moreover we have upgraded the RAM from 1GB
to 4GB, expecting the performance improvement. Queries execute fine on
Windows based DB2 with 2GB of RAM but on AS400 machine the same queries
completes in a longer time. Furthermore we have also altered the
Machine, Base, Spool and Interactive memory.
Please guide me in optimizing the queries on AS400 DB.
Thanking you in anticipation.
With regards
Allah Hafiz
Muhammad Owais Bilal Awan,
+923002171163
Composite query
~~~~~~~~~~~~~~~
2006-11-07 15:32:31.078941 .316 .316 .316 0 0 0
.316 2006-11-07 15:32:31.078941 2006-11-07 15:32:31.078941 UPDATE
1 UPDATE QUSRSYS / QAUGDBPMD SET "Jobs Monitored" = : H , "Number of
Jobs" = : H WHERE "Name" = : H AND "Date Started" = : H AND "Time Started" = :
H WITH NC 1 0 2 1 1 Reusable ISV
Different Lengths 0 1 0 0 0 0
2006-11-07 15:32:30.980811 1 A7? QZDASOINIT QUSER
062220 - QIWS QZDGDBPM
U - - - - - -
- - - - - - - - - -
- - - - - - - - - 1
1 0 0 QUSRSYS QAUGDBPMD QUSRSYS
QAUGDBPMD QUSRSYS QAUGDBPMD 2 1 1 1
0 1 1 1 0 Y 3
N N N Record Selection Y QSYS_QAUGDBPMD_00001
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - DB2ADMINPERF ,
20061107 , 153229
2006-11-07 15:32:31.976847 .220 .056 .001 .205 .002 .013
0 2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN
4 (SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT
DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12 1
0 1 3 0 Reusable ISV Varying Length Fixed
Length 2 0 0 0 0 1 - 0 -
QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 S STMT0005 1 1
0 0 QUSRSYS QAUGDBPMD QUSRSYS QAUGDBPMD
1 1 0 1 1 1 N
N T1 - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - 2 1 0
0 188 3 4704768 0 2 5620 5563 UNION -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - 1, 2
2006-11-07 15:32:31.976847 .220 .056 .001 .205 .002 .013
0 2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN
4 (SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT
DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12 1
0 1 3 0 Reusable ISV Varying Length Fixed
Length 2 0 0 0 0 1 - 0 -
QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 S STMT0005 1 1
0 0 QUSRSYS QAUGDBPMD QUSRSYS QAUGDBPMD
1 1 0 1 1 1 N
N T1 - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - 2 1 0
0 188 3 4704768 0 2 5620 5563 UNION -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - 1, 2
2006-11-07 15:32:31.976847 .220 .056 .001 .205 .002 .013
0 2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN
4 (SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT
DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12 1
0 1 3 0 Reusable ISV Varying Length Fixed
Length 2 0 0 0 0 1 - 0 -
QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 S STMT0005 2 1
0 0 QUSRSYS QAUGDBPMD2 QUSRSYS QAUGDBPMD2
1 1 0 1 1 1 N
N T1 - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - 2 1 0
0 188 3 4704768 0 2 5620 5563 UNION -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - 1, 2
2006-11-07 15:32:31.976847 .220 .056 .001 .205 .002 .013
0 2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN
4 (SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT
DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12 1
0 1 3 0 Reusable ISV Varying Length Fixed
Length 2 0 0 0 0 1 - 0 -
QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 S STMT0005 2 1
0 0 QUSRSYS QAUGDBPMD2 QUSRSYS QAUGDBPMD2
1 1 0 1 1 1 N
N T1 - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - 2 1 0
0 188 3 4704768 0 2 5620 5563 UNION -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - 1, 2
2006-11-07 15:33:56.842838 .093 .093 .093 0 0 0
.093 2006-11-07 15:33:56.842838 2006-11-07 15:33:56.842838 SELECT
INTO 1 SELECT "Jobs Monitored" , "Number of Jobs" INTO : H , : H FROM
QUSRSYS / QAUGDBPMD WHERE "Name" = : H AND "Date Started" = : H AND "Time
Started" = : H 1 0 2 0 0 Reusable
ISV - 0 1 0 0 0 0 2006-11-07
15:33:56.807690 1 A7? QZDASOINIT QUSER 062220 -
QIWS QZDGDBPM S
- - - - - - - -
- - - - - - - - - -
- - - - - - - 1 1 0
0 QUSRSYS QAUGDBPMD QUSRSYS QAUGDBPMD
QUSRSYS QAUGDBPMD 2 1 1 1 0 1
1 1 0 Y 3 N N
N Record Selection Y QSYS_QAUGDBPMD_00001 - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - DB2ADMINPERF , 20061107 , 153229
2006-11-07 15:33:56.717824 .003 .002 .002 0 0 0
.003 2006-11-07 15:33:56.717824 2006-11-07 15:33:56.720403 PREPARE
2 CALL QIWS.QZDGDBPM ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?)
0 0 0 0 0 - - 0 0
0 0 0 0 - 0 - QZDASOINIT QUSER
062220 -
O STMT0005 - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - -
2006-11-07 15:32:31.762142 .003 .003 .003 0 0 0
.003 2006-11-07 15:32:31.762142 2006-11-07 15:32:31.762142 CALL
1 CALL QSYS.QCMDEXC('QSYS/CHKOBJ OBJ(QUSRSYS/QAUGDBPMD)
OBJTYPE(*FILE)',0000000049.00000) 0 0 0 0 0
- - 0 0 0 0 0 0 - 0
- QZDASOINIT QUSER 062220 -
O QZ8C4A8ADF05528C3E -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
2006-11-07 15:33:56.709728 .003 .003 .003 0 0 0
.003 2006-11-07 15:33:56.709728 2006-11-07 15:33:56.709728 CALL
1 CALL QSYS.QCMDEXC('QSYS/CHKOBJ OBJ(QSYS/DB2ADMIN)
OBJTYPE(*LIB)',0000000044.00000) 0 0 0 0 0
- - 0 0 0 0 0 0 - 0
- QZDASOINIT QUSER 062220 -
O QZ8C4A8B30088315F4 -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
- - - - - - - - - -
Databaase Performance Monitor Data Conversion Information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2006-11-07 15:32:31.078941 Different Lengths .316 .316 .316
0 0 0 .316 2006-11-07 15:32:31.078941 2006-11-07
15:32:31.078941 UPDATE 1 UPDATE QUSRSYS / QAUGDBPMD SET "Jobs
Monitored" = : H , "Number of Jobs" = : H WHERE "Name" = : H AND "Date Started"
= : H AND "Time Started" = : H WITH NC DB2ADMINPERF ,
20061107 , 153229 2 1 1 1 0 Reusable
ISV 1 0 0 0 0 1 2006-11-07
15:32:30.980811 A7? QZDASOINIT QUSER 062220 -
QIWS QZDGDBPM
2006-11-07 15:32:31.976847 Varying Length Fixed Length .220 .056
.001 .205 .002 .013 0 2006-11-07 15:32:31.976847
2006-11-07 15:32:31.978767 OPEN 4 (SELECT SUMMARY.*, ? FROM
QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2
DETAILED) ORDER BY 1,11,12 1, 2 1 3
0 1 0 Reusable ISV 0 0 0 0
1 0 - - QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:32:31.976847 Varying Length Fixed Length .220 .056
.001 .205 .002 .013 0 2006-11-07 15:32:31.976847
2006-11-07 15:32:31.978767 OPEN 4 (SELECT SUMMARY.*, ? FROM
QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2
DETAILED) ORDER BY 1,11,12 1, 2 1 3
0 1 0 Reusable ISV 0 0 0 0
1 0 - - QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
Database Performance Monitor Sort Information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2006-11-07 15:32:31.976847 .188 3 UNION 4704768 0 2
5620 5563 2 1 0 0 .220 .056 .001 .205
.002 .013 0 2006-11-07 15:32:31.976847 2006-11-07
15:32:31.978767 OPEN 4 (SELECT SUMMARY.*, ? FROM
QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2
DETAILED) ORDER BY 1,11,12 1, 2 1 0
1 3 0 Reusable ISV Varying Length Fixed Length
2 0 0 0 0 1 - 0 -
QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:32:31.976847 .188 3 UNION 4704768 0 2
5620 5563 2 1 0 0 .220 .056 .001 .205
.002 .013 0 2006-11-07 15:32:31.976847 2006-11-07
15:32:31.978767 OPEN 4 (SELECT SUMMARY.*, ? FROM
QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2
DETAILED) ORDER BY 1,11,12 1, 2 1 0
1 3 0 Reusable ISV Varying Length Fixed Length
2 0 0 0 0 1 - 0 -
QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
Database Performance Monitor Scan Information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2006-11-07 15:32:31.976847 .001 T1 1 1 0 -
- - - No - 1 1 0 0 1
1 No QUSRSYS QAUGDBPMD QUSRSYS
QAUGDBPMD .220 .056 .001 .205 .002 .013 0
2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN 4
(SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ?
FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12 1,
2 1 0 1 3 0 Reusable ISV
Varying Length Fixed Length 2 0 0 0 0 1
- 0 - QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:32:31.976847 .001 T1 1 1 0 -
- - - No - 1 1 0 0 1
1 No QUSRSYS QAUGDBPMD QUSRSYS
QAUGDBPMD .220 .056 .001 .205 .002 .013 0
2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN 4
(SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ?
FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12 1,
2 1 0 1 3 0 Reusable ISV
Varying Length Fixed Length 2 0 0 0 0 1
- 0 - QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:32:31.976847 .001 T1 1 1 0 -
- - - No - 2 1 0 0 1
1 No QUSRSYS QAUGDBPMD2 QUSRSYS
QAUGDBPMD2 .220 .056 .001 .205 .002 .013 0
2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN 4
(SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ?
FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12 1,
2 1 0 1 3 0 Reusable ISV
Varying Length Fixed Length 2 0 0 0 0 1
- 0 - QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:32:31.976847 .001 T1 1 1 0 -
- - - No - 2 1 0 0 1
1 No QUSRSYS QAUGDBPMD2 QUSRSYS
QAUGDBPMD2 .220 .056 .001 .205 .002 .013 0
2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN 4
(SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ?
FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12 1,
2 1 0 1 3 0 Reusable ISV
Varying Length Fixed Length 2 0 0 0 0 1
- 0 - QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
Database Performance Monitor Open Information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2006-11-07 15:32:31.078941 1 0 .316 .316 .316 0
0 0 .316 2006-11-07 15:32:31.078941 2006-11-07
15:32:31.078941 UPDATE 1 UPDATE QUSRSYS / QAUGDBPMD SET "Jobs
Monitored" = : H , "Number of Jobs" = : H WHERE "Name" = : H AND "Date Started"
= : H AND "Time Started" = : H WITH NC DB2ADMINPERF ,
20061107 , 153229 2 1 1 Reusable ISV
Different Lengths 0 1 0 0 0 0 1
2006-11-07 15:32:30.980811 A7? QZDASOINIT QUSER 062220
- QIWS QZDGDBPM
2006-11-07 15:32:31.976847 1 0 .220 .056 .001 .205
.002 .013 0 2006-11-07 15:32:31.976847 2006-11-07
15:32:31.978767 OPEN 4 (SELECT SUMMARY.*, ? FROM
QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2
DETAILED) ORDER BY 1,11,12 1, 2 1 3
0 Reusable ISV Varying Length Fixed Length 2 0
0 0 0 1 0 - - QZDASOINIT QUSER
062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:32:31.976847 1 0 .220 .056 .001 .205
.002 .013 0 2006-11-07 15:32:31.976847 2006-11-07
15:32:31.978767 OPEN 4 (SELECT SUMMARY.*, ? FROM
QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2
DETAILED) ORDER BY 1,11,12 1, 2 1 3
0 Reusable ISV Varying Length Fixed Length 2 0
0 0 0 1 0 - - QZDASOINIT QUSER
062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:33:56.842838 1 0 .093 .093 .093 0
0 0 .093 2006-11-07 15:33:56.842838 2006-11-07
15:33:56.842838 SELECT INTO 1 SELECT "Jobs Monitored" , "Number
of Jobs" INTO : H , : H FROM QUSRSYS / QAUGDBPMD WHERE "Name" = : H AND "Date
Started" = : H AND "Time Started" = : H DB2ADMINPERF ,
20061107 , 153229 2 0 0 Reusable ISV -
0 1 0 0 0 0 1 2006-11-07
15:33:56.807690 A7? QZDASOINIT QUSER 062220 -
QIWS QZDGDBPM
Database Performance Monitor Basic Statment Information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2006-11-07 15:32:31.078941 .316 .316 .316 0 0 0
.316 2006-11-07 15:32:31.078941 2006-11-07 15:32:31.078941 UPDATE
1 UPDATE QUSRSYS / QAUGDBPMD SET "Jobs Monitored" = : H , "Number of
Jobs" = : H WHERE "Name" = : H AND "Date Started" = : H AND "Time Started" = :
H WITH NC DB2ADMINPERF , 20061107 , 153229 1 0
2 1 1 Reusable ISV Different Lengths 0
1 0 0 0 0 2006-11-07 15:32:30.980811 1
A7? QZDASOINIT QUSER 062220 - QIWS
QZDGDBPM
2006-11-07 15:32:31.976847 .220 .056 .001 .205 .002 .013
0 2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN
4 (SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT
DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12
1, 2 1 0 1 3 0 Reusable
ISV Varying Length Fixed Length 2 0 0 0 0
1 - 0 - QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:32:31.976847 .220 .056 .001 .205 .002 .013
0 2006-11-07 15:32:31.976847 2006-11-07 15:32:31.978767 OPEN
4 (SELECT SUMMARY.*, ? FROM QUSRSYS.QAUGDBPMD SUMMARY UNION SELECT
DETAILED.*, ? FROM QUSRSYS.QAUGDBPMD2 DETAILED) ORDER BY 1,11,12
1, 2 1 0 1 3 0 Reusable
ISV Varying Length Fixed Length 2 0 0 0 0
1 - 0 - QZDASOINIT QUSER 062220 -
SQL_CUR036201A0 STMT0005
2006-11-07 15:33:56.842838 .093 .093 .093 0 0 0
.093 2006-11-07 15:33:56.842838 2006-11-07 15:33:56.842838 SELECT
INTO 1 SELECT "Jobs Monitored" , "Number of Jobs" INTO : H , : H FROM
QUSRSYS / QAUGDBPMD WHERE "Name" = : H AND "Date Started" = : H AND "Time
Started" = : H DB2ADMINPERF , 20061107 , 153229
1 0 2 0 0 Reusable ISV - 0
1 0 0 0 0 2006-11-07 15:33:56.807690 1
A7? QZDASOINIT QUSER 062220 - QIWS
QZDGDBPM
2006-11-07 15:33:56.717824 .003 .002 .002 0 0 0
.003 2006-11-07 15:33:56.717824 2006-11-07 15:33:56.720403 PREPARE
2 CALL QIWS.QZDGDBPM ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?)
- 0 0 0 0 0 - - 0
0 0 0 0 0 - 0 - QZDASOINIT
QUSER 062220 -
STMT0005
2006-11-07 15:32:31.762142 .003 .003 .003 0 0 0
.003 2006-11-07 15:32:31.762142 2006-11-07 15:32:31.762142 CALL
1 CALL QSYS.QCMDEXC('QSYS/CHKOBJ OBJ(QUSRSYS/QAUGDBPMD)
OBJTYPE(*FILE)',0000000049.00000) - 0 0 0 0 0
- - 0 0 0 0 0 0 -
0 - QZDASOINIT QUSER 062220 -
QZ8C4A8ADF05528C3E
2006-11-07 15:33:56.709728 .003 .003 .003 0 0 0
.003 2006-11-07 15:33:56.709728 2006-11-07 15:33:56.709728 CALL
1 CALL QSYS.QCMDEXC('QSYS/CHKOBJ OBJ(QSYS/DB2ADMIN)
OBJTYPE(*LIB)',0000000044.00000) - 0 0 0 0 0
- - 0 0 0 0 0 0 -
0 - QZDASOINIT QUSER 062220 -
QZ8C4A8B30088315F4
Database Performance Monitor Operation Summary
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
UPDATE 1 .316 .316 .316 0 0 0 .316 1
0 0 1.000 0 0 0 0 1 2 1
1 2.000 1.000 1.000
OPEN 4 .224 .220 .056 .205 .002 .013 0 1
0 2 0 0 0 0 1 0 1 3
0 1.000 3.000 0
SELECT INTO 1 .093 .093 .093 0 0 0 .093
1 0 0 1.000 0 0 0 0 1 2
0 0 2.000 0 0
CALL 2 .006 .003 .003 0 0 0 .003 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
PREPARE 2 .004 .003 .002 0 0 0 .003 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0
Database Performance Monitor Index Used Information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2006-11-07 15:32:31.078941 Record Selection - - No
0 - - - - - 1 1 0 0
2 1 1 1 0 .001 1 1
Yes 3 No No Yes QSYS_QAUGDBPMD_00001 QUSRSYS
QAUGDBPMD QUSRSYS QAUGDBPMD QUSRSYS
QAUGDBPMD .316 .316 .316 0 0 0 .316
2006-11-07 15:32:31.078941 2006-11-07 15:32:31.078941 UPDATE 1
UPDATE QUSRSYS / QAUGDBPMD SET "Jobs Monitored" = : H , "Number of Jobs" = : H
WHERE "Name" = : H AND "Date Started" = : H AND "Time Started" = : H WITH NC
DB2ADMINPERF , 20061107 , 153229 1 0 2
1 1 Reusable ISV Different Lengths 0 1
0 0 0 0 A7? 1 2006-11-07 15:32:30.980811
QZDASOINIT QUSER 062220 - QIWS QZDGDBPM
2006-11-07 15:33:56.842838 Record Selection - - No
0 - - - - - 1 1 0 0
2 1 1 1 0 .001 1 1
Yes 3 No No Yes QSYS_QAUGDBPMD_00001 QUSRSYS
QAUGDBPMD QUSRSYS QAUGDBPMD QUSRSYS
QAUGDBPMD .093 .093 .093 0 0 0 .093
2006-11-07 15:33:56.842838 2006-11-07 15:33:56.842838 SELECT INTO
1 SELECT "Jobs Monitored" , "Number of Jobs" INTO : H , : H FROM QUSRSYS
/ QAUGDBPMD WHERE "Name" = : H AND "Date Started" = : H AND "Time Started" = :
H DB2ADMINPERF , 20061107 , 153229 1 0
2 0 0 Reusable ISV - 0 1 0
0 0 0 A7? 1 2006-11-07 15:33:56.807690
QZDASOINIT QUSER 062220 - QIWS QZDGDBPM
Database Performance Monitor Access Plan Rebuild Information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2006-11-07 15:33:56.842838 1 2006-11-07 15:33:56.807690 A7?
SELECT INTO 1 SELECT "Jobs Monitored" , "Number of Jobs" INTO : H , :
H FROM QUSRSYS / QAUGDBPMD WHERE "Name" = : H AND "Date Started" = : H AND
"Time Started" = : H DB2ADMINPERF , 20061107 , 153229
.093 .093 .093 0 0 0 .093 2006-11-07
15:33:56.842838 2006-11-07 15:33:56.842838 1 0 2 0
0 Reusable ISV - 0 1 0 0 0
0 QZDASOINIT QUSER 062220 - QIWS
QZDGDBPM
2006-11-07 15:32:31.078941 1 2006-11-07 15:32:30.980811 A7?
UPDATE 1 UPDATE QUSRSYS / QAUGDBPMD SET "Jobs Monitored" = : H , "Number
of Jobs" = : H WHERE "Name" = : H AND "Date Started" = : H AND "Time Started" =
: H WITH NC DB2ADMINPERF , 20061107 , 153229 .316
.316 .316 0 0 0 .316 2006-11-07 15:32:31.078941
2006-11-07 15:32:31.078941 1 0 2 1 1
Reusable ISV Different Lengths 0 1 0 0
0 0 QZDASOINIT QUSER 062220 - QIWS
QZDGDBPM
Database Performance Monitor Program Summary
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
QIWS QZDGDBPM 1 .409 .316 .204 0 0
0 .316 2 2 0 0 1.000 0 0 0
0 2 2 1 1 2.000 .500 .500
1 .234 .220 .016 .205 .002
.013 .003 8 1 0 2 0 0 0 0
1 0 1 3 0 .250 .750 0
Performance Monitor Job Summary
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
QZDASOINIT QUSER 062220 .643 .316 .078 .205 .002
.013 .316 10 3 0 2 .333 0 0 0
1 2 2 3 1 0 .666 .166 0
Performance Monitor General Summary
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.643 .316 .078 .205 .002 .013 .316 10 3 0
2 .333 0 0 0 1 2 2 3 1
.833 .666 .166
midrange.com
