Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

DCW Hub (Product Documentation & Tutorials)

By Jordan Hodges posted 04/07/21 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
1077 views

Permalink

https://community.ibm.com/community/user/blogs/jordan-hodges1/2021/04/07/dcw-product-hub

Comments

Yaseen Shaik
04/10/23 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