Category Archives: DB2

IBM DB2 related entries

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

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

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

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

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

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

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

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

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

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

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