|
Problem IC69995
|
Status: Closed |
TRANSPORT SCHEMAS FAILS WHEN TRANSPORTING OBJECTS WITH COMMENTS ON THEM |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Whenever a user performs a transport operation using using the
Transportable Schemas functionality (i.e. "restore db srcdb
tablespace(tbsp1) schema(s1) transport into targetdb"), and any
of the objects in the schemas being transporting have comments
associated with them, the transport operation will fail with the
following error:
SQL2590N The requested RESTORE operation cannot be completed
because a schema transport error has occurred. Reason Code: 16.
The following entry will also be printed in the db2diag.log
2010-06-04-16.21.33.796000+120 I416954H529 LEVEL: Error
PID : 3892 TID : 1428 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000 DB :
SYSTG001
APPHDL : 0-737 APPID: *LOCAL.DB2.100604142108
AUTHID : USERID
EDUID : 1428 EDUNAME: db2agent (SYSTG001)
FUNCTION: DB2 UDB, database application extension for utili
transport_extractDDLtoFile, probe:6083
MESSAGE : Transport:Invalid command type
DATA #1 : unsigned integer, 4 bytes
0
This error will occur on all platforms. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 UDB systems on all Linux, Unix, and Windows *
* platforms on Version 9.7.3 are vulnerable. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Whenever a user performs a transport operation using using *
* the Transportable Schemas functionality (i.e. "restore db *
* srcdb tablespace(tbsp1) schema(s1) transport into *
* targetdb"), and any of the objects in the schemas being *
* transporting have comments associated with them, the *
* transport operation will fail with the following error: *
* *
* SQL2590N The requested RESTORE operation cannot be completed *
* because a schema transport error has occurred. Reason Code: *
* 16. *
* *
* *
* The following entry will also be printed in the db2diag.log *
* *
* 2010-06-04-16.21.33.796000+120 I416954H529 LEVEL: *
* Error *
* PID : 3892 TID : 1428 PROC : *
* *
* db2syscs.exe *
* *
* INSTANCE: DB2 NODE : 000 DB : *
* *
* SYSTG001 *
* *
* APPHDL : 0-737 APPID: *
* *LOCAL.DB2.100604142108 *
* AUTHID : USERID *
* *
* EDUID : 1428 EDUNAME: db2agent (SYSTG001) *
* *
* FUNCTION: DB2 UDB, database application extension for utili *
* *
* transport_extractDDLtoFile, probe:6083 *
* *
* MESSAGE : Transport:Invalid command type *
* *
* DATA #1 : unsigned integer, 4 bytes *
* *
* 0 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9 FixPak 3. *
**************************************************************** |
| Local Fix: |
Prior to running transport, remove all comments from objects in
the schemas you wish to transport. You can readd the comments on
these objects after the transport is complete. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The complete fix for this problem first appears in DB2 UDB
Version 9 FixPak 3 and all thesubsequent FixPaks. |
| Workaround |
Prior to running transport, remove all comments from objects in
the schemas you wish to transport. You can readd the comments on
these objects after the transport is complete. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.07.2010
23.09.2010
23.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
