Return
-
Title
Foglight repository query is producing a lot of user I/O -
Description
The query below seems to be generating a lot of user I/O:
"update persistence_storage_config_xml set pscx_version=:1 , pscx_xml=:2 where pscx_id=:3 and pscx_version=:4"
What is this query and is it normal for it to run?
-
Resolution
This query updates the storage config stored in the data base. The persistense_storage_config_xml table stores the current storage configuration of the FMS. This includes information like what tables are assigned to what time slices, whether or not those time slices have been rolled up and what table spaces have been configured etc.
It is normal that this query is producing user I/O. There is no need to be concerned.