Need assistance with error code OFSC003E in Health Checker

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Starting Database Management Solutions Xmanager and receiving message:

OFSC003E The Health Check has determined that the GENERATE_COLUMN_NAMES_WITH_SELECT(*) parmlib option in member OFS has been set to Y or N, which is not recommended setting.

Resolution

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'.