utilities

These utilities are the easiest way to get information about what your instance is doing.

They are fast and simple to use, providing options to filter and order the output.

list of utilities

utility description
infx alert List SQL task scheduler alerts
infx all List status of each instance on this host
infx cdr List status of connected CDR servers
infx checkpoint List the recent checkpoint tracing times
infx chunks List information about instance chunk files
infx cmap List information about storage allocation within chunks
infx dbs List information about the databases in this instance
infx dbspace List information about the storage spaces in this instance
infx dri List information about connected HDR/SDS/RSS servers
infx fs List information about file systems on this host
infx hist List the history of service execution in this instance
infx list List the status of each instance on this host
infx running List the infx services that are running on this host
infx sched List the task scheduler information
infx service
List the status of the latest execution of each service
infx spool List information about storage pool entries
infx users List information about users connected to the instance
You can list the available command line utilities using the infx alias command.

ordering

All utilities accept the order parameter. Simply pass the name of a column and the utilities output will be ordered by that column.

The first column header in the table (from the left), that matches the order parameter will be selected to order by. The default order is descending, rows with lower values are last. To reverse this, specify a “-” in front of the column name.

Standard command.

Change the order so the space with the most amount of writes is listed first.

Change the order so the space with the least amount free listed first.

In the above example, if you specify order=used, it orders by the “used mb” column, Specify order=used% to order by the percentage instead.

filtering

You can also filter the output based on any of the columns.

Only show storage spaces with “smart” in their name.

The pattern matching is performed case in-sensitive.

Enclose the parameter in quotes (“) if you need to use special characters, such as *.

You can match multiple patterns, separating them with a comma.

The filtering and ordering is performed as a function of the template, see the template reference for more details.

modified output

These command line utilities each have their own output template.

The templates are stored in /infx/template/infx-cli, and you can customize the output by modifying the template.

Always copy the template from /infx/template/infx-cli to /infx/local/template and change the local copy.

Here is a list of utilities and template names.

utility template
infx alert infx-cli-alert.htmlt
infx all infx-cli-list.htmlt
infx cdr infx-cli-cdr.htmlt
infx checkpoint infx-cli-ckps.htmlt
infx chunks infx-cli-chunk.htmlt
infx cmap infx-cli-cmap.htmlt
infx dbs infx-cli-dbs.htmlt
infx dbspace infx-cli-dbspace.htmlt
infx dri infx-cli-dri.htmlt
infx fs infx-cli-fs.htmlt
infx hist infx-cli-hist.htmlt
infx list infx-cli-list.htmlt
infx running infx-cli-running.htmlt
infx sched infx-cli-sched.htmlt
infx service
infx-cli-service.htmlt
infx spool infx-cli-spool.htmlt
infx users infx-cli-users.htmlt

For example, to modify the infx status command output, first make a local copy of it.

cp /infx/template/<wbr>infx-cli/infx-cli-status.htmlt /infx/local/<wbr>template/cli

Now when you execute infx status, the output will be based on the local template.

Any template under the /infx/local/template directory tree will be used in place of the template from /infx/template.