by Dawn May | Oct 17, 2017 | SQL, IBM i Services
IBM i Services have become quite popular, and it has become typical for new and enhanced services to be included with IBM i announcements. STACK_INFO is one of the new services that is part of the recent IBM i 7.3 TR3 / IBM i 7.2 TR7 announcement.
(more…)
by Dawn May | Aug 22, 2017 | SQL, Db2 for i
Trigger programs are a data-centric technology to deploy business logic by establishing code that will run (fire) when the associated triggering event occurs.
(more…)
by Dawn May | Mar 16, 2016 | SQL, Navigator for i, Db2 for i, Performance
Last week I wrote about collecting performance data for database. This week I will review how you can visualize that database performance data with the Performance Data Investigator (PDI).
(more…)
by Dawn May | Mar 9, 2016 | SQL, Db2 for i, Performance
In the past, IBM i database performance management and analysis was done using tools specifically created for database, while system performance management and analysis was done using the system performance tools. There was little integration between the two toolsets.
(more…)
by Dawn May | Feb 8, 2016 | SQL, Navigator for i, Db2 for i, Performance
It’s free. It’s simple to enable. It can improve the performance of your IBM i system. Sound interesting?
(more…)
by Dawn May | Jan 15, 2016 | SQL, IBM i Services, Performance
SQL CPU Utilization was introduced in the IBM i 7.2 release. This metric helps you discover how much of your CPU is being used by SQL operations, and is a starting point to determine if your CPU utilization is due to SQL or other work on the system. This metric is available on a per-thread basis and aggregated for the partition as a whole.
(more…)