SQL Insert of Multiple rows and FIRELIMIT


Article ID: 140628


Updated On:


CA OPS/MVS Event Management & Automation


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?


Release : 13.5

Component : OPS/MVS


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.