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.
Run the appropriate script for your database and operating system to create tables in the property extension repository. Use the sample values to specify database parameters. If the database exists on a system where WebSphere Application Server is not installed, the following examples assume that your PATH variable includes an entry for the location to which you copied the script files. For the AIX, HP-UX, Linux, and Solaris operating systems, the entry might be the app_server_root/etc/wim/setup/bin/ or the /setup/bin/ directory. For Windows operating systems, the entry might be the app_server_root\etc\wim\setup\bin\ or the \setup\bin\ directory.
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) |