Category Archives: DB2

DB2 10.5.6 – db2val failing afer fresh install

Posted on 23.8.2015 by admin

That feeling you have brand new version. Very common setup, after install steps. And surprise!! db2val is yelling „discrepancies found“! 🙂

Posted in DB2 | Leave a comment

DB2 – Transparent Data Encryption (DB2 10.5.5 on SLES12)

Posted on 31.1.2015 by admin

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 →

Posted in DB2 | Leave a comment

db2setup – invalid hostname in a first setup window

Posted on 29.11.2014 by admin

„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 =

-a-

Posted in DB2 | Leave a comment

DB2 – „Virtual storage or database resource is not available“ error

Posted on 8.10.2014 by admin

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.

Posted in DB2 | Leave a comment

DB2 data sampling

Posted on 7.4.2014 by admin

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 →

Posted in Databases, DB2 | Leave a comment

DB2 – column encryption

Posted on 11.2.2014 by admin

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.

Posted in Databases, DB2 | Leave a comment

DB2 10.5 communication (server<-->client), Debian 7.2 x64

Posted on 4.2.2014 by admin

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.

Posted in Databases, DB2 | Leave a comment

How DB2 stores data

Posted on 28.1.2014 by admin

Second visit in enterprise level database software area 🙂 What about simple varchar saving in datafile in an IBM flagship? Let´s see!

Posted in Databases, DB2 | Leave a comment

DB2 10.5 install (Debian 7.2 x64) in text mode

Posted on 28.1.2014 by admin

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….

Posted in Databases, DB2 | Leave a comment