dblobsizes - Database LOB Size

dblobsizes [-s size] [-S suffix] [-k] dataArea [name ...]

dblobsizes enables you to find the size of LOB files within a data area.

Program Options	Description
-s size or --minsize=N	Check for LOBs greater than this size. The size is in bytes unless you use the -S opton.
S suffix	Set the size suffix. Valid values are K, M, and G for KB, MB, and GB, respectively.
k or --keys	Dump the keys for the LOBs. You must specify the size parameter with this option.
dataArea	The data area you want to check LOB sizes in.
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.

Sample output using the "dump keys" option

c:\sandboxes\ricepark\univ>dblobsizes -s 100 -S K -k lmhcm Resume

Resume
  Key Fields(Applicant)
  Lobs over 100K
        Keys: ABCDEFGHI JKLMNOPQR 131   FieldName: RESUMEDOC    Size: 287744
        Keys: ABCDEFGHI JKLMNOPQR 168   FieldName: RESUMEDOC    Size: 159232
        Keys: ABCDEFGHI JKLMNOPQR 59    FieldName: RESUMEDOC    Size: 364796
        Keys: ABCDEFGHI JKLMNOPQR 6     FieldName: RESUMEDOC    Size: 113625
        Keys: ABCDEFGHI JKLMNOPQR 67    FieldName: RESUMEDOC    Size: 104960
  Totals:
        RESUMEDOC = 5