MQSeries.net :: View topic

felfel · Posted: Wed Nov 03, 2004 1:58 pm Post subject:

Hi ,

I tried to create a broker with the command mqsicreatebroker . The command don't terminate . I have to stop it with (ctrl + c) .

My enviroment is:
1. AIX 5.2 64bit mode
2. IBM db2 8.1(fix pack 7)
3. WBIMB 5.0.1 ( fix pack 4)

I used mqsi user as my broker user, I've added it into all groups required. About database user, i used db2inst1 user which is administrator user of db2.
mqsicreatebroker mybroker -i mqsi -p xxxxx -q myQM -n MSQIBKDB -u db2inst1 -p xxxx
When i active traces , it looks like it doesn't connect via ODBC to database :

[i][size=7]oot@aphrodite:/var/mqsi/odbc #ls
.odbc.ini odbctrace.out
root@aphrodite:/var/mqsi/odbc #cat .odbc.ini
[ODBC Data Sources]
MQBK01ET=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 410 Oracle 8 Driver
SYBASEDB=DataDirect 410 Sybase ASE Driver

[MQBK01ET]
Driver=/u/db2inst1/sqllib/lib/libdb2.a
Description=MQSIBKDB DB2 ODBC Database
Database=MQBK01ET

[MYDB]
Driver=/u/db2inst1/sqllib/lib/libdb2.a
Description=MYDB DB2 ODBC Database
Database=MYDB

[ORACLEDB]
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=YourServerName
EnableDescribeParam=1
OptimizePrepare=1

[SYBASEDB]
Driver=/usr/opt/wmqi/merant/lib/UKase18.so
Description=Sybase11
Database=sybasedb
ServerName=YourServerName
WorkstationID=id
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=10.30.14.72,5000
SelectUserName=1

[ODBC]
Trace=1
TraceFile=/var/wmqi/odbc/odbctrace.out
TraceDll=/usr/opt/wmqi/merant/lib/odbctrac.so
InstallDir=/usr/opt/wmqi/merant

root@aphrodite:/var/mqsi/odbc #

-------------------------------------
$ set -o vi
$ odbctest MQBK01ET db2inst1 db2inst1
Operation: Enter ODBC Test Program, RETCODE = 0
Operation: Completed Initialization, RETCODE = 0
Operation: SQLAllocEnv, RETCODE = 0
Operation: SQLAllocConnect, RETCODE = 0
dsn=MQBK01ET; uid=db2inst1; pwd=db2inst1
Operation: SQLConnect, RETCODE = -1
SQLSTATE = 01000
SQLCODE = 0
Error Message:

Operation: SQLSetConnectOption (IV license), RETCODE = 0
Operation: SQLSetConnectOption (IV password, RETCODE = 0
Operation: Environment settings written to $(VWS_LOGGING)/odbctest.set,
RETCODE = 0

*** General Informaion ***
Error SQLAllocStmt,-1.
SQLGetInfo is not supported!
Operation: SQLAllocStmt, RETCODE = -1
SQLSTATE = 01000
SQLCODE = 0
Error Message:

Table type=TABLE
Operation: SQLFetch, RETCODE = -2
SQLSTATE = 00000
SQLCODE = 0
Error Message:

Operation: SQLDisconnect, RETCODE = -1
SQLSTATE = 01000
SQLCODE = 0
Error Message:

Operation: Exit ODBC Test Program, RETCODE = 0
$

ppid=741420:pid bb040:1 ENTER SQLSetEnvAttr
SQLHENV 0x2003ab98
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3
SQLINTEGER 0

ppid=741420:pid bb040:1 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x2003ab98
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3
SQLINTEGER 0

ppid=741420:pid bb040:1 ENTER SQLAllocConnect
HENV 0x2003ab98
HDBC * 0x2003d078

ppid=741420:pid bb040:1 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 0x2003ab98
HDBC * 0x2003d078 ( 0x2005a208)

ppid=741420:pid bb040:1 ENTER SQLSetConnectOption
HDBC 0x2005a208
UWORD 102
UDWORD 0

ppid=741420:pid bb040:1 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 0x2005a208
UWORD 102
UDWORD 0

ppid=741420:pid bb040:1 ENTER SQLConnect
HDBC 0x2005a208
UCHAR * 0x2ff20a48 [ -3] "MQBK01ET"
SWORD -3
UCHAR * 0x2ff209c8 [ -3] "db2inst1"
SWORD -3
UCHAR * 0x2ff208a0 [ -3] "******"
SWORD -3

ppid=741420:pid bb040:1 ENTER SQLConnectW
HDBC 0x2005a208
WCHAR * 0x2003d158 [ -3] "MQBK01ET"
SWORD -3
WCHAR * 0x2003d188 [ -3] "db2inst1"
SWORD -3
WCHAR * 0x2ff20810 [ -3] "******"
SWORD -3 [/i][/size]

Thanks fo any help
_________________
"Mens sana in corpore sano"