|
Problem IT15114
|
Status: Closed |
A 'DB2 GET DB CFG SHOW DETAIL' FROM THE CLP MAY REPORT AN INCORRECT 'CURRENT VALUE' FOR DECFLT_ROUNDING
|
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The DB2 CLP (command line processor) will display the wrong
'Current Value' for the DECFLT_ROUNDING parameter after it has
been changed. The parameter cannot be changed dynamically but
the Current and Delayed values can be displayed.
As a result of this issue, DB2 reports the 'Delayed Value' in
place of the 'Current value':
Display the current default value:
db2 get db cfg show detail| grep -i decflt
Decimal floating point rounding mode (DECFLT_ROUNDING) =
ROUND_HALF_EVEN ROUND_HALF_EVEN
db2 update db cfg using DECFLT_ROUNDING ROUND_HALF_UP
DB20000I The UPDATE DATABASE CONFIGURATION command completed
successfully.
SQL1418W Changing the database configuration parameter
DECFLT_ROUNDING may have unintended consequences. The value was
not changed
dynamically. All applications must disconnect from this database
before the
changes become effective.
SQLSTATE=0168M
db2 get db cfg show detail| grep -i decflt:
Description Parameter
Current Value Delayed Value
----------------------------------------------------------------
-----------------------------------------------
Decimal floating point rounding mode (DECFLT_ROUNDING) =
ROUND_HALF_UP ROUND_HALF_EVEN
The 'Current value' should be the one that is currently in
effect, in this case it should be: ROUND_HALF_EVEN
The 'delayed value' is the one that is yet to take effect, in
this case it should be: ROUND_HALF_UP
The clp is printing the wrong value for this parameter.
Contrast that with db2pd:
db2pd -d sample -dbcfg:
Description Memory Value Disk Value
DECFLT_ROUNDING ROUND_HALF_EVEN
ROUND_HALF_UP
Local fix:
Use db2pd - d -dbcfg to display the correct values. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* See SYSROUTE APARs to see where this APAR is addressed *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner :
follow-up : IT15199 IT15200 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.05.2016
08.05.2017
08.05.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
