when one of my client using
db2 get db cfg
he is getting the following error,

sql5066w the db configuration value for token SQLF_DBTN_STMTHEAP has been truncated.

help me out..

> db2 ? sql5066w


SQL5066W The database configuration parameter value for token
"<token-name>" has been truncated.

Explanation:

The database configuration parameter value is larger than the specified
token can contain.

A new token now represents this database configuration parameter value
and should be used if the value is larger than can be contained by the
old token.

User response:

Use the new token for this database configuration parameter.




What version are you using? Which Version does your client use?

See the following link for APAR related to this issue. Applying latest fixpack might resolve the issue

IBM JR31525: THE GET_DB_CONFIG() UDF FAILS WITH SQL5066W WHEN STMTHEAP CONFIGURATION PARAMETER IS GREATER THAN 65535 PAGES - United States

they r using 8.2, i already refered above explanation, but i did not understand, in above explanation wat is TOKEN refers???????

in the error wat is meant by TRUNCATED ?? whether i have update STMTHEAP (db cfg paramter) below 65535 ??