var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 Instance B2 Node:000
PID:33(DB2SYSC.EXE) TID:54 Appid:*LOCAL.DB2.030530223238
data_protection sqlp_AsyncLogReadAPI Probe:220 Database FC
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.
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.
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).
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