ALTER PUMP is used to start/restart or stop/pause the operation of one or more pumps. If you start multiple pumps, these will be started in topological order*. That is, pumps that depend on other pumps for their data will be started after the pumps they require.
You can use a wildcard character to indicate pumps by schema (such as myschema.*), or list them individually, (pump1, pump2, pump3). Wildcarding for referencing catalog objects uses a standard SQL syntax. Statements that use incorrect syntax (such as *schema_*.) will fail.
Topological order is automatically calculated by s-Server. As a result, you can list pumps in the ALTER statement in any order.
In order for an application or application module to function correctly, you should start all the pumps in a single ALTER PUMP statement. This ensures no data loss.
It is also best practice to stop all pumps with a single ALTER PUMP statement to undeploy an application or application module. Pump Behavior on s-Server Shutdown or Restart
When s-Server is shutdown gracefully, all active pumps are suspended.
When s-Server is restarted, any pumps that were suspended at shutdown time are restarted. Pumps that have been stopped by a user SQL script will not be restarted automatically, and must therefore be restarted by a SQL script.
<alterpump> ::= ALTER PUMP <qualified-pump-name> | <pumps-list> <pumpaction> <pumps-list> ::= [pump-expr[, pump-expr ] * ] <pumpaction> ::= START | STOP
--start pump "mypump" in current schema ALTER PUMP "mypump" START; --start pump "mypump" in schema "myschema" ALTER PUMP "myschema"."mypump" START; -- start all pumps in myschema in topological order ALTER PUMP myschema.* START; -- stop all pumps in “myschema” in reverse topological order ALTER PUMP myschema.* STOP; -- start a given list of pumps in topological order ALTER PUMP pump1, pump2, pump21, pump11 START; -- or ALTER PUMP newschema.pump2, oldschema.* START; -- start all pumps in the catalog -- Pumps without start/stop privileges for the user -- will be skipped ALTER PUMP *.* START;