Thanks for your help Knut.

Knut Stolze wrote:
> aj wrote:
>
>>> - 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.
>
> Well, I made the same change and DB2 did tell me to restart:
>
> SQL1363W One or more of the parameters submitted for immediate modification
> were not changed dynamically. For these configuration parameters, all
> applications must disconnect from this database before the changes become
> effective.
>
>>> - 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?
>
> deactivate/activate is sufficient, i.e. make sure that no connection to the
> DB exists and if the DB was activated explicitly, run the DEACTIVATE
> command.
>
>> 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
>
> So the change is not active yet.
>