Need help with error codes OFSC003E in Health Checker

book

Article ID: 143082

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Database Management for DB2 for z/OS - Administration Suite CA Endevor SCM Interface for DB2 for z/OS CA Endevor SCM Interface for Remote DB2 for z/OS CA RC/Extract for DB2 for z/OS CA RC/Migrator for DB2 for z/OS CA RC/Merger for DB2 for z/OS CA RC/Query for DB2 for z/OS CA RC/Secure for DB2 for z/OS CA RC/Update for DB2 for z/OS

Issue/Introduction

Starting Xmanager, receiving messages:

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.

Environment

Release : 20.0

Component : General Services for DB2

Resolution

The [email protected] 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 Release R19 the setting was Y or N, however, on R20 the recommended setting is 'O'.