Db2

 View Only

DCW Hub (Product Documentation & Tutorials)

By Jordan Hodges posted Wed April 07, 2021 09:10 PM

  

Welcome to DCW Hub

On this page you can find information about DCW and links to key resources. 

What is DCW?
The IBM Database Conversion Workbench (DCW) provides an end-to-end solution through UI tooling to facilitate the conversion of Oracle & Teradata databases to DB2 on premise and cloud databases.

DCW provides features such as:

  • SQL evaluation & effort estimation
  • SQL editing & debugging
  • SQL conversion & deployment


These features and processes are based on several leading practices that are identified by IBM data migration consultants.

DCW 5.0.1:

Key Links:



Please reach out to the DCW team for any feedback on the slack channel #data-conversion-wb
Also, feel free to send your comments, suggestions and questions to 
askdcw@ca.ibm.com


#Db2
#DCW

1 comment
903 views

Permalink

Comments

Mon April 10, 2023 01:47 PM

Hello Team,
As per the document we started migrating our DB from ORACLE to DB2, and we successfully extracted DATA from source but while loading data in to target we are facing below issue.

2023-04-10-07.26.09.092012-240 I584376904E666        LEVEL: Error
PID     : 15214                TID : 140171764819712 PROC : db2sysc 0
INSTANCE: db2bou               NODE : 000            DB   : BOU
APPHDL  : 0-4650               APPID: 10.45.16.136.9094.230410112524
UOWID   : 1323                 ACTID: 1
AUTHID  : DB2BOU               HOSTNAME: pcgboudb201
EDUID   : 112                  EDUNAME: db2agent (BOU) 0
FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag, probe:0
DATA #1 : String, 136 bytes
LOADID: 112.2023-04-10-07.26.08.912229.0 (11;3537)
Error loading partition. , -2146107283, (nil), Detected in file:sqluvtld.C, Line:1259
 
2023-04-10-07.26.09.103907-240 I584377571E557        LEVEL: Severe
PID     : 15214                TID : 140171764819712 PROC : db2sysc 0
INSTANCE: db2bou               NODE : 000            DB   : BOU
APPHDL  : 0-4650               APPID: 10.45.16.136.9094.230410112524
UOWID   : 1323                 ACTID: 1
AUTHID  : DB2BOU               HOSTNAME: pcgboudb201
EDUID   : 112                  EDUNAME: db2agent (BOU) 0
FUNCTION: DB2 UDB, database utilities, sqlu_register_table_load, probe:1255
MESSAGE : Load Error: Error loading partition.


if anyone faced this issue please provvide the resoluton for the same