Category:AS/400
From Plex-XML
System i (formerly known as AS/400, eServer, iSeries, System i5)
- Special hints regarding SQL on System i
If you are realizing very poor perfomance using your 2/E-generated database with SQL try to find some information about the QUSRSYS/QAQQINI file. Since V3R3 the SQL optimizer decrease performance if any LF has select/omit options.
Setting QQPARM:IGNORE_DERIVED_INDEX set to QQVAL:*YES can help in this case. The SQL Query Engine will now ignores any LFs with select/omit statements.
Further info can be found on this IBM page.
Pages in category "AS/400"
The following 4 pages are in this category, out of 4 total.
