Four solutions from NewPush have been approved by IBM. The solutions are now featured on the IBM Showcase website: Hosted Lotus Connections 3 Hosted VDI – IBM Smart Business Server 2 Hosted DB2 10.5 (SaaS) Hosted Domino Mail, Collaboration, and Knowledge Management 8.5.3
Updated IBM DB2 e-kit for Database Professionals
Refresh of the DB2 e-kit As a follow up to the DB2 Discovery Kit post, here is a link the the Updated IBM DB2 e-kit for Database Professionals This new kit has a number of resources for migrating to DB2 from other databases, such as Oracle.
Understanding Business Intelligence
What is Business Intelligence? From the thread “My Quest for Understanding Business Intelligence” this comment was posted by Leslie Dudley: Business Intelligence Background A little off topic perhaps, but as an IT business intelligence worker who was interviewing during the economic downturn, I have a slightly different perspective. First, I found myself to be fortunate [...]
DB2 Query Writing Best Practices
Problem Writing efficient SQL SELECTqueries for DB2 can be tricky. Some general SQL guidelines apply, and there are also specific practices that apply only to DB2. Solution Here is a list of tips you can use to write good SELECT queries: Avoid SELECT * in your queries. Instead, state the columns you want to select. [...]
Creating a User Defined Function (UDF) in Java for IBM DB2 9.7
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 [...]
IBM Expands in Analytics Market
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 that work best [...]
Connection pooling with mod_perl
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); [...]
How to delete records with duplicate fields, such as dupplicate emails?
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 [...]
How to delete dupplicate records in DB2, Oracle, MySQL, and PostgreSQL
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, [...]
DB2 Client Install on Linux
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 line, the [...]