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.