Improved Temporary Storage Tracking for IBM i (Part 9)
IBM continues to enhance temporary storage tracking and management, which was significantly improved beginning with IBM i 7.2.
(more…)IBM i 7.2 Improved Temporary Storage Tracking (Part 8)
Temporary storage is tracked in a set of buckets; each active job has its own bucket, and there are global buckets used for temporary storage, but not associated with a specific job.
This week I want to let you know of an article written by IBMer Tim Clark of IBM that was recently published on the IBM i Developer site titled: Temporary storage and the database, Part 2 – Manage your Maintained Temporary Indexes (MTIs).
(more…)Manage Trigger Programs in Production
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…)JSON_TABLE Function
There’s a new type of data that can be consumed by using SQL on IBM i… JSON (JavaScript Object Notation).
(more…)