| More

Recent News » Performance

DB2 MAXFILOP

Posted by: DBA DB2, on 12 Dec 2011 | View original | Bookmarked: 0 time(s)

While troubleshooting a DB2 performance problem for Websphere Portal 6.1.0   using  DB2 9.5 Enterprise Edition ,  one of the DB2 tuning recommendations from the Portal Tuning guide was to set MAXFILOP = 512   or higher  MAXFILOP is  the Maximum database files open per application configuration parameter. What level to set it? The MAXFILOP parameter defines the maximum file handles that can be opened by a database agent.  If the number is to small , a CPU...

Advertisement

Free Agile Project Management Tool from Telerik TeamPulse Community Edition helps your team effectively capture requirements, manage project plans, assign and track work, and most importantly, be continually connected with each other.

Category: Performance | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 574 | Hits: 3

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD