Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    62

    Unanswered: Do db2 logs include DDL statements ?

    Hi,

    Do db2 logs include DDL statements ?
    For example like "create table", "drop table" and etc.

    thanks
    Vilius

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Yes, the create and drop objects are logged..

    But not sure whether the ascii "create table " text is stored in DDL format
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    No, it is not - there is no reason to do so. The changes to the catalog tables are logged, and from the catalog you could reconstruct the CREATE TABLE statement (and "db2look" does exactly that). The only thing you loose are information where defaults were used.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Knut,
    The only thing you loose are information where defaults were used
    Like Tablespace name, if not explicitly specified ?

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Yes, things like that.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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