Category Archives: Databases

PostgreSQL 9.5 First Impression

There are many ways how one can be impressed by software product. Size of package, company/community promotion, installer functions + user/friendly UI, etc. I like PostgreSQL, no doubt about it – so let’s check how is it packed by Enterprise … Continue reading

Posted in PostgreSQL | Leave a comment

PostgreSQL’s inspiring…

With no doubt PostgreSQL really can be „the World’s most advanced open-source database. At least, this database  inspired many developers to adjust it for their purposes. Tiny article, link collector 😉

Posted in PostgreSQL | Leave a comment

DB2 10.5.6 – db2val failing afer fresh install

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)

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

Lightning MariaDB install (Manjaro openbox 0.8.11)

-a-

Posted in MySQL | Leave a comment

TokuDB 7.5.3 (MySQL 5.5.40) on Oracle Linux 6.6

Fascinated by fractal trees? Astonished by TokuDB storage engine? Watching new trends where MySQL/MariaDB serves as baseline and competitive advantages are based on storage engines? Welcome! 🙂

Posted in MySQL | Leave a comment

db2setup – invalid hostname in a first setup window

„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

Master-master replication (MariaDB on Manjaro)

Sometimes it’s very useful to skip well-known master-slave replication scenario and focus on master-master possibility 🙂

Posted in MySQL | Leave a comment

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

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

Oracle Database 11.2.0.4 install on Oracle Linux 6.5 (x64)

There are installing processes that I really do love (DB2) and on the other side there are install processes which I really hate (Oracle Database). Bright and dark side of database software in linux world. Let´s uncover one of the … Continue reading

Posted in Databases, Oracle | Leave a comment

Change data directory – MariaDB 10.0.x

One of most valuable thing is good documentation – for common database actions. I didn´t find any well documented step-by-step guide to change data directory in MariaDB, Debian environment. Please be aware that this one guide is not perfect and … Continue reading

Posted in Databases, MySQL | Leave a comment

MariaDB 10.x install – Debian 7.4 x64

As Debian is still using MySQL in default, there are very few steps to install MariaDB 10.x…

Posted in Databases, MySQL | Leave a comment

Change data directory – PostgreSQL

Useful and common task, should be well documented. Let´s try it! Debian 7.4 x64, PostgreSQL 9.3.2

Posted in Databases, PostgreSQL | Leave a comment

DB2 data sampling

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

OpenSUSE 13.2, PostgreSQL installation (by zypper)

I love linux distributions alpha-releases. They are commonly more stable than any Windows family operating system + provides interesting new features sometimes. OpenSUSE 13.2 Milestone 0 was released 19.3.2014, providing btrfs as default file system, few minor changes and rolling- … Continue reading

Posted in Databases, PostgreSQL | Leave a comment