AIX clustered server: Run a task to automatically setup SQL server databsaes

This topic provides instructions on automatically setting up 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, ensure that the following prerequisites are met:

  1. Change to the directory WP_PROFILE/ConfigEngine

  2. To create the databases, type the following command:

      ./ConfigEngine.sh create-database -DWasPassword=foo

  3. To create the database users, type the following command:

      The task setup-database assigns the minimum database privileges to the database configuration and runtime database users.

        ./ConfigEngine.sh setup-database -DWasPassword=foo


      This task will automatically create the necessary users, permissions, and table spaces.

After setting up 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 changes to the Change Autogrowth screen.

  8. Click OK to save changes to the Database Properties screen.

  9. Exit the Microsoft SQL Server Management Studio.


Parent

AIX clustered server: Set up SQL Server automatically

 


+

Search Tips   |   Advanced Search