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: 1679
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: 1679
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: 650
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 copy SEQ to PDS and create stats steve-myers JCL & VSAM 4 Thu Apr 27, 2017 1:15 am
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts Mail via SMTP with an image? Mike 1304 JCL & VSAM 4 Thu Jan 26, 2017 2:01 pm


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