IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Remote Unload of CLOB Columns


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Tue Nov 14, 2023 7:20 pm
Reply with quote

Hi ,
We have a situation to unload the data from remote DB2 for LUW server to Mainframe Zos DB2 .
Remote unload using DSNTIAUL is working fine for normal tables not having LOB columns.

But while unloading the CLOB columns data is getting truncated and maximum length allowed is restricted till 32755 .Our CLOB columns are having length more than 32755 & JSON content.

Any alternative way to unload CLOB columns from remote server to mainframe DB2 ?


Note:
We tried cross loader also but ended with
DSNU283I -DSNURWBF - LOB ERROR
SQLCODE = -433
SQLERRM = <Lob-Value
i.e. -433 VALUE value IS TOO LONG


Any DB2 experts view will be helpful .

Thanks
Yogi
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2050
Location: USA

PostPosted: Tue Nov 14, 2023 9:48 pm
Reply with quote

Google bless you:

Unloading LOB data
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Wed Nov 15, 2023 1:08 pm
Reply with quote

Thanks .The link you shared is for DB2 for zos .i.e. Unload utility that will perfectly work for CLOB table within Mainframe(zOS).But it won't work for a table present in remote location (DB2 for LUW).We tried this option too already. This Unload utility will not recognize the Remote table .We will get error DSNU056I csect-name TABLE table-name NOT FOUND.

I am referring here REMOTE unload.i.e. RemotLocation.Schema.Table


Thanks for the advice !
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3059
Location: NYC,USA

PostPosted: Thu Nov 16, 2023 4:50 pm
Reply with quote

Did you try giving LOBFILE in Parms ?
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Fri Nov 17, 2023 7:02 pm
Reply with quote

Hi Rohit,

Yes finally i got this option yesterday & testing .
So remote unload is possible only thru DSNTIAUL .
Its generating file for each row .Looks thats expected behaviour .

https://www.ibm.com/docs/en/db2-for-zos/12?topic=dpasp-dsntiaul-sample-program

Happy Learning!

Thanks
Yogi
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3059
Location: NYC,USA

PostPosted: Fri Nov 17, 2023 8:20 pm
Reply with quote

Glad it worked .. the link that you shared can’t be opened ..
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Mon Nov 20, 2023 6:48 pm
Reply with quote

The link is reference to "DSNTIAUL sample program" where LOBFILE was explained.

www.ibm.com/docs/en/db2-for-zos/13?topic=dpasp-dsntiaul-sample-program

Thanks
Yogi
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Unload and Load ISPF Table TSO/ISPF 4
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Increase the number of columns in the... IBM Tools 3
No new posts Storing a BLOB/CLOB in PL/I PL/I & Assembler 4
Search our Forums:

Back to Top