IC61417: 11.50.XC4W1: DRDA CLIENTS DO NOT RECOGNIZE SETTINGS IN SYSDBOPEN

APAR status

• Closed as program error.

Error 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
  

Local fix

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.                              *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC5.  . DRDA client was
  included into the list of clients capable of executing
  sysdbopen() routine
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP