Isolating Error Location

It is important to determine where the error is occurring. An error might occur within DB2 client libraries, or it might be returned by a DB2 server instance to the client. As discussed in this book, many programming interfaces use the DB2 CLI driver as a common client interface. If the CLI driver returns the error, you can get a better idea why by taking a DB2 CLI trace. This is described in the “Tracing Facilities” section of this appendix.

From the CLI trace, you can determine whether the problem occurred because the application used the CLI driver incorrectly. For example, were all of the parameters in a function call correctly specified? Was a step missed? These are questions you should ask when looking at a CLI ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.