by Dawn May | May 1, 2018 | Run SQL Scripts, Spooled files, Navigator for i, Db2 for i, IBM i Services
Job logs for ended jobs, where the job log is in a spooled file, are easy to search on the green screen. When viewing the spooled job log, you simply enter your search text in the find field and press F16. In addition, you can use F14 to limit the columns in which your search is performed, then press F16 to search.
However, when using the green screen, there is no find field when viewing the job log of an active job. Jobs with pending job logs have a similar problem.
(more…)
by Dawn May | Apr 26, 2018 | Db2 for i, Work Management
IBM continues to enhance temporary storage tracking and management, which was significantly improved beginning with IBM i 7.2.
(more…)
by Dawn May | Feb 7, 2018 | Db2 for i, IBM i Services, Work Management
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…)
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 | Jan 3, 2017 | Db2 for i
There’s a new type of data that can be consumed by using SQL on IBM i… JSON (JavaScript Object Notation).
(more…)