Specifies the DB2 optimization profile that is used during SQL optimization. The optimization profile contains optimization guidelines that are passed to DB2 to influence the generation of query plans. This property sets the value of the DB2 OPTIMIZATION PROFILE special register.
This property only applies to DB2 V9.1 and higher for Linux/UNIX/Windows.