db2 move with COPY option between db2 9.5 and 9.7 supported?

[hsn_]

I can not get db2move work with db2 9.5 -> 9.7. I am running db2move
utility on target system. Source db is 9.5.4 target db is 9.7.1

db2move test COPY -sn hsn -co TARGET_DB SAMPLE SCHEMA_MAP ((hsn,test))
-u db2inst1 -p db2

fails with:

create dmt: systools.dmt_xxxxx

Error message: sqlcode -206: select objschema, objname, type. subtype,
generated_cols

in db2 diag log is entire failed select statement

2009-12-02-22.29.15.193268+060 I98022G789 LEVEL: Severe
PID : 13740 TID : 3050243776 PROC : db2move
INSTANCE: hsn NODE : 000
APPID : 10.0.0.6.53253.091202212916
FUNCTION: <0>, <0>, <0>, probe:397
MESSAGE : ZRC=0xFFFFFF32=-206
DATA #1 : String, 111 bytes
[IBM][CLI Driver][DB2/LINUX] SQL0206N "SUBTYPE" is not valid in the
context where it is used. SQLSTATE=42703
DATA #2 : String, 276 bytes
select objschema, objname, type, subtype, generated_cols,
valid, min(nest_level) as nesting_level from
"SYSTOOLS"."DMT_4b16dc2aab0ef" group by (objschema,
objname, type, subtype, generated_cols, valid) order by
nesting_level
DATA #3 : signed integer, 4 bytes
-206
DATA #4 : String, 5 bytes
42S22

It seems that DMT table is created by some stored procedure in v9.5
but db2move from 9.7 expect it in different format.

Table is created by following event:

57) Statement Event ...
Type : Dynamic
Operation: Execute Immediate
Section : 65
Creator : NULLID
Package : SYSSH200
Consistency Token : SYSLVL01
Package Version ID :
Cursor :
Cursor was blocking: FALSE
Text : CREATE TABLE
"SYSTOOLS"."DMT_4b16d0a15af85" ( OBJNAME
VARCHAR(128), OBJSCHEMA VARCHAR
(128), TYPE CHAR,
GENERATED_COLS INT, REF_OBJNAME VARCHAR
(128), REF_OBJSCHEMA VARCHAR(128),
REF_TYPE CHAR, NEST_LEVEL
SMALLINT, VALID VARCHAR
(2), CATEGORY SMALLINT) IN SYSTOOLSPACE
-------------------------------------------
Start Time: 12/02/2009 21:39:56.462770
Stop Time: 12/02/2009 21:39:56.534017
Elapsed Execution Time: 0.071247 seconds

Is there way to get this work? it will need to replace SYSSH200
package on db2 9.5 with 9.7 version but db2lkfun.bnd from 9.7 does not
binds against 9.5 database

[Serge Rielau]

I propose you call support and open a PMR.

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

[koza]

any resolution for this? I got exactly the same issue.

[koza]

There is an article on IBM mentioning that you might end up with this
error, but there is no explanation why it happens and what would be
the solution:
http://www.ibm.com/developerworks/data/library/techarticle/dm-0608schuetz/index.html

Please, let me know if you got this working eventually. I am also
trying 9.7 to 9.5. Same OS.

[Serge Rielau]

Seems like we have a standoff. ;-) I ask you guys to open a PMR and you
guys ask for updates.
This is NOT support, unless someone opens this PMR there will be no answer.

Cheers
Serge