Enabling Workspaces

Note: This task applies to Siebel Tools and Web Tools.

Workspaces are enabled automatically during installation and upgrade.

Workspace Administrators can enable Workspaces by running the executable (EnableWorkspace) utility. After Workspaces have been enabled, the root Workspace is added to the S_WORKSPACE table and a repository-based version record is added to the S_WS_VERSION table.

For more information on the responsibilities of a Workspace Administrator, see About Workspaces.

Note: The EnableWorkspace utility and its command-line arguments are applicable for all platforms. 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 Workspaces

1. Execute the EnableWorkspace utility without any arguments to get a list of the supported options:

   • -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))

   • -v: Generate Schema File Only (Default : N, for DB2390 only)

   • -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

2. Run the EnableWorkspace utility using the available arguments and parameters, for example, as follows:

   <-- ORACLE DB -->
   C:\Siebel\siebsrvr\BIN> EnableWorkspace -s "C:\Siebel\siebsrvr" -u SIEBEL -p ******** 
   -t SIEBEL -r "Siebel Repository" -d "Oracle" -o ORAXXXX -w SADMIN -y SADMIN -z ********

   Or:

   <-- MSSQL DB -->
   C:\Siebel\siebsrvr\BIN> EnableWorkspace -s "C:\Siebel\siebsrvr" -u SIEBEL -p ******** 
   -t dbo -r "Siebel Repository" -d "MSSQL" -o Siebel_DSN -w SADMIN -y SADMIN -z ********

3. Review the output stages, representing the progress of the tasks performed by the utility.

   The Command Prompt window shows 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

4. Confirm that the EnableWorkspace utility has processed successfully on your environment by doing the following:

   1. Access and open your client.

   2. In the Workspace Explorer, confirm that there is one and only one Workspace named MAIN.