Express (Distributed operating systems), v8.0 > Secure applications and their environment > Authenticate users > Select a registry or repository > Manage realms in a federated repository > Virtual member manager > Troubleshoot and Support > Support issues and limitations > Database issues and limitations


setupIdMgrDBTables command fails

The setupIdMgrDBTables command might fail because the WebSphere variable DB2_JDBC_DRIVER_PATH is set incorrectly.

Invoke 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:

  1. 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

  2. Save the configuration.

  3. Restart the WAS.

Parent topic: Database issues and limitations



+

Search Tips   |   Advanced Search