Aqua Data Studio 15.0.11 running in PC-BSD 10.1

Know that kind of concerns? You bought really expensive license for great software…. changed operating system… and just rely that if it is written in Java, it can’t be problem to use it. Agreed.

Continue reading

Posted in Applications, BSD | Leave a comment

PC-BSD 10.1 – customizing powerd

Know that feeling that something is just different while using new operating system? Ok, fan is running and – indeed – it is caused by power (non-)saving features in default setting (at least in my case). How to solve it and make your laptop quiet?

Continue reading

Posted in BSD | Leave a comment

PC-BSD 10.1 as main operating system ?!

Getting rid of kernel fixing (dividing by zero), kernel versions, unbelievable bugs on every step, poor disk setting (file system), poor security (shell shock, remember?)? Ok, I tell you something. I switched from linux(thx for 15 great years anyway!) to BSD in about 2 hours with no mercy and I’m happy 😀

Continue reading

Posted in BSD | 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 🙂

Continue reading

Posted in MySQL | Leave a comment

Oracle jdk 8u25 running on OpenSUSE 13.1

As you probably know, Oracle denied to distribute jre/jdk of Oracle Java directly in linux distributions. Exchange with OpenJDK packages was cruel, anyway there are few ways how to install original Java environment again.

Continue reading

Posted in Linux | 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.

Continue reading

Posted in DB2 | Leave a comment

Shrinking linux .vdi (convincing host fs to claim real size, not more :-) ) in Virtualbox

Maybe you know it – virtual linux machine is used for anything (installing Oracle for example) – and its size says something about 12GB /df -h/ – what a surprise that your host OS is allocating around 25GB and still wants more, more, MORE!!! 🙂

Continue reading

Posted in Linux, Virtualbox | 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 most tricky installer I know… 🙂

Continue reading

Posted in Databases, Oracle | Leave a comment

Oracle Java 1.8 JDK installation (Debian Jessie alpha)

As you know, Openjdk is spammed through all main linux distributions. If you like Oracle (eh) or just want to have good old Sun java, not slow Openjdk…. and you are really lazy, check this out 🙂

Continue reading

Posted in Linux | Leave a comment

Disk benchmarking – Bonnie++ (OpenSUSE 13.1)

If you think that simple „dd bs=1M count=512 if=/dev/zero of=test conv=fdatasync“ disk benchmarking is not enough – you’re completely right. There are not so many tools benchmarking your disk, one of the most used is Bonnie++.

Continue reading

Posted in Linux | 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 some hidden traps can be found there. I have a dream to have some scripts for these basic database tasks…. 🙂

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…

Continue reading

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

Continue reading

Posted in Databases, PostgreSQL | Leave a comment

Why am I using XFS?

I must admit I´m really conservative person in many ways. I´m using XFS almost from my linux beginnings, from 2001, when this file system was released for masses 🙂

Continue reading

Posted in Linux | 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