SQL$HELP72.HLB  —  CREATE  DATABASE  Arguments  PRESTARTED_TRANSACTIONS
    Syntax options:

       PRESTARTED TRANSACTIONS ARE ENABLED
       PRESTARTED TRANSACTIONS ARE DISABLED

    Enables or disables the prestarting of transactions.

    Note that the keyword ON, available in previous versions, is
    synonymous with ENABLED, and the OFF keyword is synonymous with
    the DISABLED keyword.

    This clause is used to establish a permanent database setting for
    prestarted transactions. In prior versions, this clause was only
    used to temporarily set the mode for prestarted transaction for
    the implicit attach performed by the CREATE DATABASE and IMPORT
    DATABASE statements.

    The prestart-trans-options can be one of the following clauses:

    o  WAIT n SECONDS FOR TIMEOUT

       The n represents the number of seconds to wait before
       aborting the prestarted transaction. Timing out the prestarted
       transaction may prevent snapshot file growth in environments
       where servers stay attached to the database with long periods
       of inactivity.

    o  WAIT n MINUTES FOR TIMEOUT

       The n represents the number of minutes to wait before aborting
       the prestarted transaction.

    o  NO TIMEOUT

       This is the default for a prestarted transaction.

    Syntax options:

    PRESTARTED TRANSACTIONS ARE ON | PRESTARTED TRANSACTIONS ARE OFF
Close Help