Database Gateway for DRDA and the iSeries iASPs (Independant Active Storage Pool) (Doc ID 1498907.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.1 to 11.2.0.4
Information in this document applies to any platform.
Note: There is no official support of the iSeries iASPs with the database Gateway for DRDA.
The following configuration has been tested and has shown that it allows the DG4DRDA
to work with iASP. However, in case of unknown issue(s), Support reserves the right
to ask you to try to reproduce the problem outside of an iASP before creating a new bug.

Goal

 

1 - What is an iASP (independant Active Storage Pool)?
iSeries servers allow you to work with multiple databases. The iSeries server provides a system database (often referred to as SYSBAS) and the ability to work with one or more user databases. User databases are implemented on the iSeries server through the use of independent disk pools, or independant active storage pools, which are set up in the Disk Management function of iSeries Navigator.
Once an independent disk pool is set up, it appears as another database under the Databases function of iSeries Navigator.
There are multiple advantages to use iASPs. For more information, you can refer to the
IBM documentation at-

http://www.redbooks.ibm.com/redbooks/pdfs/sg247811.pdf

2 - Configuring DG4DRDA to work with an iASP.

The problem :
When the DG4DRDA is configured to access a Database located on a iASP, distributed transactions are no longer allowed. Any try to commit or rollback a distributed transaction reports the error:

[Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]Unknown error: SQLCODE -7017 {HY000,NativeErr = -7017}

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms