 
| Subject: | |
| From: | |
| Reply To: | [log in to unmask][log in to unmask]]On Behalf Of RON HORNER Sent: Friday, March 12, 1999 12:07 PM To: [log in to unmask]Subject: Re: Privaleged files that RoadRunner creates Where are you when you try to purge the file. You have to sign on as the creator of the file, to purge it. Later. Ron Horner Operations Manager Administrative Management Group [log in to unmask] [...]40_12Mar199916:23: [log in to unmask] |
| Date: | Thu, 11 Mar 1999 01:44:30 GMT |
| Content-Type: | text/plain |
| Parts/Attachments: |
|
|
In addition to blocking all sets at 2048 (that is 'generally' the best
blocking factor to use - you may want to change some sets to a
different value), you should also perform the following:
:RUN DBUTIL.PUB.SYS
SET basename BUFFSPECS=30(1/120)
SET otherbasename BUFFSPECS=30(1/120)
EXIT
The 30 is arbitrary. The thrust is to override the Image default of:
1(1/2), 2(3/4), ... etc.
This way, the first process to open the database incurs all the
overhead of opening buffers that all subsequent opens do not.
Bob Tyler...
On Wed, 10 Mar 1999 15:09:05 GMT, [log in to unmask] (Curt
Narvesen) wrote:
>I have a client with performance problems on their database. I have run a how
>messy report and identified several datasets that could use repacking based upon
>the elongation values. Besides adding or deleting paths, is there anything else
>that I can look at to help improve their database efficiency?
>
>
>Thanks,
>
>Curt
|
|
|
