Portal | 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

Global Moderator

Joined: 21 Sep 2010
Posts: 2489
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 REORG to reduce segment size new DBD Floramq IMS DB/DC 1 Wed Oct 14, 2020 7:22 pm
No new posts Question for Cobol Report Writer jackzhang75 COBOL Programming 3 Wed May 27, 2020 4:35 am
No new posts Infoprint AOPPRINT question ecsk All Other Mainframe Topics 0 Fri May 15, 2020 12:35 pm
No new posts CICS Web Services configuration question SickPup404 CICS 36 Mon Nov 04, 2019 9:56 pm
No new posts User question - dbzTHEdinosaur SickPup404 General Talk & Fun Stuff 2 Mon Nov 04, 2019 9:47 pm

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