Category: SQL Error Messages

3

A Couple of db2look Problems

I recently ran into a couple of db2look problems for different clients, and thought I’d share them in case someone else runs into them. db2look is a tool used to mimic databases, objects, or statistics. If you are not familiar with it, check out my post on DB2 Basics: db2look. db2look Problem with Packages Bound This problem occurred when I...

2

Binding DB2 Base Packages for Various Versions

When connecting between different versions of DB2, you generally need to bind packages from the different versions against the DB2 database. Just because you’ve bound db2ubind and db2cli on the server does not mean that all possible clients connecting in are covered. Sometimes binds happen implicitly, but sometimes they don’t. And you don’t necessarily want to grant a user rights...

4

SQL5005C and Ulimit Issues

I’m spoiled. While we build a fair number of environments each year, we also have basic starting standards. Because of this, I sometimes miss the basics when a problem shows up. Or at least it takes me longer to get there. In this case, we had a couple of alerts over the high-volume weekend (Black Friday 2013). They were alerts...

4

Binding Packages

I approach binding from a physical/system DBA point of view. I’m not an application developer, and don’t understand all the possible intricacies of binding. But there is some information and tips I can share on binding packages in DB2. There are definitely some application developer topics included here. Static vs. Dynamic SQL This is a basic division in how SQL...