Hi Martin, It takes affect at the next database activation (i.e. the first connect/activate after all of the current connections have been stopped). You do NOT have to start and stop the instance though (db2stop/db2start).
Kelly Kelly Schlamb DB2 Universal Database Development, IBM Toronto Lab, Canada Email: [EMAIL PROTECTED] Phone: 905-413-2469 DB2 Online Support Website: http://www.ibm.com/software/data/db2/udb/winos2unix/support "Killen, Martin W - To: [EMAIL PROTECTED], [EMAIL PROTECTED] CNF" cc: <Killen.Martin Subject: [DB2EUG] Alter bufferpool Command for UDB V7.2 FP3 Unix @cnf.com> 4.3.3 Sent by: owner-db2eug@l ugwash.org 04/18/2002 05:12 PM Please respond to "Killen, Martin W - CNF" Hi listers, Can anyone tell me if an alter bufferpool on UDB takes affect immediately or do you have to do a stop & start????? Marty Killen Sr. DB2 DBA CNF Inc. 503-450-2681 [EMAIL PROTECTED] IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration for OS/390 DB2 UDB V7.1 Database Administration for UNIX, Windows & OS/2 - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
