by Dawn May | May 10, 2018 | Navigator for i, IBM i Services
The QSYS2.Services_Info service is an easy way to see all of the available services along with an example of each. It shows both the IBM i Services and the Db2 for i Services, which are the ones specifically related to the database. This service was made available with 7.3 and added to 7.2 via PTF.
(more…)
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 | 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 | Nov 14, 2017 | IBM i Services, Security
Syslog is a very popular reporting system that runs on many devices and OSes. It uses various parts and programs to encode, transmit, consolidate, and analyze messages from a wide range of devices. Everything from Windows and UNIX to firewalls and IoT devices participate in sending and centralizing messages from across the enterprise. That is, except for IBM i. Of course, we always must be different (usually for good reasons). However, when a security team wants to have an enterprise-wide view of events with a tool such as a SIEM (Security Information and Event Management), we sometimes feel left out. Until now!
(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 | Apr 18, 2017 | Subsystems, Documentation, IBM i Services, Work Management
Some of you may have read the subsystem configuration experience reports that were written way back in 2004, which was about when V5R3 became available. The experience reports were under the related information section of the Work Management topic. The subsystem configuration experience reports were covered in three sections:
- Why multiple subsystems are important, along with how to configure subsystems for server jobs
- How to configure interactive subsystems
- How to manage server jobs
(more…)