sysadmin shrink and pack functions
Question: Can shrink and pack functions on Informix tables be run during business hours without locking users out? Answer: Yes, if using online modes (e.g., "table repack shrink") and no exclusive locks are held. Offline repack ("table repack_offline") acquires exclusive locks and blocks access, so should be done during maintenance windows.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
can this be run on a table during the online day will it lock users out of the table being processed?
No, if no other exclusive lock is being held during your transaction processes, and supposing you are running shrink and repack in online modes. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: bruce.simms@talx.com > Subject: sysadmin shrink and pack functions [29039] > Date: Fri, 7 Dec 2012 08:57:12 -0500 > > can this be run on a table during the online day will it lock users out of the > table being processed? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Hi Bruce,
There are 2 options that you can use to repack tables, the one is to run
execute function task ("table repack shrink", "table", "database", "owner");
this can be run during the day - I do use it on a large database with many
active users.
The other way would be to run an offline repack
execute function task ("table repack_offline", "table", "database", "owner");
execute function task ("table shrink", "table", "database", "owner");
This version acquires an exclusive lock on the table.
Regards
> To: ids@iiug.org
> From: bruce.simms@talx.com
> Subject: sysadmin shrink and pack functions [29039]
> Date: Fri, 7 Dec 2012 08:57:12 -0500
>
> can this be run on a table during the online day will it lock users out of
the
> table being processed?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>