DB2 - Problem description
Problem IT01411 | Status: Closed |
USING DB2MOVE WITH THE COPY OPTION TO MOVE FROM V9.5/V9.7 TO V10.1 FAILS WITH 'SQLCODE -204' | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
Using the db2move with the COPY option to move schema from V9.5 or V9.7 to V10.1 fails with : Error: Error Message : sqlcode -204:select obj_qualifier, related_obj_info, sql_stmt, db2move failed with -1 (debuginfo:50). db2diag.log shows: 2014-04-23-14.04.01.292685-240 I683470E1667 LEVEL: Severe PID : 28598 TID : 140649062643488 PROC : db2move INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPID : 10.54.186.49.38446.140423180354 HOSTNAME: nykpcr00008n03 FUNCTION: <0>, <0>, <0>, probe:403 MESSAGE : ZRC=0xFFFFFF34=-204 SQL0204N "" is an undefined name. DATA #1 : String, 94 bytes [IBM][CLI Driver][DB2/SUN64] SQL0204N "SYSCAT.PERIODS" is an undefined name. SQLSTATE=42704 DATA #2 : String, 1063 bytes select obj_qualifier, related_obj_info, sql_stmt, case when exists ( select 1 from SYSCAT.PERIODS where (OBJ_SCHEMA,OBJ_NAME) = (HISTORYTABSCHEMA,HISTORYTABNAME) and HISTORYTABSCHEMA <> TABSCHEMA) then 'H' when exists ( select 1 from SYSCAT.PERIODS where (OBJ_SCHEMA,OBJ_NAME) = (TABSCHEMA,TABNAME) and HISTORYTABSCHEMA is not NULL and HISTORYTABSCHEMA <> TABSCHEMA) then 'S' else 'N' end as skipped from SYSTOOLS.DB2LOOK_INFO where OP_TOKEN = ? AND SQL_OPERATION = 'CREATE' and OBJ_TYPE = ? and OBJ_NAME = ? and OBJ_SCHEMA = ? DATA #3 : signed integer, 4 bytes -204 DATA #4 : String, 5 bytes 42S02 == This is because new code was added in v10.1 that queries the SYSCAT.PERIODS table, which does not exist in V9.5 / V9.7. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.1 Fix Pack 5 or higher * **************************************************************** | |
Local Fix: | |
Use "db2move EXPORT" on the source database (v95 or v97 system), and then "db2move IMPORT" or "db2move LOAD" on target database (v10 system) | |
Solution | |
First Fixed in DB2 V10.1 Fix Pack 5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.04.2014 15.07.2015 15.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |