SQL Insert of Multiple rows and FIRELIMIT

book

Article ID: 140628

calendar_today

Updated On:

Products

CA OPS/MVS Event Management & Automation

Issue/Introduction

On a scheduled calendar basis, it can be necessary to execute a job that inserts thousands of rows in an OPS/MVS table.These inserts always call the SQL security rule which then hits the FIRELIMIT.

Is it possible to do a multiple row insert in one SQL statement, avoiding reaching the FIRELIMIT value?
Any possible bypass to that situation?

Environment

Release : 13.5

Component : OPS/MVS

Resolution

Unfortunately, it isn't possible to do this multiple row insert in one SQL statement.

So a first suggestion could be to add OPTIONS "NOFIRELIMIT" to the specific rule.

Alternatively,  it is possible to offload the work to a TOD rule, in which case no security rule would fire.