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

UNLOAD from Image Copy Tablespace with LOB Column
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
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
 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

Global Moderator


Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
PostPosted: Wed Sep 23, 2015 8:02 pm
 Reply with quote
Please check this, if still doesn't work then talk to DBA.
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
 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

Global Moderator


Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
PostPosted: Wed Sep 23, 2015 10:13 pm
 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
 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: 765
Location: Whitby, ON, Canada
PostPosted: Thu Sep 24, 2015 12:36 am
 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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us