dbmaint - Database maintenance

dbmaint [OPTIONS] dataarea [name]

dbmaint performs administrative tasks on the database for a data area.

Program Option Description
-U or --update Perform actions on database.
-q or --quiet Do not print DDL to stdout.
Y or --YES Assume Yes for any prompts.
-c or --create Create files and indexes for the specified data area.
-d or --drop Delete files and indexes from the specified data area.
-r or --rebuild Recreate (drop and create) selected database objects.
-S or --subsetswitches Fix the subset switches for conditional indexes in the specified data area.
-L or --supplementalindexes Create or delete Landmark supplemental indexes.
-T or --tables Create or delete tables in the specified data area.
--alterlobstorage (Oracle only) Alter LOB storage attributes.
--movelobstorage (Oracle only) Move LOB storage.
-I (uppercase i) or --indexes Create or delete indexes in the specified data area.
--primaryonly Affect the primary index only.
--excludeprimary Do not affect the primary index.
--excludetext Do not affect text indexes.
--indexname=NAME Name of the index to be processed (can be repeated).
-E or --textonly Affect text indexes only.
--noSyncText (Oracle only) Create text indexes but delay the start of synchronization or population of the text indexes by thirty minutes. This matches the behavior of dbreorg and allows the text creation to finish more quickly.
--syncTextOnly (Oracle only) Perform the text index synchronization immediately rather than waiting the default thirty minutes.
-t dbType or --dbtype=TYPE Set the database type.
-O or --selectonly Select only files of specified type .
-V or --includeviews Include isView objects.
--splitTable=OPTION Control whether to include/exclude split table objects. OPTION can be BASE_ONLY, SPLIT_ONLY, or DEFAULT. This option is ignored for tables that are not split.
--showdataarea Print data area name.
--useupgradenames Use the upgrade names for tables. Only use if directed to by support personnel.
dataarea The data area to affect through dbmaint.
name

A list of names of dictionary files, business classes, modules, database spaces, or business class patterns to execute the command against.

Use the prefixes file-, pattern-, space-, or module- to resolve ambiguity. Use prefix- and type- to select files by prefix name or types used. File names can be the long or classic name and can include ? and *. Specifying "!" anywhere in the list will complement the selected files. Specifying @path reads names from the file, one per line. A hyphen ( - ) indicates stdin. Wildcard characters may need to be quoted in the command line or they will be interpreted by the command processor. A :L on a file name selects the lobs table. A :B on a file name selects the base table.