Using Siebel Tools > Using Siebel Tools > Workspaces Administration >

Enabling the Workspaces Mode for Siebel Tools

Workspace administrators can enable the Workspace feature (or Workspace mode) for Siebel Tools at the database level by running the executable utility. After the Workspace mode is enabled, the root workspace is added to the S_WORKSPACE table, a repository-based version record is added to the S_WS_VERSION table, and the required indexes are added to the repository tables.

NOTE:  After the Workspace mode is enabled, you cannot revert back to the non-workspace mode.

To enable the Workspace feature for Siebel Tools

1. Ensure that Siebel Tools Client is installed successfully.

   For more information on how to install Siebel Tools, see the Siebel Installation Guide.

2. Open the Command Prompt window from your computer by clicking the Start button and then selecting the Run option.

   The Run window appears.

3. Enter the value CMD in the Open field.

   The Command Prompt window appears.

4. Change the directory in the Command Prompt window to the <TOOLS_HOME>/BIN folder using this command:

   cd <TOOLS_HOME>/BIN

   The Command Prompt window displays the following arguments and parameters, which you can use to run the EnableWorkspace.exe utility:

   • -s Siebsrvr/Tools Installation path specified (required)
   • -t Siebel Table Owner (required)
   • -u Username (required)
   • -p Password (required)
   • -o ODBC Data Source (required)
   • -d DB Platform Name (Oracle, MSSQL, DB2UDB or DB2390)
   • -l Log File Name (default: EnableWorkspace.log)
   • -w Workspace Owner Username (required)
5. Use the listed arguments and parameters to run the EnableWorkspace.exe utility.

   This example shows the arguments and parameters that are used to run the EnableWorkspace.exe utility:

   C:\Siebel\Tools\BIN>EnableWorkspace -s "C:\Siebel\Tools" -t ORAJQ152 -u ORAJQ152 -p ORAJQ152 -o "SSD default instance" -d Oracle -l EnableWorkspace.log -w SADMIN

6. View the output stages, representing the progress of the tasks performed by the utility.

   The Command Prompt window lists the following output stages after you run the EnableWorkspace.exe utility:

   • Stage 1 of 7: Setting the Repository ID
   • Stage 2 of 7: Validate the Workspace Data
   • Stage 3 of 7: Generate the Workspace Data
   • Stage 4 of 7: Update the Workspace Data in all Repository Tables
   • Stage 5 of 7: Generate the indexes
   • Stage 6 of 7: Update the statistics for all Workspace enabled Repository Tables
   • Stage 7 of 7: Post Run Cleanup
7. Confirm that the EnableWorkspace.exe utility has processed successfully on your environment using the following steps:
   1. Access and open Siebel Tools.
   2. Confirm that the Siebel Tools title bar at the top of the window displays this title:

   Siebel Tools -Siebel Repository -[MAIN/0] - Read Only-

   3. On the menu bar, confirm that the Workspace menu appears between the Tools menu and the Window menu.
   4. Click the Workspace menu and then select the Workspace Explorer option.

      On the left of the window, the Workspaces dashboard (Workspaces explorer pane) appears on the top of the visibility View Mode pane.

   5. Note that the MAIN workspace (also known as the root, parent, or master workspace) is selected, the Workspace Versions and Modified Objects panes are displayed.

      NOTE:  By default, Siebel Tools opens the latest version of the MAIN workspace and this workspace is set at the session. Also, the MAIN workspace is the only workspace in the Workspace explorer pane and it is always a read-only workspace.