SAP Note 705888 - DB4: Performance Enhancement: All I/O Optimizer Indicator

Component : DB2 for AS/400 - IBM AS/400

Solution : https://service.sap.com/sap/support/notes/705888 (SAP Service marketplace login required)

Key words :
stream file '/tmp/sqe/< yyy>/dboptrace<xxxx>', instance profile parameter called                    dbs/db4/nqe_optimize_method = [, terms nqe_optimize_method querycompletionindicator db2/400 iseries, parameter dbs/db4/nqe_optimize_method, iseries dbsl offers means, work-process developer trace, existing optimization goal parameter, detailled plan cache dump, instance profile parameter, secondary connection settings configured

Related Notes :

898203iSeries: "ALL I/O" and "UPTO ROWS" performance
523381BW: External DB connect for an IBM i database
445872DB multiconnect from Windows/LinuxPPC to IBM DB2 for i5/OS
146624i5/OS: Database Multiconnect for IBM DB2 for i5/OS