Topic profile page for IBM DB2.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: IBM DB2.
Topic "Ibm db2" was discussed 0 times on 0 sites in last 3 months
Started 1 day, 21 hours ago (2009-12-28 14:22:00)
by vikita
Has anyone successfully configured the WCS enterprise development environment 6.0.0.6 to connect to a IBM DB2 v9.5 database server using IBM DB2 v8.1 client? If yes, can you provide the steps? Thanks.
Started 2 weeks ago (2009-12-15 22:28:00)
by user8849294
Hi all, I tried to create Master repository connection for IBM db2.but dont know how to proceed further. I got the following error: **com.sunopsis.sql.c: com.ibm.db2.jcc.DB2Driver** com.sunopsis.sql.c: com.ibm.db2.jcc.DB2Driver at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.j ava) at com.sunopsis.sql.SnpsConnection.testConnection(...
Started 2 weeks, 1 day ago (2009-12-15 03:52:00)
by user8849294
Hi all, I am new to this technology.I want to configure my IBM db2 data base with oracle data integrator.I have installeled IBM db2 & ODI on my machine.I am trying to create repositories but how to do it for IBM db2. My task is.. 1)creating the repository for IBM db2. 2)Configuring it with ODI 3)Exporting the dump data to IBM db2 database Thanks in ...
Started 3 weeks, 4 days ago (2009-12-04 15:23:00)
by kcakir
Hi! I try to install db2 9.7 express -c in ubuntu linux but when i execute sudo ./db2setup command it brings the first screen but nothing else. It creates db2setup.err file in tmp directory inluding the following message Exception in thread "main" java.lang.NullPointerException at com.ibm.db2.install.core.PreLaunch.initialize(Unkn own Source) at DB2Setup.doInstall(Unknown Source...
Started 1 month, 2 weeks ago (2009-11-11 13:18:00)
by StevenRC
Hello. I'm new to db2, I'm using the IBM.Data.DB2 libraries. When I call a Stored Procedure with no parameters, it succeeds . When I call db with command text, it succeeds (IE: SELECT * FROM TABLE) However, When I call a Stored Procedure with parameters, It fails . I need to be able to call a sproc with Parameters Here is the error I recieve when calling a sproc ...
Started 1 month, 4 weeks ago (2009-11-02 05:42:00)
by chribicus Junior Member
Hi, I'm trying to connect my transformation to an IBM DB2 database. But my URL, which work correctly when I use it for a JBDC connection, does not contain a port number (jdbc:db2://hostName/databaseName). In Pentaho Data Integration, The URL contains necessarily a port number. How can I configure a new connection to DB2 bypassing this limit please ? Thank you, Ahmed
Started 1 month, 4 weeks ago (2009-11-02 05:42:00)
by chribicus
Hi, I'm trying to connect my transformation to an IBM DB2 database. But my URL, which work correctly when I use it for a JBDC connection, does not contain a port number (jdbc:db2://hostName/databaseName). In Pentaho Data Integration, The URL contains necessarily a port number. How can I configure a new connection to DB2 bypassing this limit please ? Thank you, Ahmed
Started 1 week ago (2009-12-22 20:04:00)
by godinez
Hi, probably you already know that there is a free DB2 version this is the link do download it IBM - Download DB2 Express-C - Free to develop, deploy, distribute adios GODINEZ
Started 1 day, 6 hours ago (2009-12-29 05:12:00)
by stolze
It really depends on your platform and what you want to do. Some applications need, for example, to link with libdb2api, which is not part of the "bldapp" script. Another aspect is that I wouldn't use the hard-coded path to /opt/ibm/db2/... but rather $HOME/sqllib/lib. That way, you will automatically get the correct version of the libraries in case you have multiple DB2 version installed, and...
Started 1 day ago (2009-12-29 10:29:00)
by Stealth_DBA
That is correct. For the current year do not subtract 1 year from the CURRENT DATE. Here is a link to the DB2 (V9.7) Information Center that lists all the Scalar Functions: Scalar functions - IBM DB2 9.7 for Linux, UNIX, and Windows Since you are not sure of what version of DB2 you are accessing, some of these may not work. The Date/Time functions are relatively easy to pick ...