Configuring the Tivoli Storage Productivity Center properties file

The Tivoli® Storage Productivity Center sensor uses SQL queries to extract data from the Tivoli Storage Productivity Center database. The SQL queries are defined in the tpc.config file and the execution of these queries is controlled by the properties defined in tpc.properties file.

The tpc.config and the tpc.properties are located in: COLLATION_HOME/osgi/plugins/com.ibm.cdb.discover.sensor.app.srm.tpc_xxx, where xxx is the sensor plugin version.

The sensor uses the following entries in the tpc.properties file to determine which queries to run:

com.ibm.cdb.discover.app.srm.tpc.sensor.ArrayQueries

This property is related to array resources. By default, the following queries are enabled: ARRAY,ARRAY_SUM_SOURCE,ARRAY_VOLUME_GROUP,ARRAY_DRIVE,ARRAY_PORT,ARRAY_VOLUME.

com.ibm.cdb.discover.app.srm.tpc.sensor.HostQueries

This property is related to host resources. By default, the following queries are enabled: HOST,HOST_PORT,HOST_DEVICE_GROUP,HOST_DEVICE,HOST_DEVICE_PARTITION,HOST_DEVICE_PARTITION_DEVICE,HOST_FS,HOST_FS_EXPORT,HOST_AGENT,HOST_SCSI_PATH,HOST_SCSI_AGENT_LESS.

HOST_SCSI_PATH query: This query is used to create an end-to-end storage mapping from FC volumes on a host to the volumes on a storage array. This query is enabled by default. Depending on how large the storage environment is, running this query can increase the discovery time of the sensor significantly. Hence, when discovering large storage environments, it is better to enable the HOST_SCSI_PATH query only occasionally. To disable this query, do not include the HOST_SCSI_PATH in the property: com.ibm.cdb.discover.app.srm.tpc.sensor.HostQueries.; For more information about editing the property, see Out-of-memory error when HOST_SCSI_PATH or HOST_SCSI_AGENT_LESS query is enabled.
HOST_SCSI_AGENT_LESS query: This query is used to create an end-to-end storage mapping from FC volumes on a host to the volumes on a storage array, when TPC SRA agents are not deployed to the endpoints. This query is enabled by default. Depending on how large the storage environment is, running this query can increase the discovery time of the sensor significantly. Hence, when discovering large storage environments, it is better to enable the HOST_SCSI_PATH query only occasionally. To disable this query, do not include the HOST_SCSI_PATH in the property: com.ibm.cdb.discover.app.srm.tpc.sensor.HostQueries.; For more information about editing the property, see Out-of-memory error when HOST_SCSI_PATH or HOST_SCSI_AGENT_LESS query is enabled.

The following example shows the com.ibm.cdb.discover.app.srm.tpc.sensor.HostQueries property with the HOST_SCSI_PATH and HOST_SCSI_AGENT_LESS queries disabled:
com.ibm.cdb.discover.app.srm.tpc.sensor.HostQueries=HOST,HOST_PORT, HOST_DEVICE_GROUP,HOST_DEVICE,HOST_DEVICE_PARTITION,HOST_DEVICE_PARTITION_DEVICE,HOST_FS,HOST_FS_EXPORT,HOST_AGENT.

com.ibm.cdb.discover.app.srm.tpc.sensor.FabricQueries

This property is related to fabric resources. By default, the following queries are enabled: FABRIC,ZONE_SET,ZONE.

com.ibm.cdb.discover.app.srm.tpc.sensor.SwitchQueries

This property is related to switch resources. By default, the following queries are enabled: SWITCH,SWITCH_PORT.

com.ibm.cdb.discover.app.srm.tpc.sensor.NASQueries

This property is related to NAS resources. By default, the following queries are enabled: NAS_FILER,NAS_CONTROLLER,NAS_VOLUME,NAS_FS,NAS_DEVICE,NAS_FS_EXPORT.

com.ibm.cdb.discover.app.srm.tpc.sensor.TapeQueries

This property is related to TAPE resources. By default, the following queries are enabled: TAPE_LIBRARY,TAPE_MEDIA_CHANGER,TAPE_DRIVE.

com.ibm.cdb.discover.app.srm.tpc.sensor.SummaryQueries

This property is related to SUMMARY resources. By default, the following query is enabled: PORT_CONNECTIVITY.

The following properties are used to control the discovery of certain types of computer systems by the IBM® Tivoli Storage Productivity Center sensor:

com.ibm.cdb.discover.app.srm.tpc.sensor.ignoreAixCompSys=true: This property determines whether the IBM Tivoli Storage Productivity Center sensor discovers computer systems on AIX® operating systems or not. By default, it is set to true which means that the sensor does not discover computer systems on AIX operating systems.

com.ibm.cdb.discover.app.srm.tpc.sensor.IgnoreCSWithoutMacaddr=true: This property determines whether the IBM Tivoli Storage Productivity Center sensor discovers computer systems without a MAC address. By default, it is set to true which means that the sensor does not discover computer systems without a MAC address.

The sensor uses the following entries in the collation.properties when HOST_SCSI_PATH or HOST_SCSI_AGENT_LESS query is enabled.

com.ibm.cdb.discover.app.srm.tpc.sensor.HOST_SCSI_PATH.maxrows: This property specifies the maximum number of rows that the sensor processes, when the HOST_SCSI_PATH query is enabled.; The default value is 20000.; If the HOST_SCSI_PATH query causes out-of-memory exceptions, decrease the default value. If you want to collect all the paths in one discovery run, depending on the storage environment, increase the default value.
com.ibm.cdb.discover.app.srm.tpc.sensor.HOST_SCSI_AGENT_LESS.maxrows: This property specifies the maximum number of rows that the sensor processes, when the HOST_SCSI_AGENT_LESS query is enabled.; The default value is 20000.; If the HOST_SCSI_PATH query causes out-of-memory exceptions, decrease the default value. If you want to collect all the paths in one discovery run, depending on the storage environment, increase the default value.