OnDemand User Group

Support Forums => Documentation => Topic started by: kilvroch on May 03, 2016, 04:36:01 AM

Title: arsdoc delete clarification please
Post by: kilvroch on May 03, 2016, 04:36:01 AM

We are using CMOD V9.0 for Multiplatforms, with a db2 database on Linux

Can someone please clarify what the ARSDOC Delete option does?
Does it delete both the db2 index records and the object from the cache?
Or does it delete just the db2 index records  and leave the object "orphaned" in the file system?
in the documenation for
http://www.ibm.com/support/knowledgecenter/SSEPCD_9.0.0/com.ibm.ondemand.administeringmp.doc/doddo003.htm?lang=en (http://www.ibm.com/support/knowledgecenter/SSEPCD_9.0.0/com.ibm.ondemand.administeringmp.doc/doddo003.htm?lang=en)

Quote

DELETE function

Use to delete documents from the system.

To identify the documents that you want to delete , you must enter an SQL query or specify the name of a public named query. The SQL query must contain clauses, database field names, index values, and operators. The DELETE function deletes all documents that match the query.

in the documenation for IBM iSeries, it specifically says it only deletes the index records
http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/com.ibm.ondemand.administeringi5os.doc/doddo003.htm?lang=en (http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/com.ibm.ondemand.administeringi5os.doc/doddo003.htm?lang=en)

Quote

DELETE function

The following information applies to OnDemand for Multiplatforms. Use to delete documents from the system.

Use to delete index records that point to individual documents in IBM® Content Manager OnDemand. The data will still exist on disk or archive media, because the documents being deleted might represent only a few pages of an entire input file. However, the data will no longer be retrievable after the index records are deleted.

Title: Re: arsdoc delete clarification please
Post by: Justin Derrick on May 03, 2016, 07:04:22 AM

It deletes index records only.  CMOD compresses and combines documents into "objects" and stores them.  In the majority of cases, it's not possible to delete an object without affecting other documents.

There's a little more information on how object names (which you'll find in the DOC_NAME field inside data tables) are formatted in the wiki:

https://cmod.wiki/index.php/DOC_NAME

Title: Re: arsdoc delete clarification please
Post by: kilvroch on May 03, 2016, 08:17:32 AM

thank you

Title: Re: arsdoc delete clarification please
Post by: kilvroch on May 04, 2016, 01:35:26 AM

I found a good explantion of the expiration logic here:
http://www-01.ibm.com/support/docview.wss?uid=swg21206601 (http://www-01.ibm.com/support/docview.wss?uid=swg21206601)