Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: db2empfa rollback

    Hi,

    We want to try turning ON db2empfa for multi page allocation.
    Is there any simple way to roll back this in case there is a problem?

    Thanks,
    toby

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Reading the FM:
    Following database creation, the parameter may be set to Yes which indicates that multipage file allocation is enabled. This is done using the db2empfa tool. Once set to Yes, the parameter cannot be changed back to No.

  3. #3
    Join Date
    Sep 2003
    Posts
    63
    Does that mean, restore of the database will roll back the db2empfa to NO?
    Is there any other way

    Thanks

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If the parameter was NO when the backup was done, then a restore (AS NEW) of the backup image will reset the parameter

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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