Category: Newbie

3

Technical Conference – It’s a skill builder, not a trip to Vegas.

What is the first thing you think of when someone says “technical conference”? Those who have attended a few technical conferences think of hours of session material, hands on labs, networking events, and coveted swag from the vendor Expo. Those who have not attended a conference may not know what to expect. Managers, who may have been out of the...

0

Getting the Most out of DB2 Support

This post is inspired by an email from a reader. Let me first say that every software support team everywhere is complained about by someone. I’ve dealt with Oracle support, so I appreciate DB2 support all the more. For those of us who work with DB2 every day and have for 5 or 10 years or more, we really do...

3

Installing DB2 Using a Response File

Some friends on Twitter were commenting that db2_install is not just deprecated in DB2 10, but is fully discontinued and not available. Melanie Stopfer mentioned this on her webcast on June 22. I do dozens of installs a year, and most of them are using a response file. The same response file, actually, since a standard starting point makes sense at...

0

Why DB2 Certification is Cool

You may have noticed that I’m down to one new post a week at this point. I have two big excuses. The first is that I had a big go-live last week that required the movement of user data from one WebSphere Commerce database to another on a more recent version of Commerce, a more recent version of DB2(8.2 to...

1

How to Download DB2 FixPacks via FTP

Just a simple post here, but you used to be able to fairly easily find the link for FTPing Fix Packs. Since I work from home, downloading and then uploading code is rather slow. If I can manage to go directly to the target server, I can save literally hours. With the introduction of “Fix Central”, DB2 Fix Packs are...

1

DB2 Clients

So there are a few topics I wanted to cover relating to DB2 clients and how Commerce uses them. Type 2 vs. Type 4 drivers So strictly speaking, this is referring to the JDBC driver being used. Type 2 JDBC drivers are the traditional kind that require having a DB2 client installed, and the databases properly cataloged within that DB2...

1

How to restore a 64-bit database into a 32-bit instance using a compressed backup

This one seems to baffle some, though like redirected restores, it’s something that is only tough the first few times. If you attempt to restore a 64-bit database on a 32-bit instance using a compressed backup image, you get this scary error message: SQL2570N A database cannot be restored on a platform that does not match the platform on which...