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.

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

Why won’t SQL accept my value? Msg 8115, Level 16, State 8

Arithmetic overflow error; converting it to data type numeric Understanding Decimal and Numeric arguments The problem: Entering a number in a field that is data type of decimal (5, 3) works for values like [85.200] but not others like [500]. The Cause: The arguments... read more