Informix - Problem description
Problem IT44199 | Status: Closed |
EXT_DIRECTIVES ONCONFIG PARAMETER CHANGE IS NOT REFLECTED IN ONLINE.LOG | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
A change in the EXT_DIRECTIVES onconfig parameter is not reflected or show in the online.log file like it should: Onconfig parameter modified from to . Here is the original value for EXT_DIRECTIVES: Configuration Parameter Info id name type maxlen units rsvd tunable 231 EXT_DIRECTIVES INT4 2 min/max : 0,2 default : 0 onconfig: 2 current : 2 Changing the value dinamically won't also work as expected and described in the documentation: prompt$> onmode -wf EXT_DIRECTIVES=0 Configuration Parameter to be changed is not valid or not supported with this option. One might change its value in the onconfig file and bounce the engine: prompt$> grep EXT_DIRECTIVES $INFORMIXDIR/etc/$ONCONFIG # EXT_DIRECTIVES - Controls the use of external SQL directives. EXT_DIRECTIVES 0 prompt$> onmode -ky; sleep 5; oninit -v New value: Configuration Parameter Info id name type maxlen units rsvd tunable 231 EXT_DIRECTIVES INT4 2 min/max : 0,2 default : 0 onconfig: 0 current : 0 There's no change input in the online.log file. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** "Note that changing the value of EXT_DIRECTIVES on the fly will not affect existing sessions. The value of the [on]config parameter is consulted only when a session connects to the server." -- Informix Engineering | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** "Note that changing the value of EXT_DIRECTIVES on the fly will not affect existing sessions. The value of the [on]config parameter is consulted only when a session connects to the server." -- Informix Engineering | |
Comment | |
Fixed in Informix Server 14.10.xC11. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.07.2023 02.06.2024 02.06.2024 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |