Health Checks

This health check verifies whether the GENERATE_COLUMNS_NAMES_WITH_SELECT(*) parameter is set to O/Y/N in the OFS parmlib member.
carcudb220
DB2_OFS_CREATE_VIEW xmanxxxx
Description
This health check verifies whether the GENERATE_COLUMNS_NAMES_WITH_SELECT(*) parameter is set to O/Y/N in the OFS parmlib member. This parmlib option controls how CREATE VIEW DDL statements are generated by Object Framework Services. Use this health check to determine whether you are running with a setting that may not generate a CREATE VIEW column list that is consistent with the original CREATE VIEW statement. The health check owner is CA_DB2.
Best Practice
Customize your OFS parmlib member. The default setting, O, is the recommended setting.
Parameters Accepted
  • O
    Generates a column list by extracting the original view text from SYSIBM.SYSVIEWS. O is the default.
  • Y
    Generates a column list when the VIEW select clause is SELECT (*).
  • N
    Suppresses generation of a column list when the VIEW select clause is SELECT (*).
Any other value returns HIGH exceptions and defaults to O.
Debug Support
No.
Verbose Support
No.
Reference
For instructions on customizing the OFS parmlib member, use the EP option on the 
CA Database Management Solutions for DB2 for z/OS
 Main Menu.
 
Messages
 
See the CA Database Management Solutions for DB2 for z/OS message documentation.