Using Siebel Tools > Using Workspaces in 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.

Before you enable the workspaces mode in Siebel Tools, note that:

• After the Workspace mode is enabled, you should not revert back to the non-workspace mode (local database).

  If you revert back to the non-workspace mode, you must flatten the workspaces before you run the Revert process or you would lose all workspace information.

• Only one mode of development (traditional or workspace-enabled) can be active at a time, but you can switch between these modes by running the Flattening process or the EnableWorkspace utility respectively.
• If workspaces are activated in the development environment, they do not need to be activated in other environments before importing the repository.
• The EnableWorkspace utility can be used to enable run-time or design repository objects and seed data. You should run this utility for both repository objects and seed data at the same time to reduce the number of performing steps.
• Before you export a repository and move it from the development environment to any other environments, you must run the Flattening process.

For more information about the Revert process, see Reverting to Previous Workspace Versions.

For more information about the Flattening process, see Flattening Workspace Versions.

For more information about the responsibilities of a Workspace Administrator, see Workspace Users.

NOTE:  EnableWorkspace utility and its commands are applied for all platforms, including Unix, Windows, local, server, and so on. You can call EnableWorkspace.exe or EnableWorkspace (without .exe) for the Windows platform; however, you must call EnableWorkspace (without .exe) for other non-Windows platforms.

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

   OR

   cd <Siebsrvr>/BIN

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

   • -s Siebsrvr/Tools Installation path specified (required)
   • -t Siebel Table Owner (required)
   • -u TBLO Username (required)
   • -p TBLO 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)
   • -r Repository Name (default: "Siebel Repository")
   • -a Action ((R)epository, (S)eed, (B)oth) (default: (B))
   • -b RepositoryType ((R)unTime, (D)esignTime, (B)oth) (default: (B))
   • -f Seed inp file
   • -y Siebel UserName (required)
   • -z Siebel User Password (required)
   • -i Integration Branch (default: All integration branches unless passed integration branch name with this parameter)
   • -c Workspace Checkpoint Status (default: N)
   • -k Log directory (default: "Current Directory")
   • -e Language Code
5. Use the listed arguments and parameters to run the EnableWorkspace utility.

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

   C:\Siebel\Tools\BIN> EnableWorkspace -s "T:\Siebel\17.0.0.0.0\Tools_23067" -u ORAXXXX -p ORAXXXX -t ORAXXXX -r "Siebel Repository" -d "Oracle" -o ORAXXXX -w SADMIN -y SADMIN -z SADMIN

   or

   C:\Siebel\Tools\BIN> EnableWorkspace -s "C:\Siebel\17.0.0.0.0\Tools" -u MSFXI219 -p MSSQL -t dbo -r "Siebel Repository" -d "MSSQL" -o MSFXI219 -w SADMIN -y SADMIN -z MSSQL

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 utility:

   • Stage 1 of 8: Setting the Repository ID
   • Stage 2 of 8: Validate the Workspace Data
   • Stage 3 of 8: Generate the Workspace Data
   • Stage 4 of 8: Update the Workspace Data in all Repository Tables
   • Stage 5 of 8: Update the indexes
   • Stage 6 of 8: Update the Workspace Data in all Seed Tables
   • Stage 7 of 8: Update the statistics for all Workspace enabled Repository/Seed Tables
   • Stage 8 of 8: Post Run Cleanup
7. Confirm that the EnableWorkspace 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 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.

      Next to the window, the Workspaces dashboard (Workspaces explorer pane) precedes 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.