Dawn May

Dawn May

Bookmark and Share

Recent Posts

  • Should You Consider Becoming a CAAC Member?
    May 14, 2019
  • IBM i 7.4
    April 24, 2019
  • Prestart Server Jobs and Exit Programs
    April 2, 2019
  • TE’s Pick ' n' Mix Client Edition
    March 25, 2019
  • IBM i Job Accounting and Prestart Server Jobs
    March 7, 2019
  • Should You Consider Becoming a CAAC Member?

    This week’s blog was written by Mike McArdle, who is an instructor at Western Technical College in La Crosse, Wisconsin, and represents education on the COMMON Americas Advisory Council (CAAC). The CAAC is looking for a few good members and Mike explains why you should consider joining the CAAC.

    Read More

    Posted: May 14, 2019 |

    IBM i 7.4

    IBM has announced IBM i 7.4. I listened to the COMMON IBM i Announcement webcast, and spent time pouring over the RFA and the 7.4 Knowledge Center (yes, the 7.4 documentation is already available). Updates are not yet published about 7.4 on developerWorks, but I anticipate we’ll see information there soon.

    Read More

    Posted: April 24, 2019 |

    Prestart Server Jobs and Exit Programs

    Securing IBM i is essential and it’s important you understand how to control access to your system with prestart server jobs. Prestart server jobs allow users to connect over the network and you must have a plan in place to ensure you don’t allow unintended or unrestricted access to the system.

    Read More

    Posted: April 2, 2019 |

    TE’s Pick ' n' Mix Client Edition

    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 |

    IBM i Job Accounting and Prestart Server Jobs

    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 |

    QSQSRVR Job Considerations

    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 |

    Client Special Registers are Special

    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 |

    The Mysterious QP0ZSPWP Jobs

    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 |

    Retrieving the Current SQL Statement for a Job

    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 |

    Prestart Jobs and Connection Pooling

    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 |

    Displaying results 1-10 (of 372)
     |<  < 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10  >  >|