Results 1 to 4 of 4

Thread: db2look

  1. #1
    Join Date
    Jun 2009
    Posts
    272

    Unanswered: db2look

    Is there any way to extract the DDL of the existing wrapper on the database ?

    I know we can do it by running db2look -d dbname -wrapper and grep for the create wrapper or create server statement but because db2look with -wrapper option is returning the DDL for all its federated objects, the box is going out of memory. So I need a workaround to extract the DDL of just the wrapper/server create statements. Any help would be appreciated.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Not sure what you mean by "going out of memory". If you are concerned about the disk space, you can pipe db2look output directly through grep, without writing the script to disk.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The only other alternatives would be to find some other tool (if there are any) or to piece together the statements based on the DB2 catalog tables. That's what db2look is doing as well.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jun 2009
    Posts
    272
    Thanks stolze

Posting Permissions

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