You can use the createIdMgrPropExtDbTables script to create tables in the property extension repository for federated repositories.
To use the IBM DB2 on z/OS® or IBM DB2 on iSeries® database, read about manually setting up the property extension repository in DB2.
app_server_root\etc\wim\setup\bin\createIdMgrPropExtDbTables.sh app_server_root\etc\wim\setup\bin\createIdMgrPropExtDbTables.bat app_server_root\etc\wim\setup\lookaside\db_type\dbclean.sql app_server_root\etc\wim\setup\lookaside\db_type\schema.sql app_server_root\etc\wim\setup\lookaside\db_type\primarykeys.sql app_server_root\etc\wim\setup\lookaside\db_type\indexes.sql app_server_root\etc\wim\setup\lookaside\db_type\references.sql app_server_root\etc\wim\setup\lookaside\keys.sql app_server_root\etc\wim\setup\lookaside\bootstrap.sql
set SCHEMA_LOCATION=app_server_root\etc\wim\setup\lookaside\sqlserver set DBOWNER=dbo ws_ant.bat -f app_server_root\etc\wim\setup\filterbuild.xml
CLIENT_LOCALE=EN_US.CP1252 DB_LOCALE=EN_US.8859-1 SERVER_LOCALE=EN_US.CP1252 DBLANG=EN_US.CP125
This value is a string value that is required for all database types.
This value is a string value that is required for a DB2 database only; do not specify a value for other database types.
This parameter applies to the AIX, HP-UX, Linux, and Solaris operating systems.
For an Oracle database, the value of the ORACLE_SID variable is the same as the name of the database.
This value is a string value that is required for all database types.
This value is a string value that is required for DB2, Oracle, Informix, and SQL Server databases only; do not specify a value for a Derby database.
On Windows operating systems, use this parameter to specify the location of the app_server_root\etc\wim\setup directory.
This value is a string value that is required for all database types.
This value is a string value that is required for all database types.
This value is a string value that is required for DB2, Oracle, Informix, and SQL Server databases only; do not specify a value for a Derby database.
The examples in the following section are organized into multiple lines for illustration purposes only.
createIdMgrPropExtDbTables.sh -b /space/oracle/product/10.2.0/Db_1/ -n orcl -u system -p manager -s /opt/IBM/WebSphere/AppServer1/etc/wim/setup -t oracle
createIdMgrPropExtDbTables.sh -b /opt/IBM/informix/ -n demo_on -u informix -p informix -s /opt/IBM/WebSphere/AppServer/etc/wim/setup -t informix
createIdMgrPropExtDbTables.sh -b /opt/ibm/db2/V9.1/ -n db2inst1 -p db2inst1 -s /opt/IBM/WebSphere/AppServer/etc/wim/setup -t DB2 -u db2inst1 -i /home/db2inst1/
createIdMgrPropExtDbTables.sh -b /opt/ibm/derby/ -n test11 -s /opt/IBM/WebSphere/AppServer/etc/wim/setup -t derby
createIdMgrPropExtDbTables.bat -b "c:\oracle\product\10.2.0\Db_1" -n orcl -u system -p manager -s "c:\Program Files\IBM\WebSphere\AppServer1\etc\wim\setup" -t oracle
createIdMgrPropExtDbTables.bat -b "c:\Program Files\IBM\informix" -n demo_on -u informix -p informix -s "c:\Program Files\IBM\WebSphere\AppServer\etc\wim\setup" -t informix
createIdMgrPropExtDbTables.bat -t db2 -u db2admin -p sec001ret# -n test23 -b "c:\Program Files\IBM\SQLLIB" -s "c:\Program Files\IBM\WebSphere\AppServer1\etc\wim\setup"
createIdMgrPropExtDbTables.bat -t derby -b "c:\Derby" -n test11 -s "c:\Program Files\IBM\WebSphere\AppServer1\etc\wim\setup"
createIdMgrPropExtDbTables.bat -t sqlserver -u sa -p sec001ret# -n sqlsrv -b "c:\Progra~1\Micros~1\90\Tools" -s "C:\Progra~1\IBM\WebSphere\AppServer1\etc\wim\setup"
In this information ...Related tasks
Related information
| IBM Redbooks, demos, education, and more(Index) |