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
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
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
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
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
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
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
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
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
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