Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2009
    Location
    Mumbai,India
    Posts
    16

    Unanswered: Error encountered:SQL30090N + Reason code = "21" while binding of module.

    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?
    Last edited by DB2 D-B-A; 12-10-09 at 01:44.
    Shuchi Mishra
    DB2 9 certified DBA for LUW

  2. #2
    Join Date
    Sep 2009
    Location
    Mumbai,India
    Posts
    16

    Red face

    This is the first time that dbforum is taking so long to post any suggestions.Please help me
    Shuchi Mishra
    DB2 9 certified DBA for LUW

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  4. #4
    Join Date
    Sep 2009
    Location
    Mumbai,India
    Posts
    16

    Unhappy

    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.
    Shuchi Mishra
    DB2 9 certified DBA for LUW

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you try the FEDERATED option of BIND?
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Sep 2009
    Location
    Mumbai,India
    Posts
    16
    yes! i have kept the option of "federated" as "yes" in bind command.
    Shuchi Mishra
    DB2 9 certified DBA for LUW

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •