ALTER BUFFERPOOL in a Stored Procedure
in [DB2]
|
Prev: International Journal of Electronics, Information and Systems (IJEIS) Call for Paper
Next: if any - sql
From: shorti on 4 Jan 2010 15:51 DB2 ESE V9.5 on AIX Is there a way to perform the alter bufferpools command in a stored procedure...I seemed to remember running into something that said it was allowed but cannot find any information on how to now. As always thanks for the help.
From: Ian on 4 Jan 2010 16:29 On 1/4/10 1:51 PM, shorti wrote: > DB2 ESE V9.5 on AIX > > Is there a way to perform the alter bufferpools command in a stored > procedure...I seemed to remember running into something that said it > was allowed but cannot find any information on how to now. As always > thanks for the help. Did you RTFM (look at the documentation)? http://j.mp/4NgXit [http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.apdv.routines.doc/doc/r0020478.html]
From: Serge Rielau on 6 Jan 2010 07:39
On 1/4/2010 3:51 PM, shorti wrote: > DB2 ESE V9.5 on AIX > > Is there a way to perform the alter bufferpools command in a stored > procedure...I seemed to remember running into something that said it > was allowed but cannot find any information on how to now. As always > thanks for the help. ALTER BUFFERPOOL is a regular SQL Statement. You should be able to simple EXECUTE IMMEDIATE it. Cheers Serge -- Serge Rielau SQL Architect DB2 for LUW IBM Toronto Lab |