Re: REORG will active in V5R3 - Does it bypass objects with locks, therefore...

I haven't used this yet, but I believe I remember reading that you have to 
have the file journaled to be able to use the reorg while active.

Thank you,
Ronald L. Zimmerman
I.T. Applications Manager
Swiss Valley Farms, Co.      http://www.swissvalley.com
"The Good for You Company"
Email: Ron-Zimmerman@xxxxxxxxxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 05/24/2006 08:42:50 AM:

> Like a sample?
> V5R3
> strsql
> CREATE TABLE ROB/ODOM (MYCHAR CHAR (10 ) NOT NULL WITH DEFAULT)
> Table ODOM created in ROB. 
> f3
> upddta rob/odom 
> enter a few records...  Delete a few...  Leave open in UPDDTA
> start other session
> RGZPFM FILE(ROB/ODOM) ALWCANCEL(*YES) LOCK(*SHRUPD)
> File ODOM in library ROB in use.
> Member *N file ODOM in ROB not reorganized.
> 
> Am I doing something wrong?
> I played around with this in the lab early on.  iNav has some very 
pretty 
> GUI's to work with this.  You can cancel the reorg and restart it and it 

> will start where it left off, etc.  Now if I could just figure out why 
the 
> above didn't work.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> "Dave Odom" <Dave.Odom@xxxxxxxxxxxx> 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 05/23/2006 03:30 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> <midrange-l@xxxxxxxxxxxx>
> cc
> 
> Subject
> REORG will active in V5R3 - Does it bypass objects with locks, 
> therefore...
> 
> 
> 
> 
> 
> 
> defeating the point of a complete reorg?   If so, I guess I'll have to
> buy a vendor product to help me eliminate downtime from complete reorgs.
> 
> 
> Thanks in advance,
> 
> Dave Odom
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>