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

we wanted to create partitioning of ARRFCASEAUDITLOG table. 

On table ARRFCASEAUDITLOG the column [DTCREATED] is nullable can we make it not null 

Do we have any issue on it?

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 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.