onstat -g arc vs select statement output ------Web
Hi All,
I'm just curious about this.. If i execute onstat -g arc, it shows the wrong
date..
=> onstat -g arc
IBM Informix Dynamic Server Version 7.31.FD8X5 -- On-Line -- Up 2 days
19:57:04 -- 4074880 Kbytes
num DBSpace Q Size Q Len Buffer partnum size scanner
1 rootdbs 0 0 0x100073
Dbspaces - Archive Status
name number level date log log-position
rootdbs 1 0 12/31/1969.17:00 166908 0x5d56018
testdat05 2 0 12/31/1969.17:00 166908 0x6118668
testbsp01 3 0 12/31/1969.17:00 166908 0x611b018
testidx01 4 0 12/31/1969.17:00 166908 0x611b018
testdat01 5 0 12/31/1969.17:00 166908 0x6115018
==============================================================================
Using the select statement below:
select
dbsnum,
name,
today - (dbinfo('utc_to_datetime', level0)) as level_0_time,
logid0,
hex(logpos0)
from
sysdbstab sdt
order by 1;
shows different output:
Database selected.
dbsnum name level_0_time logid0 (expression)
1 rootdbs 0 166908 0x05D56018
2 testdat05 0 166908 0x06118668
3 testbsp01 0 166908 0x0611B018
4 testidx01 0 166908 0x0611B018
5 testdat01 0 166908 0x06115018
------WebKitFormBoundaryD81fX7dHWkI7r+dW