Author: "MC Matt Cooper (2838)" <Matt.Cooper AT AMGREETINGS DOT COM>
Date: Mon, 17 Feb 2003 09:28:15 -0500
Hello all, I have been reading the dialog on OS/390 performance tuning. I too have found that lowering the size of the address space to 512MB has helped. I have also seen improvements in my throughpu
Author: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Mon, 17 Feb 2003 10:12:13 -0500
I like to set it about 10% higher than the happy point and set it to yes on AIX. Then check it every once and a while to see if it needs adjusting. The problem is you can create a lot of GETMAINs on
Author: John Naylor <john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK>
Date: Mon, 17 Feb 2003 15:00:47 +0000
Matt, I have always had SELFTUNEBUFPOOLSIZE no By the way I run with buffpool 48mb against 28 gb database 70% full. Experiment with some different settings against same workloads to see which gives y
Author: "MC Matt Cooper (2838)" <Matt.Cooper AT AMGREETINGS DOT COM>
Date: Mon, 17 Feb 2003 10:44:30 -0500
Paul, How can I tell what size my BUFPOOLSIZE has grown to? I know I start at 32MB but I don't know how much it grows/shrinks. Matt I like to set it about 10% higher than the happy point and set it t
Author: "Miller, Ryan" <Miller.Ryan AT PRINCIPAL DOT COM>
Date: Mon, 17 Feb 2003 12:02:48 -0600
You can check the size of your buffer pool by querying your server options. q opt Ryan Miller Principal Financial Group Tivoli Certified Consultant Tivoli Storage Manager v4.1 Paul, How can I tell wh
If you do a "q status" command, look at the line titled BufPoolSize. This is the actual bufferpoolsize that has being used when using SELFTUNEBUFPOOLSIZE set to YES.. I like to set it about 10% highe
Author: "MC Matt Cooper (2838)" <Matt.Cooper AT AMGREETINGS DOT COM>
Date: Mon, 17 Feb 2003 14:11:08 -0500
Thanks Matt If you do a "q status" command, look at the line titled BufPoolSize. This is the actual bufferpoolsize that has being used when using SELFTUNEBUFPOOLSIZE set to YES.. so too looks just Da
Author: Zlatko Krastev <acit AT ATTGLOBAL DOT NET>
Date: Mon, 17 Feb 2003 23:09:14 +0200
Misleading! - "q opt" returns what is set in dsmserv.opt not the actual usage, i.e. 32 MB from the initial question; - "q db f=d" is the correct answer! Have in mind the result is in pages, not kB or