DB2 FOR LUW / DB2FORLUW / B50 - DB2

If a db2move COPY operation is performed on a remotely cataloged
database which resides on a client at version 11.5.6.0 or
11.5.7.0, and the remote database server is at version older
than 11.5.6.0, then it may fail with error message "Invalid
object type specified".

Example:
Suppose a database "localDB" resides on a database server
running 11.5.4.0, and it is cataloged on a remote client as
"remoteDB" running version 11.5.6.0.

$  db2move remoteDB COPY -sn remoteschema -co TARGET_DB localDB
SCHEMA_MAP "((remoteschema ,localschema)" -u usserid -p



The db2move will fail with error like so:

Application code page not determined, using ANSI codepage 1208
*****  DB2MOVE  *****
Action:  COPY
Start time:  Mon Oct 25 11:29:14 2021

All schema names matching:  REMOTESCHEMA;
Connecting to database REMOTEDB ... successful!  Server : DB2
Common Server V11.1.4
Copy schema REMOTESCHEMA to LOCALSCHEMA on the target database
LOCALDATABASE
Create DMT :
Rolled back all changes from the create phase (debuginfo:120).

Error Message : Invalid object type specified
db2move failed with -1 (debuginfo:50).

db2diag.log on local server will contain a message like this

XXXXXXXXXXXXXXXX           LEVEL: Severe
PID     : 73058    TID : 140439345940256 PROC :
db2move
INSTANCE: instance             NODE : 000            DB   :
LOCALDB
APPID   : xxxxxxxxxxxxx
HOSTNAME: hostname
FUNCTION: , , , probe:1006
MESSAGE : ZRC=0xFFFFFFFF=-1
DATA #1 : String, 29 bytes
Generate dependency tree call
DATA #2 : Hexdump, 136 bytes
0x00007FFD1D109F50 : 5351 4C43 4120 2020 8800 0000 45FE FFFF
SQLCA   ....E...
0x00007FFD1D109F60 : 4100 4144 4D49 4E5F 4745 545F 4445 5054
A.ADMIN_GET_DEPT
0x00007FFD1D109F70 : 5245 45FF 4144 4D49 4E5F 4745 545F 4445
REE.ADMIN_GET_DE
0x00007FFD1D109F80 : 5054 5245 45FF 496E 7661 6C69 6420 6F62
PTREE.Invalid ob
0x00007FFD1D109F90 : 6A65 6374 2074 7970 6520 7370 6563 6966
ject type specif
0x00007FFD1D109FA0 : 6965 6420 2020 2020 5351 4C45 5246 5250
ied     SQLERFRP
0x00007FFD1D109FB0 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x00007FFD1D109FC0 : 0000 0000 0000 0000 2020 2020 2020 2020
........
0x00007FFD1D109FD0 : 2020 2033 3830 3030
38000

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to	db2_v115m7fp1                                     *
****************************************************************

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to	db2_v115m7fp1                                     *
****************************************************************

Upgrade to	db2_v115m7fp1

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

28.10.2021
09.03.2022
09.03.2022