Author Topic: arsdoc delete clarification please  (Read 1368 times)

kilvroch

  • Guest
arsdoc delete clarification please
« 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
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
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.

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 1720
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: arsdoc delete clarification please
« Reply #1 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
« Last Edit: December 14, 2017, 10:52:21 AM by Justin Derrick »
#Install, #Educate, #Repair, #Upgrade, #Migrate, #Enhance, #Optimize.

IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SA #Performance #Security #Audits #Customizing #Availability #HA #DR #Training

kilvroch

  • Guest
Re: arsdoc delete clarification please
« Reply #2 on: May 03, 2016, 08:17:32 AM »
thank you

kilvroch

  • Guest
Re: arsdoc delete clarification please
« Reply #3 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