Posted on Monday, 24th August 2009 by Balazs
Intro
One of the great features of DB2 is that it can be extended with custom code using SQL, C/C++, Java and COBOL. One of the great new features added to DB2 in 9.7 is the ability to run native Oracle PL/SQL code, that capability opens up a world of possibilities, and at the same [...]
Tags: DB2, DB2 9.7, IBM, Java, UDF
Posted in DB2 | Comments (Comments)
Posted on Wednesday, 5th August 2009 by Balazs
Infoworld’s Pete Babb has an article about IBM to acquire analytics firm SPSS. Pete sees this acquisition by IBM in line with the earlier acquisition of Cognos also by IBM. He underlines that the key aspect of this acquisition is the focus on predictive analysis. IBM clearly shows a preference for solutions [...]
Tags: Analytics, DB2, IBM, SAS, SPSS
Posted in DB2, Technology | Comments (Comments)
Posted on Sunday, 31st May 2009 by Balazs
I found this info in the PostgreSQL archives. Here are 2 methods:
Best method from Dan Lyke: Apache::DBI will pool across Perl programs, and you don’t have to change anything in your scripts.
Next best method from Gilles DAROLD: in your perl script use the following code
use vars qw($dbh);
$dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd);
These can be use [...]
Tags: Apache, DB2, DBI, IBM, mod_perl, PostgreSQL
Posted in DB2, Perl | Comments (Comments)
Posted on Sunday, 3rd May 2009 by Balazs
To delete records where only a field is duplicated, we can use a similar technique to the general duplicate removal technique:
CREATE TABLE temp AS SELECT DISTINCT ON (email) * FROM table_to_deduplicate;
DROP TABLE table_to_deduplicate;
ALTER TABLE temp RENAME TO table_to_deduplicate;
Be mindful of the fact that this process will not preserve the constraints on the original table. So [...]
Tags: DB2, IBM, MySQL, Oracle, PostgreSQL
Posted in DB2, Technology | Comments (Comments)
Posted on Sunday, 3rd May 2009 by Balazs
To delete dupplicate records in SQL, the following sequence of commands will do the trick:
CREATE TABLE temp AS SELECT DISTINCT * FROM table_to_deduplicate;
DROP TABLE table_to_deduplicate;
ALTER TABLE temp RENAME TO table_to_deduplicate;
Be mindful of the fact that this process will not preserve the constraints on the original table. So if you have indexes, NOT NULL attributes, primary [...]
Tags: DB2, IBM, MySQL, Oracle, PostgreSQL
Posted in DB2, Technology | Comments (Comments)
Posted on Friday, 1st May 2009 by Balazs
Allowing client machines to connect to a DB2 database is not as simple as regular databases. If you are using a client application, such as a Java web application, usually the application server has what is needed to configure a DB2 connection pool. However, if you need to access DB2 from the command [...]
Tags: DB2, IBM
Posted in DB2 | Comments (Comments)
Posted on Monday, 13th April 2009 by Balazs
When trying to LOAD table data where one of the rows are generated, DB2 9.1 and 9.5 on Linux and AIX will crash if the generated field uses a user defined function (fenced or unfenced). IBM is aware of the issue, and the following APARs exist to track the problem:
V9.1 APAR is IZ48197
V9.5 APAR is [...]
Tags: DB2, IBM
Posted in DB2 | Comments (Comments)
Posted on Thursday, 26th March 2009 by Balazs
PostgreSQL and DB2 use different styles of conventions to represent NULL. In PostgreSQL, the convention is to have “N” in the data to be loaded with the COPY command. In DB2, the LOAD command can be set to consider and empty field as NULL. Thus, to convert from DB2 to POstgreSQL style [...]
Tags: DB2, IBM, PostgreSQL
Posted in DB2 | Comments (Comments)
Posted on Wednesday, 18th March 2009 by Balazs
After a fresh install of DB2 Express C (free download from IBM) 9.5.2 on Linux AMD 64bit, I got the following error trying to load some tables for testing:
SQL3500W The utility is beginning the “LOAD” phase at time “01/22/2009
07:40:27.557594″.
SQL0958C The maximum number of open files has been reached. SQLSTATE=57009
After some investigation, I [...]
Tags: DB2, IBM
Posted in DB2 | Comments (Comments)
Posted on Tuesday, 17th March 2009 by Balazs
To retrieve to list of tables in DB2, you need to use the system tables, and then a little bit of sed. Here is how it goes:
db2 “SELECT tabschema || ‘.’ || tabname FROM syscat.tables” | sed -e ‘/ //g’
You can redirect this into a file, and you may need to cut off the first [...]
Tags: DB2, IBM
Posted in DB2 | Comments (Comments)