|
Problem IT40261
|
Status: Closed |
FEDERATION: COLUMN LENGTH AUTO VARIATION (COLUMN_LENGTH_AUTO_VARIATION) CANNOT BE DISABLED WHEN TARGET DATABASE IS ORCALE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
In Db2 v11.5.6 or higher federation environment, when the target
database is Oracle, running the following alter server to
disable Column Length Auto Variation (new feature implemented
from v11.5.6) does not actually work (It is not disabled).
alter server options (add
COLUMN_LENGTH_AUTO_VARIATION 'N') |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* On Db2 V11.5.6, Federation Server NET8 wrapper, nickname *
* CHAR and VARCHAR column length extended to 3 times the *
* original length *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 V11.5.7. *
* Set the server option COLUMN_LENGTH_AUTO_VARIATION to 'N'. *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* On Db2 V11.5.6, Federation Server NET8 wrapper, nickname *
* CHAR and VARCHAR column length extended to 3 times the *
* original length *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 V11.5.7. *
* Set the server option COLUMN_LENGTH_AUTO_VARIATION to 'N'. *
**************************************************************** |
| Comment |
On Db2 V11.5.6, Federation Server NET8 wrapper, nickname CHAR
and VARCHAR column length extended to 3 times the original
length.
The problem is fixed on V11.5.7.
To ensure that the nickname column length does not change
automatically, set the server option
COLUMN_LENGTH_AUTO_VARIATION to 'N'.
CREATE SERVER "SERVER1"
TYPE ORACLE
VERSION '19.1'
WRAPPER "NET8"
OPTIONS
(COLLATING_SEQUENCE 'Y'
,NODE 'ora19c'
,COLUMN_LENGTH_AUTO_VARIATION 'N'
); |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.03.2022
04.07.2022
08.09.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
