I have written several posts on the 7.2 temporary storage tracking improvements, and I thought I had covered everything sufficiently. But wait, there’s more! Here’s more information on temporary storage accounting.
Part 1 on this topic introduced the temporary storage buckets that were added in the 7.2 release; that article summarized how there are two types of temporary storage buckets: those associated with a job and the global buckets. Part 2 showed you how you could display the temporary storage buckets via the Navigator for i web console, and part 6 described how you could display the temporary storage buckets by using the temporary storage service.
This week I wanted to let you know of an article recently published on the IBM i developer site, Temporary storage and the database – Part 1. It reviews temporary storage use for database, describing the global temporary storage buckets that are used for database queries.
The SQL Query Engine (SQE) uses temporary storage to optimize and run queries, and there are global temporary storage buckets that track the SQL temporary storage use. What is particularly nice about this article is that it describes the various SQE temporary storage buckets. What is *DATABASE SQE Heap? *DATABASE Segment Cache? And others? This article will explain these temporary storage buckets to you and what they are used for. I’m not going to repeat the information written there, but it is an excellent resource for understanding temporary storage use on your IBM i.
For your reference, below are links to all the prior blog articles on improved tracking of temporary storage.
- Part 1 – Introduced the changes made in 7.2 including the new temporary storage buckets
- Part 2 – System status enhancements in 7.2, including the ability to display the temporary storage buckets in Navigator for i
- Part 3 – Enhancements made to better understand temporary storage consumption at a job level
- Part 4 – Enhancements made to IBM i performance data and the new charts in the performance data investigator
- Part 5 – Notification/automation support to proactively determine potential temporary storage issues
- Part 6 – Temporary storage service that allows you to use SQL to query the temporary storage buckets
This blog post was edited to fix broken links on April 15, 2020.
This blog post was originally published on IBMSystemsMag.com and is reproduced here by permission of IBM Systems Media.