Recommendations for Symantec Control Compliance Suite (CCS) v11.0 database creation

Article:TECH195669  |  Created: 2012-08-27  |  Updated: 2012-08-27  |  Article URL http://www.symantec.com/docs/TECH195669
Article Type
Technical Solution


Subject

Issue



A Control Compliance Suite (CCS) user can choose to create the CSM_DB and the CSM_Reports databases manually rather than let the product create the databases. This document will cover certain dos and don’ts for manual database creation.

 

When a database is created by the installer the database is a copy of the model database with some exceptions.


Environment



Following are the considerations for manual database creation:

 

·         Support for custom database names does not exist.

·         The default file group of the CCS databases must be PRIMARY.

o   CCS continues to use the PRIMARY file group even if the default file group on the CCS databases is set to a user defined file group.

·         For manually created databases, the Application Server Service account must have the DBO privilege on CSM_DB and CSM_Reports. No SYSADMIN privilege is required once the databases are created.

·         Initial database size of 1024 MB is recommended for both CSM_DB and CSM_Reports.

·         The growth of the databases is based on the following factors

o   Number of assets in the system

o   Frequency of evaluation of standards against assets

o   Evaluation results

o   Purge criteria

Indicative scaling guidelines for the CCS databases can be found in the Online Help.

 

Best practices around database growth settings can be found at

http://www.symantec.com/business/support/index?page=content&id=HOWTO60732&actp=search&viewlocale=en_US&searchid=1343286323305

 

·         If the user wishes to have multiple database files, it is recommended that addition of the same is done post the installation of the product.


Solution



Post installation properties of CSM_DB (Production Database)

 

·         Recovery model of CSM_DB is set to Full.

·         CSM_DB has two file groups

o   PRIMARY (Default)

§  Autogrowth – 1 MB, unrestricted

o   CCS_QUERIES – Used to store Queries data.

§  Initial Size – 50 MB

§  Autogrowth – 10%, unrestricted

 

 

Post installation properties of CSM_Reports (Reporting Database)

 

Following are the database properties post installation:

 

·         Recovery model of CSM_DB is explicitly set to Simple.

·         CSM_Reports has two file groups

o   PRIMARY (Default)

§  Autogrowth – 1 MB, unrestricted

o   CSM_Reports_EvidenceStorage_%DATE% – Used to store Evidence data.

§  Initial Size – 100 MB

§  Autogrowth – 100%, unrestricted





Article URL http://www.symantec.com/docs/TECH195669


Terms of use for this information are found in Legal Notices