Improving performance when making Db2 Admin Tool available to users

You can eliminate the need for performing ISPF LIBDEFs each time that Db2 Admin Tool is invoked, which significantly reduces Db2 Admin Tool start-up time.

Procedure

When you make Db2 Admin Tool available to users, use one of the following methods to eliminate the need for ISPF LIBDEFs and thus improve performance when invoking the tool:

  • Copy the Db2 Admin Tool ISPF and TSO libraries to your standard libraries. Your standard libraries are allocated in your TSO LOGON procedure or are allocated dynamically before you invoke ISPF.
  • Allocate the Db2 Admin Tool target libraries in the TSO LOGON procedure or dynamically before you invoke ISPF.
    Tip: If possible, define the libraries that you are using for Db2 Admin Tool (and all of the libraries allocated on the same DD statements before the ones that you are using for Db2 Admin Tool) to LLA with the FREEZE option. This approach significantly reduces the number of input/outputs (I/Os) and the I/O time used when ISPF and TSO perform a search for Db2 Admin Tool members in the concatenation sequence.