Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    11

    Unanswered: extract the DDL to create the Database

    Hi,
    Could anyone help me how to extract the DDL to create a Database. I am aware that using db2look we are able to extract the DDL of all Database objects? My doubt is how to extract the DDL to create the Database?
    Nambi

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There is no DB2 facility to do that since create database is a command and not SQL. Some 3rd party tools will do it.

    You can get all the necessary options to replicate a database (codeset, territory, etc) using the following command:

    db2 get db cfg
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2006
    Posts
    97
    my 2 cent suggestion.

    Redirected restore may be be better option for you (If don't want that data Load with /dev/null in unix)

Posting Permissions

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