If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > RSAM Version 5.10.UC1 -- Log Question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-28-04, 19:43
rupee2003 rupee2003 is offline
Registered User
 
Join Date: Apr 2003
Location: Melbourne, Australia
Posts: 53
Unhappy RSAM Version 5.10.UC1 -- Log Question

Hi All,

I have RSAM Version 5.10.UC1 server on AIX 4.1 .

The problem is that when i issue the command tbstat -d it shows the following output

address chunk/dbs offset size free bpages flags pathname
300aab90 7 7 1 20000 92 PO- /link/PHYLOG_GIL
300aac28 8 8 1 80000 892 PO- /link/LOGFILES_GIL

and when i check the status of the logical logs using the command tbstat -l, the status of the logical logs are shown as free

tbstat -l

RSAM Version 5.10.UC1 -- On-Line -- Up 03:34:12 -- 36774 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 8 33 6 5.50
phybegin physize phypos phyused %used
700198 19500 19292 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 8 3365 480 475 7.0 1.0

address number flags uniqid begin size used %used
3097f6b4 4 F------ 0 800648 2500 0 0.00

fyi -- there are about 32 logical logs defined.

Is this behaviour of informix server normal ?? Am i missing out on anything.

Appreciate your time and view.

-Raghavan
Reply With Quote
  #2 (permalink)  
Old 11-29-04, 17:49
RobP RobP is offline
Registered User
 
Join Date: Mar 2004
Location: Netherlands
Posts: 183
Hi,

I assume you cut and pasted somethings, like the number of lines in tbstat -l. However everything looks fine. Is there a special thing you are worried about?

Please let me know. But it is normal if the defined logfiles show all space used in tbstat -d (space is reserved for logical logs, so not free anymore).

If you have any questions please inform me.

Greetz,

Rob Prop
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On