Solaris clustered server: Running a task to automatically setup SQL Server databases

This topic provides instructions on automatically setting up your database using the ConfigEngine task. As an alternative to automatically setting up the database, you can manually create users and grant privileges.

Before you begin

Before you begin, ensure that the following prerequisites are met:
  • The database management system software is installed.

Procedure

  1. Change to the directory wp_profile_root/ConfigEngine
  2. To create the databases, type the following command:
    • ./ConfigEngine.sh create-database -DWasPassword=password
  3. To create the database users, type the following command:
    Note: The task setup-database assigns the minimum database privileges to the database configuration and runtime database users.
    • ./ConfigEngine.sh setup-database -DWasPassword=password
    Note: This task will automatically create the necessary users, permissions, and table spaces.

What to do next

Important: After setting up your databases, enable the autogrowth feature for the log associated with the JCR database. This will ensure that uploading large files (approximately 100 MB or larger) to Web Content Manager works properly.
  1. Start the Microsoft SQL Server Management Studio.
  2. Expand the Databases folder.
  3. Right-click on the JCR database and select Properties.
  4. Click Files.
  5. Locate the database log row and click the details button (...) located immediately after the Autogrowth field.
  6. Check the Enable Autogrowth check box and set the autogrowth properties as needed. When using Restricted File Growth, set the value to at least 100 MB.
  7. Click OK to save your changes to the Change Autogrowth screen.
  8. Click OK to save your changes to the Database Properties screen.
  9. Exit the Microsoft SQL Server Management Studio.