DB2 - Problem description
Problem IC64398 | Status: Closed |
SET SERVER OPTION DOES NOT WORK AT ALL | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
The SET SERVER OPTION command does not have any effect on DB2 version 9.1 or higher | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Federated Systems where the "SET SERVER OPTION" command * * isattempted * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Use alternative methods of specifying federated * * serveroptions. * **************************************************************** | |
Local Fix: | |
define any required options in the server definitions (CREATE or ALTER SERVER), use different Server definitions for the same data source where different options are required. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
Problem first fixed in DB2 Version 9.7 Fix Pack 2 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.11.2009 14.06.2010 14.06.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |