DescribeInputOnPrepare CLI/ODBC configuration keyword

db2cli.ini keyword syntax:

DescribeInputOnPrepare = 0 | 1

Default setting:

Do not request describe information when preparing an SQL statement.

Usage notes:

 

By default, CLI does not request input parameter describe information when it prepares an SQL statement. If an application has correctly bound parameters to a statement, then this describe information is unnecessary and not requesting it improves performance. If, however, parameters have not been correctly bound, then statement execution will fail and cause the CLI error recovery retry logic to request input parameter describe information. The result is an additional server request and reduced performance, compared to if the describe information had been requested with the prepare. Setting DescribeInputOnPrepare to 1 causes the input describe information to be requested with the prepare. This setting may improve performance for applications which rely heavily on the CLI retry logic to recover from application binding errors.