dbcount - Count Database Table Rows

dbcount [OPTIONS] dataarea [name]

dbcount [OPTIONS] --prodline prodLine [name]

dbcount [OPTIONS] --tenant tenant [name]

dbcount [OPTIONS] --all [name]

dbcount counts the number of rows in a database table.

Program Option Description
--prodline prodLine Display counts for all active data areas of the product line.
--tenant tenant Display counts for all active data areas of the tenant.
-all Display counts for all active data areas.
-f filter or --filter=filterString Specify a filter to determine which records to count.
--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.
-i setName or --index=setName The index set name to use.
-n Show only files with non-zero counts.
--showtotal Show the total rows for all tables checked.
--showdataarea Print the data area name.
--threads=count

Maximum active threads for processing, for example, --threads=3. 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.

The default number of threads is four.
--useupgradenames Use the upgrade names for tables. Only use if directed to by support personnel.
dataarea Specify a data area that you want to count rows for.
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