Salesforce

How to run a promon gather script on Windows with Workgroup Database license?

« Go Back

Information

 
TitleHow to run a promon gather script on Windows with Workgroup Database license?
URL Name000051233
Article Number000110462
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.x,11.x
OS: Windows
Question/Problem Description
How to run a promon gather script on Windows with Workgroup Database license?
How to gather promon statistics from a database running on Windows with Workgroup Database license?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution

NOTE:  As of 8/16/2013 a new form of the Gather for Windows has been created.
An attachment to this article contains the gather.txt file
The file should be downloaded and renamed gather.cmd.
It will now create a gatherin.txt and run both promon and Windows Performance Monitor tools to collect data.
The older information below has been maintained for legacy sake for anyone who prefers the manual approach.
Using the below text file will not collect the Windows Performance Monitor data which is less useful than using the full scripted gather.

Windows PerfMon data is collected into a perfmon_gather.blg file.

1.   Create a text file called gatherwin.txt that contains the following entries:

m
1
9999
3
1
4
1
q
4
1
q
4
1
q
4
1
q
6
q
7
q
R&D
5
1
9999
3
10
4
10
5     
1                   
6
3
t                      
1                      
4                      
3                      
p                      
2                      
p                      
5                      
p                    
6                    
p                    
4                    
p                    
7                    
t                    
1                    
3                    
p                    
6                    
1                    
p                    
14                   
p                    
12                   
p                    
1                    
t                    
2                    
1                    
s                    
t                    
2                    
2                    
t                
2                
5                
a                
p                
13               
a                
p                
7                
a                
t                
3                
2                
p                
4                
t                
3                
2                
t                
1                
16              
r
r
t         
debghb    
6         
t         
3         
1         
t         
6         
5         
p         
6         
t         
6         
8         
s         
p         
9         
s         
x   

2. Save the text file into the OpenEdge working directory.

3. Launch a proenv session from the OpenEdge Program group.

4. Type in the following command: 

        promon dbname -NL < gatherwin.txt >> output.txt  

A text file called output.txt will be created in the working directory.

Workaround
Notes
The following is a listing of the gatherwin.txt file with comments indicating what the numbers relate to.  Please do not use the information in this note as a gatherwin.txt file as the process will fail to gather appropriate data due to the comment characters of #.  REM has also been used and experienced the same issue. 

3  # Block Access
1  # Display all Entries
q  # Return to Main Menu
R&D  # Access the R&D Advanced Options
5  # Adjust Monitor Options
1  # Display page length
9999  # Enter 9999 for length
3  # Monitor sampling interval
3  # Enter 3 for the sampling interval
5  # Pause between screens
10 # Enter 10 for pause between pages entry
6 # Number of auto repeats 
3 # Enter 3 for # of auto repeats
t # Enter t to get back to the Main (Top) R&D menu 
1 # Status Displays
4 # Processes/Clients
3 # Active Transactions
p # Enter P for previous screen
2 # Blocked clients
p # Enter P for previous screen
5 # Local Batch Clients
p # Enter P for previous screen
6 # Remote Clients
p # Enter P for previous screen
4 # Local Interactive Clients
p # Enter P for previous screen
7 # Background Processes
t # Enter t to get back to the Main (Top) R&D menu
1 # Status Displays
3 # Servers
p # Enter P for previous screen
6 # Lock Table 
1 # Display all lock entries
p # Enter P for previous screen
14 # Shared Memory Segments
p # Enter P for previous screen
12 # Startup Parameters
p # Enter P for previous screen
1 # Database
t # Enter t to get back to the Main (Top) R&D menu
2 # Activity Displays
1 # Summary
a # Enter a to activate auto repeat
t # Enter t to get back to the Main (Top) R&D menu
2 # Activity Displays
2 # Servers
z # Enter Z to zero the counters 
u # Enter U to update the counters
t # Enter t to get back to the Main (Top) R&D menu
2 # Activity Displays
5 # BI Log
a # Enter A to activate auto repeat mode.
p # Enter P for previous screen
13 # Other
a # Enter A to activate auto repeat mode
p # Enter P for previous screen
7 # Lock Table
a # Enter A to activate auto repeat mode
t # Enter t to get back to the Main (Top) R&D menu
3 # Other Displays
2 # I/O Operations by Process
p # Enter P for previous screen
4 # Checkpoints
t # Enter t to get back to the Main (Top) R&D menu
debghb # Enter debghb and press return to start access to hidden menu
6 # Enter 6 to access the hidden menu
3 # Page Writer Queue
p # Enter P for previous screen
6 # Buffer Locks
p # Enter P for previous screen
8 # Resource Queues
a # Enter A to activate auto repeat mode
p # Enter P for previous screen
9 # TXE Lock Activity
a # Enter A to activate auto repeat mode

x # Enter x to exit
Keyword Phrase
Last Modified Date12/9/2020 3:32 PM

Powered by