Dear All
I am still suffering with this problem . Memory is very low
vmstat indicates low fre . As vijay said can we tune "minperm and maxperm"
or need to go to AIX ML 11 . Currently we use DB2 7.2 and ML 9
Anybody using " TSM online backup " . The Process looks like " dsmc " on
ps aux.
--- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 1 718285 583 0 0 1 33 103 0 173 895 194 13 5 80 2
2 2 718132 776 0 1 0 0 0 0 310 2387 273 6 3 88 2
3 2 718132 772 0 0 0 0 0 0 338 1517 231 11 25 57 7
0 2 718132 772 0 0 0 0 0 0 275 1159 198 6 2 91 1
0 2 718132 768 0 0 0 0 0 0 301 1568 246 10 2 86 2
0 2 718132 767 0 0 0 0 0 0 304 556 184 8 1 90 0
0 2 718132 765 0 0 0 0 0 0 277 1264 183 3 1 95 1
0 2 718132 763 0 0 0 0 0 0 288 2422 238 6 3 91 0
1 3 718132 758 0 0 0 0 0 0 422 4946 437 18 48 18 17
0 2 718135 755 0 0 0 0 0 0 262 462 75 2 6 91 1
0 2 718132 756 0 0 0 0 0 0 289 488 156 2 0 97 1
3 2 718135 749 0 0 0 0 0 0 378 2576 788 32 2 62 3
2 2 718132 751 0 0 0 0 0 0 278 1825 422 58 3 39
Raghavan.Anand-[Email Address Removed] 09:55 AM
To: "Venkat, Vijay" <[Email Address Removed] cc: [Email Address Removed] Subject: RE: Db2 issue on AIX 4.3.3
We have reduced the bufferpool for one of the non-mission critical
databases and things have improved. ----------------------------------------------------------
This email is confidential. If you are not the addressee tell the sender
immediately and destroy this email without using, sending or storing it.
Emails are not secure and may suffer errors, viruses, delay, interception
and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not
accept liability for damage caused by this email and may monitor email
traffic. Unless expressly stated, any opinions are the sender's and are
not approved by SCGroup and this email is not an offer, solicitation,
recommendation or agreement of any kind.
Standard Chartered Bank ("SCB") is a member of SCGroup incorporated in
England with limited liability. SCB's principal office is 1 Aldermanbury
Square, London, EC2V 7SB, UK. SCB is authorised and regulated by the
Financial Services Authority ("FSA") and in FSA's register under no.
114276. SCB's VAT no. is GB244106593. FSA is the lead regulator for the
SCGroup. For regulators in other countries contact the local compliance
officer.
---------------------------------------------------------
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail:
db2udbdba-[Email Address Removed] message has originated from an open public network and cannot be
wholly relied upon to be authentic.
---------------------------------------------------------
----------------------------------------------------------
This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by SCGroup and this email is not an offer, solicitation, recommendation or agreement of any kind.
Standard Chartered Bank ("SCB") is a member of SCGroup incorporated in England with limited liability. SCB's principal office is 1 Aldermanbury Square, London, EC2V 7SB, UK. SCB is authorised and regulated by the Financial Services Authority ("FSA") and in FSA's register under no. 114276. SCB's VAT no. is GB244106593. FSA is the lead regulator for the SCGroup. For regulators in other countries contact the local compliance officer.
---------------------------------------------------------
DB2 & UDB email list listserv db2-l LazyDBA home page