IT36054: THE DB2MOVE COMMAND DOES NOT EXPORT PARTITIONED TABLES WHEN USED WITH OPTION: TS

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error 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
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to fixpack inclusive of this APAR fix.                *
  ****************************************************************
  

Problem conclusion

• See APAR Details
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IT25468

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSY

     UP

• RB50 PSY

     UP