I accidentally issued folloiwng command twice and it was showing partition detach status for a while for small table.
alter table T1 detach partition PART5 intoT1_02
db2 list utilities show detail | grep -p -i detach
ID = 1208
Type = ASYNCHRONOUS PARTITION DETACH
Database Name = DB1
Partition Number = 0
Description = Finalize detach for partition '9' of table 'T1' and make table 'T1_02' available
Start Time = 01/28/2014 10:48:37.682113
State = Executing
Invocation Type = Automatic
Progress Monitoring:
Description = Waiting for old access to the partitioned table to complete.
Start Time = 01/28/2014 13:08:40.480134
db2pd -util
Database Partition 0 -- Active -- Up 93 days 14:48:44 -- Date 2014-01-28-13.18.33.334414
Utilities:
Address ID Type State Invoker Priority StartTime DBName NumPhases CurPhase Description
0x0780000001FAE4C0 1208 ASYNCHRONOUS PARTITION DETACH 1 1 0 Tue Jan 28 10:48:37 DB1 -1 -1 Finalize detach for partition '9' of table 'T1' and make table 'T1_02' available
Progress:
Address ID PhaseNum CompletedWork TotalWork StartTime Description
Hope this helps..
alter table T1 detach partition PART5 intoT1_02
db2 list utilities was showing AIC was running for 90 mins..
ID = 1208
Type = ASYNCHRONOUS PARTITION DETACH
Database Name = DB1
Partition Number = 0
Description = Finalize detach for partition '9' of table 'T1' and make table 'T1_02' available
Start Time = 01/28/2014 10:48:37.682113
State = Executing
Invocation Type = Automatic
Progress Monitoring:
Description = Waiting for old access to the partitioned table to complete.
Start Time = 01/28/2014 13:08:40.480134
db2pd -util
Database Partition 0 -- Active -- Up 93 days 14:48:44 -- Date 2014-01-28-13.18.33.334414
Utilities:
Address ID Type State Invoker Priority StartTime DBName NumPhases CurPhase Description
0x0780000001FAE4C0 1208 ASYNCHRONOUS PARTITION DETACH 1 1 0 Tue Jan 28 10:48:37 DB1 -1 -1 Finalize detach for partition '9' of table 'T1' and make table 'T1_02' available
Progress:
Address ID PhaseNum CompletedWork TotalWork StartTime Description
I killed the hanging application as per the following link..
http://www-01.ibm.com/support/docview.wss?uid=swg21601085Hope this helps..
No comments:
Post a Comment