Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Red face Unanswered: Should I need increase the buffpage or parameters?

    Hi, Dear all,
    I found the following information in db2diag.log:

    2003-05-30-21.08.25.710000 InstanceB2 Node:000
    PID:33(DB2SYSC.EXE) TID:54 Appid:*LOCAL.DB2.030530223238
    data_protection sqlp_AsyncLogReadAPI Probe:220 DatabaseFC

    Error: sqlcode -2038, rc 32, hflag2LsnReuse 0
    action 1, startLSN 0094 7D2D D90C, endLSN 0094 7D2D E00C, logBufferSize 204800


    This error oftern happened and our system has large update transaction, does it mean should I increase buffpage or others relative parameter? If need to adjust other parameters, what parameter?

    Thanks in advance.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't see a place where reason code 32 is documented for sqlcode -2038 in the Messages and Codes manual, but maybe someone else knows where it is.

    I am not sure what you mean by "large update transaction" but frequent commits should be taken if possible. I would recommend commits after every 100 logical units of work.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Also, what version and fixpak are you on. You might want to get the latest fixpack (FP9 for version 7, and FP2 for version 8).

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    sql2038n indicates a system error. Is an error returned to the application? Because according to documentation there should be another error returned. I have had this issue before and the real error code is the embedded error code in

    SQL2038N A database system error "<errcode>" occurred during
    processing.

Posting Permissions

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