Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
Question: REORG on LOB tablespaces

Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Question: REORG on LOB tablespaces
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

Senior Member

Joined: 21 Sep 2010
Posts: 2265
Location: NY,USA

PostPosted: Tue Aug 18, 2015 2:11 am    Post subject:
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    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 Blksize question darioits JCL & VSAM 11 Tue Sep 10, 2019 8:32 pm
No new posts INREC IFTHEN question knobi SYNCSORT 2 Mon Apr 15, 2019 11:55 pm
No new posts Attachmate file transfer question John Poulakos All Other Mainframe Topics 3 Wed Mar 20, 2019 1:45 am
No new posts COBOL Table Question GAPX1 COBOL Programming 3 Thu Mar 07, 2019 9:48 pm
No new posts CICS program with Delay question MSTP CICS 5 Tue Dec 11, 2018 11:18 pm

Back to Top
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us