1 2 Previous Next 26 Replies Latest reply on Jun 27, 2012 10:11 PM by Yogesh Deshpande

AIE DB2 adapter issue

Yogesh Deshpande Jun 21, 2012 3:00 PM

We are on 764patch2 (ARS/Atrium/ITSM) in a windows environment.

We are trying to use AIE's DB2 adapter to pull data from DB2 tables.

From the command prompt, when we run the below command, it throws error

*************

D:\Program Files\BMC Software\AtriumCore\aie\service64\bin>db2helper -ax <AR Server> -ar <PORT> -al <RemedyAdminLogin> -ap <RemedyAdminPwd> -da <DB2ALias> -dl <DB2User> -dp <DB2UserPwd> -di <DB2Instance> -t

ERROR ***
Connection to DB2 database failed:[Microsoft][ODBC Driver Manager] Function sequ
ence error

Failed to Connect to DB2 Database

*************

1 The DB2 Client is installed on the server where AIE is installed

2 We are able to login to DB2 using the Db2 client with the details used in the above command (Which proves that the Db2 client & the credentials are fine)

3 Same Db2 client (but a 32Bit version) is installed on a 7.1 AIE server where this works fine.

we are in the proces of upgrading AIE from 71 to 764 patch2 and the issue is coming..

Has anyone seen this?

Thanks

1. AIE DB2 adapter issue

Praveen NameToUpdate Jun 22, 2012 7:55 AM (in response to Yogesh Deshpande)

DC,
What version of DB2 server are you using is it 9.5 or 9.7 and I hope this is 64 bit?
May I know the client version as well ?
Like Show 0 Likes(0)

Actions
2. AIE DB2 adapter issue

Yogesh Deshpande Jun 22, 2012 9:17 AM (in response to Praveen NameToUpdate)

DB2 client - 9.7patch5 64-Bit, DB2 server - zOS 9.1
Like Show 0 Likes(0)

Actions
3. AIE DB2 adapter issue

Laurent Matheo Jun 22, 2012 10:49 AM (in response to Yogesh Deshpande)

Sorry for the dumb question, that means you created an OBDC link to the DB2 database? Using windows ODBC manager?
Like Show 0 Likes(0)

Actions
4. AIE DB2 adapter issue

Yogesh Deshpande Jun 22, 2012 12:01 PM (in response to Laurent Matheo)

We did not manually went and creaed an ODBC entry.. When DB2 is installed, guess it creates and uses the ODBC connection which seems to have some problem (Just a guess, I am not sure. I want to know if anyone can help me on this).
Like Show 0 Likes(0)

Actions
5. AIE DB2 adapter issue

Laurent Matheo Jun 22, 2012 12:26 PM (in response to Yogesh Deshpande)

I know that at ARS installation we had to create a connection with DB2 but I didn't try AIE with DB2...
Perhaps it doesn't like x64 client...

We also have DB2 here (Windows ARS and DB2 9.7 x64 on AIX), if you tell me how to configure / do an example with AIE connecting with DB2 I could try here.
I'm sorry to ask you this, but I don't know anything in AIE, that's why...
Like Show 0 Likes(0)

Actions
6. AIE DB2 adapter issue

Yogesh Deshpande Jun 22, 2012 12:36 PM (in response to Laurent Matheo)
That would be a big help!!

1 You will have to install DB2 client on the machine where you have AIE installed.
2 Login to this machine > open command prompt > Navigate to AIE installation directory “D:\Program Files\BMC Software\AtriumCore\aie\service64\bin”
3 run this command ….. db2helper -ax <AR Server> -ar <PORT> -al <RemedyAdminLogin> -ap <RemedyAdminPwd> -da <DB2ALias> -dl <DB2User> -dp <DB2UserPwd> -di <DB2Instance> -t

Let me know what you get…

Thanks a lot J
Like Show 0 Likes(0)

Actions
7. AIE DB2 adapter issue

Laurent Matheo Jun 22, 2012 1:03 PM (in response to Yogesh Deshpande)

Same error you have.
I tried to create an ODBC source (microsoft ODBC) using the Windows ODBC handler but it didn't help.

The weird thing is that if you create a microsoft ODBC connection, you can test it (connect button) and it works (I mean, ODBC, not db2helper).
Like Show 0 Likes(0)

Actions
8. AIE DB2 adapter issue

Laurent Matheo Jun 22, 2012 1:22 PM (in response to Laurent Matheo)

I found this:
http://forums.codeguru.com/showthread.php?134717-Function-Sequence-error-!!!!-Urgent

I wonder if there could be a problem with db2helper, perhaps too old now (?).
Like Show 0 Likes(0)

Actions
9. AIE DB2 adapter issue

Yogesh Deshpande Jun 22, 2012 1:30 PM (in response to Laurent Matheo)

*****The weird thing is that if you create a microsoft ODBC connection, you can test it (connect button) and it works (I mean, ODBC, not db2helper).*******

Same is true with here
Like Show 0 Likes(0)

Actions
10. AIE DB2 adapter issue

Laurent Matheo Jun 22, 2012 1:33 PM (in response to Yogesh Deshpande)

Did you try opening an issue with BMC support? Perhaps they "just" need to rebuild the db2helper tool.
Like Show 0 Likes(0)

Actions
11. AIE DB2 adapter issue

Yogesh Deshpande Jun 22, 2012 1:39 PM (in response to Laurent Matheo)

I had an issue opened with BMC but they could not help much because we are on DB2 Server zOS-9.1.

We have DB2 client on 9.7 fp5 but BMC needs both DB2 Server & Client to be later than 9.5 in order to support it.

But I think you are on the right versions and stiil facing the issue... not sure where to go after this
Like Show 0 Likes(0)

Actions
12. AIE DB2 adapter issue

Laurent Matheo Jun 22, 2012 1:42 PM (in response to Yogesh Deshpande)

I see. Well you can tell them you have someone who can test in:
Windows DB2 client 9.7 x64 and database beeing 9.7 x64 (on AIX).
I guess if they solve it "for me", it'll be working for you as well.

If they / you agree on this it shouldn't be a problem for me to send logs or whatever is needed
Like Show 0 Likes(0)

Actions
13. AIE DB2 adapter issue

Yogesh Deshpande Jun 22, 2012 1:50 PM (in response to Laurent Matheo)
The first thing they will ask is to have a webex and probably we will have to wait for their replies for 2-3 days or sometimes a week if they escalate it to their backline.
--- doesnt sound good..
I am planning to write a web service if this does not take me anywhere and stay quiet

I dont have an option to upgrade the DB2 server to 9.5 at this moment
Like Show 0 Likes(0)

Actions
14. AIE DB2 adapter issue

Yogesh Deshpande Jun 22, 2012 1:51 PM (in response to Yogesh Deshpande)

I am sure as you are that if they resolve your issue, mine will be resolved
Like Show 0 Likes(0)

Actions