Tracking IBM i System Limits, Part 2

My last blog was an Introduction to IBM i System Limits and Maximum Capacities. In that blog, I introduced System Health Services, which allow you to track system limits. System limits tracking support is provided via Db2 PTFs, so be sure to install the latest Db2 Group PTF when you start to explore this capability. The limits tracked vary by release and Db2 Group PTF level. 

(more…)

Job Level SQL Metrics in Collection Services

Late last year, IBM enabled new support to collect SQL metrics in Collection Services. I’ll be covering this new capability in two blog articles:

  1. This blog will review the new metrics that are now collected and describe what you need to do to enable the collection of these additional metrics.
  2. A subsequent blog will review the support added to the Performance Data Investigator to allow you to view and analyze these metrics.
(more…)

Integrate Web Services With Db2 for i, Part Two

In part one of this two-part blog entry, the idea was introduced that Db2 for i could be integrated with a Web service, using the user-defined functions in the SYSTOOLS schema and the built-in SQL/XML support. Part one includes a number of links to information about the user-defined functions, and also to information on the built-in SQL/XML support. One important resource was a link to a whitepaper that provides the complete details for these functions.

(more…)