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: