ARRFCASEAUDITLOG partitioning query
search cancel

ARRFCASEAUDITLOG partitioning query

book

Article ID: 232025

calendar_today

Updated On:

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.