By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

UDB V8 (Fixpak8) - "Database files closed" monitor element

P: n/a
Hi:

Currently, MAXFILOP cfg parameter is set to maximum value allowed for
AIX 64bit:
Max DB files open per application (MAXFILOP) = 1950

Still, we see "Database files closed" increasing gradually:
Database files closed = 825

DGTT's are used heavily by application and most of the files closed
comes from "user temporary tablespace" and some from "system temporary
tablespace". We also have DB2_SMS_TRUNC_TMPTABLE_THRESH=0 to avoid JFS2
hangs.

Any ideas?

Thanks.

Vijay

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.