setupIdMgrDBTables command fails
The setupIdMgrDBTables command might fail because the WebSphere variable DB2_JDBC_DRIVER_PATH is set incorrectly.
Invoking the setupIdMgrDBTables command might result in the following
error:
wsadmin>$AdminTask setupIdMgrDBTables {-report_sql_error true -schema_location
C:\WASX_n0607.09\etc\wim\setup -dbprop_xml C:\WASX_n0607.09\etc\wim\setup
-db_type db2 -db_jdbc_url jdbc:db2:wim -db_driver COM.ibm.db2.jcc.DB2Driver
-db_user db2user -db_password password -dn "o=Default Organization"}
WASX7015E: Exception running command: "$AdminTask setupIdMgrDBTables
{-report_sql_error true -schema_location C:\WASX_n0607.09\etc\wim\setup
-dbprop_xml C:\WASX_n0607.09\etc\wim\setup -db_type db2 -db_jdbc_url
jdbc:db2:wim -db_driver COM.ibm.db2.jcc.DB2Driver -db_user db2user
-db_password password -dn "o=Default Organization"}"; exception information:
com.ibm.bsf.BSFException: error while eval'ing Jacl expression:
com.ibm.ws.scripting.ScriptingException: com.ibm.websphere.wim.exception.WIMSystemException:
com.ibm.websphere.wim.exception.WIMSystemException: CWWIM1999E An exception occurred
during processing: COM.ibm.db2.jcc.DB2Driver
while executing
"$AdminTask setupIdMgrDBTables {-report_sql_error true -schema_location C:\WASX_n0607.09\etc\wim\setup
-dbprop_xml C:\WASX_n0607.09\etc\wim\setup -db_t..."
If this error occurs:
- Use the WebSphere Administrative Console (Environment ->WebSphere
Variable) to set the WebSphere variable DB2_JDBC_DRIVER_PATH to
the db2 driver jar/zip file. For examples:
- c:\Progra~1\IBM\SQLLIB\java\db2jcc.jar
- c:\Progra~1\IBM\SQLLIB\java\db2jcc_license_cu.jar
- c:\Progra~1\IBM\SQLLIB\java\db2jcc_license_cisuz.jar
- Save the configuration.
- Restart the WebSphere Application Server.