Starting Database Management Solutions Xmanager and receiving message:
OFSC003E The Health Check has determined that the GENERATE_COLUMN_NAMES_WITH_
The DB2_OFS_CREATE_VIEW@PTXDV200 health check has determined that the GENERATE_COLUMN_ NAMES_WITH_SELECT(*) parmlib option in member
OFS should be set to 'O', which is the recommended setting.
Specifying 'O' causes OFS to retrieve the original CREATE VIEW text that is used by the User to create the view.
If 'Y' is specified then all the column names in the CREATE VIEW statement are brought back.
If 'N' is specified then all the column names in the CREATE VIEW
statement are replaced and implied in the SQL using '*'.
For Database Management release R19 the setting was Y or N, however, on Database Management release r20 the recommended setting is 'O'.