Results 1 to 3 of 3

Thread: db2look

  1. #1
    Join Date
    Dec 2012

    Unanswered: db2look

    HI every one

    db2look command to extract databse definition to create same database on other instance.

    please help mee

  2. #2
    Join Date
    Jul 2004
    Depends what you want created and order etc.

    One I've used in the past is
    db2look -d <dbname> -e (to extract the DDL) -l (tablespaces and bufferpools etc) -x (grant statements) -o <outputfilename>

    Note this doesn't move data, just objects. An easier option might be a redirected restore?

    You can get all the options and explanations in the Infocenter:
    db2look - DB2 Statistics and DDL extraction tool - IBM DB2 9.7 for Linux, UNIX, and Windows

  3. #3
    Join Date
    Jan 2013
    If you want to move data along with object creation, please look in to db2move tool.
    db2move-Database Movement Tool Command.

Posting Permissions

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