Wanna be a hero?

Post #69,997 by imric 12/19/02 5:33:33 PM 12/19/02 6:11:48 PM Reply	Wanna be a hero? I've seen performance problems that seem similar before. Turn on the 'performance adjustment' - some admins with experience on older versions of OS/400 turn this off (it used to be really bad). To turn it on, use: wrksysval qpfradj and select '3' (automatic adjustment). If you don't want to turn on the performance adjustment, memory pools can be adjusted manually with wrksyssts - use f11 for different views. I've seen the performance adjustment (post v4 OS/400, anyway) make dramatic performance gains, though... Imric's Tips for Living Paranoia Is a Survival Trait Pessimists are never disappointed - but sometimes, if they are very lucky, they can be pleasantly surprised... Even though everyone is out to get you, it doesn't matter unless you let them win. Edited by imric Dec. 19, 2002, 05:34:20 PM EST Edited by imric Dec. 19, 2002, 06:11:48 PM EST Expand All History
Post #69,999 by inthane-chan 12/19/02 5:45:26 PM Reply	Boggle To get turn it on, use: wrksysval qpfradj and select '3' (automatic adjustment). Man, if I didn't know any better - I'd say that looks like somebody smacking the keyboard to make random values come out. Gimli's Rules for Surviving in Middle Earth #43: When attempting to destroy an artifact, remember to use somebody else's axe.
Post #70,001 by bepatient 12/19/02 5:49:53 PM Reply	Used to think the same thing... ...but its actually relatively easy to get used to. Once you know what everything is called...you can almost start to guess what the IBM folks ended up using for the command abbreviation. You were born...and so you're free...so Happy Birthday! _{Laurie Anderson} [link\|mailto:bepatient@aol.com\|BePatient]
Post #70,003 by imric 12/19/02 6:10:39 PM Reply	chuckle Command names are pieced together from 1, 2, or 3 letter 'pieces' like, wrk for work, sys for system, dsp for display, f, for files, etc. wrksysval actually means "work with system values" dspf means "display file" cpyf is "copy file", etc, etc. As bepatient says, its actually not hard to get used to. Imric's Tips for Living Paranoia Is a Survival Trait Pessimists are never disappointed - but sometimes, if they are very lucky, they can be pleasantly surprised... Even though everyone is out to get you, it doesn't matter unless you let them win.
Post #70,035 by slugbug 12/19/02 9:00:50 PM Reply	and... before turning on auto-tuner: wrkshrpool is everything running out of *base and is there adequate min/max for the pool? or, is the db activity running in a shared pool? you can see where it is running by doing: wrkactjob F11 look for the pool ID you might also run idoctor against the system to get a clearer understanding of where the performance troubles are coming from. also, are you using toolkit or native driver for sql access? this can impact performance too. as for processors, there are 400 models that have single processor (maybe this is a 270?) as well as models that exceed 20+ processors. -slugbug
Post #70,040 by imric 12/19/02 9:18:08 PM Reply	smile Trust you to be more thorough than I! Imric's Tips for Living Paranoia Is a Survival Trait Pessimists are never disappointed - but sometimes, if they are very lucky, they can be pleasantly surprised... Even though everyone is out to get you, it doesn't matter unless you let them win.
Post #70,139 by mmoffitt 12/20/02 3:15:55 PM Reply	Thank you. I will see if they let me check any of that the next time I'm in. Appreciate your efforts and suggestions. Knowing these guys, I should have prefaced my initial post with "I understand that any host is only as good as its Admin, but, ..." ;-) This is all stuff they know to do, I suppose. But I'd bet not. BTW, a friend of mine that works there just pinged me. He ran a Crystal Report based on a single query with one join. It was some numbers grouped by week over 3 months. The report took 19 hours to run. Now, I know his Sql could be really bad, but 19 hours? <:-O

Welcome to IWETHEY!