SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  SHUTDOWN_TIME
    Syntax option:

    SHUTDOWN TIME IS n MINUTES

    Specifies the number of minutes the database system will wait
    after a catastrophic event before it shuts down the database.
    The shutdown time is the period, in minutes, between the point
    when the after-image journaling subsystem becomes unavailable
    and the point when the database is shut down. During the after-
    image journaling shutdown period, all database update activity is
    stalled.

    If notification is enabled with the NOTIFY IS clause, operator
    messages will be broadcast to all enabled operator classes.

    To recover from the after-image journaling shutdown state and
    to resume normal database operations, you must make an .aij file
    available for use. You can do this by backing up an existing
    modified journal file, or, if you have a journal file reservation
    available, by adding a new journal file to the after-image
    journaling subsystem. If you do not make a journal file available
    before the after-image journal shutdown time expires, the
    database will be shut down and all active database attachments
    will be terminated.

    The after-image journaling shutdown period is only in effect when
    a fixed-size .aij file is used. When a single extensible .aij
    file is used, the default action is to shut down all database
    operations when the .aij file becomes unavailable.

    The default is 60 minutes. The minimum value is 1 minute; the
    maximum value is 4320 minutes (3 days).
Close Help