QRYDEGREE Setting
If the SMP feature is on your machine, set the system value QRYDEGREE to *OPTIMIZE. Include a CHGQRYA DEGREE(*MAX) in the calling CL program within the jobs that update/add/delete files to let your system use as many DBL3 jobs as possible. However, use CHGQRYA DEGREE (*OPTIMIZE) in jobs that run SQL, OPNQRYF, or AS/400 Query. (Jobs that have the QRYDEGREE system value set to *OPTIMIZE don’t need to include a CL command.) *OPTIMIZE tells the system to use some of the DBL3 tasks but to not fill the system with them.
Tuesday, March 01, 2005
Subscribe to:
Post Comments (Atom)
Popular Posts
- Linux Forum: Apache, Webmin and Mandrake - Linux Operating System Help
- Yahoo! Mail: Revenge of the Oddpost
- Free AS400 & iSeries Software Tools & Utilities Downloads
- Basic Requirements of a JavaServer Faces Application
- UDATE and *DATE in AS400 RPG
- IBM eServer iSeries - The Laughing Boardroom
- AS400 APIs
- The Laughing Boardroom video...a real world example!
- Fast-track your Web apps with Ruby on Rails
- Encrypt Data on as400 (QC3ENCDT, Qc3EncryptData)
No comments:
Post a Comment