Administer > Manage WebSphere Commerce features > Marketing > Catalog and marketing attachments

Delete attachments from the database

You can manually delete attachments from the database to create more space for new data.

Before you begin

Before you delete any attachments review the following list of tables that can be affected:

• ATCHREL - Attachment Relation

• ATCHRELDSC - Attachment Relation Description

• ATCHTGT - Attachment Target

• ATCHTGTDSC - Attachment Target Description

• ATCHAST - Attachment Asset

• ATCHASTLG - Attachment Asset Language

• CMFILE - Content Managed File

• CMSMALLFILE - Content of CMFILE

• CMLARGEFILE - Content of CMFILE

• ATCHRLUS - Attachment Relation Usage

• ATCHRLUSDS - Attachment Relation Usage Description

Do not delete ATCHOBJTYP, Attachment Object Type, as this is part of the bootstrap.

To delete attachments:

Procedure

1. Backup the database. Refer to the database manual for instructions.

2. Delete the attachment relation by typing in the following statement at a command line:

   db2 delete from ATCHREL where ATCHOBJTYP_ID='objectype' and
   OBJECT_ID='XXX'  
   

   where objectype can be one of the following values:

   • 1; indicates that the attachment is associated with a catalog object type, catalog.

   • 2; indicates that the attachment is associated with a category, catgroup.

   • 3; indicates that the attachment is associated with the catalog entry, catentry.

   • 4; indicates that the attachment is associated to an espot, collateral.

   This will cascade delete to the ATCHRELDSC table. OBJECT_ID is the primary key of the associated table. If ATCHOBJTYP_ID=3 (catentry), then this corresponds to a CATENTRY identifier for example, @catentry_product_id_kitchenware_coffeemaker_1. If ATCHOBJTYP_ID=4 (espot), then this corresponds to the primary key in the COLLATERAL table

   If you only delete the relation, the attachment is prevented from showing up in the Accelerator however, it still exists in the database.

3. Delete the attachment target by typing the following statement at a command line:

   db2 delete from ATCHTGT where ATCHTGT_ID in (select ATCHTGT_ID from
   ATCHAST where ATCHASTPATH like '%subdirectory/filename%') 
   

   where :

   • filename - the name of the attachment.

   • subdirectory - the subdirectory where the file is located.

   This will cascade delete to the to ATCHTGTDSC, ATCHAST, and ATCHASTLG tables.

4. Delete the attachment object by typing in the following statement on a command line:

   db2 delete from CMFILE where CMFILEPATH like '%StoreDirectoryName/subdirectory/filename%' 
   

   where

   • filename - the name of the attachment.

   • subdirectory - the subdirectory where the file is located.

   • StoreDirectoryName - the name of the store directory.

   This will cascade delete to the CMSMALLFILE and CMLARGEFILE tables.

Results

The attachment is deleted from the database.

+

Search Tips   |   Advanced Search