Re: setobjacc

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

P
Hello Jeff,

Assuming you have enough storage to load the entire file then it probably will 
help.  
I recall some comments about performance deterioration if the file is updated 
frequently.  

You don't need to run SETOBJACC for each job.  The AS/400 shares main storage 
(even 
in private pools) so stick the file in a private pool and all jobs will 
reference it 
from main storage.

Create a subsystem with a private pool large enough to hold the entire file.  
(700,000 records * 1100 bytes = 734MB)  Start the subsystem to allocate main 
storage.  
Run SETOBJACC once from some job (the start up job perhaps?) specifying the 
private 
pool as the target for the load.

Run the application and see if the users notice any improvement.  Run the 
performance 
tools to measure actual improvement.

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
//--- forwarded letter -------------------------------------------------------
> X-Mailer: AOL 5.0 for Windows sub 70
> Date: Fri, 24 Mar 2000 10:12:18 -0500
> From: JGracetri@aol.com
> To: MIDRANGE-L@midrange.com
> Reply-To: MIDRANGE-L@midrange.com
> Subject: setobjacc

> 
> I have and inquiry over a detail file 700,000 records X 1100. on our 720 
> there is know wait. On our 170(salesman dialin) there is a wait. I have been 
> reading about setobjacc. This looks like it might spped things up. But it 
> looks like this done per each job. 
> 
> I would appreciate any input.
> 
> Jeff G.

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---