Input File for Reorganizing Groups of Tables with SAPDBA (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Input File for Reorganizing Groups of Tables with SAPDBA

Definition

The input file tells SAPDBA the tables to reorganize and how to perform the reorganization.

Use

When you reorganize a group of tables with SAPDBA for Informix, you can use an input file to specify the tables and parameters for the reorganization. This is relevant to the following SAPDBA reorganization options:

Tables Listed in File by 'alter fragment …'

Tables Listed in File by 'insert into select from …'

For more information, see Reorganizing a Group of Tables with SAPDBA.

The input file contains a list of tables to be reorganized and the parameter target dbspace. To set up your input file correctly, observe the following points:

If you enter no input parameters other than the table name, SAPDBA reorganizes the table to the same dbspace as at the start of processing.

The following is an example of how to specify the target dbspace:

target_dbspace: psapsource

Input parameters can be of the following types:

The default dbspace applies to all tables listed after it is specified, until another default dbspace is given. For example:

default: target_dbspace: psapsource

A specific parameter relates only to a single table ( dd14s in this example). It overrides the current default dbspace parameter. For example:

dd14s next_extent: 15

List the tables you want to reorganize, observing the previous points about input parameters.

An example of some entries in a typical input file is given below:

Note

This example is for the "insert into select from" method. If you are using the "alter fragment" method, you can only use the target_dbspace parameter.

default: lock_mode: page
default: target_dbspace: psapddic
dd02mss
dd02syb
verpf
verpf2 lock_mode: row
dd10l
default: target_dbspace: paspsource
dd15t
ddacl
ddntf
ddntt next_extent: 25
ignss
default: lock_mode: row
macid
macob first_extent: 45
svers
tdi01 target_dbsp
SAPDBA checks the syntax of this file before processing starts so there is no problem with misspelt entries.

Copyright

Disclaimer

Privacy Statement

Legal Disclosure

Trademark

Terms of Use