Db2

 View Only
  • 1.  Migration of databases hangs indefinitely

    Posted Mon March 30, 2020 11:37 AM

    Hi,

    after installing the new beta drop "DB2 v11.1.1010.131", "s1611060100", "DYN1611060100WIN64" I tried to migrate two databases from the previous DB2 Express-C installation with DB2 10.5 or 11.1

    The command "db2 migrate db xxx" begins, but does not return to a command prompt. In the db2diag.log I can see, the migration finished within some seconds, but it cannot finish the post migration steps.

    I find following errors in db2diag.log. To me it looks, the final connect to the database fails.

     

    Cheers

    Roland

     

    db2diag.log:

    2016-11-28-10.21.39.730000+060 I153270F411          LEVEL: Warning
    PID     : 10684                TID : 12564          PROC : db2bp.exe
    INSTANCE: DB2                  NODE : 000           DB   : PK2I11C1
    APPID   : *LOCAL.DB2.161128092135
    HOSTNAME: JUDITH
    EDUID   : 12564
    FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:396
    DATA #1 : <preformatted>
    End engn migration(pk2i11c1): with sqlcode = 6

    2016-11-28-10.21.39.730000+060 I153683F401          LEVEL: Warning
    PID     : 10684                TID : 12564          PROC : db2bp.exe
    INSTANCE: DB2                  NODE : 000           DB   : PK2I11C1
    APPID   : *LOCAL.DB2.161128092135
    HOSTNAME: JUDITH
    EDUID   : 12564
    FUNCTION: DB2 UDB, base sys utilities, sqlePostUpgDpfTask, probe:1360
    DATA #1 : <preformatted>
    Begin post upgrade tasks

    2016-11-28-10.21.39.933000+060 I154086F843          LEVEL: Warning
    PID     : 14048                TID : 14992          PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   : PK2I11C1
    APPHDL  : 0-35                 APPID: *LOCAL.DB2.161128092139
    AUTHID  : DB2ADMIN             HOSTNAME: JUDITH
    EDUID   : 14992                EDUNAME: db2agnti (PK2I11C1) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::SubsequentConnect, probe:12292
    RETCODE : ZRC=0xFFFFFBF5=-1035
              SQL1035N  The operation failed because the specified database cannot
              be connected to in the mode requested.

    MESSAGE : db_state2/ use/ use_count/ rqst_type :
    DATA #1 : ASCII Char, 1 bytes
    <2>
    DATA #2 : ASCII Char, 1 bytes
    X
    DATA #3 : unsigned integer, 2 bytes
    1
    DATA #4 : Hex integer, 4 bytes
    0x800000AA
     

    2016-11-28-10.21.39.933000+060 I154931F1044         LEVEL: Warning
    PID     : 14048                TID : 14992          PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   : PK2I11C1
    APPHDL  : 0-35                 APPID: *LOCAL.DB2.161128092139
    AUTHID  : DB2ADMIN             HOSTNAME: JUDITH
    EDUID   : 14992                EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleIndDBConnInit, probe:1882
    RETCODE : ZRC=0xFFFFFBF5=-1035
              SQL1035N  The operation failed because the specified database cannot
              be connected to in the mode requested.

    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1035   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQLESBCN
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:

    2016-11-28-10.21.39.933000+060 I155977F1009         LEVEL: Severe
    PID     : 14048                TID : 14992          PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   : PK2I11C1
    APPHDL  : 0-35                 APPID: *LOCAL.DB2.161128092139
    AUTHID  : DB2ADMIN             HOSTNAME: JUDITH
    EDUID   : 14992                EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleIndCoordInit, probe:295
    RETCODE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
              "SQLCA has been built and saved in component specific control block."
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1035   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQLESBCN
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
     


    #Db2
    #Db2EarlyAccessProgram(EAP)Forum


  • 2.  RE: Migration of databases hangs indefinitely

    Posted Thu April 08, 2021 09:35 AM

    Hi Roland,

     

    This is Arnold from the DB2 Beta team. We're currently looking into your issue. In the meantime, could you please provide us with the full db2diag.log and a db2trc on the command?

     

    Thanks,

    Arnold




  • 3.  RE: Migration of databases hangs indefinitely
    Best Answer

    Posted Mon March 30, 2020 11:38 AM

    Hi Arnold,

     

    I'm sorry for the late response. I just didn't notice your reply to my question. In the meantime I upgraded also my environment to the latest code drop.

     

    So I did a clean uninstall of the old version, reboot and reinstalled DB2 10.5FP5 Express-C with default settings.

    In DB2 10.5 I created the SAMPLE database and checked the accessibility. The I did an upgrade install to the latest

    DB2 vNext code (build 20161228, release mid of January) and the migration run without problems.

     

    I'm sorry, I cannot reproduce the problem anymore.

     

    Kind regards

    Roland