Thanks Terry,

we have received similar answer from another forum:

"I would have thought for a heavily hit DB2 there will be a heavy load on
the Catalog at startup and at peak load times, depending on how many table
spaces and index yor database comprises. I think the default is still 3, so
I would be surprised to find a big kicker like a DB2 catalog to be so low,
maybe up around the 7 or 8 mark. The downside of having multiple strings is
that you use more storage (big deal), so yes, increasing this should be
worthwhile. But as always with an exercise  like this, always monitor the
before and after impact on a known or simulated workload."

Also we have opened a PMR to ask IBM about it. When we obtain a response we
post it here.

Regards
Christian Blesa
DMR-Qualitas

----------------------------------------------------------------------
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

Reply via email to