Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: sql5066w (db2 get db cfg error)

    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..
    Last edited by ravichandrapratap; 05-16-11 at 08:54.

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    > 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?

  3. #3
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    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

  4. #4
    Join Date
    Dec 2010
    Posts
    123
    Quote Originally Posted by nvk@vhv View Post
    > 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?
    they r using 8.2, i already refered above explanation, but i did not understand, in above explanation wat is TOKEN refers???????

  5. #5
    Join Date
    Dec 2010
    Posts
    123
    Quote Originally Posted by ravichandrapratap View Post
    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 ??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •