Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008
    Posts
    14

    Unanswered: How I can discover if a database it is AUTOMATIC STORAGE YES or NO ?

    Hi,

    How I can discover if a database it is AUTOMATIC STORAGE YES or NO ?

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Do a snapshot of the tablespace (see Command Reference manual). Unfortunately, I don't believe that the info is in the snapshot table function for tablespaces.
    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
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You can do
    Code:
    db2pd -d MyDB -storagepaths
    Andy

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    another way is a db snapshot, but db2pd is the best one to use

    db2 get snapshot for db on <db_name> | grep -i automatic

Posting Permissions

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