To be more precise, database performance. Why would this be. The Plan Cache is a repository that contains the access plans for queries that were optimized by SQE. The Plan Cache is interrogated each time a query is executed in order to determine if a valid access plan exists that satisfies the requirements of the query. If a valid access plan is found, it is used to implement the query. Otherwise a new access plan is created and stored in the Plan Cache for future use.
Note, with the latest Database Group PTF, the size of the Plan cache can now be larger holding more information to make the database performance better.
See, it pays to be on the latest release, at the latest PTF level. If you are still on V5R4, send Pete an email and he can help you upgrade to 6. With over 6. We have the skills to help you get the most out of your IBM i. For more information on any of the articles below please visit us at on the web at iTech Solutions or email iTech Solutions. We would love for you to let us know any articles that you wish for the future, or if you enjoy any of the articles in the current newsletters. The hardware is restarted only if a PTF that requires a hardware restart is to be applied.
The following restrictions apply when the keylock position is being changed: The keylock position cannot be set to MANUAL for security reasons. If the system has a keylock and the key is not inserted, the keylock position cannot be changed. Recovery is done when Mail Server Framework starts. Start to restricted state STRRSTD Specifies whether or not the system should be started to the restricted state, which means that only the system console will be active.
What do you need to know when upgrading to IBM i 6. Tips and Tricks to improve performance and reduce disk space. A Programmers future: Looking back to see into the Future. Building Virtual i partitions hosted by IBM i. New IBM Hardware recently announced. There are some really nice enhancements that I would like to summarize, most of them deal with improving performance, virtualization, and physical footprint.
If you need help with hardware, contact either Glenn or Paul for help. This is a great statement of direction, as the HMC is a great management interface for any Power Systems.
In addition, there is an imbedded pair of SAS disk controllers built directly into the disk draw. Note, that you can't use this if you have a P05 class machine. Be careful, as these controllers have ZERO write cache. There is also an option to have these towers owned by a 6. We can help you make the most of your investment, because we know and understand the hardware, the direction, and what will become obsolete.
Understanding this, insures that when you use iTech Solutions for your IBM Power System purchases, you will be able to leverage your investment into the future. People are always asking me how often they should be performing PTF maintenance, and when is the right time to upgrade their operating system.
I updated this article from last month with the current levels of PTFs. Let's look at PTFs. In addition, some times PTFs add new functionality, security, or improve performance. Therefore, I am always dumbfounded as to why customers do not perform PTF maintenance on their machine at least quarterly.
If IBM has come out with a fix for your disk drives, why do you want to wait for your disk drive to fail with that problem, only to be told that there is a fix for that problem, and if you had applied the PTF beforehand, you would have averted the problem. Therefore, I think a quarterly PTF maintenance strategy is a smart move. Many of our customers are on our quarterly PTF maintenance program, and that provides them with the peace of mind of knowing their system is up to date on PTFs.
Below is a table of the major group PTFs for the last few releases. This is what we are installing for our customers on iTech Solutions Quarterly Maintenance program.
Pack Tech. HTTP 13 25 31 Not surprising, this confidence can breed complacency where backups are concerned.
You may be doing incremental or even full application backups periodically, but are you are neglecting the full system backup and IPL? Make no mistake, a full system backup and IPL is a required bit of maintenance that you should not avoid. Some high volume users will do this critical piece of work weekly. A restore of critical data can take days to reassemble from the incremental saves done since your last full backup. Share this: Twitter Facebook. Like this: Like Loading IPL-related System Values.
Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email required Address never made public. Name required. Follow Following. Sign me up. Already have a WordPress.
0コメント