sobota, 25. julij 2015

Bring database out of BACKUP PENDING state ASAP

If you manage to put your database into BACKUP PENDING state and want to bring it out of it ASAP you can do a backup to a NULL device:
db2 backup db MYDB to /dev/null
The backup will still read the data that should go into the backup image, but it will discard it by writing it into NULL device. In this way you can cut the unwanted downtime by about 50%-60%.

četrtek, 07. maj 2015

BOINC "Show graphics"

I'm using Xubuntu 14.04.2 and BOINC 7.2.42. I'm running SETI@Home and World Community Grid. When I click "Show graphics" on a SETI@Home task nothing happens.
If you run BOINC Manager from command line you get:
    libssl.so.10: cannot open shared object file: No such file or directory

ldd on SETI@Home executable shows:
    libssl.so.10 => not found
    libcrypto.so.10 => not found

Now you do this:
sudo apt-get install freeglut3 libssl1.0.0
cd /lib/x86_64-linux-gnu
ln -s libssl.so.1.0.0 libssl.so.10
ln -s libcrypto.so.1.0.0 libcrypto.so.10 
I'm using 64-bit Xubuntu and for 32-bit you should look for these libs yourself.

ponedeljek, 23. marec 2015

DB2 and "Error applying transforms. Verify that the specified transform paths are valid"

You can get "Error applying transforms. Verify that the specified transform paths are valid" when you want to install or uninstall DB2.
These are possible fixes:

  1. run setup.exe from installation image with /I en parameter: setup.exe /i en
  2. use a tool to fix your registry. I've used Free Windows Registry Repair.