Access LUW Db2 Column Organized Table from Db2 Z via Federation

Gary Maculsay

Access LUW Db2 Column Organized Table from Db2 Z via Federation

Attempting this, I received:

DSNT408I SQLCODE =   -1668, SQLSTATE =      , UNKNOWN SQLSTATE TYPE FROM DB2

         UDB FOR AIX,LINUX,HP-UX,SUN AND WINDOWS TOKENS 8        

User response:

8

Respond to reason code 8 in the following ways:

  • Create or access column-organized tables in only non-XA transactions.
  • In XA transactions, create or access only row-organized tables.

Anyone successful at this? I'm not having great luck understanding the XA transaction message.

 

Thanks!

-Gary

           

 

 

Jeff Mucher

Access LUW Db2 Column Organized Table from Db2 Z via Federation
(in response to Gary Maculsay)
Hi Gary,

Unfortunately accessing Db2 columnar data from Db2 for z/OS has been a
restriction from the beginning. My understanding (my terminology may be
imprecise) is DDF only knows how to communicate with Db2 using XA
protocol. Db2 doesn't support a transaction accessing a column organized
table using a XA connection.

I've always thought the 'XA' restriction should be clarified with it's
practical implications.


A list of restrictions:
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061528.html


Jeff




From: Gary Maculsay <[login to unmask email]>
To: [login to unmask email]
Date: 02/20/2018 01:08 PM
Subject: [DB2-L] - Access LUW Db2 Column Organized Table from Db2 Z
via Federation



Attempting this, I received:
DSNT408I SQLCODE = -1668, SQLSTATE = , UNKNOWN SQLSTATE TYPE FROM
DB2
UDB FOR AIX,LINUX,HP-UX,SUN AND WINDOWS TOKENS 8
User response:
8
Respond to reason code 8 in the following ways:
Create or access column-organized tables in only non-XA transactions.
In XA transactions, create or access only row-organized tables.
Anyone successful at this? I'm not having great luck understanding the XA
transaction message.

Thanks!
-Gary





Site Links: View post online View mailing list online Start new thread
via email Unsubscribe from this mailing list Manage your subscription


This email has been sent to: [login to unmask email]
** ** ** IDUG DB2 Data and Analytics Technical Summit in Bengaluru, India
2018 ** ** **
---> Bengaluru, India, March 27, 2018 <---
http://ibm.biz/IDUGBengaluru2018

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2




Nadir Doctor

Access LUW Db2 Column Organized Table from Db2 Z via Federation
(in response to Jeff Mucher)
Hi Gary,

Just curious - have you attempted to create a view on the column-organized
table and use that to access from [login to unmask email] to confirm if that error can be
bypassed?


Best Regards,
Nadir


On Wed, Feb 21, 2018 at 10:12 AM, Jeff Mucher <[login to unmask email]> wrote:

> Hi Gary,
>
> Unfortunately accessing Db2 columnar data from Db2 for z/OS has been a
> restriction from the beginning. My understanding (my terminology may be
> imprecise) is DDF only knows how to communicate with Db2 using XA protocol.
> Db2 doesn't support a transaction accessing a column organized table using
> a XA connection.
>
> I've always thought the 'XA' restriction should be clarified with it's
> practical implications.
>
>
> A list of restrictions:
> https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/
> com.ibm.db2.luw.admin.dbobj.doc/doc/c0061528.html
>
>
> Jeff
>
>
>
>
> From: Gary Maculsay <[login to unmask email]>
> To: [login to unmask email]
> Date: 02/20/2018 01:08 PM
> Subject: [DB2-L] - Access LUW Db2 Column Organized Table from Db2
> Z via Federation
> ------------------------------
>
>
>
> Attempting this, I received:
>
> DSNT408I SQLCODE = -1668, SQLSTATE = , UNKNOWN SQLSTATE TYPE FROM
> DB2
>
> UDB FOR AIX,LINUX,HP-UX,SUN AND WINDOWS TOKENS 8
>
> *User response:*
> 8
> Respond to reason code 8 in the following ways:
>
> - Create or access column-organized tables in only non-XA transactions.
> - In XA transactions, create or access only row-organized tables.
>
> Anyone successful at this? I'm not having great luck understanding the XA
> transaction message.
>
> Thanks!
> -Gary
>
>
>
>
>
>
> -----End Original Message-----
>

Gary Maculsay

RE: Access LUW Db2 Column Organized Table from Db2 Z via Federation
(in response to Nadir Doctor)

No joy from a view either. 

 

Thanks for responses, by the way!

Charles Brown

Access LUW Db2 Column Organized Table from Db2 Z via Federation
(in response to Gary Maculsay)
Hmm!! Does db2 z/os have federation offerings — idk ? You may have a better chance doing the push and pull from LUW. Your thoughts.



Sent from my iPhone

> On Feb 22, 2018, at 9:14 AM, Gary Maculsay <[login to unmask email]> wrote:
>
> No joy from a view either.
>
>
>
> Thanks for responses, by the way!
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> ** ** ** IDUG DB2 Data and Analytics Technical Summit in Bengaluru, India 2018 ** ** **
> ---> Bengaluru, India, March 27, 2018 <---
> http://ibm.biz/IDUGBengaluru2018
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Gary Maculsay

RE: Access LUW Db2 Column Organized Table from Db2 Z via Federation
(in response to Charles Brown)

Just a follow-up - I was able to connect to the LUW Db2 instance, federate a pile of Z tables, and join that pile with the column-organized table, so I suppose the difference is the direction of travel? Perhaps something to do with the Application Requestor not being an XA transaction, so it worked? I'll have to dig out more information, time-permitting.

Thanks again to all that replied!