Informix - Problem description
Problem IC61417 | Status: Closed |
11.50.XC4W1: DRDA CLIENTS DO NOT RECOGNIZE SETTINGS IN SYSDBOPEN | |
product: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problem description: | |
With 11.50.xC4W1 the settings in sysdbopen are not recognized when a client connects via Data Server Driver. CREATE PROCEDURE "public".sysdbopen() SET LOCK MODE TO WAIT; SET ENVIRONMENT USELASTCOMMITTED 'COMMITTED READ'; SET ISOLATION TO COMMITTED READ RETAIN UPDATE LOCKS; END PROCEDURE; IBM Informix Dynamic Server Version 11.50.FC4W1 -- On-Line -- Up 13:33:46 -- 174820 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 68 SELECT mydb CR Not Wait 0 0 - Off The same works in 11.50.FC4: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 00:01:00 -- 166628 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 9 SELECT mydb LCU Wait 0 0 - Off | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of SYSDBOPEN() procedure * **************************************************************** * PROBLEM DESCRIPTION: * * SYSDBOPEN() is not executed with DRDA clients. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC5 and above. * **************************************************************** | |
Local Fix: | |
Solution | |
Problem first fixed in IDS 11.50.xC5. . DRDA client was included into the list of clients capable of executing sysdbopen() routine | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.06.2009 19.01.2010 19.01.2010 |
Problem solved at the following versions (IBM BugInfos) | |
11.50.xC5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
11.50.xC5 |