> Am using version 10.00.UC7X1 and have a few *basic* questions on the
> usage of the logical log file.
[quoted text clipped - 16 lines]
> documentation says: numrecs: Is the number of records written;
> numpages: Is the number of pages written
The key to the answer of this question is the fact that you are using
unbuffered logging. So that as soon as a commit work is hit, it
forces the logical log buffer to be flushed to disk. When this
occurs, it will only use the portion of a page that is needed, so you
will possibly end up with non-full logical log pages.
> For the above operation, I observe that for each insert the numrecs
> gets incremented by three whereas the numpages gets incremented by 1.
> What does the term "records" mean in this context?
Logical log records. As you mention below, you have 3 log records, 1
for the begin, 1 for the hinsert and 1 for the commit.
> 2. onlog displays a length of 44 (for begin) + 64 (for hinsert) + 40
> (for commit) for a transaction involving a single insert. What does
> this length mean? The length of the logical record in bytes?
Yes
> Thanks a lot in advance!