Inoffizielles deutsches Xbase-Forum

Transitioning to the New Table During Online Pack

Clients cannot transition to the new table until all locks on the table are released. The pack operation must wait until all updates to the table are committed before the transition stage can begin.

In order for a user to transition to the new table of an online pack, they must make a call to the server and reposition their record pointer. The server calls that can transition a user are Goto, GoTop, GoBottom, Skip, Seek, SetFilter, Append, SetRelativeKeyPosition, GoScopeEnd, GetFilteredRecordCount, GetRecordCount, and CloseTable. The online pack operation will not fully complete until all users of the table have transitioned. Note that the system procedure sp_PackTableOnline will return from the server when the transition stage begins. The entire operation isn't complete until all users transition to the new table, but the system procedure doesn't need to wait for that to happen before returning.