IT34630: DB2CONVERT DOES NOT WORK WITH DPF AND WITH A TABLE IN A TABLE SPACE THAT DOES NOT EXIST ON THE HEAD NODE

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

APAR status

• Closed as program error.

Error description

• db2convert does not work with DPF and with a table in a table
  space that does not exist on the head node. It converts no
  tables, for example:
  
  (assuming db2convert connects to database at partition 0, and
  table space TS1 is in a database partition group that does not
  include partition 0)
  
  ==> db2 -tvf table1.sql
  CREATE TABLE "TEST1 "."TABLE1" ( "COL1" INTEGER ) IN TS1
  ORGANIZE BY ROW
  DB20000I The SQL command completed successfully.
  
  ==> db2 "insert into test1.table1 values (1)"
  DB20000I The SQL command completed successfully.
  
  ==> db2convert -d edwdba -z test1 -t table1
  Proceeding with the conversion...
  Table RowsNum RowsComm Status Progress (%)
  --------------------------------------- ---------------
  --------------- --------------- ---------------
  "TEST1"."TABLE1" 1 0 UNSTARTED 0.00
  Table RowsNum RowsComm Status Progress (%)
  --------------------------------------- ---------------
  --------------- --------------- ---------------
  "TEST1"."TABLE1" 1 0 INIT 100.00
  ****************************************************************
  *************************************************
  Errors:
  ****************************************************************
  *************************************************
  SQL2448N The db2convert command failed to convert any
  row-organized tables to column-organized tables.
  

Local fix

• Call ADMIN_MOVE_TABLE directly
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all db2convert users running DPF                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1.4.7                                      *
  ****************************************************************
  

Problem conclusion

• Problem is fixed in Db2 11.1.4.7
  

Temporary fix

Comments

APAR Information

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

• 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 PSN

     UP