wos data moveout

Hi Eugenia,

I am trying to enlarge the wosdata pool :I do the following ; in the end I have no sessions connected ;

yet the wos_pool does not cleaned out entirely , hence it keeps failing .

Since I change to 0 connections I can't just play around with it .

The db is very large , but still there should be a way to get to a clean up .

Thanks!

================= sequence to change a resource pool ========================
select GET_CONFIG_PARAMETER('MaxClientSessions') ; -- ( save the value)
select SET_CONFIG_PARAMETER('MaxClientSessions',0) ;
Select do_tm_task('moveout') ;
Select close_all_sessions();
Select do_tm_task('moveout') ;
select * from wos_container_storage ;
select node_name ,user_name,client_pid,session_id,client_label,transaction_id ,statement_start ,statement_id from sessions ;
alter resource pool wosdata MEMORYSIZE '2G' MAXMEMORYSIZE '2G';
select SET_CONFIG_PARAMETER('MaxClientSessions',500) ;