Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

UNLOAD from Image Copy Tablespace with LOB Column

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
alluri12

New User


Joined: 15 Aug 2006
Posts: 44
Location: Virginia, USA

PostPosted: Wed Sep 23, 2015 7:00 pm    Post subject: UNLOAD from Image Copy Tablespace with LOB Column
Reply with quote

I am trying to unload data from a table that has CLOB column in it and need to load the same into other test region. I am getting error
"DSNU1218I -PA0D 266 09:08:39.66 DSNUULIA - LOGICAL RECORD LENGTH OF OUTPUT RECORD EXCEEDED THE LIMIT FOR TABLE CDF0001.CLOB_TBL_XML

Here is the code for unload.

Code:
//UNLD1 EXEC DSNUPROC,SYSTEM=TEST01,                             
//             LIB='TEST01.DSNLOAD',                             
//             UID=''                                         
//SYSPUNCH  DD DSN=TEST.FILE1L.CNTL.DBNAME.TSNAME.A01,       
//             DISP=(,CATLG,DELETE),                           
//             DCB=(LRECL=80,BLKSIZE=0,RECFM=FB,DSORG=PS),     
//             SPACE=(TRK,(5,5),RLSE),                         
//             UNIT=SYSDA                                     
//SYSREC    DD DSN=TEST.FILE1L.UNLD.DBNAME.TSNAME.A01,,       
//             DISP=(,CATLG,DELETE),                           
//             SPACE=(TRK,(12203,1220),RLSE),                 
//             UNIT=SYSDA                                     
//SYSTSPRT  DD SYSOUT=*                                       
//SYSPRINT  DD SYSOUT=*                                       
//SYSIN     DD *                                               
UNLOAD TABLESPACE DBNAME.TSNAME                             
  FROMCOPY TESTFILE.IC.DBNAME.TSNAME.P001.D001         
  EBCDIC                                                   
  SHRLEVEL CHANGE ISOLATION CS                                 
/*                                                             



Could you please help me for unload and load jcls from image copy using clob column.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Sep 23, 2015 8:02 pm    Post subject:
Reply with quote

Please check this, if still doesn't work then talk to DBA.
http://www-01.ibm.com/support/knowledgecenter/#!/SSEPEK_10.0.0/com.ibm.db2z10.doc.msgs/src/tpc/dsnu1218i.dita
Back to top
View user's profile Send private message
alluri12

New User


Joined: 15 Aug 2006
Posts: 44
Location: Virginia, USA

PostPosted: Wed Sep 23, 2015 8:09 pm    Post subject:
Reply with quote

I tried the option with NOPAD and it did not work either
Code:
"DSNU1220I -PA0D 266 09:11:30.41 DSNUULIA - UNLOADING LOB/XML COLUMNS FROM IMAGE COPY IS NOT SUPPORTED FOR TABLE CDF0001.CLOB_TBL_XML
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Sep 23, 2015 10:13 pm    Post subject:
Reply with quote

How about the other options given to you in the link and have talked to DBA yet on this?
Back to top
View user's profile Send private message
alluri12

New User


Joined: 15 Aug 2006
Posts: 44
Location: Virginia, USA

PostPosted: Wed Sep 23, 2015 10:24 pm    Post subject:
Reply with quote

Yes. they are also doing research.... but as of now no clue.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Thu Sep 24, 2015 12:36 am    Post subject:
Reply with quote

As per the DB2 V10 Messages & Codes manual:
Code:
--------------------------------------------------------------------------     
DSNU1220I UNLOAD OF lob-or-xml FROM IMAGE COPY NOT SUPPORTED                   
                                                                               
Explanation:                                                                   
                                                                               
For the UNLOAD utility, one or more XML, BLOB, CLOB, and/or DBCLOB columns     
are selected on the indicated table when the source object is an image         
copy data set.                                                                 
                                                                               
System Action:                                                                 
                                                                               
The utility job terminates.                                                     
                                                                               
User Response:                                                                 
                                                                               
Specify a field selection list that does not include any XML, BLOB, CLOB,       
or DBCLOB column from the indicated table.                                     
                                                                               
Problem Determination:                                                         
                                                                               
When the source object of the UNLOAD utility is an image copy, selection       
of a LOB or XML column is not supported.                                       
                                                                               
Severity:                                                                       
                                                                               
8 (error)                                                                       
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us