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

New User

Joined: 21 Jan 2009
Posts: 84
Location: India

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


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

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.

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: 2914
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.

Also I see this is a work around, try it
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 question on Outrec and sort #Digvijay DFSORT/ICETOOL 20
No new posts panel creation question TSO/ISPF 12
No new posts Sort w/OUTREC Question DFSORT/ICETOOL 2
No new posts SYSSPUXB and SYSSPUXA tablespaces DB2 3
No new posts Assembler test under mask question PL/I & Assembler 5
Search our Forums:

Back to Top