Hi,

We are using DB2 v9.7 ESE,HP-UX 11.31(64-bit) as database server and AIX 5.3 (64 bit) as application server.

I configured federation b/w two local db2 databases in database server.
I am trying to bind a module in application server which access federated table named "SYSC" of database server through nickname,I get following error:

<OS PROMPT> db2 bind DBIOSYSC.bnd

LINE MESSAGES FOR DBIOSYSC.bnd
------ ----------------------------------------------------------
SQL0061W The binder is in progress.
706 SQL30090N Operation invalid for application execution
environment. Reason code = "21". SQLSTATE=25000
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.

This module named "DBIOSYSC" contains nothing but cursors contains select,insert,update and delete statement.

When I try to fire any select,insert,update & delete statement for "SYSC" with the help of nicknames on OS prompt,they run fine.What can be possible cause??How can I rectify it?

This is the first time that dbforum is taking so long to post any suggestions.Please help me

SQL30090N Operation invalid for application execution environment.
Reason code = "<reason-code>".

Explanation:

The operation is invalid for the application execution environment. For
example, an operation might be invalid for applications that have
special restrictions on statements or APIs - applications such as those
that operate in an XA Distributed Transaction Processing environment,
such as CICS; those that operate with CONNECT type 2 connection
settings; or those that use federated system functionality to update
multiple heterogeneous data sources. The operation was rejected.

Possible reason codes are:


21 The operation that you want performed at the specified data
source(s) is not supported by the wrapper by which DB2 accesses
the data source(s). Consult the documentation to find out what
operations this wrapper supports.

sqlcode: -30090

sqlstate: 25000



Andy

Hi,

Thanks for your suggestions.But, we are neither using XA Distributed Transaction Processing environment,
such as CICS nor CONNECT type 2 connection settings.

Yes,we are trying to update the federated table through COBOL application (in application server(AIX))through cursors .But,the data source is not heterogeneous(It's DB2 on unix on both sides).

Also,we are able to update the same table through command line.So,please suggest what can be the possible solution?I tried googling but couldnt find much help.

PS: Sathyaram,Marcus!!! still waiting for your expert suggestions.

Did you try the FEDERATED option of BIND?

yes! i have kept the option of "federated" as "yes" in bind command.