Hi,
Some data field changes will force the database to create a copy of the table
and all records into this slightly modified table. This can take a lot of
time, and there is not really any good way to prevent it.
I do not remember exactly when, but it could be on field deletes/additions and
when changing the size of char fields.
Being able to import in place is a good thing with newer versions, if you
still pay your support contract...
You can use our new RRR|DefDiff tool to create delta def-files with
new/changed objects, and also a backup of changed objects in the target
environment. That tool should work fine on 5.1.2 as it only works on
def-files.
You can use it to verify that all changes got to production.
I will do a presentation on that tool, and some other helper tools not yet
published at WWRUG13 in a week.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Thanks Misi.
> Yup, our's is totally manual approach.
> We do all our changes manually except new forms,workflow - we do import
> them.
> Basically was trying to get some ideas, as lately we have seen while making
> changes on forms - DBA noticed locks on corresponding tables(latch
> contention), which inturn causing issues - the modification to the form
> fails as the system hangs and eventually view gets corrupted, etc.
> Yes, I have been actively using RRR|DefFieldDiff and also few other command
> line utilities you have on RRR. Thanks to you for such great
> tools/utilities.
>
>
>
>
> On Tue, Sep 24, 2013 at 10:15 AM, Misi Mladoniczky <[email protected]> wrote:
>
>> Hi,
>>
>> A very big difference in 5.1.2 is that when you import a form definition,
>> the
>> form data will be truncated. That changed in version 6 where you have
>> different options.
>>
>> This means that it is hard to automate the release and do it quickly.
>>
>> Your best option would be to manually add fields that you need to add.
>> After
>> that you might import a view-definition file with the new layout.
>>
>> You might want to have a look at our RRR|DefFieldDiff to find out which
>> forms
>> that has data-changes. Make sure to include the display-only-fields when
>> running it.
>>
>> https://rrr.se/cgi/tools/main?tool=rrrDefFieldDiff
>>
>> Most people would consider 5.1.2 to be a slightly outdated version... But
>> it
>> was a good version ;-)
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
>> Find these products, and many free tools and utilities, at http://rrr.se.
>>
>> > Environment info:
>> > Server : 5.01.02 Patch 1313
>> > Hardware : sun4u
>> > OS: SunOS 5.10
>> > DB: SQL -- Oracle
>> > DB Version : 0.2.0.5.0 - 64bi
>> > No Mid-Tier.
>> >
>> > Thanks Tommy. For this version, I do not see an option to enable
>> > Development Cache Mode. Assume it was introduced in later versions.
>> >
>> >
>> _______________________________________________________________________________
>> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> > "Where the Answers Are, and have been for 20 years"
>> >
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
