We were trying to fix the ODBC connection and were not connecting with Optim.
We were looking for help on ODBC connection.
Will try to get DB2connect also installed.
Now our ODBC connection is working - some parameters being supplied were incorrect.
We will try to use this in Optim now and let you know if we need help.
Thanks for quick response.
Thanks
Shilpi
------------------------------
Shilpi Mehta
------------------------------
Original Message:
Sent: 07-17-2018 13:31
From: Shilpi Mehta
Subject: Having trouble connecting Optim LUW to mainframe DB2 tables
Hi Vishwas,
Are you able to connect to the mainframe with the ODBC connection outside of Optim? - NO.
We are not able to connect to mainframe with ODBC connection.
So the other case you are saying is installing Db2Connect to connect to mainframe. We do not have this software on our Optim distributed servers. It might take longer to get the software installed on the server.
Thanks
Shilpi
------------------------------
Shilpi Mehta
Original Message:
Sent: 07-17-2018 13:24
From: Vishwas Balakrishna
Subject: Having trouble connecting Optim LUW to mainframe DB2 tables
Hello Shilpi,
Are you able to connect to the mainframe with the ODBC connection outside of Optim?
Also most of the cases or in my experience we have always gone to Mainframe with DB2 connect not with ODBC connection. No harm in trying out a new way to connect Optim with Mainframe.
------------------------------
Vishwas Balakrishna
Original Message:
Sent: 07-17-2018 13:05
From: Shilpi Mehta
Subject: Having trouble connecting Optim LUW to mainframe DB2 tables
Hi,
We are trying to connect DB2 using ODBC connection for Optim distributed.
We still did not reach the Optim configuration so sending PR0CNFG logs will not be useful.
Also, we do not have DB2 Connect installed.
We are trying to create DB2 connection using ODBC and getting this error in ODBC-32 bit connection:
SQL30081N : a communication error has been detected.
Thanks
Shilpi
------------------------------
Shilpi Mehta
Original Message:
Sent: 07-17-2018 12:40
From: Vishwas Balakrishna
Subject: Having trouble connecting Optim LUW to mainframe DB2 tables
Hello Dave,
Do you have DB2 connect installed on your workstation and server before trying to connect to ?
Also, can you attach any screenshot and PR0CNFG trace files for me to review and guide Thanks,
Vishwas
------------------------------
Vishwas Balakrishna
Original Message:
Sent: 07-17-2018 12:37
From: Dave Lewis
Subject: Having trouble connecting Optim LUW to mainframe DB2 tables
Does this require Federated server? It looks as though you should be able to connect to mainframe DB2 via ODBC like connecting to SQL Server database, but it's not going easily. Any tips?
Thanks!
------------------------------
Dave Lewis
Nationwide Insurance
------------------------------
#InfoSphereOptim
#Optim