Frequently Asked Questions
* NEW *
Free AS400 App Monitoring
Free 1 Year Pro License Offer
Topics
Send Email
00194 - SQL buffer size of the DDS logical is only 8192 bytes (32)
Every time the SQL engine goes to process, it is picking up minimal index entries. A DDL created index is defaulted to a buffer size of 64K, but can be changed at creation time if a larger or smaller size is truely required. Be advised though, that if another index is created, with a larger buffer with the same access path, the larger will be used. (source: LinkedIn AS/400 Professionals)