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

gabrielatme · #1 (**permalink**) 05-22-09, 13:13

Hi,

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

Thanks

Marcus_A · #2 (**permalink**) 05-22-09, 15:03

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.

ARWinner · #3 (**permalink**) 05-22-09, 15:15

You can do

Code:

db2pd -d MyDB -storagepaths

Andy

db2girl · #4 (**permalink**) 05-22-09, 18:51

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

Internet Services

Web Development

Digital Marketing

Consumer Tech