(CKPT REQ)
Hello.
Two or three monts ago we have solved one big problem: Subject was "DBSpace
is disabled".
Now I've another one:
Parameter LTAPEDEV in ONCONFIG file is set to /dev/null, parameters LTXHWM
50, LTXEHWM 60.
onstat -l reports:
INFORMIX-OnLine Version 7.10.UD1 -- On-Line (CKPT REQ) -- Up 5 days
04:50:12 -- 9544 bytes Blocked:CKPT
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 16 0 0 0,00
phybegin physize phypos phyused %used
10003f 250 243 0 0,00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 1 16 1 1 1 1,0 1,0
Buffer Waiting
Buffer ioproc flags #bcpiers
L-1 4000a010 0x1 0
address number flags uniqid begin size used %used
300514e0 1 U-B-C-- 2335 100139 125 125 100,00
300514fc 2 U-B---- 2336 1001b6 125 125 100,00
30051518 3 U-B---- 2337 100233 125 125 100,00
30051534 4 U-B---- 2338 1002b0 125 125 100,00
30051550 5 U-B---- 2339 10032d 125 125 100,00
3005156c 6 U---C-L 2340 1003aa 125 125 100,00
(EOF):
Very interesting are the first and the last row: flags and uniqid.
My question is:
can I unblock server without restoring from back-up ?
Saulius Raudys,
Vilnius,
Lithuania
Saulius wrote:
>
> Hello.
> Two or three monts ago we have solved one big problem: Subject was "DBSpace
> is disabled".
> Now I've another one:
>
> Parameter LTAPEDEV in ONCONFIG file is set to /dev/null, parameters LTXHWM
> 50, LTXEHWM 60.
>
> onstat -l reports:>
> INFORMIX-OnLine Version 7.10.UD1 -- On-Line (CKPT REQ) -- Up 5 days
> 04:50:12 -- 9544 bytes Blocked:CKPT
>
> Physical Logging
> Buffer bufused bufsize numpages numwrits pages/io
> P-1 0 16 0 0 0,00
> phybegin physize phypos phyused %used
> 10003f 250 243 0 0,00
>
> Logical Logging
> Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
> L-1 1 16 1 1 1 1,0 1,0
>
> Buffer Waiting
> Buffer ioproc flags #bcpiers
> L-1 4000a010 0x1 0
>
> address number flags uniqid begin size used %used
> 300514e0 1 U-B-C-- 2335 100139 125 125 100,00
> 300514fc 2 U-B---- 2336 1001b6 125 125 100,00
> 30051518 3 U-B---- 2337 100233 125 125 100,00
> 30051534 4 U-B---- 2338 1002b0 125 125 100,00
> 30051550 5 U-B---- 2339 10032d 125 125 100,00
> 3005156c 6 U---C-L 2340 1003aa 125 125 100,00
>
> (EOF):
>
> Very interesting are the first and the last row: flags and uniqid.
>
> My question is:
> can I unblock server without restoring from back-up ?
Likely you cannot. You need more logical logs, you need to set
LBU_PRESERVE in the ONCONFIG file so this does not happen again. If you
have support and cannot restore you can try calling tech support they can
login and truncate the last logfile so that the server can recover. You
MAY loose some transactions besides the big one that was rolling back
though, but perhaps not.
Art S. Kagel