Marc Petros

Junior DBA

Marc Petros is a junior DBA for XTIVIA, primarily working with Db2 for the VDBA team. He’s well-versed in Db2 and also has significant experience in PostgreSQL and Microsoft SQL Server. With a certification in MS MTA database fundamentals — and working towards his Db2 LUW Fundamentals certification — Marc scripts, sets permissions, and maintains client records/settings for VDBA. In his free time, he enjoys reading, writing, and spending time with his two children.

How to Build a CockroachDB Sandbox on Windows

Setting up a lab environment on your local machine to run CockroachDB is very helpful for learning about this exciting database platform and testing applications locally. This article outlines the procedure for setting up a local installation of CockroachDB on a... read more

Investigating Locking in Db2

The purpose of this article is to provide guidance on the various ways available for getting basic information about locking events in a Db2 database. Where possible the information gathered allows for targeting a specific table. The information provided by these... read more

Writing SQL with SQL

The Db2 RDBMS offers many great tools for getting things done. There are, however, times when tools are unavailable. This isn’t a problem when you’re performing a simple and discrete task. When the task has many iterations then like dropping triggers or granting... read more

Three Text Highlighting Tricks with PuTTY

PuTTY is a free, cross-platform terminal program that supports SSH, telnet, and raw socket connections. For authentication it supports public key and kerberos single-sign-on. This application, is one of the oldest clients for Microsoft Windows, released by Simon... read more

Working with Crontab Files

The purpose of this article is to review the three approaches to working with crontab. The first is the mainstream proposed best practice of using crontab -e. The second is to edit the crontab file directly. The third method is to use your text editor to create files... read more

Db2 System Authorities

How do I grant a user SYSADM, SYSCTRL, SYSMAINT, or SYSMON privileges in Db2? As a newbie to the database administration world, I was tasked with giving a pretend user the ability to create databases in a virtual environment setup for learning. I easily found that the... read more