Category Archives: Mac OS X

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

Using the PayPal express checkout API in Perl

Perl API for PayPal There are a number of apps written in Perl that connect to classic CC transaction gateways. Meanwhile, PayPal has become so inexpensive, that a number of merchants can save significant amounts by switching to PayPal. The … Continue reading

Posted in AIX, Hosting Support, Linux, Mac OS X, Managed Hosting, OpenBSD, Perl | Tagged , , , , , | Leave a comment

Migrating Data to DB2 9.7 LUW

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

Trouble shooting sendmail base configuration

There is a simple command that can be used to make sure that the basic configuration of sendmail is correct: echo \$Z | sendmail -d0.1 The output of that command should look like: Version 8.13.1 Compiled with: DNSMAP HESIOD HES_GETMAILHOST … Continue reading

Posted in AIX, Cloud Computing, Collaboration, Linux, Mac OS X, Managed Hosting, OpenBSD | Tagged | 1 Comment

Get grep right

Problem When you look for a process in the ps output, the command line of grep often shows up: ps auwwx | grep sshd root 648 0.0 0.0 3732 1012 ? S Apr06 0:00 /usr/sbin/sshd user 20807 0.0 0.0 4836 … Continue reading

Posted in AIX, Linux, Mac OS X | Tagged | Leave a comment

Create Explain Tables in DB2 9.7

Problem The explain tables allow to create access plans and visualize them. Before the explain feature of DB2 can be used, the EXPLAIN tables need to be generated. Solution To create the EXPLAIN tables, the following command needs to be … Continue reading

Posted in AIX, DB2, Linux, Mac OS X, Windows | Tagged , | Leave a comment

Netapp Automation for DB2 9.7 (or Oracle)

Problem You have one or more NetApp storage systems (F960 or later series), running Data ONTAPĀ® 7G (or later). You would like to take advantage of the snapshot capabilities, to facilitate the database backup process. However, you don’t want to … Continue reading

Posted in AIX, DB2, Linux, Mac OS X | Tagged , , , | Leave a comment

Migrating a directory to a separate filesystem on AIX

Problem You have a directory that deserves it’s own file system for some reason. This could be because you need to increase throughput, manage backups separately, manage quotas separately or just to have a cleaner data architecture. Solution Create a … Continue reading

Posted in AIX, Linux, Mac OS X, OpenBSD | Tagged , , , | Leave a comment

NetApp bonded VLAN configuration

Problem To maximize the benefit from the multi-port adapters on a NetApp, it is best to bond the ports together (some vendors refer to this as “trunk groups”). Then over the new bonded trunk, the various networks can be assigned … Continue reading

Posted in AIX, Linux, Mac OS X, OpenBSD, Windows | Tagged , | Leave a comment

Installing DB2 Express C 9.5 on Mac OS X 10.6

OS X developers do not need to use a virtual machine any longer to be able to run DB2 in their favorite development environment. The latest version of DB2 9.5 available for download works on Snow Leopard (OS X 10.6). Continue reading

Posted in DB2, Mac OS X | Tagged , , , | 2 Comments