Question & Answer
Question
When will an index not share the RCDFMT of the underlying physical file?
Answer
An index will not share the RCDFMT of the underlying physical file if any of the below are true. This means that an Alter table of the physical file to change or add fields will not be seen in other files that do not share the record format. This will require those files with their own record formats to require a rebuild of the access path if those changes are needed.
1. You use the RCDFMT parameter (even if the name matches the record format of the physical file - it will not share).
Exmaple:
CREATE UNIQUE INDEX INDEX01
ON TABLe1 (FIELD1)
RCDFMT TABLE1RCDFMT
2. The index uses derived keys
3. The key columns have been named using AS clause
4. The index uses a WHERE clause
5. The index uses an INCLUDE clause
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 for IBM i","Platform":[{"code":"","label":"iSeries"},{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
nas8N1021967