Category Archives: Data Warehouse

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

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

Cognos and SPSS

Posted on 2010/08/24 by Pete

SPSS enables extracting the essence of the heaps of data available today, and as a result dramatically reducing the time to present actionable information to decision makers. Continue reading →

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

Migrating Data to DB2 9.7 LUW

Posted on 2010/08/07 by Pete

Problem You reached the limit or your unhappy with the performance or features of your database server, and you want to move to DB2. The transition can be simple with respect to your code, as it may be just a … Continue reading →

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

IBM Security Tools

Posted on 2010/07/29 by Pete

IBM has a comprehensive approach to encourage security by design. A free Red Book is available for developers: The IBM Redbook for Security in Development The home page for IBM’s main security testing tool is IBM Rational AppScan

Posted in AIX, Cloud Computing, Cognos 10, Data Warehouse, DB2, Java, Linux, Services | Tagged , , | Leave a comment

How to change ownership of a PostgreSQL database

Posted on 2009/05/31 by Balazs

To change the owner of a database we have found this solution: UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE usename=’new_owner’) WHERE datname=’db_name’; http://archives.postgresql.org/pgsql-admin/2003-07/msg00301.php * From: Tom Lane * To: Devrim GUNDUZ * Subject: Re: changing ownership of db * … Continue reading →

Posted in Cloud Computing, Data Warehouse, Dedicated Servers, Linux, Managed Hosting | Tagged | Leave a comment