Oninit Logo
The Down System Specialists
+1-913-732-8892
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g mgm Memory grant manager

The onstat -g mgm command displays the current activity being controlled by the memory grant manager. 

Memory Grant Manager (MGM)                                                   
--------------------------                                                   
                                                                             
MAX_PDQPRIORITY:  100                                                        
DS_MAX_QUERIES:    2                                                         
DS_MAX_SCANS:      1048576                                                   
DS_TOTAL_MEMORY:   256 KB                                                    
                                                                             
Queries:   Active     Ready   Maximum                                        
                0         0         2                                        
                                                                             
Memory:     Total      Free   Quantum                                        
(KB)          256       256       128                                        
                                                                             
Scans:      Total      Free   Quantum                                        
           1048576   1048576         1                                       
                                                                             
Load Control:    (Memory)      (Scans)  (Priority)  (Max Queries)   (Reinit) 
                   Gate 1       Gate 2      Gate 3         Gate 4     Gate 5 
(Queue Length)          0            0           0              0          0    
                                                                                
Active Queries:  None                                                           
                                                                                
Ready Queries:  None                                                            
                                                                                
Free Resource        Average #        Minimum #                                 
--------------    ---------------     ---------                                 
Memory               0.0 +- 0.0            32                                   
Scans                0.0 +- 0.0          1048576                                
                                                                                
Queries              Average #        Maximum #    Total #                      
--------------    ---------------     ---------    -------                      
Active               0.0 +- 0.0             0          0                        
Ready                0.0 +- 0.0             0          0                        

Resource/Lock Cycle Prevention count:  0

Parameters

Label Description
MAX_PDQPRIORITY The maximum percentage of system resources that can be used for parallel operations.
DS_MAX_QUERIES The maximum number of queries that can be run simultaneously for parallel operations.
DS_MAX_SCANS The maximum number of scan threads that can participate in parallel operations.
DS_TOTAL_MEMORY The total amount of memory set aside for parallel operations.

Queries

Heading Description Format
Active The current number of active queries. Dec
Ready The number of queries waiting to run. Dec
Maximum The maximum number of queries that can run simultaneously. Dec

Memory

Heading Description Format
Total The total amount of memory assigned for parallel operations. Kbytes
Free The amount of memory remaining for parallel operations. Kbytes
Quantum The smallest unit in which memory will be granted for a request. The quantum is computed as DS_TOTAL_MEMORY / DS_MAX_QUERIES Dec

Scans

Heading Description Format See Also
Total The total number of scan threads allocated for parallel operations. Dec  
Free The number of free scan threads remaining for parallel operations. Dec  
Quantum The smallest unit in which scan threads will be granted for a request. The quantum is computed as DS_MAX_SCANS / DS_MAX_QUERIES Dec  

Load Control

Heading Description Format
Memory The number of queries gated due to memory limitations Dec
Scans The number of queries gated due to scan thread limitations Dec
Priority The number of queries gated due to PDQPRIORITY limitations Dec
Max queries The number of queries gated due to maximum query limitations Dec
Reinit The number of queries gated due to MGM parameters waiting to be reinitialized Dec

Active Queries

Heading Description Format See Also
Session The session ID Dec onstat -g ses
Query The query identifier assigned to this query Dec  
Priority The PDQPRIORITY for this query Dec  
Thread The thread ID performing the query Hex  
Memory The number of memory blocks granted/reserved. Dec  
Scans The number of scan threads granted/reserved. Dec  
Gate If waiting on a gate, the gate number for which the query is waiting. For active queries, always a dash. Dec  

Ready Queries

Heading Description Format See Also
Session The session ID Dec onstat -g ses
Query The query identifier assigned to this query Dec  
Priority The PDQPRIORITY for this query Dec  
Thread The thread ID performing the query Hex  
Memory The number of memory blocks granted/reserved. Dec  
Scans The number of scan threads granted/reserved. Dec  
Gate If waiting on a gate, the gate number for which the query is waiting. Dec  

Free Resource

Heading Description Format See Also
Free Resource The name of the resource being controlled by the memory grant manager Str  
Average # The average number of free units of this resource Flt  
Minimum # The minimum number of free units of this resource Flt  

Queries

Heading Description Format
Queries The type of query being tracked Str
Average # The average number of queries occupying this queue Flt
Maximum # The maximum number of queries to ever occupy this queue Dec
Total # The current total number of queries occupying this queue Dec

Monitoring and Tuning

    The MAX_PDQPRIORITY, DS_MAX_QUERIES, DS_MAX_SCANS and DS_TOTAL MEMORY parameters in the server configuration file tune the Memory Grant Manager.

Notes

    memory quantum = DS_TOTAL_MEMORY / DS_MAX_QUERIES

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.