Net.Data Books

Administration and Programming Guide for OS/390


Suppressing DB2 for OS/390 Messages

You can improve the performance of Net.Data for OS/390 when using the SQL language environment by suppressing DB2 messages from non-zero SQLCODEs. Use the DB2MSGS configuration variable to indicate the level of messages that is necessary for your application. Within production environments, you can bypass DB2 message lookups by setting DB2MSGS to NONE. When DB2MSGS is set to NONE or ERRORONLY, you can still catch non-zero SQLCODEs with MESSAGE blocks within your macro. See Net.Data Reference to learn how to use the MESSAGE block in your macro.

To specify the messaging level, use the DB2MSGS configuration variable in the Net.Data initialization file.

Possible values:

DB2MSGS [=] message_level

Where message_level indicates the level of DB2 messages provided by Net.Data and can be specified as follows:

NONE
Specifies that Net.Data provides no messages.

ERRORONLY
Specifies that Net.Data provides messages only for negative SQLCODE values.

ALL
Specifies that Net.Data provides messages for all SQLCODE values. This is the default. If a value is provided for DB2MSGS other than one of the valid values listed above, Net.Data uses the default value of ALL.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]