Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums 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
rakesh1155

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

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

Senior Member


Joined: 21 Sep 2010
Posts: 1827
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.

http://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    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 question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am
No new posts QUESTION: RETURN CHANNEL pahiker CA Products 21 Thu Apr 20, 2017 12:31 am
No new posts The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Asynchronous CICS Processing Question moezbud CICS 1 Mon Mar 06, 2017 6:13 pm

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