Category Archives: DB2

IBM DB2 related entries

Installing a Secure Certificate on IBM Smart Business Server (VERDE)

Posted on 2011/05/23 by Balazs

At the time of this writing, the IBM Smart Business Server’s control panel doesn’t allow importing a secure certificate (SSL cert). Never-the-less it is possible to install a valid (CA signed) secure certificate from the command line. This article assumes … Continue reading →

Posted in Business Intelligence, Cloud Computing, Cognos 10, Collaboration, Data Warehouse, DB2, Dedicated Servers, Domino, Hosting Support, Java, Linux, Managed Hosting, Windows | Tagged , , , | Leave a comment

Updated IBM DB2 e-kit for Database Professionals

Posted on 2011/03/04 by Balazs

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 … Continue reading →

Posted in Data Warehouse, DB2, Hosting Support | Tagged , , | Leave a comment

Java Shopping Cart and eCommerce Solutions

Posted on 2010/12/07 by Pete

Java Shopping Cart Hosting The need to host a shopping cart comes up on a regular basis. There are literally hundreds of very good solutions out there. Here is a list of carts that satisfy the following criteria: – configurable … Continue reading →

Posted in AIX, Cloud Computing, Data Warehouse, DB2, Dedicated Servers, Hosting Support, Java, Linux, Managed Hosting | Tagged , , | 1 Comment

Updating the Rate Sheet in the COGEXO Rating Engine

Posted on 2010/11/09 by Pete

Rate table update on MySQL backed database The concepts in this guide apply for the DB2 version of the rating engine. Data Fromat product_code_call,description,cost,call_type Data Upload For the MySQL back-end, use phpMyAdmin to upload the data: Log in to phpMyAdmin … Continue reading →

Posted in Business Intelligence, DB2 | Tagged | Leave a comment

Migrating Data Between DB2 Servers

Posted on 2010/10/28 by Pete

DB2 Support for Data Migration When it is time to upgrade from DB2 on Intel to DB2 on Power for example, taking a backup/restore approach isn’t possible as DB2′s backups are platform dependent. The solution is to use a DB2 … Continue reading →

Posted in AIX, Business Intelligence, Cloud Computing, Cognos 10, Data Warehouse, DB2, Linux, Mac OS X, Managed Hosting, Windows | Tagged | Leave a comment

Planning for Storage, Server, and Network Infrastructure

Posted on 2010/10/27 by Pete

Questions to ask when planning storage and server infrastructure Storage Requirements What our their current storage environment? (What technology do we use? NetApp, EMC, HP, Hitachi, Compellant?) What is our current amount of usable storage? What is our current data … Continue reading →

Posted in AIX, Cloud Computing, Collaboration, Data Warehouse, DB2, Dedicated Servers, Managed Hosting, NetApp, OpenBSD, Windows | Tagged , , | Leave a comment

NetApp downgrade firmware

Posted on 2010/10/25 by Pete

Downgrading firmware on a NetApp SAN If you have just reclaimed a shelf from a NetApp SAN that you would like to use with an older head, you will notice that the drives are not recognized. This is due the … Continue reading →

Posted in AIX, Cloud Computing, Data Warehouse, DB2, Hosting Support, Linux, Mac OS X, Managed Hosting, NetApp, Windows | Tagged | Leave a comment

NetApp route add default gateway

Posted on 2010/10/24 by Pete

NetApp SAN default gateway setup DataOntap is a FreeBSD based operating system built by NetApp. However, most of the command line interface commands differ from the usual FreeBSD commands. When a new NetApp installation is performed, or a NetApp migration … Continue reading →

Posted in AIX, Cloud Computing, Data Warehouse, DB2, Domino, Hosting Support, Linux, Mac OS X, Managed Hosting, NetApp, OpenBSD, Windows | Tagged , | Leave a comment

Understanding Business Intelligence

Posted on 2010/10/23 by Balazs

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 … Continue reading →

Posted in Business Intelligence, Cognos 10, Data Warehouse, DB2 | Tagged , , , , | Leave a comment

Installing Informix IDS 11.x on Mac OS X

Posted on 2010/09/19 by Pete

Problem Installing IDS 11 on Mac OS X Solution After installing the server, update the sqlhosts file and replace the default host name by * so that the server listens on all IPs. The sqlhosts file may be names sqlhosts.ol_server_name, … Continue reading →

Posted in DB2, Java, Mac OS X, Technology | Tagged , , , | Leave a comment