Archive | DB2 RSS feed for this section

Cognos 10.1 install on CentOS 6.3 64 bit

yum update (then reboot if kernel has been patched) yum install glibc.i686 yum install openmotif yum install libgcc.i686 yum install openmotif22 yum install openmotif22.i686 yum install xauth yum install libXtst tar xvzf bisrvr_linuxi8664h_10.1.1_ml.tar.gz cd linuxi38664h/ ./isetup


Leave a comment Continue Reading →

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 that the reader is familiar with SSL and the basic SSL KEY, CSR, and CRT [...]


Leave a comment Continue Reading →

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.


Leave a comment Continue Reading →

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 – customizable – embeddable – has a flexible API – compatible with IBM DB2 – [...]


Leave a comment Continue Reading →

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 Select the rate table Click the import tab Select the file that has the comma [...]


Leave a comment Continue Reading →

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 command called db2move. Basics of db2move db2move allows to export data from DB2 at different [...]


Leave a comment Continue Reading →

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 in GB / TB? How much of that data is deemed critical as opposed to [...]


Leave a comment Continue Reading →

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 the fact that DataOntap upgrades the drives automatically when you plug them in to an [...]


Leave a comment Continue Reading →

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 is needed, typically the IP address needs to be changed, as well as the default [...]


Leave a comment Continue Reading →

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 [...]


Leave a comment Continue Reading →