| UNIX | OS/2 | WIN |
The type of the "CURRENT EXPLAIN MODE" special register has changed from CHAR(8) to VARCHAR(254).
Symptom: If the application assumes that the type is still CHAR(8), then the value may be truncated from 254 to 8 bytes.
Redefine the type of all host variables which read the special register from CHAR(8) to VARCHAR(254).
This change is required to accommodate two new values for the "CURRENT EXPLAIN MODE" special register. These new values are "EVALUATE INDEXES" and "RECOMMEND INDEXES".
| UNIX | OS/2 | WIN | DB2 PE |
As of Version 6, the USING and SORT BUFFER parameters of the LOAD command are no longer supported (the parameters are ignored).
If specified on the LOAD command, the use receives a warning message saying that USING and SORT BUFFER parameters are no longer supported and are ignored by the LOAD utility.
Ignore the warning message. See Data Movement Utilities Guide and Reference for additional information.