SQL Insert of Multiple rows and FIRELIMIT

Products

• 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

OPS/MVS Event Management & Automation

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.