DCW 1.1 Release
OlafMueller 120000D8S1 Visits (2020)
Hello DCW users,
Finally I end up as well as a blogger in the social media world. The new release of the IBM Database Conversion Workbench (DCW) is actually a great point to start this journey.
Why am I so excited about this release? There are several reasons for this excitement.
Significant performance improvements
With the first releases of DCW we have seen some performance flaws while running the eval
As people use DCW at customer sites they want to see evaluation results as soon as possible. Therefore our first idea was to split the eval
This improved performance for both steps . But not at a level that we expected. Hence we digged deeper into each separate step. We were able to reduce the memory footprint of both processes significantly.
As a result of these optimizations evaluation and conversion are executing up to five times faster than before.
In case you are dealing with large files you might want to discuss intermediate results with a customer already. You can use the Split functionality to break your DDL file into smaller pieces organized by database objects.
Afterwards just execute evaluation on each file separately. This way you can discuss certain incompatibilities already while other files are executed.
DB2 10.1 FP2 support
This DCW release recognizes all the new Oracle compatibility features implemented. Hence it does not report these features as incompatible any more.
Data Studio 3.2 compatibility
As DCW is build as a plug-in into Data Studio it benefits from any improvements to this base. This is why we enabled DCW for the new release of Data Studio. With this DCW release we do not support Data Studio 3.1.1 any more.
Oracle to DB2 data movement using Federation (LOAD FROM CURSOR)
So far DCW supported data movement only through files or pipes for conversions from Oracle to DB2. With this release we enabled the LOAD FROM CURSOR movement through Federation for Oracle source databases.
This feature was implemented earlier already for DB2 to DB2 migrations. The new feature for Oracle conversions supports both DB2 and PureData System Transactions (PDTX) targets. This feature improves your data movement sign
Stay tuned for updates to this blog. In the next edition I will talk about what to expect next from DCW.