Db2

 View Only
Expand all | Collapse all

Database Conversion Workbench - Windows10 not starting only displays startup splash screen

  • 1.  Database Conversion Workbench - Windows10 not starting only displays startup splash screen

    Posted Tue January 04, 2022 12:35 PM
    Hi Folks,

    I am hope I am posting this is the right location.
    I couldn't see an option to post the question in IBM Database Conversion Workbench library, but if there is a way to post in the
    library perhaps someone can let me know how please?

    I have downloaded and installed the latest version 5.0.1 of the Database Conversion Workbench tool onto Windows 10.
    Did the full download client.
    The install seems to have gone ok but when I launch DCW the initial splash screen appears and it just sits there spinining
    I have waited a full 30mins and nothing.
    It starts 4 background process as shown in the Task Manager screen shot below, but nothing ever appears apart from the s
    startup splash shown in the second screenshot below.

    What's it doing?
    - no error message displayed?
    - what do I need to do to get it work?

    My second question is I need to migrate a database from IBM iSeries Db2 to old version 5.xx to AIX Db2 v11.5
    - will the Conversion Workbench  help me analysis the Generated Schema file I have extracted from the IBM iSeries?
    - will it convert the "LABLEL ON" statement for example to "COMMENT ON" statements, if it doesn't then that is not a big issue
        if it just tells me there a 1,000 such statement that is fine, I will easily do the conversion myself using sed or whatever.
    - if can tell there at X thousand CREATE TABLES, X thousand CREATE VIEW, X thousand AQT / MQT statement
      this will help me size the amount of work effort I need to do to perform the migration which would be great.

    But my first issue is to get to run and work and see what it can do?
    Appreciate the help please.
    Thank you
    Michael






    ------------------------------
    Michael
    ------------------------------

    #Db2


  • 2.  RE: Database Conversion Workbench - Windows10 not starting only displays startup splash screen

    Posted Wed January 05, 2022 01:47 PM

    Hi Michael,

    Comments on your migration

    tool choice
    i heard from people doing the migration from Db2 on IBM system i to Db2 LUW.
    What i never heard is that the used DCW.
    When you check the downloads you have 2 versions . One is for migration from Oracle and Teradata and one is from Netezza to a warehouse version of Db2.

    Since Db2 on i series is part of the db2 family there are other tool options like data studio or DMC

    I would expect that you have to extract the ddl somehow and adapt it to the target Db2 (data types and tablespace layout).
    And the you have to move the data somehow. (export/import . replication ,  select from cursor using views)

    Connectivity
    There are other gaps occuring thats the connectivity.
    How does customer administer their database today. Do they use a graphical tool on windows? There is one tool provided by i series , which had a name like client
    access.  In this case they use i series specific connectivity.

    For Db2 internal connectivity over db2 cmdline or tools like data studio or Data Management Console you need a db2 connect license. This should also be part of a developer edition

    Sorry these are only some comments to proceed somehow.
    kind regrads
    Joachim



    ------------------------------
    joachim stumpf
    ------------------------------

    Original Message


  • 3.  RE: Database Conversion Workbench - Windows10 not starting only displays startup splash screen

    IBM Champion
    Posted Wed January 05, 2022 04:31 PM
    Having done a number of migrations from Db2 for iSeries to Db2 for LUW, I'd be happy to discuss this with you.

    Some thoughts on what you've posted so far -

    1) There are lots of options in the IBM i Access Client Solutions feature which generates DDL.  Careful choice of these can ease the process of generating DDL compatible with Db2 for LUW.
    2) If you set up a federated link from LUW to iSeries then you give yourself another bunch of possibilities for generating DDL using SQL.  This also can really speed up data migration using "crossloader" (LOAD from CURSOR)
    3) One area which can be problematic is dealing with some iSeries specifics.  You'll need to sort out what are really relevant indexes - you probably don't want the logical indexes, which are more akin to MQTs.  You may have objects where the system name and the schema name don't match - in this case you can use aliases to work around this problem if you don't want to convert all your code.
    4) You may need to sort out the "running order" of the generated DDL.   In iSeries you can define objects which refer to other objects that don't yet exist, but you can't do that on LUW.  In complex cases I used some recursive SQL over the catalog to get the nesting sequence, so I could deal with the most deeply embedded objects first.

    That's just a few things to think about as a starter.   Reach out to me (teamdba@scotdb.com) if you would like to discuss further.

    Phil



    Original Message