archive link tables in xml DAS

[Former Member]

Hi,

SAP NW PI 7.31 single stack, we are planning to configure archiving using XML DAS administration. During XML-based archiving the meta data and the property indexes used for value-based searches of archived data are stored in the database of the AS Java. The actual data that has been archived is stored in filesystem.

We want to configure deletion procedure for tables which stores these archive links.

What are the tables that stores these archive links to access archived messages from file system?

Is there any standard procedure by  SAP for deleting data from these link tables?

Thank you.

[ACE-SAP]

Hi

Have a look at table TOAR7 - SAP ArchiveLink: Request table (asynchronous storage)

Regards

[Former Member]

Hi Yves KERVADEC

Thanks your reply.

But I am not able to find table TOAR7 with java schema. We are on PI 7.31 single stack, no abap stack exists.

Please let me know if it exists with different schema name.

Best Regards, Prasanth

[ACE-SAP]

Hi

Just a blind guess, I've got an XI dual stack system but archiving is not setup.

Looking at Java schema that table might be the one you're looking for.

Regards

desc sapsr3db.BC_SLM_ARCHIVE ;

Name                                      Null?    Type

BSA_ID                                    NOT NULL NUMBER(19)

BSA_ARCH_LIST_ID                                   NUMBER(19)

BSA_GUID                                           NVARCHAR2(36)

BSA_NAME                                           NVARCHAR2(60)

BSA_SIZE                                           NVARCHAR2(20)

BSA_URL                                            NVARCHAR2(256)

BSA_OS                                             NVARCHAR2(20)

BSA_DB                                             NVARCHAR2(20)

BSA_STATE                                          NVARCHAR2(20)

BSA_DOWNLOAD_ID                                    NVARCHAR2(20)

BSA_MODIFIED_ON                                    NUMBER(19)