Db2 (On Premises and Cloud)

Expand all | Collapse all

Migration of databases hangs indefinitely

Jump to Best Answer
  • 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:
     



  • 2.  RE: Migration of databases hangs indefinitely

    Posted 30 days ago

    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