Category: SQL Error Messages

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...

0

Tips for Using the IBM DB2 Information Center Part 3: Information Structure – Parameter and Message Reference and General Guidance

This article is the third in a series about the IBM DB2 Information Center. Please check out the other articles in this series: Tips for Using the IBM DB2 Information Center Part 2: Information Structure – System Monitor and Syntax Tips for Using the IBM DB2 Information Center Part 1: Navigating Adminstration Guide: Performance / Parameter References Man, it would...

8

Tips for Using the IBM DB2 Information Center Part 1: Navigating

Note: this post refers to an obsolete version of the IBM DB2 Knowledge center, and therefore many of the links are broken. For details on the current version, see The New IBM DB2 Knowledge Center The IBM DB2 Information Center is a wonderful resource if you know what you’re looking for. Unfortunately, sometimes you do not know exactly what you...

14

SQL1265N on Rollforward When Restoring Database From One Server to Another

As I mentioned in a recent post, I do a lot of restoring databases to get them from one server to another. On rollforward after a recent restore, I saw this: $ db2 force applications all; db2 deactivate db WC037P01; db2 “restore db WC037D01 from /app/IBM/db2/db_bkup taken at 20120723030327 into WC037P01 logtarget /app/IBM/db2/db_bkup/logs replace existing without prompting” DB20000I The FORCE...

0

DBI1306N when trying to use db2set

This was a new one for me, so I thought I’d write up a quick blog entry on it. After creating a new instance and a new database, and even after executing one db2set command successfully, I got this: > db2set DB2_CAPTURE_LOCKTIMEOUT=YES DBI1306N The instance profile is not defined. Explanation: The instance is not defined in the target machine registry....