rename dm_folder with 4 million subfolders

ilya basin · 2022-07-11T06:53:00+00:00

There was an error rendering this rich post.

Hi. I need to rename a dm_folder having 4 million subfolders. On the Acceptance env we have 200 thousand subfolders and the rename took 30 minutes. Now we need to do this on Production and I'm afraid that either Oracle or the Content Server will fail with not enough resources or the rename will take 10 hours.

Is there a faster way? Maybe stop the content server and manually set object_name, then do "update dm_folder_r set r_folder_path". Are there other places that need to be updated?

Find more posts tagged with

Comments

DCTM_Guru

Most of objects in DCTM are normalized, so what you are described should be fine, since documents are linked to the object ID of the folder (not the object_name nor the r_folder_path). I would test this out in DEV/TST env first.

Hicham Bahi

Alternatively, you could create a new folder with the new name and move all direct desendants to new folder. That would have the advantage of splitting up the rename operation in smaller transactions.

If you go with renaming directly r_folder_path (not supported really!), don't forget to requeue all folders to the fulltext index queue (in case you are using xPlore).

ilya basin

@bacham3 how do I invalidate a full text index entry?

Hicham Bahi

You don't. Just queue the folder again (using iapi queue or DFC IDfSysObject.queue()) and xPlore will update the entry.

ilya basin

Thank you all.