The setupIdMgrDBTables command fails for the Microsoft SQL Server

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

  1. Open a command window.
  2. Change to the WAS_HOME/etc/wim/setup directory.
  3. 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
  4. Run WAS_HOME/bin/ws_ant.bat -buildfile filterbuild.xml.
  5. 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


Terms of use | Feedback

http://publib.boulder.ibm.com/infocenter/wasinfo/v7r0/index.jsp?topic=/com.ibm.websphere.wim.doc/thesetupidmgrdbtablescommandfailsforthemicrosoftsqlserver.html