Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: Anyone know to generate existing create database ddl script and clone dbcfg

    Hi All,
    Anyone know how to generate existing source database create database ddl script, the db version I am using is db2 9.7 running in windows.

    The purpose of this is to create a dummy database for me to restore redirect to this db using TSM.

    Thanks.

    Thanks

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Use db2look to generate the DDL for tablespaces+tables(etc) from an existing database. Refer to the Knowledge-centre for V9.7 for details.
    Use db2cfexp , db2cfimp for the settings.

    But if your backup is on TSM, why not restore from there into a new database?

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    look up redirected restore. You can put backup of your database into a different database with a different name
    Dave

  4. #4
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    the createdb option for db2look was introduced in 10.5 fixpack 4. Not much use to the original poster but may be of interest to others

Posting Permissions

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