Hi Saradhi, Sorry for interrupting the question.
The admin or task routine that performs the defragment function can be executed for a specific table or index. There is no option to perform the entire database.
https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/ids_sapi_107.htmThe defragment function can be performed online, but I think it is burdensome to perform the entire table and index in batch.
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
Original Message:
Sent: Tue May 05, 2020 09:03 PM
From: Saradhi Motamarri
Subject: Reclaim Dbspace after a purge operation
Hi Art,
I read in one of your posts that to reclaim table/ index space after a deletes, needs to run the API function ("table shrink") and ("index shrink") manually.
Is this process can be run for an entire database (as many tables might have been cleaned in a purge operation)?
How heavy this operation, mean any impact to the online transactions when the shrink operation runs in the background?
#Informix