I was going through the java samaples(TDELETE.java) provided on the IBM Content Management Information Center for deleting a item. This program deletes a document, does this physically deletes a document from Resource Manager? or would I have to perform another delete operation to delete the item physically(from resource manager)?
I tried a similar program and after deletion I was not able to find the itemId in the itemtype table and the ICMSTITEMEVENTS table had an entry for this document as deleted. So does that mean that the document has been physically also deleted?
Please respond to my question above...
This topic has been locked.
Pinned topic Deleting a Document
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
JKMorrow 200000260U44 Posts
Re: Deleting a Document2012-06-04T13:37:05ZThis is the accepted answer. This is the accepted answer.When the item is deleted a row is put in the table ICMSTITEMSTODELETE, referencing the RM object. If you have a z/OS RM using OAM, running program ICMMOSDI will delete the objects from OAM.
Re: Deleting a Document2012-06-04T18:20:02ZThis is the accepted answer. This is the accepted answer.
- JKMorrow 200000260U
I did the same. I imported a document to Content Manager. Deleted the document via the utility. But I was not able to find an entry in the ICMSTITEMSTODELETE table for that itemId I deleted. Thats when I tried checking the ICMSTITEMEVENTS table and it said - Document Deleted.
Did I miss something? Where else can I search for the item id? A reference would help...
SystemAdmin 110000D4XK228 Posts
Re: Deleting a Document2012-06-05T00:55:51ZThis is the accepted answer. This is the accepted answer.
MikeAA 1000005XSB36 Posts
Re: Deleting a Document2012-06-05T22:34:57ZThis is the accepted answer. This is the accepted answer.When an item is deleted from the library server - entries are made in the ICMITEMSTODELETE as others mentioned. The physical file is not deleted from the resource manager at that time. JKMorrow gave you what is necessary to delete the file if you are using a z/OS resource manager. If your resource manager is on any other platform then how the resource manager gets cleaned up depends on the release of Content Manager. For version 8.4.x - the resource manager checks the ICMITEMSTODELETE table every 30 minutes (by default) and processes the deletions. For earlier versions you must schedule the migration utility. The first step in the migration utility is to do the deletes.
Re: Deleting a Document2012-06-06T14:22:38ZThis is the accepted answer. This is the accepted answer.
- MikeAA 1000005XSB
thats the problem, whenever I delete an item I'm not able to see that itemID in the ICMSTITEMSTODELETE table. Is it very fast? I checked the table the moment I deleted the item and the entry was not present in the that table.
I also tried deleting the item through the windows client and the same happened, no entry in the ICMSTITEMSTODELETE table.
So, I'm left with the question that how should I trace the resource manager holding this file if this table is never updated.
Also, I constantly kept checking the ICMSTITEMEVENTS table it showed the deleted item with event code 303 (Delete).
Any suggestions as to how can I trace the item to resource manager?
SystemAdmin 110000D4XK228 Posts
Re: Deleting a Document2012-06-08T18:12:55ZThis is the accepted answer. This is the accepted answer.
- gsharma84 060001P5VU
To find the name of the physical file, you'll need to know the CMBObject's ItemID and find the row in the RMOBJECTS table of the RM database. There's a column OBJ_PATH that has a number 1-99. The file will be under your LBOSDATA directory in the subdirectory named that number, and then L1.<itmeID>.V1 (V1 is for the version number if you have that implemeted)
Re: Deleting a Document2012-06-30T07:04:59ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Now that I have developed some understanding of CM I feel that there is some utility that is running in the background that is emptying my ICMSTITEMSTODELETE table.
Everytime I delete an image I'm not able to see its entry in the ICMSTITEMSTODELTE table as its getting emptied...It was only once that I saw an entry in that table and by the time i performed another select on that table, the entry was gone. Do you have any idea of any service that could be doing this...I checked purger and thats not running.
Is there any configuration parameter that may have been set that could be emptying the ICMSTITEMSTODELTE table like the DK_CM_DESTROY_DELETE flag (If I'm correct it cause irrecoverable delete)...