Start of Content Area

Object documentation SAPDBA Files, Directories, and Reports  Locate the document in its SAP Library structure

Definition

The files, directories, and reports created by SAPDBA are listed in this section.

Note

You need to delete this data from time to time. For more information about deleting the data listed below, see SAPDBA Housekeeping.

Use

The following topics are described here:

Directories and Files from Reorganizations

SAPDBA creates directories and files when you reorganize indexes, tables and dbspaces. This includes all the actions under the following sub-menus of the Reorganization menu (including the corresponding Test Unloads):

The directories are held under the directory $INFORMIXDIR/sapreorg (UNIX) or %INFORMIXDIR%\sapreorg (NT) and are date and time stamped to enable you to tell the age of the data. SAPDBA creates the following kinds of directory for indexes and tables:

These are named as follows:

RI_<index name>_<date/time stamp>

RI_<table name>_<date/time stamp>

For example, the directory RI_affh_p_950601094502 refers to the reorganization of the index affh_p carried out on 1st June 1995 at 09:45:02.

These are named as follows:

DBS_REORG_<dbspace to reorganize>_<date/time stamp>

For example, DBS_REORG_psapload_960710165308

Procedure

Table Name

Example

Reorganize tables in dbspace by "alter fragment"

FRAG_<source dbspace name>_<date/time stamp>

FRAG_psapload_960710165308 .

Reorganize tables listed in file by "alter fragment"

FRAG_FILE_<date/time stamp>

FRAG_FILE_960710165308

Procedure

Table Name

Example

Reorganize single table by "insert into select from"

MOVE_<table name>_<date/time stamp>

MOVE_a014_960710165308 .

Reorganize tables in dbspace by "insert into select from"

MOVE_<source dbspace name>_<date/time stamp>

MOVE_psapload_960710165308

Reorganize tables listed in file by "insert into select from"

MOVE_FILE_<date/time stamp>

MOVE_FILE_960710165308

EXIM_<table name>_<date/time stamp>

For example, EXIM_a014_960710165308 . For a test run, the prefix is TEST instead of EXIM .

For more information about reorganizing groups of tables, see Reorganizing a Group of Tables with SAPDBA.

The files contained in these directories are prefixed with the index or table name to further assist you in case you need to be quite sure that they can safely be deleted. Once sure, you can delete all the files in these directories and then drop the directories themselves.

Directories and Files from Dbspace Actions

The following write to the dbspace.log file, which contains logging information about actions on dbspaces:

You can find the dbspace.log file in the directory $INFORMIXDIR/sapreorg (UNIX) or %INFORMIXDIR%\sapreorg (NT).

Directories and Files from Data Consistency Checks

The following generate directories and files:

The directories are held under $INFORMIXDIR/sapreorg (UNIX) or %INFORMIXDIR%\sapreorg (NT) and are date/time stamped to enable you to tell the age of the data. SAPDBA creates the following kinds of directory according to whether the action name starts with Check... or ‘ONCHECK’... :

CHECK_<object name>_<date/time stamp>

For example, a check of the table a014 on the 6th January 1997 at 14:24:03 would produce a directory called:

CHECK_a014_970106142403

For ‘ONCHECK -cI’ for all tables that contain ‘Blob’ Fields, the following directory is created:

ONCHECK_cI_BLOB_<date/time stamp>

For example, CHECK_cI_BLOB_970106142403 .

For the ‘ONCHECK -cD’ for all tables that contain ‘Blob’ Fields action, the names are the same except that "cD" appears instead of "cI".

The files contained in these directories are prefixed with the table name to further help you in case you need to be sure that they can safely be deleted. Once sure, you can delete all the files in these directories and then drop the directories themselves.

Download Files from "Export/Import" Reorganizations

Download files containing table data that is generated when you reorganize tables using the "Export/Import" method. See Reorganizing a Group of Tables with SAPDBA. You must delete the download file resulting from this procedure yourself.

Caution

Do not delete the download file unless you are sure it is no longer required. If you are not sure about whether or not to delete the download file after a SAPDBA operation has unexpectedly failed, contact the Informix hotline because otherwise you might lose database data.

The download files are located in the directory you specified for download path. For example, if you reorganize a table called a014 , SAPDBA produces a file called a014.uld000.Z . There are two exceptions to this naming scheme: first, small tables which are not compressed and so are downloaded to files without the . Z suffix; second, large tables (only with UNIX) are compressed into several files, numbered sequentially. For example: atab.uld000.Z , atab.uld001.Z , atab.uld002.Z and so on.

SAPDBA Recovery Report Files

When you produce a recovery report in SAPDBA, a file is generated. For more information about recovery reports, see Recovery Report with SAPDBA.

The recovery report feature is only available if your operating system is UNIX and you use ON-Archive for your archives and backups. You can find the reports in the directory $INFORMIXDIR/sapreorg/recover.rpt . The report name contains the date and time. For example:

1995.05.29_18:43:50_recover.rpt