SQL API's in Java? sqlugtpi and sqlugrpn in DPF environment, DB2 ESE V9

[wombat53]

HI group
Am wondering if any DPF users use these two (2) api's to obtain the
target partition number, and so bypass the inter-pertition transfer of
data from co-ordinator partition to target partition, aka "LOCAL
BYPASS".
My question is "is there information on the use of database manager API
calls in applications written in the JAVA language", as opoposed to C ,
C++ , COBOL , FORTRAN , REXX as per the Administrative API Reference
Manual, Pub. SC10-4231-00
I realize one could write some wrapper around a C language call, but I
have been asked by people wanting to avoid this step, if possible.
Thanks
GP

[Ian]

wombat53 wrote:

HI group
Am wondering if any DPF users use these two (2) api's to obtain the
target partition number, and so bypass the inter-pertition transfer of
data from co-ordinator partition to target partition, aka "LOCAL
BYPASS".
My question is "is there information on the use of database manager API
calls in applications written in the JAVA language", as opoposed to C ,
C++ , COBOL , FORTRAN , REXX as per the Administrative API Reference
Manual, Pub. SC10-4231-00
I realize one could write some wrapper around a C language call, but I
have been asked by people wanting to avoid this step, if possible.
Thanks

You might want to check out:

http://www-128.ibm.com/developerwork...m-0510coleman/

[wombat53]

Ian - (sadly) , my client does not use WAS, although we do have a Java
OLTP application, using the Type Driver. So I am still left with the
same question.
Thanks
wombat
Ian wrote:

wombat53 wrote:

HI group
Am wondering if any DPF users use these two (2) api's to obtain the
target partition number, and so bypass the inter-pertition transfer of
data from co-ordinator partition to target partition, aka "LOCAL
BYPASS".
My question is "is there information on the use of database manager API
calls in applications written in the JAVA language", as opoposed to C ,
C++ , COBOL , FORTRAN , REXX as per the Administrative API Reference
Manual, Pub. SC10-4231-00
I realize one could write some wrapper around a C language call, but I
have been asked by people wanting to avoid this step, if possible.
Thanks

You might want to check out:

http://www-128.ibm.com/developerwork...m-0510coleman/

[Ian]

wombat53 wrote:

Ian - (sadly) , my client does not use WAS, although we do have a Java
OLTP application, using the Type Driver. So I am still left with the
same question.

Well, that article references the 'useTransactionRedirect' property that
is part of the Type 4 JCC driver -- it isn't specific to WAS. I asked
the author of that article this question when the article was published,
and he confirmed that this should work for any JDBC app using the JCC
driver.

SACR definitely has some limitations (and you really need to know what
you're doing when it comes to physical database design), but it can be
pretty powerful.

[wombat53]

Ian - many thanks. Let me pursue that course...withing the JCC driver
itself.
wombat53

On Dec 14, 9:15 am, Ian <[e-mail]:

wombat53wrote:

Ian - (sadly) , my client does not use WAS, although we do have a Java
OLTP application, using the Type Driver. So I am still left with the
same question.Well, that article references the 'useTransactionRedirect' property that

is part of the Type 4 JCC driver -- it isn't specific to WAS. I asked
the author of that article this question when the article was published,
and he confirmed that this should work for any JDBC app using the JCC
driver.

SACR definitely has some limitations (and you really need to know what
you're doing when it comes to physical database design), but it can be
pretty powerful.