Greetings,
Ok, so I've managed to get the user passwords issue from my previous post sorted. However, now I get the following error when I try to connect to the database via ColdFusion:

Connection verification failed for data source: db2_sample
[]java.sql.SQLException: [Macromedia][DB2 JDBC Driver][DB2]PROGRAM NAME DEFAULT.DDTEKA 0X4A44424334444232 NOT FOUND IN PLAN null
The root cause was that: java.sql.SQLException: [Macromedia][DB2 JDBC Driver][DB2]PROGRAM NAME DEFAULT.DDTEKA 0X4A44424334444232 NOT FOUND IN PLAN null

I'm using the sample database that was created during the installation of Ver.8 Personal Edition.

Can someone point me in the right direction here? I'm a complete newbie to DB2 (clearly).

Well, it turns out all I needed was an update for the version of ColdFusion I'm using (MX6.1 standalone). The update includes new JDBC drivers, which someone hinted could be the issue. I did the update and now all is well