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

Question: REORG on LOB tablespaces


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Fri Aug 14, 2015 2:14 pm
Reply with quote

Hi,

We are trying to REORG a tablespace (partition by growth) with table having two LOB columns -

Background
Tablespace name: TSAAAC
LOB tablespace name for LOB column1: TSAAA1
LOB tablespace name for LOB column2: TSAAA2


For REORG, the default AUX parameter option is AUX=NO except for a few scenarios like "REORG TABLESPACE of a partition-by-growth base table space with one or more LOB columns, where the REORG is reorganizing the entire partition-by-growth table space" - as per DB2 v10 Utility Reference Guide.

We also have an inline imagecopy in the REORG performed with a LIST defined in LISTDEFDD with the corresponding dataset defined as a template on TAPE.


Issue:
The REORG utility attempts to perform the INLINE imagecopy in parallel and fails with S513 abend while writing on the tape. (S513)

The COPY utility has the option TAPEUNITS under PARALLEL option to specify the maximum number of tape drives that the utility dynamically
allocates for the list of objects to be processed in parallel

But, how do we specify this option for an inline imagecopy which is causing the S513 abend ?

Not sure if I have explained the query in the best way, but let me know if there are any confusions ?
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


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

PostPosted: Tue Aug 18, 2015 2:11 am
Reply with quote

There seems to be a ticket already , check if you get the solution.

www-01.ibm.com/support/docview.wss?uid=swg1PM55471#more

Also I see this is a work around, try it
Quote:
Write the reorg inline imagecopies to DASD and have HSM archive it.
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 Assembler test under mask question PL/I & Assembler 5
No new posts REORG to reduce segment size new DBD IMS DB/DC 2
No new posts Question for Cobol Report Writer COBOL Programming 3
No new posts Infoprint AOPPRINT question All Other Mainframe Topics 0
No new posts CICS Web Services configuration question CICS 36
Search our Forums:

Back to Top