Displays information about the degree of fragmentation for each LOB in a database.

Syntax

proutil db-name -C lobanalys [ area area-name ]
     [ tenant tenant-name | group group-name | shared ]
     [-csoutput [ -fieldsep sep-value ] [ -csfilePrefix pref-name ] 
           [ -verbose ] [ -help ] [ -RO ]]

Parameters

db-name
Specifies the database to display information.
area area-name
Specifies that LOBANALYS is to be performed on the area-name area only.
tenant tenant-name
Specifies that LOBANALYS is to be filtered to only provide information related to LOB objects that are owned by tenant-name. If tenant-name is not valid, LOBANALYS exits with an error. Specifying tenant is only allowed on databases enabled for multi-tenancy.
group group-name
Specifies that LOBANALYS is to be filtered to only provide information related to objects that are owned by group-name. If group-name is not valid, LOBANALYS exits with an error. Specifying group is only allowed on databases enabled for multi-tenancy.
shared
Specifies that LOBANALYS is to be filtered to only provide information related to shared objects. Specifying shared is only allowed on databases enabled for multi-tenancy.
-csoutput

Specifies that LOBANALYS output the analysis data to text files in addition to the screen. The result is that the following files are created:

  • db-name .block.txt — For block analysis output
  • db-name .lob.txt — For LOB analysis output

If you specify an area, LOBANALYS appends the area number to the file name, for example, block analysis output for the sports2020 database in area 20 would be sports2020.block_20.txt.

If the file already exists, it is overwritten. To avoid file overwriting, you can use the -csfilePrefix argument to customize the first part of the file name, which is db-name by default. See Database analysis output.

-fieldsep sep-value
When -csoutput is specified, sep-value indicates the value to separate the columns of output. A space is used by default. Accepted values for sep-value are:
  • Any ASCII character between 0x21 and 0x7E
  • sp — to denote a space (the default)
  • tab — to denote a the TAB character (<\t> or ASCII character 0x09)
-csfilePrefix pref-name
When you specify -csoutput, pref-name indicates a file name prefix. The database name is used by default. All remaining elements of the file name are not customizable.
-verbose

When -csoutput is specified, the first row of the output files contains header names for each column of output.

The column headers are "Time Stamp" "DBUID" "DB name" "Area" "Area #" “Partition Type” “Tenancy” “Tenancy #” “Partition Policy” "Partition" "Partition #" "Owner" "Table" "Table #" "Lob" “LOB #” "Size" "Min" "Max" "Mean".

-help
Displays syntax for utility and specified subcommands. If the syntax displayed ends with ellipses, type the command shown followed by -help to view subcommand syntax.
-RO
Runs the utility in read-only mode. Use read-only mode to connect to databases on read-only media or to diagnose and repair issues on a stopped database before starting it. Read-only mode allows any number of connections at once, up to the maximum number of connections. You may run multiple diagnostic utilities concurrently, while the database broker is down, if they all support read-only connection and you run them in read-only mode. This reduces bottlenecks and expedites disaster recovery on large databases.
Note: Use -RO with caution because it is designed to work only with a read-only connection. Unexpected errors may result if you specify -RO when using a single-user or multi-user connection.

Output format

In a complete report where no optional elements are specified on the command line, shared objects (both partitioned and non-partitioned) appear in alphabetical order by name. Partitions of partitioned tables are ordered as follows: the initial partition, then the remainder of the partitions in alphabetical order by partition name.

Example

The following output is a sample display of PROUTIL LOBANALYS run on a multi-tenant database:

LOB SUMMARY FOR AREA mtArea4: 23


LOB SUMMARY FOR SHARED TABLES:                                    
----------------------------------------------


                                                               ---    LOB Size   ---
Table                                       LOBs     Size      Min      Max     Mean
PUB.BLOBTABLE:7
    BLOBFIELD:13                             800   391.4K     2.0B  1000.0B   501.0B
                                 -----------------------------------------------------------------------------
Subtotals:                                   800   391.4K     2.0B  1000.0B   501.0B



LOB SUMMARY FOR TENANT MT_Tenant2: 2
--------------------------------------------------


                                                               ---    LOB Size   ---
Table                                       LOBs     Size      Min      Max     Mean
PUB.mtCustomer:6
    CustBlob1:10                               0     0.0B     0.0B     0.0B     0.0B
    CustBlob2:11                               0     0.0B     0.0B     0.0B     0.0B
    CustClob1:12                               0     0.0B     0.0B     0.0B     0.0B
PUB.mtInvoice:2
    InvBlob1:7                               400    10.2M     1.0B   976.6K    26.1K
    InvBlob2:8                               400   129.2M     1.0B   976.6K   330.6K
    InvClob1:9                               400    11.0M     1.0B   976.6K    28.1K
                                 -----------------------------------------------------------------------------
Subtotals:                                  1200   150.3M     1.0B   976.6K   128.3K

Summary for AREA "mtArea4": 23
                                 -----------------------------------------------------------------------------
Subtotals:                                  2000   150.7M     1.0B   976.6K    77.2K
Table
Table owner and table name.
LOBs
Total number of large object values in the database for the table.
Size
Total number of bytes used in the database for the LOB..
Min
Minimum number of bytes used by any record for the table.
Max
Maximum number of bytes used by any record for the table.
Mean
Mean number of bytes used by any record for the table.

Notes

  • You can run this utility using a read-only connection. You may run multiple diagnostic utilities concurrently, while the database broker is down, if they all support read-only connection and you run them in read-only mode. To run it in read-only mode, append -RO to the utility start command.
  • The PROUTIL DBANALYS display includes the information displayed by PROUTIL LOBANALYS.
  • See Manage Performance for more information about database fragmentation.