Syntax

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Other Data Restore Utilities > Restoring Table-level Data > Using the archecker Utility to Restore Data >

Syntax

>>-archecker---------------------------------------------------->
 
>--+-+-+- -b------+--| Table-Level Restore |--+-----+--+---------------------+-+--+-----+--+-----+-+-><
   | | |     (1)  |                           '- -d-'  |                (2)  | |  '- -v-'  '- -s-' |
   | | '- -t------'                                    '- -Z--page_size------' |                   |
   | +- -D---------------------------------------------------------------------+                   |
   | '- -i---------------------------------------------------------------------'                   |
   '- -V-------------------------------------------------------------------------------------------'
 
Table-Level Restore:
 
|--+----------------------------------------------------+-------|
   '- -X--+-------------------------------------------+-'
          +-+---------------+--+--------------------+-+
          | '- -f--cmd_file-'  |      .-,---------. | |
          |                    |      V           | | |
          |                    '- -l----+-phys--+-+-' |
          |                             +-stage-+     |
          |                             '-apply-'     |
          '- -D---------------------------------------'

Notes:

Dynamic Server Only
Extended Parallel Server Only

Element	Description
-b	Provides direct XBSA access.
-d	Deletes previous archecker restore files, except the archecker message log.
-D	Deletes previous archecker restore files, except the archecker message log, and then exits. The -D option can be used with the -X option to delete previous restore files plus any table-level-restore working tables in the sysutils database.
-f cmdfile	Specifies that archecker use the command file specified by cmdfile. This option overrides the value of the AC_SCHEMA configuration parameter. For more information, see The archecker Schema Command File.
-i	Manually initializes the system.
-l phys,stage,apply	Specifies the level of logical restore: phys: Starts a logical restore of the system, but stops after physical recovery is complete. stage: After physical recovery is complete, extracts the logical logs from the storage manager and stages them in their corresponding tables, and starts the stager. apply: Starts the applier. The applier takes the transactions stored in the stage tables and converts them to SQL and replays the operations. The default level of logical restore if -l is not listed is -lphys,stage,apply. You can specify any combination of the logical restore levels, separated with commas. Spaces are not allowed between -l and levels. For more information, see Manually Controlling a Logical Restore.
-s	Prints a status message to the screen.
-t	Specifies ontape as the backup utility for Dynamic Server only.
-v	Specifies verbose mode.
-V	Displays archecker version information.
-X	Specifies a table-level restore.
-Z page_size	Specifies the page size used by the database server: 2, 4, or 8. This option overrides the value of the AC_PAGESIZE configuration parameter. For more information, see AC_PAGESIZE (XPS).