Promon report

#1
Need Help on generating promon report
i'm working on Database analysis report using Promon.But i'm not able to get details properly for each option.

$DLC/bin/promon -zn $DBPATH/$DB -NL </dbawork/hit_amon>> /dbawork/

input file:
more hit_amon
echo " "
echo "m
1
99999
1
1
q
4
1
q
4
1
q
4
1
q
4
1
q
5
q
6
q
7
q
R&D
1
4
3
q
R&D
1
4
3
r
r
r
q
q"

But i'm receiving output for only first page for all the Database otion

recording locking table

User Control:
Usr Name Type Wait Trans PID Sem Srv Login Time
0 pgresdba BROK -- 0 0 203544 0 0 04/03/18 02:00
1 pgresdba SERV -- 0 0 131022 0 0 04/03/18 02:16
2 pgresdba SERV -- 0 0 202138 0 0 04/03/18 10:35
3 APW -- 250 0 590156 0 0 04/03/18 02:00
4 WDOG -- 0 0 384964 0 0 04/03/18 02:00
5 BIW -- 436 0 110456 0 0 04/03/18 02:00
6 pgresdba MON -- 0 0 174106 0 0 04/03/18 19:57
1044 y290exg REMC -- 0 0 0 4 2 04/03/18 17:22
1045 asilva REMC -- 0 0 0 4 2 04/03/18 11:40
1046 egarcia REMC -- 5264576 0 0 4 2 04/03/18 11:40
1047 y280dxd REMC -- 0 0 0 4 2 04/03/18 16:21
1048 jcruz2 REMC -- 0 0 0 4 1 04/03/18 19:24
1049 joperez REMC -- 0 0 0 4 1 04/03/18 17:41
1050 y290exg REMC -- 0 0 0 4 1 04/03/18 19:44
1052 nsandova REMC -- 0 0 0 4 1 04/03/18 18:48
^L
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags
1049 joperez REC 449 3165589 103 SHR
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L
Record Locking Table:
Usr Name Chain # Rec-id Table Lock Flags
1049 joperez REC 449 3165589 103 SHR
1045 asilva REC 1268 5360143 563 SHR
1045 asilva REC 1271 5360144 565 SHR
1046 egarcia REC 1539 5360414 563 SHR
1046 egarcia REC 1542 5360415 565 SHR
1047 y280dxd REC 2356 5361231 563 SHR
1047 y280dxd REC 2367 5361240 565 SHR
1044 y290exg REC 2499 5361374 563 SHR
1044 y290exg REC 2502 5361375 565 SHR
1049 joperez REC 2542 5361417 563 SHR
1049 joperez REC 2545 5361418 565 SHR
1048 jcruz2 REC 2696 5361571 563 SHR
1048 jcruz2 REC 2699 5361572 565 SHR
1050 y290exg REC 2725 5361600 563 SHR
1050 y290exg REC 2728 5361601 565 SHR
1046 egarcia REC 3470 1562646 103 SHR
1048 jcruz2 REC 5962 4543641 103 SHR
1045 asilva REC 9277 5237894 103 SHR
^L
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#2
I suggest you execute these steps manually in promon so you can see where you're going wrong.

After you enter the page count to 99999, you're still in the "modify defaults" menu. I assume the two "1" lines following that are meant to display the user list, but first you need to a "q" to return to the main menu.

Also, I'm not sure why you have two instances of "R&D"; you don't need that. And once you're in R&D, there is no more "q" for quit so you don't need that either. R&D has different navigation options, like "p" for previous menu, "t" for top-level menu, and "x" for exit.

Here is a sample promon input file, with explanatory comments so you can see what the options do. If you wanted to test it, you would first have to strip off the comments, e.g. with a "cut" command.

Code:
m         Modify defaults
1           page size
9999
q
1         User control
1           all users
q
4         Record locking table
1           all users
q
5         Activity
q
6         Shared resources
q
7         Database status
q
R&D
5         Adjust monitor options
1           Display page length
9999
6           Number of auto repeats
3
p           previous menu
1         Status displays
4           Processes/clients
2             Blocked clients
p
3             Active transactions
p
p
7           Buffer Cache
p
9           BI log
p
10          AI log
p
12          Startup parameters
p
13          Shared resources
p
14          Shared memory segments
p
17          Servers by broker
t         Main menu
2         Activity displays
3           Buffer cache
p
5           BI log
p
6           AI log
p
10          Space allocation
p
13          Other
t         Main menu
3         Other displays
1           Performance indicators
p
4           Checkpoints
t         Main menu
debghb
6         Hidden menu
8           Resource queues
p
11          Latch counts
x         Exit
Note also that the page size you set initially only applies while you're within the main menu. Once you go into R&D, it has its own defaults, including page length, under "adjust monitor options".
 
#3
Thanks Rob,

But still i'm not able to get required information.

Input file:
*p-10035*:/dbawork: more hit_amon
m
1
9999
q
1
1
q

I tried Manually checked using the above option it is showing all the user list, but when i ran using input file it is showing only below user lists
And also i observed for Activity option it showing wrong information.
Any Suggestion.

^LActivity - Sampled at 04/04/18 04:37 for 2:36:28.

Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 %
Writes by APW 85 % Writes by BIW 0 % Writes by AIW 0 %
Buffer Hits 84 %
DB Size 3071 MB BI Size 1023 MB AI Size 8 K
FR chain 0 blocks RM chain 2 blocks
Shared Memory 40184 K Segments 1

0 Servers, 0 Users (0 Local, 0 Remote, 0 Batch),1 Apws

*p-10033*:/dbawork: more db.rpt
^L
User Control:
Usr Name Type Wait Trans PID Sem Srv Login Time
0 pgresdba BROK -- 0 0 367666 0 0 04/04/18 02:00
3 APW -- 0 0 404082 0 0 04/04/18 02:00
4 WDOG -- 0 0 289796 0 0 04/04/18 02:00
5 BIW -- 0 0 413666 0 0 04/04/18 02:00
6 pgresdba MON -- 0 0 182868 0 0 04/04/18 04:24


Manaul tried steps:


*p-10037*:/progdata/prd/reydb1: promon prdrey

PROGRESS MONITOR Version 9

Database: /progdata/prd/reydb1/prdrey

1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database

T. Transactions Control
L. Resolve Limbo Transactions
C. Coordinator Information

M. Modify Defaults
Q. Quit

Enter your selection: m

1 Page size: 24
2 Clear screen for first page: Yes
3 Short pause after each page: 4
4 Long pause after last page: 8
5 Monitor Sampling Interval: 30 sec.
6 APW queue delay: 100 ms.
7 APW queue start: 1
8 APW scan delay: 1 sec.
9 APW scan count: 1
a APW write limit: 25
b BIW scan delay: 0
c Group commit delay: 10

Q Return to main menu

Enter your selection: 1

Page size: 9999

1 Page size: 9999
2 Clear screen for first page: Yes
3 Short pause after each page: 4
4 Long pause after last page: 8
5 Monitor Sampling Interval: 30 sec.
6 APW queue delay: 100 ms.
7 APW queue start: 1
8 APW scan delay: 1 sec.
9 APW scan count: 1
a APW write limit: 25
b BIW scan delay: 0
c Group commit delay: 10

Q Return to main menu

Enter your selection: q

PROGRESS MONITOR Version 9

Database: /progdata/prd/reydb1/prdrey

1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database

T. Transactions Control
L. Resolve Limbo Transactions
C. Coordinator Information

M. Modify Defaults
Q. Quit

Enter your selection: 1

1. Display all entries
2. Match a user number
3. Match a range of user numbers

Q. Return to main menu

Enter your selection: 1

User Control:
Usr Name Type Wait Trans PID Sem Srv Login Time
0 pgresdba BROK -- 81147 0 230164 0 0 04/04/18 02:00
1 pgresdba SERV -- 0 0 391932 0 0 04/04/18 02:00
2 pgresdba SERV -- 0 0 353860 0 0 04/04/18 02:00
3 pgresdba SERV -- 0 0 650724 0 0 04/04/18 02:01
4 pgresdba SERV -- 0 0 640636 0 0 04/04/18 02:03
5 pgresdba SERV -- 0 0 296594 0 0 04/04/18 02:05
6 pgresdba SERV -- 0 0 598308 0 0 04/04/18 02:06
7 pgresdba SERV -- 0 0 571044 0 0 04/04/18 02:06
8 pgresdba SERV -- 0 0 521256 0 0 04/04/18 02:09
9 pgresdba SERV -- 0 0 310710 0 0 04/04/18 02:11
10 pgresdba SERV -- 0 0 321474 0 0 04/04/18 02:12
11 pgresdba SERV -- 0 0 680534 0 0 04/04/18 02:15
12 pgresdba SERV -- 0 0 494270 0 0 04/04/18 02:17
13 pgresdba SERV -- 0 0 750804 0 0 04/04/18 02:20
14 pgresdba SERV -- 0 0 504024 0 0 04/04/18 02:21
15 pgresdba SERV -- 0 0 284104 0 0 04/04/18 02:25
16 pgresdba SERV -- 0 0 208176 0 0 04/04/18 02:31
17 pgresdba SERV -- 0 0 684100 0 0 04/04/18 02:34
18 pgresdba SERV -- 0 0 245554 0 0 04/04/18 02:36
19 pgresdba SERV -- 0 0 231702 0 0 04/04/18 02:44
20 pgresdba SERV -- 0 0 201430 0 0 04/04/18 02:46
21 pgresdba SERV -- 0 0 218442 0 0 04/04/18 02:55
22 pgresdba SQSV -- 0 0 329036 0 0 04/04/18 03:09
23 pgresdba SQSV -- 0 0 223800 0 0 04/04/18 03:09
24 pgresdba SQSV -- 0 0 566808 0 0 04/04/18 03:09
25 pgresdba SERV -- 0 0 366106 0 0 04/04/18 03:30
26 pgresdba SERV -- 0 0 316440 0 0 04/04/18 03:44
27 pgresdba SERV -- 0 0 488122 0 0 04/04/18 04:12
28 pgresdba SERV -- 0 0 443888 0 0 04/04/18 04:30
36 APW -- 14908 0 558038 0 0 04/04/18 02:00
37 APW -- 4348 0 706176 0 0 04/04/18 02:00
38 APW -- 11902 0 347390 0 0 04/04/18 02:00
39 APW -- 10557 0 65376 0 0 04/04/18 02:00
40 APW -- 10490 0 454060 0 0 04/04/18 02:00
41 WDOG -- 0 0 541308 0 0 04/04/18 02:00
42 BIW -- 15156 0 347478 0 0 04/04/18 02:00
43 AIW -- 14994 0 602806 0 0 04/04/18 02:00
44 pgresdba SELF -- 437264832 0 495272 0 0 04/04/18 02:00
45 pgresdba SELF -- 437607552 0 84046 0 0 04/04/18 02:00
46 pgresdba SELF -- 420881344 0 709770 0 0 04/04/18 02:00
47 pgresdba SELF -- 420881344 0 423036 0 0 04/04/18 02:00
48 pgresdba SELF -- 293264576 0 346596 0 0 04/04/18 02:30
49 pgresdba MON -- 0 0 124570 0 0 04/04/18 04:29
971 Fhernand REMC -- 0 844849916 0 3 27 04/04/18 04:28
972 EHernand REMC -- 0 0 0 3 27 04/04/18 04:12
973 y280emh REMC -- 0 0 0 3 26 04/04/18 04:11
974 y280hds REMC -- 0 0 0 3 26 04/04/18 03:44
975 y280yxl REMC -- 0 0 0 3 26 04/04/18 03:49
976 hoparra REMC -- 0 0 0 3 26 04/04/18 03:48
977 y285emo REMC -- 0 0 0 3 25 04/04/18 03:46
978 gperez REMC -- 0 0 0 3 25 04/04/18 03:43
979 y281gxb REMC -- 0 0 0 3 25 04/04/18 03:59
980 y280sds REMC -- 0 0 0 3 21 04/04/18 03:29
981 y280djc REMC -- 0 0 0 3 25 04/04/18 03:41
982 y280tcg REMC -- 0 0 0 3 21 04/04/18 03:26
983 y280sds REMC -- 0 0 0 3 25 04/04/18 03:41
984 mblas REMC -- 0 0 0 3 21 04/04/18 03:22
985 y280yrh REMC -- 0 0 0 3 10 04/04/18 03:53
986 y280yag REMC -- 0 0 0 3 19 04/04/18 04:10
987 y285emo REMC -- 0 0 0 3 5 04/04/18 03:25
988 y280hxz REMC -- 0 0 0 3 21 04/04/18 03:03
989 dperez REMC -- 0 0 0 3 20 04/04/18 03:20
990 DPEREZ REMC -- 0 0 0 3 21 04/04/18 02:55
991 dperez REMC -- 0 0 0 3 20 04/04/18 02:54
992 y281yps REMC -- 0 0 0 3 20 04/04/18 02:53
993 dperez REMC -- 0 0 0 3 26 04/04/18 04:10
994 hdelossa REMC -- 0 0 0 3 20 04/04/18 02:48
995 Dcharcas REMC -- 0 0 0 3 20 04/04/18 02:46
996 y280emh REMC -- 0 0 0 3 18 04/04/18 04:09
997 yguzman REMC -- 0 0 0 3 19 04/04/18 02:44
998 yguzman REMC -- 0 0 0 3 19 04/04/18 02:44
999 yguzman REMC -- 0 0 0 3 19 04/04/18 02:44
1000 y280smm REMC -- 0 0 0 3 19 04/04/18 02:44
1001 y280emh REMC -- 0 0 0 3 18 04/04/18 02:38
1002 y282fxp REMC -- 0 0 0 3 18 04/04/18 02:37
1003 sdelossa REMC -- 0 0 0 3 18 04/04/18 02:37
1004 y284axr REMC -- 0 0 0 3 27 04/04/18 04:25
1005 y280pgv REMC -- 0 0 0 3 18 04/04/18 04:15
1006 y280hvr REMC -- 0 0 0 3 17 04/04/18 02:35
1007 hvizcarr REMC -- 0 0 0 3 17 04/04/18 03:12
1008 y280yag REMC -- 0 0 0 3 17 04/04/18 02:51
1009 y282mxb REMC -- 15054 0 0 3 17 04/04/18 02:51
1010 y287jxr REMC -- 0 0 0 3 17 04/04/18 02:50
1011 y283cxr REMC -- 409504896 844825559 0 3 16 04/04/18 02:32
1012 y283cxr REMC -- 0 0 0 3 16 04/04/18 02:32
1013 y281mmc REMC -- 409285056 0 0 3 16 04/04/18 02:31
 
#5
HI Rob,

yes, Our database running on v9.
Actual Activity option from promon should be

Input file :
m
1
9999
q
1
1
q
5
q
x

DB Size 64 GB BI Size 4095 MB AI Size 691 MB
FR chain 6636 blocks RM chain 12732 blocks
Shared Memory 418900 K Segments 4

34 Servers, 257 Users (4 Local, 253 Remote, 4 Batch),5 Apws


But when i using input file i'm getting wrong information as below.

Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 %
Writes by APW 85 % Writes by BIW 0 % Writes by AIW 0 %
Buffer Hits 84 %
DB Size 3071 MB BI Size 1023 MB AI Size 8 K
FR chain 0 blocks RM chain 2 blocks
Shared Memory 40184 K Segments 1
 
#7
Thanks Rob, yes Database path is wrong. I made changes to script.
Now i able to receive all the input information.
$DLC/bin/promon /progdata/prd/rey -NL </dbawork/hit_amon>> /dbawork/rey.rpt

User Control:
Usr Name Type Wait Trans PID Sem Srv Login Time
0 pgresdba BROK -- 93197 0 230164 0 0 04/04/18 02:00
1 pgresdba SERV -- 0 0 391932 0 0 04/04/18 02:00
2 pgresdba SERV -- 0 0 353860 0 0 04/04/18 02:00
3 pgresdba SERV -- 0 0 650724 0 0 04/04/18 02:01
4 pgresdba SERV -- 0 0 640636 0 0 04/04/18 02:03
5 pgresdba SERV -- 0 0 296594 0 0 04/04/18 02:05
6 pgresdba SERV -- 0 0 598308 0 0 04/04/18 02:06
7 pgresdba SERV -- 0 0 571044 0 0 04/04/18 02:06
8 pgresdba SERV -- 0 0 521256 0 0 04/04/18 02:09
9 pgresdba SERV -- 0 0 310710 0 0 04/04/18 02:11
10 pgresdba SERV -- 0 0 321474 0 0 04/04/18 02:12
11 pgresdba SERV -- 0 0 680534 0 0 04/04/18 02:15
12 pgresdba SERV -- 0 0 494270 0 0 04/04/18 02:17
13 pgresdba SERV -- 0 0 750804 0 0 04/04/18 02:20
14 pgresdba SERV -- 0 0 504024 0 0 04/04/18 02:21
15 pgresdba SERV -- 0 0 284104 0 0 04/04/18 02:25
16 pgresdba SERV -- 0 0 208176 0 0 04/04/18 02:31
17 pgresdba SERV -- 0 0 684100 0 0 04/04/18 02:34
18 pgresdba SERV -- 0 0 245554 0 0 04/04/18 02:36
19 pgresdba SERV -- 0 0 231702 0 0 04/04/18 02:44
20 pgresdba SERV -- 0 0 201430 0 0 04/04/18 02:46
21 pgresdba SERV -- 0 0 218442 0 0 04/04/18 02:55
22 pgresdba SQSV -- 0 0 329036 0 0 04/04/18 03:09
23 pgresdba SQSV -- 0 0 223800 0 0 04/04/18 03:09
24 pgresdba SQSV -- 0 0 566808 0 0 04/04/18 03:09
25 pgresdba SERV -- 0 0 366106 0 0 04/04/18 03:30
26 pgresdba SERV -- 0 0 316440 0 0 04/04/18 03:44
27 pgresdba SERV -- 0 0 488122 0 0 04/04/18 04:12
28 pgresdba SERV -- 0 0 443888 0 0 04/04/18 04:30
29 pgresdba SERV -- 0 0 197670 0 0 04/04/18 08:15
30 pgresdba SERV -- 0 0 295666 0 0 04/04/18 08:18
31 pgresdba SERV -- 0 0 480790 0 0 04/04/18 08:18
32 pgresdba SERV -- 0 0 162296 0 0 04/04/18 08:20
33 pgresdba SERV -- 0 0 55260 0 0 04/04/18 08:21
34 pgresdba SERV -- 0 0 608304 0 0 04/04/18 08:22
36 APW -- 14908 0 558038 0 0 04/04/18 02:00
37 APW -- 16125 0 706176 0 0 04/04/18 02:00
38 APW -- 16509 0 347390 0 0 04/04/18 02:00
39 APW -- 1468 0 65376 0 0 04/04/18 02:00
40 APW -- 15677 0 454060 0 0 04/04/18 02:00
41 WDOG -- 0 0 541308 0 0 04/04/18 02:00
42 BIW -- 10803 0 347478 0 0 04/04/18 02:00
43 AIW -- 10897 0 602806 0 0 04/04/18 02:00
44 pgresdba SELF -- 228122432 0 495272 0 0 04/04/18 02:00
45 pgresdba SELF -- 94242112 0 84046 0 0 04/04/18 02:00
46 pgresdba SELF -- 94242112 0 709770 0 0 04/04/18 02:00
47 pgresdba SELF -- 94242112 0 423036 0 0 04/04/18 02:00
48 pgresdba MON -- 0 0 754546 0 0 04/04/18 14:18
49 pgresdba MON -- 0 0 376680 0 0 04/04/18 15:16
804 maramire REMC -- 0 0 0 3 13 04/04/18 13:10
805 fsantiag REMC -- 0 0 0 3 12 04/04/18 13:07
806 cnguyen REMC -- 0 0 0 3 11 04/04/18 12:48
808 JGriffit REMC -- 0 0 0 3 9 04/04/18 12:47
809 y281exs REMC -- 0 0 0 3 10 04/04/18 15:15
810 ESERAFIN REMC -- 0 0 0 3 7 04/04/18 12:45
811 jegarcia REMC -- 0 0 0 3 6 04/04/18 14:12
812 y281rxe REMC -- 0 0 0 3 9 04/04/18 14:59

Activity - Sampled at 04/04/18 15:16 for 13:15:30.


DB Size 64 GB BI Size 4095 MB AI Size 740 MB
FR chain 6478 blocks RM chain 12368 blocks
Shared Memory 418900 K Segments 4

34 Servers, 285 Users (4 Local, 281 Remote, 4 Batch),5 Apws

Input file:

m
1
99999
q
1
1
q
5
q
R&D
5
1
9999
t
1
6
1
t
1
4
2
t
1
4
3
t
1
3
t
3
3
x
 
#8
Hello,
I'm on OE 11.6 / RHEL 5.11 so it might be different but I'm

Just curious of the command line arguments you are using for promon in the original post. I haven't been able to find any documentation on promon's command line arguments. Looking at promon, it passes the argumenst to _mprshut. But I haven't been able to find any documentation there either.

Need Help on generating promon report
i'm working on Database analysis report using Promon.But i'm not able to get details properly for each option.

$DLC/bin/promon -zn $DBPATH/$DB -NL </dbawork/hit_amon>> /dbawork/
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#9
Hello,
I'm on OE 11.6 / RHEL 5.11 so it might be different but I'm

Just curious of the command line arguments you are using for promon in the original post. I haven't been able to find any documentation on promon's command line arguments. Looking at promon, it passes the argumenst to _mprshut. But I haven't been able to find any documentation there either.
The _mprshut binary implements many different functions, e.g. page writers, watchdog, online backup, and promon, among others. You can pass in UI commands via standard input and redirect output to standard out as shown above. The -NL param is a client startup parameter that can also be used with promon. Its impacts are described in this article:
Using -NL (No-Lock) with promon utility
Knowledge Article

Also see this article on batch use of promon:
How to run a promon gather script on Windows?
Knowledge Article
 
Top