QVC23: Previous rebuild code subtype QQC11: Plan required optimization Y N Plan had to be re optimized & rebuilt QAQQINI Re optimize option prevent access plan rebuild The 1000 row contains an indicator regarding whether the rebuilt access plan can be saved (QVC24). Example 4-11 shows a query with some of the most commonly used columns in the 3006 record. Example 4-11 Common columns in the 3006 record WITH xx AS (SELECT * FROM qgpl.qzg0000478 WHERE qqrid = 3006), yy AS (SELECT qq1000 AS qqsttx, qqstim, qqetim, qqjfld, qqucnt FROM qgpl.qzg0000478 WHERE qqrid = 1000 AND qqc21 <> 'MT' AND (qvc1c = 'Y' OR (qqc21 IN('DL', 'UP') AND qqc181 <= ' ') OR qqc21 IN ('IN', 'IC', 'SK', 'SI') OR qqc21 LIKE 'O%')) SELECT qqtime AS "Time", qqtim1 AS "Last Access Plan Rebuilt", qqc11 AS "Optimization req.", qqrcod AS "AP Rebuild Reason", HEX(qqc21) AS "Rebuild Subcode", HEX(qvc22) AS "Original Rebuild Reason", HEX(qvc23) AS "Original Rebuild Subcode", varchar(qqsttx,20000) AS "Statement Text" FROM xx a LEFT JOIN yy b ON a.qqjfld = b.qqjfld AND a.qqucnt = b.qqucnt WHERE (a.qqtime BETWEEN b.qqstim AND b.qqetim OR b.qqstim IS NULL) ORDER BY "Time"; Figure 4-29 show the result of the query in Example 4-11. The information from the 3006