ca.portal.admin

IDMS 17 & zIIP

Discussion created by ca.portal.admin on Apr 21, 2009
Latest reply on Apr 21, 2009 by ca.portal.admin
preliminary results

our heaviest hit CV: 10-12 million transactions/hour
defaulted to 11 subtask - MQDEPTH of 4 (i have since lowered it to 3)

DISPLAY MPMODE TABLE
*** MULTITASK ENVIRONMENT, MPMODE TABLE ***
NAME REQUEST COUNT WAIT COUNT
---- ------------- ----------
ANY 1,470,820,261 00
DC 3,267,846,172 59,505,028
DB 2,835,150,425 2,527,385,023
USER 9,596 00
LOADER 128 00
DRIVER 35,999 00

DISPLAY SUBTASKS
*** Display all subtasks ***
Work Task dispatch
Name Nr type Status count Wakeup count Total
CPU
time
---- -- ---- ------ ------------- ------------
--------------
MAINTASK 01 IDMS IDLE 6,916 2,191
00:00:01.0722
SUBT0001 02 IDMS IDLE 00 00
00:00:00.0000
SUBT0002 03 IDMS IDLE 00 00
00:00:00.0000
SUBT0003 04 IDMS IDLE 00 00
00:00:00.0000
SUBT0004 05 IDMS IDLE 21 02
00:00:00.0000
SUBT0005 06 IDMS IDLE 2,655 202
00:00:00.0000
SUBT0006 07 IDMS IDLE 225,131 18,183
00:00:00.0113
SUBT0007 08 IDMS IDLE 17,259,205 1,223,667
00:00:00.5681
SUBT0008 09 IDMS IDLE 513,523,667 32,498,883
00:00:16.8398
SUBT0009 10 IDMS BUSY 1,633,182,761 171,603,197
00:01:13.4576
SUBT0010 11 IDMS IDLE 1,493,003,343 1,072,724,051
00:06:43.1507

DISPLAY SUBTASK 011
*** Display Subtask details ***
Name SUBT0010
Number 11
Status IDLE
Work type IDMS
Count wakeups 1,073,640,352
Count task dispatches 1,497,998,329
User mode CPU time 00:00:00.0000
System mode CPU time 15:37:16.2435
CPU effectiveness (%) 80
Count times fast posted 1,129,049,368
Count times OS posted 00
Count found work pass 1 997,711,198
Count found work pass 2 500,287,131
Count times POSTEXIT resumed 1,070,597,878
*** Enclave Info ***
zIIP time 15:10:27.3379
zIIP on CP time 00:20:05.3424
CPU effectiveness (%) 100
Count swap attempts 14,885,075
Count actual swaps 14,885,061

DISPLAY SUBTASK 010
*** Display Subtask details ***
Name SUBT0009
Number 10
Status BUSY
Work type IDMS
Count wakeups 172,083,035
Count task dispatches 1,634,439,141
User mode CPU time 00:00:00.0000
System mode CPU time 03:55:27.7465
CPU effectiveness (%) 83
Count times fast posted 7,879,043
Count times OS posted 00
Count found work pass 1 1,550,134,708
Count found work pass 2 84,304,433
Count times POSTEXIT resumed 172,081,958
*** Enclave Info ***
zIIP time 03:41:39.8137
zIIP on CP time 00:12:34.4059
CPU effectiveness (%) 99
Count swap attempts 2,622,414
Count actual swaps 2,622,412

DISPLAY SUBTASK 009
*** Display Subtask details ***
Name SUBT0008
Number 09
Status IDLE
Work type IDMS
Count wakeups 32,527,577
Count task dispatches 513,790,538
User mode CPU time 00:00:00.0000
System mode CPU time 01:02:42.6629
CPU effectiveness (%) 81
Count times fast posted 296,225
Count times OS posted 00
Count found work pass 1 495,360,877
Count found work pass 2 18,429,661
Count times POSTEXIT resumed 32,527,515
*** Enclave Info ***
zIIP time 00:57:19.5505
zIIP on CP time 00:05:06.2642
CPU effectiveness (%) 98
Count swap attempts 650,039
Count actual swaps 650,039

DISPLAY SUBTASK 008
*** Display Subtask details ***
Name SUBT0007
Number 08
Status IDLE
Work type IDMS
Count wakeups 1,223,958
Count task dispatches 17,261,417
User mode CPU time 00:00:00.0000
System mode CPU time 00:02:03.1556
CPU effectiveness (%) 74
Count times fast posted 4,899
Count times OS posted 00
Count found work pass 1 16,606,326
Count found work pass 2 655,091
Count times POSTEXIT resumed 1,223,957
*** Enclave Info ***
zIIP time 00:01:41.8965
zIIP on CP time 00:00:20.6906
CPU effectiveness (%) 98
Count swap attempts 21,445
Count actual swaps 21,445

DISPLAY SUBTASK 007
*** Display Subtask details ***
Name SUBT0006
Number 07
Status IDLE
Work type IDMS
Count wakeups 18,184
Count task dispatches 225,131
User mode CPU time 00:00:00.0000
System mode CPU time 00:00:01.6190
CPU effectiveness (%) 75
Count times fast posted 63
Count times OS posted 00
Count found work pass 1 215,671
Count found work pass 2 9,460
Count times POSTEXIT resumed 18,184
*** Enclave Info ***
zIIP time 00:00:01.2986
zIIP on CP time 00:00:00.3090
CPU effectiveness (%) 97
Count swap attempts 323
Count actual swaps 323

DISPLAY SUBTASK 006
*** Display Subtask details ***
Name SUBT0005
Number 06
Status IDLE
Work type IDMS
Count wakeups 202
Count task dispatches 2,655
User mode CPU time 00:00:00.0000
System mode CPU time 00:00:00.0180
CPU effectiveness (%) N/A
Count times fast posted 01
Count times OS posted 00
Count found work pass 1 2,543
Count found work pass 2 112
Count times POSTEXIT resumed 202
*** Enclave Info ***
zIIP time 00:00:00.0147
zIIP on CP time 00:00:00.0033
CPU effectiveness (%) 98
Count swap attempts 01
Count actual swaps 01

DISPLAY SUBTASK EFFECTIVENESS
*** Subtask display ***
Subtask Elapsed time Total CPU time %
CPU SRB
Name TCB SRB TCB SRB TCB
SRB
-------- -------------- -------------- -------------- -------------- ---
---
MAINTASK 00:00:04.3765 00:00:00.0684 00:00:01.0722 00:00:00.0749 24
109 Y
SUBT0001 00:00:00.0001 00:00:00.0000 00:00:00.0000 00:00:00.0000 00
N/A Y
SUBT0002 00:00:00.0001 00:00:00.0000 00:00:00.0000 00:00:00.0000 00
N/A Y
SUBT0003 00:00:00.0000 00:00:00.0000 00:00:00.0000 00:00:00.0000 N/A
N/A Y
SUBT0004 00:00:00.0000 00:00:00.0001 00:00:00.0000 00:00:00.0001 N/A
100 Y
SUBT0005 00:00:00.0000 00:00:00.0183 00:00:00.0000 00:00:00.0180 N/A
98 Y
SUBT0006 00:00:00.0149 00:00:01.6460 00:00:00.0113 00:00:01.6077 75
97 Y
SUBT0007 00:00:00.7672 00:02:05.0245 00:00:00.5685 00:02:02.6041 74
98 Y
SUBT0008 00:00:20.5983 01:03:33.8557 00:00:16.8550 01:02:27.3845 81
98 Y
SUBT0009 00:01:27.7680 03:56:32.8645 00:01:13.5999 03:54:26.2755 83
99 Y
SUBT0010 00:08:21.4708 15:29:31.2295 00:06:44.2907 15:32:01.1725 80
100 Y
-------- -------------- -------------- -------------- -------------- ---
---
Totals 00:10:14.9959 20:31:44.7070 00:08:16.3976 20:30:59.1373 80
99


to be honest - it will take me a while to digest all this to determine
what this means - but our perf/tuning folks tell me that IDMS is
exploiting zIIP more than any other WLM group on the LPAR ...(DDF is a
not-so-close second ...)

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com




The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you
receive this material/information in error, please contact the sender
and delete or destroy the material/information.
"
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: IDMS 17 & zIIP
"Chris, two questions come to mind.

1. How many engines are available to the LPAR where this
system runs?
2. How do your stats look running at 3 subtasks ?


Hal Govan
Senior Database Administrator
Reed Elsevier - Technology Services
harold.govan@reedelsevier.com
Phone: (937) 865-7820

Outcomes