ODBC DB2 AS/400 Solution error: [Table] in [Collection] not valid for operation. 3

ODBC DB2 AS/400 Solution error: [Table] in [Collection] not valid for operation. 3

book

Article ID: KB0075645

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) Core 2.5.0

Description

Using the TIBCO Scribe® Online Connector For ODBC to connect to an AS/400 table, the Scribe® Online connection tests successfully, but running a Solution results in the error below.  The ODBC datasource is configured to use the Progress DataDirect DB2 Wire Protocol Driver.

SLSREL in TEST#FILE not valid for operation.  3
: Error in calling Operation Create

On the server hosting the on-premise agent, a test of the ODBC datasource using a SQL query tool returns the following error:
 
ERROR: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]SLSREL in TEST#FILE not valid for operation. 3   Error Code: -7008


Default "Advanced" settings for the DB2 datasource

User-added image

Issue/Introduction

Using the TIBCO Scribe® Online Connector For ODBC to connect to an AS/400 table, the “not valid for operation. 3” error can occur when the ODBC datasource Default Isolation Level is set to “1 - READ COMMITTED”.

Resolution

This error is unique to DB2 on the AS/400.  The DB2 error SQL7008 is returned when an update is attempted to a table on the AS/400 that is not journalled with an Isolation Level that requires journalling.  There are two ways to resolve this error:
  1. Change the ODBC datasource Default Isolation Level from “1 - READ COMMITTED”  to “4 - NONE”
  2. Work with the Database Administrator to enable journalling on the AS/400 server for the target table.  


"Advanced" settings for the DB2 datasource

User-added image

For additional information, see the following Progress DataDirect DB2 Wire Protocol Driver reference:   Default Isolation Level

Additional Information

Powered by Wolken Software