Tag Archives: DB2

Backups using storage level snapshots for DB2 using EqualLogic

This post will detail the steps to go through to allow you to create storage level snapshots using DELL EqualLogic ASM/LE on Linux SLES 11 SP2, and then move the data off onto other storage arrays. – This is handy [...]

DB2 LDAP configuration on SLES11 SP2

Having problems with YaST wiping out your custom PAM setting for DB2 since upgrading to SLES 11 SP2?? This is a short post detailing a problem I found with the YaST method of managing manual pam/ldap configuration under SLES 11 [...]

A DB2 ETL Tool

This is going to be a really short post as it is more of a question. A request for enlightenment into what the rest of the DB2 community does in terms of getting their data from however you guys receive into your [...]

db2advis command an idiots guide

This article was prompted by the fact that the new Express-C version of DB2 uninstalls the much maligned Control Center and installs the IBM Data Studio that so far, after much reading of the reading materials, I struggle to get [...]

Can’t Believe DB2 does not have this function – Convert seconds to hours, minutes and seconds

For the third in the series and possibly the last I am going to look at the little doosie that was presented to me the other day where the seconds of time passed from a system are presented as an integer and [...]

Can’t Believe DB2 does not have this function – Friendly Dates

So our marketing gurus at where I work needed a english friendlier format (thanks @_PeUR on the description of my last post via twitter) for the text in the emails that they send out, personally I would be happy with a dd/mm/yyyy [...]

Can’t Believe DB2 does not have this function – Convert Times

Seen as though DB2 LUW has had a major update 10.1, and I have not got round to blogging about it thought there was no point as everyone else has done it to death by now and maybe I can [...]