IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

UNLOAD from Image Copy Tablespace with LOB Column


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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: 2503
Location: NY,USA

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

Please check this, if still doesn't work then talk to DBA.
Use [URL] BBCode for Links
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: 2503
Location: NY,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: 692
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 All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Can we Insert duplicates in Primary U... DB2 0
No new posts DB2 tablespace space limitation DB2 3
No new posts COnvert a column with mix of hex ,cha... DB2 5
No new posts Unload Report in ARCHIVE from CA-Disp... CA Products 0
No new posts VSAM Open During Copy-Excessive EXCP ... JCL & VSAM 1

Back to Top