IBM Support

JR37949: EXECUTE INSERT/ DELETE / UPDATE ON NICKNAME, WHEN CONNECT FROM A DB2 TO A OS/400 DB FAILED, ERROR SQL1822N AND SQL7008N.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When connect from a DB2 9.5 to a OS/400 database - using
    nicknames in the Local database
    SELECT statements works but trying to INSERT/ DELETE / UPDATE
    raises an SQL 7008 error.
    For example,
    insert into customer values (1,'aa')
    DB21034E  The command was processed as an SQL statement because
    it was not a valid Command Line Processor command.  During SQL
    processing it returned:
    SQL1822N  Unexpected error code "-7008" received from data
    source "SERVER1".
    Associated text and tokens are " SQL7008N  REXX variable
    "CUSTOMER  " contains inconsist".  SQLSTATE=560BD
    

Local fix

  • There are 2 methods to solve this problem.
    
    1. You can use "set passthru" work around this problem. For
    example,
    
    set passthru SERVER1
    DB20000I The SQL command completed successfully.
    
    insert into test(cusnum) values ( 19923 ) WITH NC
    DB20000I The SQL command completed successfully.
    
    set passthru reset
    DB20000I The SQL command completed successfully.
    
    2. Journal your tables.
    
    This problem is fixed in V95fp8 and V97fp4.
    A new server option "APP_ISOLATION_ENABLE" that is maintained by
    DRDA wrapper is added in above two versions to solve this
    problem.
    If set it to 'Y', FS will get isolation level from application
    and set application isolation as a connect attribute.
    If set it to 'N', FS won't set isolation when connect to client.
    Then client  can use the isolation set in configure file such as
    db2cli.ini
    
    For example:
    (1) default (user don't set that server option)
    create server "SERVER1" type DB2/ISERIES version 97 wrapper
    "WRAPPER1" authorization "J15USERA1" password "passw0rd" options
    (node 'FEDNODE2', dbname 'DATASD
    2',FOLD_ID 'N')
    DB20000I  The SQL command completed successfully.
    
    insert into customer values (1,'aa')
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL1822N  Unexpected error code "-7008" received from data
    source "SERVER1".
    Associated text and tokens are " SQL7008N  REXX variable
    "CUSTOMER  " contains
    inconsist".  SQLSTATE=560BD
    
    delete customer
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL1822N  Unexpected error code "-7008" received from data
    source "SERVER1".
    Associated text and tokens are " SQL7008N  REXX variable
    "CUSTOMER  " contains
    inconsist".  SQLSTATE=560BD
    
    (2)set APP_ISOLATION_ENABLE to 'Y'
    create server "SERVER1" type DB2/ISERIES version 97 wrapper
    "WRAPPER1" authorization "J15USERA1" password "passw0rd" options
    (node 'FEDNODE2', dbname 'DATASD
    2',APP_ISOLATION_ENABLE 'Y')
    DB20000I  The SQL command completed successfully.
    
    insert into customer values (1,'aa')
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL1822N  Unexpected error code "-7008" received from data
    source "SERVER1".
    Associated text and tokens are " SQL7008N  REXX variable
    "CUSTOMER  " contains
    inconsist".  SQLSTATE=560BD
    
    delete customer
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL1822N  Unexpected error code "-7008" received from data
    source "SERVER1".
    Associated text and tokens are " SQL7008N  REXX variable
    "CUSTOMER  " contains
    inconsist".  SQLSTATE=560BD
    
    (3)set APP_ISOLATION_ENABLE to 'N'
    create server "SERVER1" type DB2/ISERIES version 97 wrapper
    "WRAPPER1" authorization "J15USERA1" password "passw0rd" options
    (node 'FEDNODE2', dbname 'DATASD
    2',APP_ISOLATION_ENABLE 'N')
    DB20000I  The SQL command completed successfully.
    
    insert into customer values (1,'aa')
    DB20000I  The SQL command completed successfully.
    
    delete customer
    DB20000I  The SQL command completed successfully.
    
    (4) alter server option
    alter server "SERVER1" options(add APP_ISOLATION_ENABLE 'N')
    DB20000I  The SQL command completed successfully.
    
    insert into customer values (1,'aa')
    DB20000I  The SQL command completed successfully.
    
    delete customer
    DB20000I  The SQL command completed successfully.
    
    alter server "SERVER1" options(set APP_ISOLATION_ENABLE 'Y')
    DB20000I  The SQL command completed successfully.
    
    insert into customer values (1,'aa')
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL1822N  Unexpected error code "-7008" received from data
    source "SERVER1".
    Associated text and tokens are " SQL7008N  REXX variable
    "CUSTOMER  " contains
    inconsist".  SQLSTATE=560BD
    
    delete customer
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL1822N  Unexpected error code "-7008" received from data
    source "SERVER1".
    Associated text and tokens are " SQL7008N  REXX variable
    "CUSTOMER  " contains
    inconsist".  SQLSTATE=560BD
    

Problem summary

  • User affected:
     Users of Federation Server who use DRDA wrapper against AS400
    Problem Descripion and Summary:
     See error description.
    

Problem conclusion

  • Problem was first fixed in V97fp4. This fix should be applied
    Federation Server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR37949

  • Reported component name

    DRDA WRAPPER

  • Reported component ID

    5724N9706

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-10-08

  • Closed date

    2011-05-02

  • Last modified date

    2011-05-02

  • APAR is sysrouted FROM one or more of the following:

    JR37887

  • APAR is sysrouted TO one or more of the following:

    IC72008

Fix information

  • Fixed component name

    DRDA WRAPPER

  • Fixed component ID

    5724N9706

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: InfoSphere Federation Server
Data Sources and Wrappers - DRDA

Software version: 9.7

Reference #: JR37949

Modified date: 02 May 2011