well this is a snapshot from your system, you need to collect data over a longer period of time
half of you memory is full with non-comutational pages, so your database has a lot of room to grow in memory
post the output of vmo -a
Quote:
I didnt understand. You mean i dont have paging space defined? Please see following
of course you have paging space defined, I mean to the time you took the svmon output, there was no paging space activity, but there was paging, since your paging space is full to 30%
you need to collect data specially to peak times, eg. backup times, a lot of concurrent users, big jobs and so on
it won't help you that your database is idle most of the time and to peak times users can't log in