Suspending and resuming DDF server activity

You can use the suspend distributed data facility (DDF) server threads temporarily and resume suspended distributed data facility (DDF) server activity.

About this task

Begin general-use programming interface information.Suspending DDF server threads frees all resources that are held by the server threads and lets the following operations complete:

  • CREATE
  • ALTER
  • DROP
  • GRANT
  • REVOKE

Procedure

  1. To suspend distributed data facility (DDF) server threads temporarily. issue the following command: 
    STOP DFF MODE(SUSPEND)
    Db2 waits for all active DDF database access threads to become pooled or to terminate. You can use the optional WAIT and CANCEL keywords, to control how long Db2 waits and what action Db2 takes after a specified time period.
  2. To resume the suspended DDF server threads, issue a START DDF command.