1 person found this helpful
"dssize" is used to report the current memory status of the permanent and temporary partitions and the maximum, allocated and in-use sizes for the database.
Command> dssize The following values are in KB: PERM_ALLOCATED_SIZE: 40960 PERM_IN_USE_SIZE: 11043 PERM_IN_USE_HIGH_WATER: 11043 TEMP_ALLOCATED_SIZE: 32768 TEMP_IN_USE_SIZE: 9446 TEMP_IN_USE_HIGH_WATER: 9509 Command>
Line 06. shows the highest usage of Permsize memory.
Line 05. shows the current allocation.
Line 04. shows the actual allocated size.
The same for the TEMP_* parameters.
The values are available/gotten from the table sys.monitor.
You do not need to reduce *_IN_USE_HIGH_WATER values as they are for information only, showing the max used memory for Tempsize and Permsize memory, as used by using the db.
To reset the stats, bounce the database and view the output of dssize BEFORE the database does any work and the high water stats will be lower in all likelyhood.
Take a look at Permsize and Tempsize as described in the manual.
Thanks for answer.