Hi All,

I have couple of questions:

1. I know this for sure that I can enable the multiple file allocation for SMS tablespaces by using db2empfa, but how do I check that its already been enabled or not. Also if db2empfa is enabled how do i get to know if temp tablespaces are available for each page size?

2. How do I check what capacity of OS file system; SMS tablespaces are using.

3. How do I check the encryption, if any?

ENV:
DB2 UDB v8.2
OS: Windows

Will appreciate ur help....

db2 get db cfg for <dbname>

If
Multi-page file allocation enabled = Yes
then empfa is enabled.