You can create an archive database by issuing the create archive database command. The syntax is:
create archive database <db name> [on <db device> [= <size>] [, <db device> [= <size>] ] ... ] with scratch_database = <db name>
where:
on – specifies the modified pages section. Adaptive Server requires traditional database storage to store modified pages. Use the on clause to specify the location and size of the modified pages section.
db device – specifies the database device on which you want to create your modified pages section.
size – specifies the size of the modified pages section you want to create. If size is omitted, 5120 pages are allocated.
with scratch_database – (required) specifies the name of an existing database in which information about the archive database is maintained. The sysaltusages system table, which maps every logical page in the archive database onto a physical page, is stored in the scratch database.
