IBM Support

DESCSTAT subsystem parameter

Question & Answer


Should I set the DESCSTAT subsystem parameter to YES or NO?


Development recommends that users set DESCSTAT to YES if they are dependent on retrieving column names. All users of the JDBC and CLI (on DB2 for Linux, UNIX, and Windows) drivers are dependent on this column information for correctly retrieving metadata from the catalog. (Note that the native ODBC driver on DB2 for z/OS® does not use the common metadata stored procedures, so this driver does not have the same dependency. )

Because of this usage, the default is DESCSTAT YES, but be aware that binding with DESCSTAT YES does increase the size of your bound plan or package.

[{"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"10.0;11.0;12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018