pw dataview

The pw dataview command can create or drop views, generate the view data dictionary, and update the instance configuration data. It updates real-time instance information for use in external reports. Instance information is updated on a 24-hour basis as a part of daily jobs. This command prints all the data views (data dictionary) and their associated columns available for reporting.

The following pw dataview commands are available:

• pw dataview create [{-all| Monitor Unique name | Monitor Type Id}]

• pw dataview drop[{-all| Monitor Unique name | Monitor Type Id}]

  Note

  If Monitor Unique Name or Monitor Type Id is not provided, all monitors are used.

• pw dataview gendoc[{-all| Monitor Unique name | Monitor Type Id}]
• pw dataview update
  

  -all — Use this option to exercise command for all monitor types.

  Monitor Type Id — System-generated number for this type of monitor. Use the pw motypes list and search for the monitor type and obtain Monitor Type ID.

  Monitor Unique Name — Unique name for a particular monitor type

pw dataview create

The only time you need to use this command is when you create a custom monitor. If the specific monitor ID is not mentioned, it builds necessary information for all data views, including creating base table instanceinfo_cfg, and all views described in the earlier section. Data views are created during installation.

Examples: MetaAPI monitors and Monitor Wizard monitors.

To create a data view, run the following command:

pw dataveiw create [{-all | Monitor Unique Name | Monitor Type Id}]

Example: pw dataview create windows process monitor

This will create a data view for windows process monitor.

pw dataview drop

This option drops the schema generated by the Create option. The only time you need to use this option is when you modify a specific custom monitor definition.

To drop a schema, run the following command:

pw dataview drop[{-all | Monitor Unique Name | Monitor Type Id}]

Example: pw dataview drop windows process monitor

This will close all the open sessions that are using data views for the monitor type windows process.

pw dataview gendoc

Generates data dictionary, which contains the views that are created, columns available and descriptions about the value it contains, and the unit based on the metadata defined in the database at the time of creation. If you add custom monitors or upgrade the product version, you might want to regenerate the data dictionary, so it reflects updated information.

To generate a data dictionary, run the following command:

pw dataview gendoc[{-all | Monitor Unique Name | Monitor Type Id}]

Example: pw dataview gendoc -all

This will generate a data dictionary for all monitor types.

pw dataview update

Removes all entries in the instanceinfo_cfg table and populates the instanceinfo_cfg table with the latest configuration information. This table is updated as part of daily jobs, which by default are run at 3:30 A.M.

To update the table, run the following command:

pw dataview update

This updates the instance information for reports use.