Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007

    Question Unanswered: its a good logical question

    suppose there are two machines A & B

    A has db2 7.1 server

    B has db2 8.1 server

    there is database ISMWL on machine A

    now the task is I have copy all the database objects of ISMWL
    in the database ISMWL1 (in machine B) with all data value

    you cannot change database on any amchine

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    1) extract the DDL-scripts from all the objects from ISMWL via B2LOOK
    2) let the script from 1) run on ISMWL1,
    3) create the stored procedures of ISMWL on ISMWL1
    3) export the tables from ISMWL
    4) load the tables obtained in 3) into ISMWL
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    There are 2 more approaches:
    (1) use db2move, which simplifies Wim's steps a bit.
    (2) if you don't have to worry about existing data in the database on machine B, then take a backup from A and restore it on B.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jun 2007



    but it answer should be in breif

    1-first step copy the script of create database tablescpace and bufferpool
    and run this script as
    db2 - tvf step1.sql

    2-In second step cut all foreign keys statement from db2look.sql and make
    seperate script for that foreign keys
    and run this script which contains create table, indexes primary keys
    alter statement
    db2 - tvf step2.sql

    til then database is created and table structure

    3-copy the back up file of ISMWL database to system B
    and run
    db2move ismwl load -u ism -p ism

    all the data will copy to database in SYSTEM B

    now data is copied to database objects

    4- run the script of foreign keys
    db2 -tvf step4.sql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts