Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    38

    Unanswered: View Creation Time

    Is there is any way thru which I can find out the time in which a view was created? I tried in syscat.views, sysibm.views but its not listed there.

    Thanks, Vij.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I haven't checked to be sure, but views are listed in syscat.tables, where I assume you can find the creation date.
    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
    Dec 2005
    Posts
    273
    Yes, it's in SYSCAT.TABLES - column name is: CREATE_TIME ( timestamp )

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    And to be 100% sure, remember to check the type, TYPE='V'

    Cheers
    Sathyaram

    Quote Originally Posted by umayer
    Yes, it's in SYSCAT.TABLES - column name is: CREATE_TIME ( timestamp )
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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