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.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany