Berts Blog

path too long to delete 27

Path too long? Use Robocopy

Having issues deleting a folder or a file? Are you getting messages about filename too long or path too long? Then read on for a simple solution. In Windows and DOS, there is a...

VHDxToVHDfeaturedPic 2

Convert VHDx to VHD

Introduction For a project I needed to import a VM created on Hyper-V (Windows only) from which the HD format was VHDx into my Mac. On my Mac I’m using Parallels version 10. This...

self-control 0

Automatic Table Maintenance Self-controlled

Using DB2 automatic table maintenance and want to get more control or simply control it yourselves? Still manually checking if a table or index is in need of reorganization and getting tired of it?...

statement performance 0

JDBC Statement Cache

Introduction Java Database Connectivity (JDBC) is an application programming interface (API) that Java applications use to access local or remote relational databases. The JDBC API consists of a set of interfaces and classes written...

statistics 2

Runstats on data change percentage

As always I like to be in control of stuff, just to know what is happening and thereby preventing unexpected behavior. Same goes for maintenance tasks. Collecting statistics on your tables for example. I...

drone 2

Great things with drones

Drones are great! The are so many great things you can do with drones, especially when they’re equipped with a camera. Dennis, someone within my family, is one of the lucky guys owning such...

safety first 0

Safety first with BLOCKNONLOGGED

Upgrades of software often comes with upgrading the database. But what if your only allowed downtime during a certain time span? Can you complete all your upgrades within this time? When you have to...