db replace compiled stored procedure

We may have to upload a stored procedure (which in this case is compiled).

So in DB2 this goes like

In Db DDL

the command looks like

cd bin
db2 "CALL SET_ROUTINE_OPTS('REOPT ALWAYS')"
db2 "put routine from ./find_path-d-r.sar OWNER <sp-owner>"
db2 "put routine from ./expand-r.sar OWNER <sp-owner>"