Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005

    Unanswered: Multiple file allocation

    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?

    DB2 UDB v8.2
    OS: Windows

    Will appreciate ur help....

  2. #2
    Join Date
    Mar 2003
    db2 get db cfg for <dbname>

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

Posting Permissions

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