RE: Database partitioning

Well said Bob.


Sandeep - If you have a mixture of disk drive models on your AS400 (some
faster, some slower) see the help text for the following v4r4 commands...

End ASP Balance  (ENDASPBAL)
Start ASP Balance (STRASPBAL)
Trace ASP Balance (TRCASPBAL)

Even in this unusual situation, the system is really handling it for you.

Regards,
Jerry Jewel

"Better living through fine code and hot coffee!"


> -----Original Message-----
> From: Bob Buchanan [SMTP:bobbyb@camstar.com]
> Sent: Friday, April 28, 2000 9:54 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Database partitioning
> 
> Why?
> 
> In addition to Single Level Storage, the AS/400 automatically moves
> frequently accessed data to locations on disk to optimize it's access. 
> You state that your "potential" table sizes are too large.  Too large
> for what?  The query (sql) optimizer on the AS/400 works quite well at
> selecting the most efficient access plan for the data.  If you find some
> queries needing a little more speed, you can use debug to determine
> additional indexes to be added to speed access.  You can also use sql
> delete statements to purge data as easily (and with as much control) as
> with the oracle partition scheme outlined.  
> 
> So, what is it you think you need to control that the system does for you?
> 
> -Bob Buchanan
> 
> > Sandeep Potnis wrote:
> > 
> > Alexei,
> > 
> > I understand that AS/400 has single level storage but I cannot control
> > it. Besides Oracle type of partitioning makes it easy to purge uneeded
> > data - you can just drop the partition and create a new one for new
> > data.
> > 
> > So -  I understand what single level storage is but I am looking for
> > more control.
> > 
> > Thanks for your response
> > 
> > Sandeep
> 
+---
| 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
+---