Dynamic Load Balancer Plus^{^tm}

A.1.5 Live Lock Analysis Menu

The Master Menu LIVE item displays the Live Analysis of Lock Holders and Waiters menu.

The items on the Live Lock Analysis menu are created from the I/O information collected when the menu item is run.

The Live Lock Analysis of Lock Holders and Waiters menu appears as follows:

Example A-5 Live Lock Analysis of Lock Holders and Waiters Menu

DLB Plus Dynamic Load Balancer PLUS 01-Sep-1995 +-----Live Analysis of Lock Holders and Waiters------+ | | | LOCK CONTENTION ANALYSIS | | LHOLDER Processes Holding Locks | | LWAITER Processes Waiting for Other Processes | +----------------------------------------------------+ EXIT = Exit \ = Back HELP = Help

Appendix B
Sample Input and Processing Screens

B.1 Sampling I/O Information

Before DLB Plus can analyze I/O and lock data, a sample of the system must first be taken. The SAMPLE menu item collects I/O data by taking a snapshot of the images (programs) currently running on the node that you are logged onto.

A new I/O data sample can be CREATED or I/O data can be APPENDED to the existing sample.

Example B-1 Sampling I/O Information

DLB Plus Dynamic Load Balancer PLUS 01-Sep-1995 Sampling Node: TTI Node name : TTI Date last sampled: September 1, 1995 Time last sampled: 11:38 AM Sample taken by : SMITH Create or append : CREATE +--Sample---+ | Create | | Append | +-----------+ Enter CREATE to make a new sample or APPEND to append to the existing sample EXIT = Exit \ = Back HELP = Help

B.2 Consolidating Samples

Samples from several nodes can be consolidated into a single sample. The CONS menu item consolidates one or more node samples into a single sample.

A previous node sample can be saved by consolidating the sample before creating a new sample. A unique name can be given to each sample or group of samples that are consolidated.

B.3 Selecting a Previous Sample

To select a single sample or consolidation from a list of previously created samples or consolidations, choose the SELECT menu item.

B.3.1 Showing Sampled Nodes and Consolidations

SHOW can be entered at the node name prompt to display a list of sampled nodes and consolidations. If only one node has been previously sampled, the screen is repainted with the data for that node.

The following screen is displayed if SHOW is entered and more than one node has been sampled and/or consolidated:

Example B-2 Showing Sampled Nodes

DLB Plus Dynamic Load Balancer PLUS 01-Sep-1995 Select Node or Consolidation +-------------------------------------------------------------------+ | 1) TTI 01-Sep-1995 11:38 AM | | 2) CONSOLIDATED 01-Sep-1995 10:13 AM (Consolidation) | +-------------------------------------------------------------------+ Sequence number? ____ EXIT = Exit \ = Back HELP = Help

Appendix C
DLB Plus Analysis Reports and Graphs

Analysis reports and graphs can be created for one or more samples from a single node or for a consolidation of samples from one or more nodes. Depending on whether one or more samples or a consolidation is being analyzed, the report and graph heading information will vary. The reports conclude with "Report Summary and Analysis" text information.

The examples shown in this appendix are for a consolidation of samples from several nodes.

C.1 Summary Reports

C.1.1 Hot File Analysis Report

The RSHOT item on the Summary Analysis Reports menu creates the "Hot File Analysis (High I/Os)" report. "Hot files" are those files having the most I/O activity. The report detail includes the file name, average rate, total I/Os, read percentage, fragments, file organization, record size, bucket size and file size. The report can be sorted by I/O rate or I/O count.

Example C-1 RSHOT - Hot File Analysis Report

September 1, 1995 DLB Plus Page 1 DLB PLUS Hot File Analysis (High I/O) Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes Sorted By I/O Rate Avg File Rec Bkt File File Name Rate I/Os Read % Frags Org Size Size Size ----------------- ---- ------ ------ ----- ---- ---- ---- ------- PAGEFILE1.SYS 2.96 300781 87.55 1 SEQ 0 0 300000 SALES_DETAIL.DAT 1.68 12621 97.66 5 IND 350 6 6858 PHONE_LOG.DAT .17 10098 33.52 9 IND 60 12 2652 SALES_HISTORY.DAT .17 1858 84.98 102 IND 445 8 21495 DCLTABLES.EXE .13 866 100.00 1 SEQ 512 0 351 TPUSHR.EXE .12 4943 100.00 1 SEQ 512 0 465 SECURESHR.EXE .10 14883 100.00 1 SEQ 512 0 111 INTOUCH.EXE .10 10073 100.00 1 SEQ 512 0 1032 SET.EXE .09 12120 100.00 1 SEQ 512 0 240 MAIL.EXE .09 3730 100.00 1 SEQ 512 0 156 ====== ====== Grand Totals: 371973 87.97

C.1.2 Files for Data Buffer or Data Caching Report

The RSCACHE menu item creates the "Files Suggested for Data Buffering or Data Caching" report. The report lists the number of I/Os for each file name on the selected node. The report detail includes the file name, read percentage, rate (number of I/O's per second), total I/Os, global buffers, file organization, record size, bucket size and file size. The report can be sorted by I/O rate or I/O count.

The "Files Suggested for Data Caching" report appears as follows:

Example C-2 RSCACHE - Files Suggested for Data Caching Report

September 1, 1995 DLB Plus Page 1 DLB PLUS Files Suggested for Data Buffering or Data Caching Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes Sorted By I/O Rate File Rec Bkt File File Name Read % Rate I/Os Gbl Bufs Org Size Size Size ----------------- ------ ----- ----- -------- ---- ----- ---- ----- SALES_DETAIL.DAT 97.66 1.68 12621 20 IND 350 6 6858 SALES_HISTORY.DAT 84.98 .17 1858 0 IND 445 8 21495 SALES_MASTER.DAT 95.74 .01 2490 20 IND 1508 10 16581 INVOICE_DET.DAT 100.00 .00 5516 0 IND 250 3 8706 DICTIONARY.DAT 100.00 .00 814 7 IND 50 3 5250 INVOICE_HDR.DAT 100.00 .00 692 0 IND 250 3 2619 RIGHTSLIST.DAT 100.00 .00 383 0 IND 0 2 120 MAIL.MAI 80.80 .00 224 0 IND 0 5 2001 SUPPORT.DAT 100.00 .00 124 0 IND 426 6 960 CUSTOMER.DAT 100.00 .00 109 0 IND 300 3 1539 STEP_LOG.DAT 84.31 .00 102 0 IND 150 6 132 ====== ===== Grand Totals: 92.04 24933

C.1.3 File Fragmentation Analysis

The RSFRAG menu item creates the "File Fragmentation Analysis" report. The report lists the number of fragments for each file on the selected node. The report includes the file name, fragments, rate (number of I/Os per second), total I/Os, read percentage, file organization, record size, bucket size and file size.

The "File Fragmentation Analysis" report appears as follows:

Example C-3 RSFRAG - File Fragmentation Analysis Report

September 1, 1995 DLB Plus Page 1 DLB PLUS File Fragmentation Analysis Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes File Rec Bkt File File Name Frags Rate I/Os Read % Org Size Size Size ------------------ ----- ----- ------ ------ ---- ----- ---- ------ ACCOUNTNG.DAT 324 .00 4259 .02 SEQ 167 0 7317 SALES_HISTORY.DAT 102 .17 1858 84.98 IND 445 8 21495 SALES.INT_IMG 61 .00 1803 100.00 SEQ 0 0 7854 FORMS_LOG.DAT 27 .00 876 26.94 IND 200 6 1902 RIGHTSLIST.DAT 22 .00 383 100.00 IND 0 2 120 REMIND_MENU.INT 20 .00 210 100.00 SEQ 0 0 8610 MAIL.MAI 15 .00 224 80.80 IND 0 5 2001 PHONE_LOG.DAT 9 .17 10098 33.52 IND 60 12 2652 INVOICE_DET.DAT 6 .00 5516 100.00 IND 250 3 8706 SALES_MASTER.DAT 6 .01 2490 95.74 IND 1508 10 16581 SALES_DETAIL.DAT 5 1.68 12621 97.66 IND 350 6 6858 INVOICE_HDR.DAT 5 .00 692 100.00 IND 250 3 2619 SALES_LOG.DAT 5 .04 649 45.92 IND 100 6 2364 JBCSYSQUE.DAT 4 .00 22282 4.72 SEQ 512 0 408 PAGEFILE.SYS 4 .00 254 60.24 SEQ 0 0 25002 NOTE$SEC.TPU$SECTION 4 .00 121 100.00 SEQ 512 0 993 OPERATOR.LOG 3 .00 632 .00 SEQ 123 0 90 DICTIONARY.DAT 2 .00 814 100.00 IND 50 3 5250 CUSTOMER.DAT 2 .00 109 100.00 IND 300 3 1539 ===== ====== Grand Totals: 65891 47.41

C.1.4 Analysis by Device Report

The RSDEVICE menu item creates the "I/O Analysis Summary by Device" report. The report lists the number of I/Os for each device on the selected node. The report detail includes the device name, rate (number of I/Os per second), total I/Os, read rate, write rate, read and write I/O counts and read percentage. The report can be sorted by I/O rate or I/O count.

The "I/O Analysis Summary by Device" report appears as follows:

Example C-4 RSDEVICE - I/O Analysis Summary by Device Report

September 1, 1995 DLB Plus Page 1 DLB PLUS I/O Analysis by Device Name (Summary) Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes Sorted By I/O Rate Device Name Rate I/Os Rd Rate Reads Wr Rate Writes Read % ----------- ------ ------- ------- ------- ------- ------- ------ _$1$DUA0 2.96 300805 2.56 263337 .40 37468 87.54 _$1$DUB3 1.93 59899 1.85 51059 .08 8840 85.24 _$1$DIA0 1.10 157955 1.10 131744 .00 26211 83.41 _$1$DUA1 .20 426 .02 394 .18 32 92.49 _$1$DUA2 .00 3915 .00 3382 .00 533 86.39 _MINI$DUA0 .00 254 .00 153 .00 101 60.24 _$1$DUC5 .00 8 .00 8 .00 0 100.00 ====== ====== ====== ====== Grand Totals: 523262 450077 73185 86.01

C.1.5 I/O Analysis Summary by Image Report

The RSIMAGE menu item creates the "I/O Analysis Summary by Image" report. The report lists the number of I/Os for each image on the selected node. The report detail includes the image name, rate (number of I/Os per second), total I/Os, read and write I/O counts and read percentage. The report can be sorted by I/O rate or I/O count.

The "I/O Analysis Summary by Image" report appears as follows:

Example C-5 RSIMAGE - I/O Analysis Summary by Image Report

September 1, 1995 DLB Plus Page 1 DLB PLUS I/O Analysis by Image Name (Summary) Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes Sorted By I/O Rate Image Name Rate I/Os Reads Writes Read % --------------------------- ----- ------- ------ ------ ------ INTOUCH_RUN.EXE .02 260 260 0 100.00 ======= ====== ====== ====== Node Totals: 260 260 0 100.00 INTOUCH.EXE .46 34358 25585 8773 74.47 MAIL.EXE .06 509 428 81 84.09 JOBCTL.EXE .00 26728 1239 25489 4.64 OPCOM.EXE .00 696 64 632 9.20 ADANUC.EXE .00 362 238 124 65.75 PRTSMB.EXE .00 211 211 0 100.00 EVL.EXE .00 130 127 3 97.69 INTOUCH_RUN.EXE .00 118 118 0 100.00 ======= ====== ====== ====== Node Totals: 63112 28010 35102 44.38 INTOUCH.EXE 3.29 5361 5361 0 100.00 ======= ====== ====== ====== Node Totals: 5361 5361 0 100.00 ======= ====== ====== ====== Grand Totals: 68733 33631 35102 48.93

C.1.6 I/O Analysis Summary by User Report

The RSUSER menu item creates the "I/O Analysis Summary by User" report. The report lists the number of I/Os for each user on the selected node. The report detail includes the user name, rate (number of I/Os per second), total I/Os, read and write I/O counts and read percentage. The report can be sorted by I/O rate or I/O count.

The "I/O Analysis Summary by User" report appears as follows:

Example C-6 RSUSER - I/O Analysis Summary by User Report

September 1, 1995 DLB Plus Page 1 DLB PLUS I/O Analysis by User Name (Summary) Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes Sorted By I/O Rate User Name Rate I/Os Reads Writes Read % ------------ ------- ------- ------- ------- ------ --VMS-- 4.10 454019 416053 37966 91.64 PETE 1.75 5788 5769 19 99.67 SUE 1.20 3487 3172 315 90.97 BATCH_CTL .95 10852 3455 7397 31.84 JON .89 744 727 17 97.72 DIANE .46 2600 2405 195 92.50 SYSTEM .21 27967 1793 26174 6.41 TOMMY .11 6438 6438 0 100.00 JULIE .04 3854 3523 331 91.41 KENT .00 3652 3458 194 94.69 RACHEL .00 1549 1437 112 92.77 DEBBIE .00 690 479 211 69.42 SMITH .00 544 468 76 86.03 RICK .00 519 482 37 92.87 ADABAS .00 362 238 124 65.75 DECNET .00 175 172 3 98.29 ======= ======= ======= ====== Grand Totals: 523240 450069 73171 86.02

C.1.7 Analysis Summary by PID Report

The RSPID menu item creates the "I/O Analysis Summary by PID" report. The report lists the number of I/Os for each user and PID on the selected node. The report detail includes the user name, node, PID, image name, rate (number of I/Os per second) total I/Os, read and write I/O counts and read percentage.

The "I/O Analysis Summary by PID" report appears as follows:

Example C-7 RSPID - I/O Analysis Summary by PID Report

September 1, 1995 DLB Plus Page 1 DLB PLUS I/O Analysis by PID (Summary) Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes User Name Node PID Image Name Rate I/Os Reads Writes Read% --------- ----- -------- ---------------- ---- ------ ------- ------ ------ DEBBIE TTI 20200A62 INTOUCH_RUN 1.00 1180 1125 55 95.34 TTI 20200BDC TPU .40 369 312 57 84.55 ====== ======= ====== ====== User Totals: 1549 1437 112 92.77 BATCH_CTL TTI 20200096 XXXXXXXXX .17 10065 3311 6754 32.90 TTI 20200097 XXXXXXXXX .04 786 143 643 18.19 TTI 20200161 XXXXXXXXX .01 1 1 0 100.00 ====== ======= ====== ====== User Totals: 10852 3455 7397 31.84 PETER MINI 20600050 XXXXXXXXX .21 16 10 0 62.50 MINI 20600050 XXXXXXXXX 3.29 5361 5361 0 100.00 ====== ======= ====== ====== PID Totals: 5377 5371 6 99.89 ====== ======= ====== ====== Grand Totals: 17778 10209 7515 86.01

C.2 Detail Reports

C.2.1 Analysis Detail by Image Report

The RDIMAGE menu item creates the "I/O Analysis Detail by Image" report. The report lists the number of I/Os for each image on the selected node. The report detail includes the image name, rate (number of I/Os per second), total I/Os, read percentage, file organization, record size, bucket size and file size.

The "I/O Analysis Detail by Image Name" report appears as follows:

Example C-8 RDIMAGE - I/O Analysis Detail by Image Name Report

September 1, 1995 DLB Plus Page 1 DLB PLUS I/O Analysis by Image Name (Detail) Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes File Rec Bkt File Image Name Rate I/Os Read % Org Size Size Size ----------------------- ---- ---- ------ ---- ---- ---- ---- $1$DIA0:JOBCTL.EXE _$1$DIA0:ACCTNG.DAT 1.00 4259 10.02 SEQ 167 0 7317 _$1$DIA0:JOBCTL.EXE .00 14 100.00 SEQ 512 0 285 ==== ====== Image Totals: 4273 57.64 $1$DIA0:OPCOM.EXE _$1$DIA0:OPER.LOG .00 632 .00 SEQ 123 0 90 _$1$DIA0:OPCOM.EXE .00 64 100.00 SEQ 512 0 90 ==== ====== Image Totals: 696 95.20 $1$DUB3:INTOUCH.EXE _$1$DUA0:TTI120.TMP .00 4 50.00 REL 7 16 90 _$1$DUB3:SAL_CON.DAT .00 6 50.00 IND 250 6 114 _$1$DUB3:SAL_DET.DAT 7.07 7620 96.13 IND 350 6 6858 _$1$DUB3:SAL_EXC.DAT .00 4 100.00 IND 150 6 126 _$1$DUB3:SAL_LOG.DAT .04 642 45.33 IND 100 6 2364 ==== ====== Image Totals: 8276 89.20 ==== ====== Grand Totals: 9245 88.20

C.2.2 Analysis Detail by User Report

The RDUSER menu item creates the "I/O Analysis Detail by User" report. The report lists the number of I/Os for each user and image on the selected node. The report detail includes the user name, rate (number of I/Os per second), total I/Os, read percentage, file organization, record size, bucket size and file size.

The "I/O Analysis Detail by User Name" report appears as follows:

Example C-9 RDUSER - I/O Analysis Detail by User Name Report

September 1, 1995 DLB Plus Page 1 DLB PLUS I/O Analysis by User Name (Detail) Consolidation ALL consolidated on Sept 1, 1995 at 03:15 PM by SMITH All nodes File Rec Bkt File User Name Rate I/Os Read % Org Size Size Size ------------------------------ ----- ---- ------ ---- ----- ---- ---- DAVID $1$DUB3:INTOUCH.EXE _$1$DUB3:TTI0001.TMP .00 4 50.00 REL 7 16 90 _$1$DUB3:FORMS_LOG.DAT 1.00 10 100.00 IND 200 6 1902 _$1$DUB3:SALES_DETAIL.DAT 1.41 71 100.00 IND 350 6 6858 _$1$DUB3:SALES_MASTER.DAT 5.21 821 100.00 IND 1508 10 6581 _$1$DUB3:CUSTOMER.DAT .01 8 100.00 IND 300 3 1539 === ====== Image Totals: 914 91.71 $1$DIA0:MAIL.EXE _$1$DIA0:SYSUAF.DAT .03 7 100.00 IND 0 3 267 _$1$DIA0:MAIL_PROFILE.DATA .03 8 75.00 IND 3 5 36 _$1$DUB3:MAIL.MAI .00 52 82.69 IND 0 5 531 === ====== Image Totals: 67 87.58 === ====== User Totals: 981 89.50 === ====== Grand Totals: 981 89.50

Contents

Index

Dynamic Load Balancer Plustm