Login or Register to Ask a Question and Join Our Community


AIX

MVS DB2 Connection from AIX

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX MVS DB2 Connection from AIX
# 1  
Old 10-15-2010
MVS DB2 Connection from AIX
Hi,

I want to try to connect to a DB2 (MVS) database from an AIX, through my c++ custom program. Is anybody who knows how can I do this? Which libraries should I use? Should I have a DB2 connect installed on my AIX?

Thank you in advance.
# 2  
Old 10-15-2010
DB2 has both ESQL C++ and C++ libraries, or you can pipe in or out of a command line tool with popen() or system(). JDBC works great, too, no cost for libraries, if your affinity to C++ is shakable. You might need your designated IBM/DB2 guy and the DB2 licence code to use a login to get free libraries for your client online. You might get your own IBM login -- might need the e-nod of a registered user for your account. Might not:

http://www-01.ibm.com/support/docvie...id=swg21254867
# 3  
Old 10-20-2010
you need a DB2 client installed locally with a valid DB2 Connect license unless you can catalog to an existing dedicated DB2 Connect server.
# 4  
Old 10-21-2010
There are open source options, just another tcp/ip subprotocol, but if you have the server, I believe all sorts of client apps and libraries are free, but perhaps licensed.

Using IBM DB2 with unixODBC
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. AIX

AIX LPAR FC connection to SAN

Hi all, In my system, I have HMC 7 with Power Machine 6 & 7. On the managed system, we have many lpars. In some lpars, I can see they are using virtual fiber channel to connect to DS8K storage. In search with google, I understand that it is configured with VIOS server to share the physical FC... (7 Replies)
Discussion started by: Phat
7 Replies

2. AIX

Unable to establish connection over TLS 1.2 on AIX 7.1/7.2

Hello Team, I would need your help to enable communication over TLS1.2 on AIX 7.1 or 7.2 with IBM JDK 1.8 latest update. By default, the request is trying to establish a connection over TLSv1 even though TLS 1.2 is explicitly enabled on server as well as on Java 8. The openssl command throws... (4 Replies)
Discussion started by: Naina2019
4 Replies

3. UNIX for Dummies Questions & Answers

AIX & DB2 paging issues

AIX & DB2 paging issues Hello I needs some help on AIX & DB2 paging issues. Recently a db2 query caused paging issues which then lead to memory problems and a server restart. Is there anyway of finding out what db2 queries were causing the problem.. Thanks in advance (2 Replies)
Discussion started by: nedkao
2 Replies

4. Emergency UNIX and Linux Support

SFTP issue when connecting from MVS to AIX

Dear all, I was given the ID_DSA.pub by an MVS user, which I placed in the appropriate user's authorized_keys file. When the user tris to SFTP from their side to the AIX box, the following error is got: error: debug1: SSH2_MSG_KEX_DH_GEX_INIT sent debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY ... (6 Replies)
Discussion started by: ggayathri
6 Replies

5. Solaris

Solaris 10 ftp connection problem (connection refused, connection timed out)

Hi everyone, I am hoping anyone of you could help me in this weird problem we have in 1 of our Solaris 10 servers. Lately, we have been having some ftp problems in this server. Though it can ping any server within the network, it seems that it can only ftp to a select few. For most servers, the... (4 Replies)
Discussion started by: labdakos
4 Replies

6. AIX

AIX Tuning For DB2

Dear friends. can anybody suggest me what to be considered in order to achieve maximum performance of AIX on which DB2 will be installed Thanks is advance :) (1 Reply)
Discussion started by: Vit0_Corleone
1 Replies

7. Programming

Acceessing DB2 UDB in AIX COBOL on unix

Hi , We are migrating our database from DB2 z/os to DB2 UDB on UNIX. and cobol on mainframes to AIX cobol on UNIX. We have some cobol Db2 programs that are accessing different Databases how do we code such type of programs in AIX cobol. Do we need to Establish connection for accessing... (0 Replies)
Discussion started by: nal.satish
0 Replies

8. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies

9. AIX

db2 command on the AIX mechine

Hello, can any one help me to debug the following command. db2 -stec +pc ; Regards, SM (2 Replies)
Discussion started by: smolgara
2 Replies

10. Shell Programming and Scripting

SFTP to MVS system

Hi All, I have written a script that transfers(FTP) files from Unix system to MVS system. Below is the code for it. ftp -inv $HOST<<ftp_test quote site LRECL=200 quote site BLKSIZE=28000 mput SOURCE DEST ftp_test Here I need the help, if the above code can get... (3 Replies)
Discussion started by: rinku11
3 Replies
Login or Register to Ask a Question