home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList