No File System Caching

redwolf · #1 (**permalink**) 08-13-08, 15:14

Once you alter a tablespace with No File System Caching, how can you tell its in this mode ? I looked in the catalog but did not find anything to show it was in this mode.

UDB V8 FP15

Thanks

rangupt · #2 (**permalink**) 08-13-08, 15:29

A snapshot of the tablespace will get you that information. Or else if you are on V8 FP 9 and higher you could use the SNAP_GET_TBSP function to find that information.

n_i · #3 (**permalink**) 08-13-08, 15:31

Code:

db2 get snapshot for tablespaces on <database> | grep "File system caching"

or

Code:

db2pd -db <database> -tablespaces

(see the FSC column in the Tablespace Configuration section)

Internet Services

Web Development

Digital Marketing

Consumer Tech