Db2

 View Only

  • 1.  Db2 restore from Linux to Windows

    Posted Mon December 05, 2022 09:41 AM
    Hello experts,

    Newbie here.

    I have a task at my hand to restore DB2 exported from Linux to Windows. I tried restoring using the command "db2move maxdb76 import -io REPLACE_CREATE". I do get quite a few errors on the tables that fail due to whatever reasons (I am happy to resolve them), however, I am getting an issue that I can resolve. The issue is that I am trying to restore the Database to F drive, however, during the restore C drive gets populated and runs out of space. 
    I am looking for advice on how I can restore DB and redirect restore to F drive.

    Db2 version DB2 v11.5.7000.1973

    Cheers


    ------------------------------
    Vitalius Svazas
    ------------------------------

    #Db2


  • 2.  RE: Db2 restore from Linux to Windows

    Posted Tue December 06, 2022 12:22 PM
    You can always change your instance default db path
    DB2 UPDATE DBM CFG USING DFTDBPATH F: IMMEDIATE
    and then cycle your instance to pick up the change

    ------------------------------
    Freddie Callander
    ------------------------------

    Original Message


  • 3.  RE: Db2 restore from Linux to Windows

    Posted Wed December 07, 2022 09:54 AM
    have you verified where the db has been created - data path
    you should always create the db yourself with correct options
    connect to db - db2 list tablespace containers for 0    will show the path for catalog
    create the db with : on f:\xxx      dbpath on ....
    take db2look from original db - restore the db2look and check you use automatic storage -
    use db2move...    with load/import ..   maybe tempspace for db2 is on c:   - check new db2look -l


    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message