Re: New IBM Nonsense

Jonathan Lewis wrote:
> I'm not sure I would call a TPCC disclosure
> document with 163 or 206 pages a simple scenario,
> but I've had a quick look through the documents.
>
> The important points to note are that:
> the log files are configured to 150 MB each
>
> 4 checkpoint occurred during the test
>
> the checkpoints were triggered (apparently)
> by explicit timeouts, rather than log switches.
>
> I note that the figures you quote seem to be the
> amount of space configured for log files, but
> there is no explicit report of redo log generated -
> only an upper limit implied by the checkpoint
> count - and the document suggests that this
> were forced on a timeout, not at logswitch.
>
> In fact, the larger number you quote appears in
> a block of numbers describing space allocation
> for 60 days running, whereas the small number
> appears in a section that comments on the need
> for allocating logs for 8 hours.
>

I was puzzling about that. The intro of the table of both 60 days and 8 hrs. But if I apply 60 days to the log the difference is even stranger (just the other way around). Obviously the form of the documents is rather freestyle in this area which doesn't help grasping it. Note that the table distinguished between space required and space configured.
Thanks for the info.

Cheers
Serge

PS: Simple scenario equals less than 10 tables.. Imagine there would be a real - real world benchmark ;-)

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab