IBM Support

IT31100: SQL0206N ERROR MAY OCCUR WHEN EXECUTING 'SET CURRENT LOCALE LC_TIME' WITH USING JCC PROPERTY ENABLESYSPLEXWLB=TRUE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • SQL0206N error may occur when executing 'SET CURRENT LOCALE
    LC_TIME' with db connection using enableSysplexWLB=true".
    
    Following is the example application to show how the error
    happens.
    
    $ cat myjdbc4.java
    import java.lang.*;
    import java.sql.*;
    import java.util.Properties;
    
    class myjdbc4 {
    static {
      try {
       Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance
       ();
      } catch (Exception e) {
       e.printStackTrace();
      }
    }
    public static void main(String argv[]) {
      Connection con = null;
       String url = "jdbc:db2://localhost:50000/SAMPLE" ;
    
       Properties properties = new Properties();
       properties.put("user" , "db2inst1");
       properties.put("password", "xxx");
       properties.put("enableSysplexWLB", "true");  // Condition 1
       properties.put("traceFile", "jcctrc1.txt");
       properties.put("traceLevel", "-1");
    
       try {
       System.out.print("Start!!");
    
       con = DriverManager.getConnection(url,properties);
       Statement stmt = con.createStatement();
       System.out.print("Connected!!");
    
       //stmt.executeUpdate("SET CURRENT LOCALE LC_TIME = 'KO_KR'");
       stmt.executeUpdate("SET CURRENT LOCALE LC_TIME = 'ko_KR'");
    
       ResultSet rs = stmt.executeQuery("SELECT
    CURRENT_TIMESTAMP,CURRENT MEMBER FROM SYSIBM.SYSDUMMY1");
       System.out.print("result set opened!!");
       System.out.print("Received results:\n\n");
    
       while (rs.next()) {
        String deptnumb = rs.getString(1);
        String deptname = rs.getString(2);
        System.out.print(" no= " + deptnumb + " name= " + deptname +
    "\n");
       }
       rs.close();
       System.out.print("rs close!!");
       stmt.close();
       System.out.print("stmt close!!");
       con.close();
       System.out.print("con close!!");
      } catch( Exception e ) {
       e.printStackTrace();
      }
    }
    }
    
    $ javac myjdbc4
    $ java myjdbc4
    Start!!Connected!!com.ibm.db2.jcc.am.SqlSyntaxErrorException:
    DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=ko_KR,
    DRIVER=3.72.44
    ..
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platform                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V11.1 mod4 fixpack 6                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT31100

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-11-27

  • Closed date

    2021-03-16

  • Last modified date

    2021-03-16

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

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

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
18 March 2021