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

Icon that indicates the type of topic Task topic

Terms and conditions for documentation | Feedback


Timestamp icon Last updated: March 30, 2016 13:35
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=cord&product=vmm&topic=thesetupidmgrdbtablescommandfailsforthemicrosoftsqlserver
File name: thesetupidmgrdbtablescommandfailsforthemicrosoftsqlserver.html