Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  data corruption the DB2 ==> MariaDB Federation

    Posted Fri September 25, 2020 02:50 PM
    hi,

    the last beta version has a data corruption bug 

    db2level:
    DB21085I This instance or install (instance name, where applicable:
    "db2inst0") uses "64" bits and DB2 code release "SQL11056" with level
    identifier "0607010F".
    Informational tokens are "DB2 v11.5.6.0", "s2008062130", "DYN2008062130AMD64",
    and Fix Pack "0".
    Product is installed at "/opt/ibm/db2/V11.5.5-beta".

    to reproduce the bug, i'have installed a mariadb in our lab:

    ==

    drop server mariadb_jdbc;
    drop wrapper jdbc;
    CREATE WRAPPER "JDBC" LIBRARY 'libdb2rcjdbc.so' OPTIONS (DB2_FENCED 'Y');


    CREATE SERVER mariadb_jdbc
    TYPE JDBC
    WRAPPER "JDBC"
    OPTIONS
    (COMM_RATE '100'
    ,DB2_MAXIMAL_PUSHDOWN 'Y'
    ,DRIVER_CLASS 'org.mariadb.jdbc.Driver'
    ,DRIVER_PACKAGE '/home/db2inst0/jdbc/mariadb-java-client-2.6.2.jar'
    ,JDBC_LOG 'Y'
    ,PUSHDOWN 'Y'
    ,URL 'jdbc:mariadb://212.83.134.220:3306/mydb_utf8?autoReconnect=true&tcpKeepAlive=true&defaultFetchSize=100000&sessionVariables=net_write_timeout=3600,net_read_timeout=3600,wait_timeout=999999&tinyInt1isBit=false&rewriteBatchedStatements=true&cachePrepStmts=false&useBulkStmts=true'
    ,VARCHAR_NO_TRAILING_BLANKS 'Y'
    );


    CREATE USER MAPPING FOR db2inst0 SERVER mariadb_jdbc OPTIONS (REMOTE_AUTHID 'db2testuser' ,REMOTE_PASSWORD 'db2testuser');

    create nickname schmjdbc.test_tinyint for mariadb_jdbc."test_tinyint";

    create nickname schmjdbc.test_utf8 for mariadb_jdbc."test_utf8";

    PS: you can down load the JDBC driver from :https://downloads.mariadb.com/Connectors/java/connector-java-2.6.2/mariadb-java-client-2.6.2.jar


    then: 


    db2 "insert into schmodbc.test_utf8 values (1,'vcol2')"

    db2 "select * from schmodbc.test_utf8"

    ICOL1 VCOL2
    -------------------- ------------------------------------------------------------------------------------------
    1 vcol2

    1 enregistrement(s) sélectionné(s).


    db2 "update schmodbc.test_utf8 set (vcol2) = (select * from (values ('MALEK1'))) where vcol2 = 'vcol2'"

    [db2inst0@db2-cdc bugodbc]$ db2 "select * from schmodbc.test_utf8"

    ICOL1 VCOL2
    -------------------- ------------------------------------------------------------------------------------------
    1 䅍䕌ㅋ

    1 enregistrement(s) sélectionné(s).


    as you see, DB2 insert corrupted data.

    Malek





    ------------------------------
    malek shabou
    ------------------------------

    #Db2


  • 2.  RE: data corruption the DB2 ==> MariaDB Federation

    Posted Tue September 29, 2020 02:43 AM
    Malek,

    Many thanks for bringing this issue to us, could you please also create a case in Salesforce so that we can work through the official support process like the other issues we supported for you? Thanks for your understanding. 

    Lei
    Federation Server Development

    ------------------------------
    LEI CUI
    ------------------------------

    Original Message


  • 3.  RE: data corruption the DB2 ==> MariaDB Federation

    Posted Tue September 29, 2020 04:00 AM
    Hi,
    already done:

    support ticket: TS004153131

    there is a couple of other issue with the MariaDB federation (JDBC Wrapper):

    Ticket: TS004254683 :     Federation MariaDB JDBC:QL1822N Unexpected error code "0A000" received from data source, when comparing timestamp

    Ticket: TS004191629: WCB 09/28 federation DB2 LUW ==> MariaDB JDBC, left outer join does not push predicat to the remote database


    ------------------------------
    malek shabou
    ------------------------------

    Original Message


  • 4.  RE: data corruption the DB2 ==> MariaDB Federation

    Posted Wed September 30, 2020 03:02 AM
    Thank you Malek, yes we're well aware of and working all the opening cases you created on Federation, including the one TS004153131 for this issue,  will let you know if we have any progress.

    Lei

    ------------------------------
    LEI CUI
    ------------------------------

    Original Message


Related Content