Preparing a Workspace-Enabled Environment

Environments: Development.

Platforms: Windows, Linux, UNIX, IBM z/OS.

This situation applies to you if you have enabled Composer Mode in Innovation Pack 16.

Remediation

In the specific scenario as previously described, run the WSCleanup utility immediately after installing the binaries, but before starting the upgrade.

Running the Utility

WSCleanup -t <Table Owner> -u <Table
        Owner User Name> -p <Table Owner Password> -o <ODBC Data Source> -r <Repository Name> -s <SIEBEL
        ROOT/BIN> -d <DB Type>

Examples of running the Utility

Microsoft SQL Server

WSCleanup -t dbo -u SIEBEL -p ******** -o Siebel_DSN -r
        "Siebel Repository" -s "C:\Siebel" -d MSSQL

Oracle

WSCleanup -t SIEBEL -u SIEBEL -p ******** -o Siebel_DSN -r
        "Siebel Repository" -s "C:\Siebel" -d ORACLE

DB2UDB

WSCleanup -t SIEBEL -u SIEBEL -p ******** -o Siebel_DSN -r
        "Siebel Repository" -s "C:\Siebel\" -d DB2UDB

DB2390

WSCleanup -t CQ10C002 -u QADMIN -p ******** -o Q10C -r
        "Siebel Repository" -s "C:\Siebel\" -d DB2390

Argument List for the Utility

Argument	Description	Comment
-t	Siebel Table Owner	Required
-u	Table Owner Username	Required
-p	Table Owner Password	Required
-o	ODBC Data Source	Required
-r	Repository Name	Default: “Siebel Repository”
-s	Siebel Server Installation Path	Required
-d	DB Platform Name	Oracle, MSSQL, DB2UDB, or DB2390

Utility Output Log Location

The utility Logs are generated in <SIEBEL SERVER_ROOT>\log.

WSCleanup performs the following actions:

• Checks if the database is Workspace-enabled. If yes, then it identifies all Repository records that are in Workspaces other than MAIN and deletes them.
• Deletes the duplicate data from objects with multiple versions within the MAIN Workspace based on the U1 index columns of respective Repository tables.
• Updates WS_ID column to NULL in all Repository tables.
• Removes the contents of the S_WORKSPACE table.