470,810 Members | 1,026 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

transaction-log memory mapped on AIX ?

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
3 1397
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
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
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.

Similar topics

2 posts views Thread by Deepak Mehta | last post: by
1 post views Thread by Avanish Pandey | last post: by
9 posts views Thread by ucasesoftware | last post: by
2 posts views Thread by Christian Stooker | last post: by
5 posts views Thread by ashley.ward | last post: by
1 post views Thread by Matik | last post: by
2 posts views Thread by Ryan Liu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.