Monitoring Memory Usage
Onstat -g mgm Print Memory Grant Manager Information
Queries that utilize the parallel features of the database may be expensive both in terms disk accesses and memory utilization. These decision support queries are identified by the fact that they are queries that run with a PDQ priority greater than zero. One of the things that the database administrator needs to be aware of is the status of the PDQPRIORITY for any queries that are running. If a query is run with a high PDQPRIORITY, it can hog the system resources to such an extent that the entire system slows to a crawl.
All memory and other resources used in DSS queries is controlled by the Memory Grant Manager in IDS. It controls:
Number of concurrent queries (specified ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
