Results 1 to 2 of 2

Thread: db2look error

  1. #1
    Join Date
    Sep 2007
    Posts
    27

    Unhappy Unanswered: db2look error

    Hi all,

    I am using db2look to extract DDL for all the tables along with authorization DDL. The problem I am facing is that db2look is generating "CREATE TABLE" DDL for almost all the tables I have but not all. Although I am getting authorization DDL for tables whose "CREATE TABLE" DDLs were not generated.

    I used the following statement:-

    db2look -d BOSS -u bossadmin -e -f -o ddl.sql

    I am not sure why this is happening. I have more than 700 tables.

    Can any one explain what is causing the problem and how I can get all the DDLs.

    Thanks a lot,
    Dev

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You are specifying the table creator ID. Is there a chance that some tables have other creator than 'BOSSADMIN'?
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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