The integrated nature of IBM i has many advantages—but knowing what you need to know can be a challenge because there is so much to know! To complicate things further, there’s hardware, virtualization technologies, storage technologies and everything else that is required for a modern computing environment.
Read More
Posted: March 25, 2019 |
Job accounting can be used to track the use of system resources, such as CPU time, transactions, printed output, and more, to a particular user or groups of users.
Read More
Posted: March 7, 2019 |
The QSQSRVR jobs handle database requests for jobs with SQL Server Mode enabled. With SQL Server Mode, the SQL statements are not run directly in the requesting job, but rather by a QSQSRVR prestart server job. SQL Server Mode is automatically enabled when using the Native JDBC driver that is part of the IBM Developer Kit for Java (5770-JV1), and it can also be enabled for Db2 call level interface (CLI) requests.
Read More
Posted: February 20, 2019 |
An early iCan blog, written by Scott Forstie in October 2009, reviewed Client Special Registers. I’m revisiting this topic since client special registers are very useful for understanding who requested work for the database server jobs (QZDASOINIT, QSQSRVR, and QRWTSRVR).
Read More
Posted: February 12, 2019 |
This week I’ll take a look at the QP0ZSPWP jobs. You’ve probably seen evidence of them and may have wondered what they do. These jobs are created by spawn() and fork() functions.
Read More
Posted: February 1, 2019 |
I often get asked how to determine what’s running in a prestart job that is taking a lot of system resources. When I ask for more details, the answer often starts with “We have these QZDASOINIT jobs…” Another common scenario I hear is “We have users that run ad-hoc queries…”
Read More
Posted: January 21, 2019 |
Connection Pooling is the ability to keep a connection to the server in place. Connections in the pool can be reused by the same application, avoiding overhead associated with creating a new connection for each request. Connection pooling improves performance by reducing the number of jobs started and ended, as well as reducing the overhead of full opens and program activations.
Read More
Posted: January 10, 2019 |
Many prestart jobs log messages to both the job log and the history log. This article will review the messages sent by various types of prestart jobs and provide examples of how to gather useful information from these messages.
Read More
Posted: January 4, 2019 |
Collection Services is always running on your system and you can use the Performance Data Investigator with Collection Services data for insights into your prestart jobs.
Read More
Posted: December 6, 2018 |
IBM recently released an updated version of Access Client Solutions (ACS). There is a long list of enhancements in this update; at the end of this article you will find the list of the enhancements from the ReadMeSPACS.txt file. The number of Request for Enhancement (RFEs) addressed in this update is impressive. The ACS development team is clearly listening to what users are asking for.
Read More
Posted: November 27, 2018 |
