ClearQuest error: CRMMD12844 unable to logon to the DB2 database . The vendor message was: CRMDB0000E SQLDriverConnect: RETCODE=-1, State S1000, Native Error: 1031 [IBM Rational][ODBC DB2 Wire Protocol driver][DB2] Unknown error: SQLCODE-1031
How to resolve this error message in IBM Rational ClearQuest after upgrading VM (for windows)
CRMMD12844 unable to logon to the DB2 database . The vendor message was: CRMDB0000E SQLDriverConnect: RETCODE=-1, State S1000, Native Error: 1031 [IBM Rational][ODBC DB2 Wire Protocol driver][DB2] Unknown error: SQLCODE-1031
Hello,
"Native Error: 1013" and "SQLCOCE-1031" may represent SQL1031N. Here is a link for DB2 LUW V9.7 SQL1031N and snippet:
http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql01031n.html
...
SQL1031N
The database directory cannot be found on the indicated file system.
...
And it tells "CRMMD12844 unable to logon to the DB2 database". So it seems there might be an user authentication issue or the database does not exist somehow by upgrading VM.
It may be nice that checking the logon ID who surely can connect database, has an expected authority or not. Or try to clarify about upgrading VM, did install it by administrator/root, power user or not. These unexpected things might lead this type of user authentication issue/trouble.
Hope this helps.