Knut Stolze wrote:
> fboldt@fastmail.fm wrote:
>
>> aj,
>>
>> You could just try to output the values:
>> select bp_name,
>> float(pool_data_p_reads) as dp_read,
>> float(pool_data_l_reads) as dl_read,
>> float(pool_index_p_reads) as ip_read,
>> float(pool_index_l_reads) as il_read
>> from db2$mon_bp )
>>
>> I guess you would see some Zeros for dl_read or il_read which would
>> definately lead to a -804.
>
> That's probably the case here. However, the setting of DFT_SQLMATHWARN
> should prevent the SQL0801!
>
> So there are a few questions to be answered by the OP first:
> - how exactly have you set DFT_SQLMATHWARN?
UPDATE DB CFG FOR <mydb> USING DFT_SQLMATHWARN YES

> - have you restarted DB2 after setting it?
No. I didn't think I had to. DB2 typically tells me if I need to,
and it didn't.

> - what does GET DB CFG SHOW DETAIL show you for this config parameter?
db2 get db cfg for <mydb> show detail | grep -i math
Continue upon arithmetic exceptions(DFT_SQLMATHWARN) = NO YES


I think you just answered my question. I need an instance bounce (or
perhaps a DB deactivate/activate?) before this is actually set?

btw - I had no idea you could use SHOW DETAIL on DBM CFG output to see
current value and delayed value. Nice tip, thanks.

> - what does the following statement produce?>
> VALUES 1 / 0
SQL0801N Division by zero was attempted. SQLSTATE=22012

aj