A primer in awk for DB2 LUW DBAs

Although awk and awkward start with the same three letters, awk by no means is awkward. Well, from the syntax of it (and I agree, sometimes, from its learning curve), it could be appear to be so. In this blog post, I share how awk’s most basic features could be powerful tools to get things done faster.

I use awk in many of my UNIX scripts that I write to automate routine tasks. In addition to this, I routinely write awk one-liners to save time. Many times, these one-liners are throw-away in that the same exact awk command might not be used again.

Continue reading


DB2 LUW – Handling database objects with mixed case and special characters in their names

Handling tables (or other database objects) that have mixed case names and/or with special character(s) in their names needs special effort. In this blog post, we will look at our options; essentially, what works and what does not work.

Continue reading

DBA tip – Easy way to handle single quotes in awk

It is no wonder that I cannot live without awk even a single (working) day in my life. Such is the power of awk (or AWK). It is simply the most powerful utility that I use on *IX (Linux/AIX) systems. awk makes my life easy when dealing with daily DBA tasks. I learned awk almost 10 years ago and I admit that it was tough to get used to its syntax. However, once I knew few basics, it was fun.

Continue reading

DBA’s friend — UNIX’s crontab utility

There are many tools and utilities that simplify routine tasks and empower DBAs to automate tasks and get the job done. One of them is UNIX’s crontab utility. Colloquially, this is referred to as ‘Cron’ . In this  blog post, first I will introduce few basics about crontab. We will then look at few gotchas to watch out for when using crontab in UNIX environments. Continue reading

Replacing a string in multiple files in AIX — perl vs. sed

I had an interesting situation this morning when I had to replace string ‘db2inst1’ in multiple files with another string ‘db2inst2’. I was working on an AIX server. I wanted to do an in-place replace. In-place replaces the file with new content.

I gave Linux’s in-place replace (option ‘-i in sed) a try and here is what I got:

$sed -i 's/db2inst1/db2inst2/g' *
 sed: illegal option -- i
 Usage: sed [-n] [-u] Script [File ...]
 sed [-n] [-u] [-e Script] ... [-f Script_file] ... [File ...]
 Continue reading