Results 1 to 3 of 3

Thread: db2look

  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: db2look

    I need to capture tablespace ddl and table ddl seperately from production database? does anyone know how to do it using db2look?

    Thanks in advance
    toby

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Yes probably

    Please post OS and Version

    If you're on AIX/Unix/Linux
    type: 'db2look' and you will
    get an exhaustive listing of
    options that will allow you to
    specify your output.

    BOW
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    db2look -d DBname -e -x -o outputfile


    this will give all tables,index,views,alias,grants.


    for only tablespaces


    use this , to get DDl for BPs;Tablespaces

    db2look -d DBname -l -o outputfilename


    if you want only DB & DBM cfg

    use this

    db2look -d DBname -f -o outputfilename


    Hope this will help you


    Lekharaju Ennam
    Certified Oracle8i & DB2 UDB DBA

Posting Permissions

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