Skip to content

Some Quick Tips for DB2 for z/OS DBAs

June 12, 2017

Before I became an expert on DB2 LUW I was a DB2 for z/OS Database Administrator and DB2 systems programmer. I see lots of questions lately from current DB2 for z/OS DBAs picking up responsibility for a DB2 LUW installation and they ask where they should start, that because it is on LUW they must do something different. Well it is really quite simple,  all the things that are important on the mainframe DB2 are as important on DB2 LUW. Things like reorgs, backups, monitoring, SQL tuning, support of application developers, etc are the same, just how you do it on DB2 LUW might be different. So it is easy to learn how to do a reorg, how to determine if a reorg is required, what type of backup to use, and how to monitor SQL, just the interfaces are different but all the things that must be done on z/OS must be done on LUW. After you learn the way to do these things on LUW then and only then start to learn about the LUW Operating Systems and the various scripting languages you might need. Lots of folks get a mental block about UNIX or Linux and can’t see the forest because of the trees…..So, in closing, learn how to do all the DB2 important things on DB2 LUW then worry about learning UNIX or Linux.

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: