On 2009-05-22 at 07:42, concerning "How do you handle SMS Pools out
of space", Lizette Koehler <[email protected]> wrote to IBM-Main:
> [snip] The pool is dedicated to DB2 Archive Logs. Normally our process
> [snip] works fine. [snip] when there is a runaway DB2 function or a
> large purge, it can fill up quite quickly. [snip]
> > We have a couple of SMS pools that are usually 80% free all the time.
> > However,
> > occasionally they do fill up and I need to manually do ML2 migrations so
> > the appls can
> > continue to work.
Lizette : I, too, have a pool for both log & Image Copies. Logs have
3 day primary & backups are 5 days to reduce recalls. (I think the
backups could be reduced as well since they've probably only used the
image copies 5 time in the last decade but...)
Another item is to carry 1-2 quiesced (QuiNew) volumes in the
destination pool. They will maintain a reserved space within the
pool and are used when the primary allocation can't be achieved by
other volumes in the pool; whether full or fragmented. (Do you
compakt your heavily migrated pool(s)?)
I find the overflow is often reached because an overly large primary
was specified. In my daily job that FDR Moves (DSS alternative)
everything in the overflow pool, most of the datasets are easily
moved back to their proper location without alteration. By that
time, FDR is working with the actual data size and it will usually
fit.
Warning: the overflow pool is preferred unless it *too* is quiesced.
For example:
- pool with quiesced, overflow pool enabled = 1) enabled pool volume,
2) enabled overflow volume, 3) quiesced pool volume, 4) quiesced
overflow volume
- pool with quiesced, overflow pool quiesced = 1) enabled pool volume,
2) quiesced pool volume, 3) overflow pool volume(s)
----------> signature = 6 lines follows <--------------
Neil Duffee, Joe SysProg, U d'Ottawa, Ottawa, Ont, Canada
telephone:1 613 562 5800 x4585 fax:1 613 562 5161
mailto:NDuffee of uOttawa.ca http:/ /aix1.uottawa.ca/ ~nduffee
"How *do* you plan for something like that?" Guardian Bob, Reboot
"For every action, there is an equal and opposite criticism."
"Systems Programming: Guilty, until proven innocent" John Norgauer
2004
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
