You must update the table space in the database schema
before you can issue the setupIdMgrDBTables command for the Microsoft
SQL Server.
About this task
Complete the following steps to update the table space in
the database schema:
Procedure
- Open a command window.
- Change to the WAS_HOME/etc/wim/setup directory.
- Enter the following commands to set the environment
variable and to set the table space owner:
set SCHEMA_LOCATION=WAS_HOME/etc/wim/setup
set DBOWNER=dbo
- Run WAS_HOME/bin/ws_ant.bat -buildfile filterbuild.xml.
- Check the WAS_HOME/etc/wim/setup/database/sqlserver/schema.sql
ddl file to see if the table spaces are updated correctly. Also,
check the schema.sql files under the following property extension
and entry mapping directories:
WAS_HOME/etc/wim/setup/lookaside/sqlserver/schema.sql
WAS_HOME/etc/wim/setup/federation/sqlserver/schema.sql