Results 1 to 5 of 5

Thread: system tables

  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: system tables

    hi

    Alter a table like adding a column increase the size of datatype is stored in system tables,
    kindly suggest
    regds
    paul

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Not sure what you are asking, but if you alter a table to add a new column to a table, a row will be inserted into the sysibm.syscolumns catalog table (better to view it via syscat.columns view if using DB2 LUW). There may be some other rows added to the DB2 catalog if you do a certain kind of runstats or if you create any indexes, constraints, FK's etc on the new column.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    marcus

    i have a sql replication of db whenever there is changes in structure in source ex: column addition etc same has to be done in target means drop and recreate the table,
    there are lot of changes in different tables in source to bring same structure in target
    want to know which all tables was modified recently in source.
    regds
    Paul

  4. #4
    Join Date
    Oct 2007
    Posts
    246
    any way to find out when the table ddl was modified

    regds
    Paul

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I would track the ALTER_TIME value for each table in the DB2 catalog.
    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
  •