|
Problem IT36054
|
Status: Closed |
THE DB2MOVE COMMAND DOES NOT EXPORT PARTITIONED TABLES WHEN USED WITH OPTION: TS
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
The db2move does not export partitioned tables when it is used
with option: -ts
Testcase that can be used to reproduce the issue:
db2sampl -name test
db2 connect to test
db2 "create table t1 (x1 int) partition by range (x1) (starting
1 ending 20 every 10) in userspace1"
db2 "insert into t1 values(1)"
db2 "insert into t1 values(4)"
..
db2 "select count(*) from t1"
1
-----------
28
$ db2 "create table tab99(col1 int) in userspace1"
$ db2 "insert into tab99 values(4)"
Then I tried to export tables..
db2move test export -ts USERSPACE*,SYSCATSPACE
The command above works only for non partitioned table tab99.
Table t1 was not exported |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to fixpack inclusive of this APAR fix. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to fixpack inclusive of this APAR fix. *
**************************************************************** |
| Comment |
See APAR Details |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.02.2021
26.02.2021
26.02.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
