ufsmaint - User Field Storage Maintenance

The User Field Stoage Maintenance utility (ufsmaint) allows you to perform several corrective actions on user field storage, including switching to numeric sorting for numeric user field values, setting the overflow indicator for the inline user field storage buffer, and deleting orphan user field values.

ufsmaint [OPTIONS] dataarea [name ...]

ufsmaint [OPTIONS] --prodline prodline [name ...]

ufsmaint [OPTIONS] --tenant tenant [name ...]

ufsmaint [OPTIONS] --all [name ...]

Program Option Description
dataarea Apply user field storage changes to the specified data area.
--prodline prodline Apply user field storage changes to all active data areas of the product line.
--tenant tenant Apply user field storage changes to all active data areas of the tenant.
--all Apply user field storage changes to all active data areas.
-b or --brief Brief mode.
--disablenumericsort Disable numeric user field values for sorting. This option cannot be applied to specific business classes through the name option.
--enablenumericsort Enable numeric user field values for sorting. This option cannot be applied to specific business classes through the name option.
--gridstatus=ID Publish progress to grid. You can then use managegrid getprogress to see a list of all running programs, or you can use managegrid getprogress ID to see the status of this program. The value you specify for ID must be unique across the system for any programs being run with the gridstatus option.
--lazyload=VALUE Load repositories lazily. The option allows for the SpecRepository to load in a faster/lightweight manner. Valid values are true and false. The default is false.
--noconfigclear Do not fire configuration clear event. Using this option means the system will be out of sync. This is useful when a systemis off-line and these utilities are being used. In that case, the system will be restarted anyway and the cache for configurationdata will be automatically built upon access so processing the event is not needed.
--orphandelete Purge orphaned UserField_Storage records.
--orphanreport Report orphaned UserField_Storage records.
-q or --quiet Quiet mode (print only errors, do not print informational messages).
--removeoverflowindicator Remove overflow indicator from inline user field buffer.
--setoverflowindicator Set or fix overflow indicator in inline user field buffer
--showtotal Show total rows affected.
--threads=n Run ufsmaint with the specified number of threads. If you use multiple threads, you may see a performance improvement. However, performance depends on other factors as well. Note that a very large table will be processed in a single thread.
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.
-v displayoptions

errorlevel, tracelevel, and verbose specified in any order, where:

  • errorlevel = {n}none | {f}atal | {e}rror | {w}arning (warning is the default)

  • tracelevel = 0:6 where 0 is no message and 6 is everything

  • verbose = whether to display exception stacktrace