
Signature
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
>> aj,
>>
[quoted text clipped - 14 lines]
> 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
Knut Stolze - 11 Jan 2007 09:14 GMT
>> - 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.

Signature
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
aj - 11 Jan 2007 13:54 GMT
Thanks for your help Knut.
>>> - how exactly have you set DFT_SQLMATHWARN?
>> UPDATE DB CFG FOR <mydb> USING DFT_SQLMATHWARN YES
[quoted text clipped - 29 lines]
>
> So the change is not active yet.