Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers. It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.
+ mqsistop WQM1 BIP8071I: Successful command completion. + mqsisetdbparms WQM1 -n IPC -u db2instl -p db2instl BIP8071I: Successful command completion. + mqsisetdbparms WQM1 -n dsn::DSN -u db2instl -p db2instl BIP8071I: Successful command completion. + mqsistart WQM1 BIP8096I: Successful command initiation, check the system log to ensure that the component started without problem and that it continues to run without problem. + mqsicvp -n IPC -u db2inst1 -p db2inst1 BIP8270I: Connected to Datasource 'IPC' as user 'db2inst1'. The datasource platform is 'DB2/LINUXX8664', version '09.07.0000'. =========================== databaseProviderVersion = 09.07.0000 driverVersion = 09.07.0000 driverOdbcVersion = 03.51 ......
So my uid and pw do not work for IPC with WMB, so from mqm, I log into db2inst1 using the pw, and try to connect to IPC
(WQM1.a1)BIP2322E: Database error: SQL State '08001'; Native Error Code '-30082'; Error Text '[IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 '. : WQM1.3e9ded37-3301-0000-0080-ac1ae0224106: /build/S700_P/src/DataFlowEngine/ImbOdbc.cpp: 480: ImbOdbcHandle::checkRcInner: :
This works from the command line, but WMB cant do it. I set the setdbparms command correctly. Any ideas ?
$ su - db2inst1 Password: [db2inst1@sandbox1 ~]$ db2 connect to IPC Database Connection Information Database server = DB2/LINUXX8664 9.7.0 SQL authorization ID = DB2INST1 Local database alias = IPC
Join the community of 500,000 technology professionals and ask your questions.