search cancel

Other list size

book

Article ID: 200746

calendar_today

Updated On:

Products

CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort) CA Strong Authentication CA Rapid App Security CA Risk Authentication CA Advanced Authentication

Issue/Introduction

Is there a product defined limit for amount of data that can be stored as "Manage List Data" with List Type of "Other Lists" as shown below.

 

Environment

Release : 9.1

Component : RiskMinder(Arcot RiskFort)

Resolution

In short, there is no product defined limit to the growth of DB rows that can be inserted  to underlying CA Risk Authentication table  (ARRFADDONRULELISTDATA) that holds the "Other Lists" data.  The space has to be planned with your DBA given max row size discussed below and your max requirements in the long run.

The ARRFADDONRULELISTDATA table is not a table that is recommended for DB trimming / Pruning as is the case for audit log tables. So you need to plan for it in terms of DB size allocation.

Here is a detailed answer to your query about the related table and its columns / max row size. 

The columns in this table are given below with their max sizes. Note the only column is "Data" which can be 1 to a max of 512 bytes. Hence a row can of 540 bytes max length.

1. VERSIONNUMBER               ====  Fixed  4 byte Integer 

2. DATA                                      ====  Variable 512 bytes (max length) 

3. DATECREATED                     ====   Fixed 8 bytes 

4. ADDONRULELISTDATA_ID   ====  Fixed  16 bytes (Primary Key)

 

Here is a Length specific allocation by columns. 

1. VERSIONNUMBER (4 bytes)

2.  DATA (512 bytes max)

3. DATECREATED (8 bytes)

4. ADDONRULELISTDATA_ID (16 bytes)

Here is a SELECT statement on this table from my environment