DB2 FOR LUW / DB2FORLUW / B10 - DB2

When you run db2exfmt after setting DB2_REDUCED_OPTIMIZATION by
set
current optimization profile, got SQL0437 and could not be
applied.

Here is the error message by db2exfmt output.
---
   SQLCA   : (Warning SQLCA from compile)
             SQLCODE 437; Function SQLNX188; Message token '13';
Warning 'None'
---

However, it can be applied by inline optguidelines without any
error.

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5m4fp0 or later                            *
****************************************************************

db2 connect to DBNAME
db2 "alter table systools.opt_profile drop primary key "
db2 "alter table systools.opt_profile add primary key (schema,
name) enforced"

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.01.2020
30.06.2020
30.06.2020