The information in this article applies to:
Product: MIM and PM4Data
Version: 8.x
Platform: Open Systems
Database: DB2 8.2
Issue
- After trying to load database tables, the user receives the DB2 database error below:
- $ xmoscrpt LoadDatabase.xms ./userdata.xml PM XMScript V 8.1.8.4 Copyright (c) 1997 - 2007 Metastorm, Inc., All Rights Reserved. \[INFO\] Executing script to load a database \[INFO\] Reading configuration and data files... \[INFO\] Connecting to database... exception caught:1 1 7739 2403 A Database Error occured:ERROR occurred During Connecting to ODBC. SQL Error: \[DataDirect\]\[ODBC DB2 Wire Protocol driver\]Specified security mechanism, (Unknown), is not supported by server. XMO Class/home/xmuser/sandbox/8184/unix/xmcommon/cpp/src/xmdb/xmdbimp.cpp XMDB::connect() 314VM terminated with rc = -1
Resolution
Configure the driver/provider to send an encrypted password to DB2. For ODBC connections:
Windows: Choose "1 Encrypt Password" in the Security Mechanism drop-down box on the General tab of your DB2 data source.
Unix: Set SecurityMechanism=1 in the DB2 data source definition of your odbc.ini file.
