DB2 - Problem description
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) |