Author Archives: George Valentin Voina

Bad #mobile data #infrastructure generates Frankenstein solutions

By | January 31, 2018

This product Zifilink is so weird that I am doing free advertisement for it. This is what happens when there are lots of mobile providers in a market and all have shitty mobile data signal. I present you the “make your own mobile gigabit” with a dongle Frankenstein tree 🙂 Come on ! look at… Read More »

#ubnt made my Holiday better.

By | January 31, 2018

I hate when you go on Holiday outside EU and your internet sucks and data roaming charges would cover Mars roaming. Lucky for me this is what I noticed in my nice Mauritius Holiday, they discovered Ubiquity devices 🙂 I think I counted like 20 UBNT Wi-Fi repeaters throughout the resort, in the palm trees.… Read More »

IT Traveller: #Failed airport #technology (Istambul)

By | January 11, 2018

I travel quite often across the world for job related purposes. Being an IT guy that does servers installations, develops and deploys enterprise software across the world I am always noticing everything that is IT related. It is always fun to see failed tech in airports I transit or in hotels where I stay. This… Read More »

#WordPress weather map plugin attack detected in #wordfence live traffic

By | January 10, 2018

Going through my Wordfence live traffic view is a nice way to see the daily fad of Chinese script kiddies. WordPress is one of the main targets of people trying to access your data. Obviously if you have a blog you must be sure you run an A+ certified security setup. See my other posts… Read More »

Map #Docker container ports to virtual IPs in Linux with docker-compose

By | February 15, 2018

Sometimes you need to export multiple instances of the same service with a specific IP using same port outside of a docker swarm environment. Using docker swarm environment is easy to have several instances of the same service exporting some API on the same port. The swarm will take care of load balancing the services… Read More »

Using temporary indices to optimize DELETE operations on big tables in #DB2

By | December 18, 2019

DELETE operations are much faster in case we disable constraints. This is because not all foreign keys affected by the DELETE are indexed. We have to detect all the foreign keys that point to the table from where you delete data. The we can create temporary indices to help speed up the delete. STEP 1.… Read More »

Optimizing DELETE operations on big tables in #DB2

By | November 21, 2017

Deletes go very slow if the log buffer size is too small and we delete lots of data from big tables. It is very important to have the right settings for log buffer size to avoid having to frequent writes to the disk, writes that cause a high IO traffic that will slow down the… Read More »

Fix #DB2 SQL1639N ( SQLCODE=-1639, SQLSTATE=08001, SQLERRMC=null) authentication issue

By | November 21, 2017

After migrating my full DB2 backup (binaries and data) to a new server I got into several issue. One was already described in the previous post here. ISSUE: Even after fixing that start issue I was still not OK. My WebSphere data source that linked to the DB2 instance was not responding. Trying to ping… Read More »