2. Using Ingres Commands : iishowres Command--Display Memory Used by Locking and Logging
 
Share this page                  
iishowres Command--Display Memory Used by Locking and Logging
Valid on UNIX.
Permission required: Access to the directory where the utility is located.
The iishowres utility displays the amount of shared memory the locking and logging system uses to manage logging and concurrency in an installation. The size of the logging and locking memory segment depends on several parameters such as the number of concurrent users, the number of open databases, and the number of lock lists.
The iishowres command has the following format:
iishowres [-d] [-node nodename][-help]
-d
Shows the amount of memory each component of the locking and logging system uses.
If you do not use the -d flag, iishowres returns the total amount of shared memory needed by the logging and locking memory segment (in bytes).
-node nodename
Queries a specific node. A nodename is valid in a cluster installation only.
-help
Displays command syntax online.