Re: SYSTEM.CATALOG table - VERSIONS attribute

2016-05-09 Thread Gaurav Agarwal
What will be the advantage of reducing the version to 5 and what version
system.catalog maintains

Thanks
On May 9, 2016 12:20 PM, "Ankit Singhal"  wrote:

> Yes, you can but it depends if you don't want to go back in time for
> schema before 5 versions.
>
> On Mon, May 9, 2016 at 8:16 AM, Bavineni, Bharata <
> bharata.bavin...@epsilon.com> wrote:
>
>> Hi,
>>
>> SYSTEM.CATALOG table is created with VERSIONS => '1000' by default. Can
>> we change this value to 5 or 10? Does this cause any side effects?
>>
>>
>>
>> Thank you,
>>
>> Bharathi.
>>
>> --
>>
>> This e-mail and files transmitted with it are confidential, and are
>> intended solely for the use of the individual or entity to whom this e-mail
>> is addressed. If you are not the intended recipient, or the employee or
>> agent responsible to deliver it to the intended recipient, you are hereby
>> notified that any dissemination, distribution or copying of this
>> communication is strictly prohibited. If you are not one of the named
>> recipient(s) or otherwise have reason to believe that you received this
>> message in error, please immediately notify sender by e-mail, and destroy
>> the original message. Thank You.
>>
>
>


Re: SYSTEM.CATALOG table - VERSIONS attribute

2016-05-09 Thread Ankit Singhal
Yes, you can but it depends if you don't want to go back in time for schema
before 5 versions.

On Mon, May 9, 2016 at 8:16 AM, Bavineni, Bharata <
bharata.bavin...@epsilon.com> wrote:

> Hi,
>
> SYSTEM.CATALOG table is created with VERSIONS => '1000' by default. Can we
> change this value to 5 or 10? Does this cause any side effects?
>
>
>
> Thank you,
>
> Bharathi.
>
> --
>
> This e-mail and files transmitted with it are confidential, and are
> intended solely for the use of the individual or entity to whom this e-mail
> is addressed. If you are not the intended recipient, or the employee or
> agent responsible to deliver it to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you are not one of the named
> recipient(s) or otherwise have reason to believe that you received this
> message in error, please immediately notify sender by e-mail, and destroy
> the original message. Thank You.
>