Why optimizer db2support is collecting very minimal details in Purescale setup
Biswarup(Bis)Mukherjee 120000HKTY Visits (8108)
Many times an optimizer db2support is collected to investigate issues related to optimizer issue with a DB2 query.
The common syntax to collect optimizer db2support is,
db2support . -d <db-name> -sf <sql_file> -cl 1
However, many times this fail to collect the required optimizer data in a Purescale setup. Even sometimes fail with multi-partition setup.
The way it will work is to add "-locahost" as an option with the syntax.
db2support . -d <db-name> -sf <sql_file> -cl 1 -localhost
-localhost option is notable as the optimizer data is usually needed from one partition only.
Without -localhost option the collection will go to all the members in the instance.
-localhost usage for optimizer db2support collection is documented in this Knowledge Center page,
However, it's very easy to miss.
This portion in the above page is to be referred,