Category Archives: DB2
That feeling you have brand new version. Very common setup, after install steps. And surprise!! db2val is yelling „discrepancies found“! 🙂
I was involved in software evaluation focused on TDE (Oracle, SQLServer, DB2) few months ago. I was really surprised that DB2 was lacking this feature within database package and it was needed to use another IBM product. With 10.5.5 version … Continue reading
„The host name ‚myHost‘ is invalid. Ensure the host name resolves to a valid ip address. Specify a valid host name and rerun the command.“ = loopback is not associated with hostname. Solution =
echo "127.0.0.1 $HOSTNAME" >>/etc/hosts
Default DB2 DB and DBM variables are set pretty well and logical. The only manual adjusting can occur when you’re trying to overload transactions a bit. For example by copying tables.
Sometimes it would be very helpful to have a chance gather sample values. What if rownum limitation affects quality of records? What if the main table logic is residental in the middle of huge table? Welcome to data sampling world … Continue reading
Column encryption is one of the oldest encryption method in this product, I think deprecated should be the right position in encryption level in these days. Anyway – it can be really handy to use it for storing sensitive data.
We have „almost“ fresh DB2 install in our Debian environment, running in VirtualBox. Well, now we want to have this db2 instance as server and client (host) would be connecting into server from some GUI. Few steps are necessary.
Second visit in enterprise level database software area 🙂 What about simple varchar saving in datafile in an IBM flagship? Let´s see!
There are 2 options for installing DB2 on linux machine – with GUI setup (Java forever) or in text mode. According praxis, text mode is usable in 100% cases so….