IBM Support

How do I process Sparse data objects Identified in the Audit

Question & Answer


How do I turn on sparse data object processing


After harvesting a volume, the audit may show "skipped - cannot
access data object", with a sparse data object message recorded in the details section.

To correct this problem, ensure that no jobs are running. SSH into the Data Server(s) and enter the following command at the prompt;

psql -U dfuser dfdata -c "insert into adminknobs (name,value,description,valuetype,use) VALUES ('read_sparse_files','1','Read sprase data objects','int','1')"

It should return the following;


if so, enter the following command and wait for the UI to come back up;

service siqinit restart

You can now run harvests as normal and sparse data objects will be processed. If your are using a policy which backs up the original files and just leaves a sparse file viewable that when accessed, will pull the original file forward, you may run into space issues. This is because SIQ will be accessing every sparse file, so the sparse files' size on disk will grow to the same size as the original file.

[{"Product":{"code":"SSSHEC","label":"StoredIQ"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"Platform","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":";;7.6","Edition":"All Editions"}]

Document Information

Modified date:
17 June 2018