ARRFCASEAUDITLOG partitioning query

Products

• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Risk Authentication

Issue/Introduction

How to create partitioning of ARRFCASEAUDITLOG table?

On table ARRFCASEAUDITLOG the column [DTCREATED] is nullable can it be Not Null?

Environment

Release : 9.1

Component : RiskMinder (Arcot RiskFort) Risk Authentication

Resolution

ARRFCASEAUDITLOG table is used by the Case Management server and if you do not use Case Management server functionalities, this table can be truncated.

The DTCREATED column is NULLABLE but it does not store any NULL values and that is programmatically handled so the DB partitioning can be done without issues as the data store is not NULL in that column.