Stack Overflow
Stack Overflow

Questions tagged [db2-connect]

db2-connect is an independent product used as a database client driver to connect IBM host database servers like zOS and i-Series servers.

db2-connect is an independent product used as a database client driver to connect IBM database servers like zOS, i-Series and Informix. db2-connect package comes with these client drivers: ODBC driver, CLI Driver, JCC Driver, .NET Driver, Python, PHP, Perl and Ruby Driver. It comes with CLPPlus command line tool too.

66 questions
7
votes
2 answers

Error 58031 connecting to a DB2 database

I have created a database in DB2. It was working until yesterday, but now I am getting the following error when attempting to connect to the database: [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. …
Monali James
  • 71
  • 1
  • 1
  • 3
4
votes
1 answer

Any DB2 database project support for Visual Studio 2010?

Back at Tech Ed in 2008, Microsoft announced that: IBM and Microsoft have agreed to work together to integrate IBM DB2 database access with Visual Studio Team System Database Edition. -- Microsoft Press Release - 6/3/2008 Has anyone seen…
Paul G
  • 2,722
  • 4
  • 37
  • 54
3
votes
9 answers

pecl instal ibm_db2 fails

I need to install ibm_db2 extension for making php connection with db2. So I have used pecl. But it produces error. $ pecl install ibm_db2 When I run this, the below error occurs. ..... checking in /home/db2inst1/sqllib/lib64... checking …
Coder
  • 133
  • 1
  • 5
  • 11
3
votes
3 answers

DB2 Communication Error

We recently developed an application which will run a query in DB2 and send a mail to the corresponding recipient. It works well in our local system and QA region. But in production, few queries failed (even if it's rare, like once in week). It…
Ryder
  • 53
  • 1
  • 6
3
votes
4 answers

what is the upper limit for the predicate WHERE IN () db2?

what is the upper limit for predicate WHERE IN in DB2. For example: select salary from employee where empid in (1,2,3,4...N)
user3492304
  • 153
  • 2
  • 4
  • 11
3
votes
1 answer

What is difference between org.apache.commons.dbcp.BasicDataSource and com.ibm.db2.jcc.DB2DataSource

I was connecting to DB2 systems using org.apache.commons.dbcp.BasicDataSource and I have found that com.ibm.db2.jcc.DB2DataSource is more extensive as it allows me to generate traces. Now I would like to know the difference more accurately and…
dodger
  • 245
  • 1
  • 3
  • 17
2
votes
3 answers

copying oracle tables to DB2

I want to access oracle tables in DB2(something like DBlink from DB2 to oracle).Any help is appreciated.
hnm
  • 789
  • 2
  • 9
  • 24
2
votes
2 answers

IBM DB2 ON AS400

I want to configure IBM DB2 on iseries AS400. The issue is I'm not getting the proper tool for AS400 and I've already installed Data Studio for configure DB2. I don't have any knowledge regarding AS400 and I'm fresher for IBM technology. I have…
uvcreation
  • 91
  • 1
  • 9
2
votes
1 answer

What are the differences between these IBM.Data.DB2 dlls?

I have these dlls installed on my box. What are the differnces between them and when would I use each? IBM.Data.DB2.dll IBM.Data.DB2.Entity.dll IBM.Data.DB2.ASP.dll IBM.Data.DB2.9.5.5.dll One other thing, my db2 data is on Z/OS Mainframe, if that…
Tony
  • 425
  • 2
  • 4
  • 13
2
votes
1 answer

License ERROR with DB2 driver on linux

Im trying to connect to a DB2 db. ive installed driver server package from IBM 10.5. When i try to connect to the db2 server im receiving that message: [IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a…
Adrián Pulido del Castillo
  • 123
  • 1
  • 3
  • 11
2
votes
2 answers

AS / 400 connection method

I have to create architecture and procedures to connect Visual Studio c# programs with the database on the IBM AS/400. I'm looking for different possibilities, I think that services Rest is the best choice but I have not yet decided how to connect…
Dallas
  • 494
  • 3
  • 14
1
vote
2 answers

Does DB2 Visual Studio Add-In work with VS2010?

I have both VS2008 and VS2010 installed and then I installed DB2 with the VS Add-ins. Now the Add-ins show up just fine in VS2008 but they do not show up in VS2010. So, does the DB2 Visual Studio Add-Ins work with VS2010? Also VS2008 is VS2008 Shell…
Tony Borf
  • 4,579
  • 8
  • 43
  • 51
1
vote
1 answer

What is the structure of the config file for Azure B2C Authetication using react app along with the Authority link structure?

I am trying to get the perfect structure of config and the authority url for my B2C auth application that will be integrated with Azure and React. I did get this structure for my config file and the auth link is specified as in the comments. but I…
Satyam Dodmani
  • 15
  • 4
1
vote
1 answer

How to know which all tables have the column ex PHONE?

Please advise. In Db2 database how can I know the list of tables that contain the column ex PHONE? Thanks, Srihari
Srihari
  • 2,509
  • 5
  • 30
  • 34
1
vote
1 answer

DB2 connection string problem

I have the following code: import pyodbc cnxn = pyodbc.connect('DRIVER={IBM DB2 ODBC DRIVER};DATABASE=TDB2;UID=username;PWD=password') I get the error message SQLSTATE=42705, which means that it cannot reach the database. When I connect to DB2…
David
  • 4,786
  • 11
  • 52
  • 80
1
2 3 4 5