- 论坛徽章:
- 6
|
如果是ase15.0的话, 有个函数tran_dumpable_status()
-----------------------------------------------------------------------------------
tran_dumpable_status
Description
Returns a true/false indication of whether dump transaction is allowed.
Syntax
tran_dumpable_status("database_name")
Parameters
database_name
is the name of the target database.
Examples
Example 1
Checks to see if the pubs2 database can be dumped:
1> select tran_dumpable_status("pubs2")
2> go
-----------
106
(1 row affected)
In this example, you cannot dump pubs2. The return code of 106 is a sum of all the conditions met (2, 8, 32, 64). See the Usage section for a description of the return codes.
Usage
tran_dumpable_status allows you to determine if dump transaction is allowed on a database without having to run the command. tran_dumpable_status performs all of the checks that Adaptive Server performs when dump transaction is issued.
If tran_dumpable_status returns 0, you can perform the dump transaction command on the database. If it returns any other value, it cannot. The non-0 values are:
*
1 – A database with the name you specified does not exist.
*
2 – A log does not exist on a separate device.
*
4 – The log first page is in the bounds of a data-only disk fragment.
*
8 – the trunc log on chkpt option is set for the database.
*
16 – Non-logged writes have occurred on the database.
*
32 – Truncate-only dump tran has interrupted any coherent sequence of dumps to dump devices.
*
64 – Database is newly created or upgraded. Transaction log may not be dumped until a dump database has been performed. |
|