How to setup DB2 mapping

Posted by Brett the Younger on August 21, 2008 under Web Development | Read the First Comment

After getting a new comp after infecting my old one with a nice little virus, I had to setup DB2 on my box again.  Luckily Ryan remembered how to do it, but in order to keep this information all in one place, here is the process:

Install DB2 Universal Database.  We used version 8.2

Mapping required to access DB2:
this info can also be seen at http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/db2.html
Under the command line in the db2 installation you will need to run the following commands.

create the instance alias using the following commands:

db2 “catalog tcpip node [dev_server] remote [dev_server] server 446″
db2 “terminate”

create the database alias using the following commands:

db2 “catalog database [dev_server] as [new_dev_alias] at node [dev_server] authentication server”
db2 “terminate”

After mapping reboot your computer so the necessary DLLs will be picked up.

Then you should configure your application’s hostname and database to the [new_dev_alias] unless you are using the db2u driver(in Codeigniter), in which case the [dev_server] works.

NordicTrack Promo tidbit

Posted by Dustin on August 7, 2008 under Javascript, Web Development, Websphere Commerce | Be the First to Comment

Here’s something to think about when dealing with promos that are assigned to specific products on NT (I mean the old NT cuz the new one has not and isn’t going live, something about it not officially being approved). if you create a promo to assign to a specific product, you must have a decimal value (or rather a precent value converted to decimal form, like 20% would be .2) in the Long Description field of the Promotion. The reason is there is a script that takes this value and figures out the new price as well as the savings and if this value is text then the Javascript pukes and goes into the fetal position all the while the JSP decides who cares about a price. And you conveniently get a product with no price showing on the cat page and product pages.

So if your promo includes a free item such as a bundle of iFIT cards it is best to either try leaving the Long desc field null or putting in a .00 as a value.

Of course we wouldn’t have this problem for long if the new NT was going live, but I’m not bitter about that >:(