By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,275 Members | 1,542 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,275 IT Pros & Developers. It's quick & easy.

transaction-log memory mapped on AIX ?

P: n/a
Environment: db2v7 on aix. 32-bit instance.

When db2v7 writes to the transaction log files (not during archival,
but when flushing logbuf), does it use MMAP on the log file or regular
system calls?

I'm assuming it uses regular system calls, but wonder if anyone can
verify.

Oct 11 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ian
mike wrote:
Environment: db2v7 on aix. 32-bit instance.

When db2v7 writes to the transaction log files (not during archival,
but when flushing logbuf), does it use MMAP on the log file or regular
system calls?

I'm assuming it uses regular system calls, but wonder if anyone can
verify.
Although I can't say for sure, I suspect it's dependent on the
DB2_MMAP_WRITE (and DB2_MMAP_READ) variables.

Oct 12 '06 #2

P: n/a
Ian wrote:
mike wrote:
Environment: db2v7 on aix. 32-bit instance.

When db2v7 writes to the transaction log files (not during archival,
but when flushing logbuf), does it use MMAP on the log file or regular
system calls?

I'm assuming it uses regular system calls, but wonder if anyone can
verify.

Although I can't say for sure, I suspect it's dependent on the
DB2_MMAP_WRITE (and DB2_MMAP_READ) variables.
I should have stated in my original query that these variables
are both at their default v7 setting (ON) , so SMS and file-dms
container files are memory-mapped, but the question is whether
the txn-log would also use that technique.

Oct 12 '06 #3

P: n/a
Ian
mike wrote:
>
I should have stated in my original query that these variables
are both at their default v7 setting (ON) , so SMS and file-dms
container files are memory-mapped, but the question is whether
the txn-log would also use that technique.
Right, and my point was that if MMAP read/write are enabled (as they
are by default), DB2 would probably use the mechanism for I/O to the
txn log files.

I could be wrong, but that's my gut feeling (based on my knowledge that
enabling DB2_NT_NOCACHE would cause DB2 to open ALL files on a Windows
server with the no-caching attribute set).

Oct 12 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.