Filter
Top Products
CHAPTER 13 Monitoring and Tuning Performance
471
• FLWait: Number of times IQ had to wait for the lock on the free list
(repeated for the temp cache)
• MemLks: Number of times IQ took the memory manager (heap) lock
• MemWts: Number of times IQ had to wait for the memory manager
lock
•
-threads displays information about processing threads
• cpus: Number of CPUs on system
• Limit: size of thread manager pool
• NTeams: Number of thread teams currently in use
• MaxTms: Largest number of teams that has ever been in use
• NThrds: Current number of existing threads
• Resrvd: Number of threads reserved for system (connection) use
• Free: Number of threads available for assignment
• Locks: Number of locks taken on the thread manager
• Waits: Number of times IQ had to wait for the lock on the thread
manager
•
-interval specifies the reporting interval in seconds. The default is every 60
seconds. The minimum is every 2 seconds. You can usually get useful
results by running the monitor at the default interval during a query or time
of day with performance problems.
•
-append | - truncate Append to existing output file or truncate existing
output file, respectively. Truncate is the default.