Previous Topic: Purge Entries From the Classification CacheNext Topic: CCS Log Files


Export Entries From Classification Cache

If necessary, you can export cache entries to .csv files for diagnostic purposes. For example, to diagnose problems with a particular classification you can import these files into a relational database. You can then perform custom queries on the data to identify documents with this classification.

CacheUtil exports entries to two .csv files:

identifiers_<timestamp>.csv

This file contains all content identifiers stored in the cache, plus a numerical key, the 'content modified' time, and the classification time.

classifications_<timestamp>.csv

This file contains the classifications for each content identifier in the cache.

Important! Export operations can adversely affect the classification cache performance. Also, export operations take a long time to complete on large classification caches. For these reasons, we strongly recommend that only run export operations during periods of low network activity. You must also temporarily disable the cache limits before you export cache entries.

Before you export cache entries

Before exporting cache entries, you must temporarily disable CA Directory cache limits. This allows the DSA to return more than the default of 200 entries.

  1. Locate this file:

    %DXHOME%\config\limits\default.dxc

    Where %DXHOME% is a Windows environment variable that specifies the path to the CA Directory installation folder. In a typical installation, this variable is set to:

    C:\Program Files\CA\Directory\dxserver

  2. Set the following settings:
    set max-op-size = none;
    set max-op-time = none;
    
  3. Restart the Cache DSA.

To export cache entries

  1. Go to the CCS \bin folder.
  2. Run the following command:
    CacheUtil -export [-page-size <n>] [-output <folder>]
    

    Where:

    -page-size <n>

    (Optional) Specifies the batch size for entries retrieved from the cache.

    If you omit this argument, CacheUtil retrieves data in batches of 1,000 cache entries. You do not normally need to set this argument. You only need to set this argument if instructed by CA technical staff.

    -output <folder>

    (Optional) Specifies the number of cache entries in each page of the exported .csv files.

    If you omit this argument, the .csv files are saved to the current folder. By default, this folder is the \bin subfolder of the CCS installation folder.

  3. Reset the CA Directory cache settings back to their original values (see 'Before you export cache entries' for details.)

Example

The following command sets the page size to 200 entries and stores the exported .csv files in C:\temp:

CacheUtil -export -page-size 200 -output "c:\temp"

More information:

About CacheUtil.exe