Skip to Content

I am from the Information Lifecycle Management team at SAP and ILM Store has recently been in the spotlight.

With the ILM Store, you have access to SAP’s own store for data retention. This enables the storing of archive files using Retention Management for SAP Information Lifecycle Management (ILM) in an SAP database such as SAP IQ or SAP HANA and stay within the SAP environment.

The storage media supported currently are:

  • File System (or within the same System DB)
  • HANA
  • IQ

This blog covers how to set up a basic ILM Store and use the same system DB as store or a secondary DB like IQ or HANA.

This document is just a quick setup checklist. Use the Installation & Config. Guide ILM Store document available in the below location for the complete document.

[[ ]]

Also refer the help documentation for more details.

You can follow the below steps to configure the ILM Store in an NW 750 SP02 and higher systems.


1. Prerequisites needed

To be able to use the ILM Store, the prerequisite is to switch on the ILM Store (ILM_STOR) business function and the Information Lifecycle Management (ILM) business function.


2. SICF Service for ILM Store

A service for ILM Store should be created and activated in transaction SICF.

  • Start transaction SICF and create a new service under node ILM and enter the following values.

Service name: ZILM_STOR (for example)

  • On the Logon Data tab, enter a user who has the authorization to access the ILM Store.

This user should have the following authorizations

-Authorization object SILMSTOR with activity ACTVT = 16 (Execute)

-Authorization object S_DATASET with the following values to this user so that the file system              can be used to temporarily store the data:

File Name: *


The following activities added to the authorization object:

06 = Delete

33 = Read

34 = Write

-Authorization object S_DEVELOP for temporary table creation


ACTVT = 07 and 40

-Authorization Object S_CTS_ADMI : CTS_ADMFCT = ‘TABL’

-Authorization Object S_CTS_SADM: CTS_ADMFCT = ‘TABL’


  • On the Handler List tab, enter the handler class (CL_ILM_STOR_WD_REQUEST_HANDLER).


  • Activate the service


3. Create RFC Destination

Go to transaction SM59. Create a new HTTP connection to the external server (type G).

Maintain the target host and service number corresponding to your system.

The path prefix that you define on the Settings tab represents the connection between the destination and the ICF node. So give the service path which you have defined using SICF in previous step.


4. Commands for using File System

You need three commands for working with the file system:


You can use the transaction External Operating System Commands (SM69) to execute these commands. Refer the ILM Store configuration guide (mentioned in point 1) for more information on this.


Command name: ILM_STOR_MKDIR

Operating system:


Operating system command: cmd /C mkdir

Parameters for operating system command: <empty>


Operating system command: mkdir

Parameters for operating system command: -p

3.[x] Additional parameters allowed



Command name: ILM_STOR_DIR

Operating system:


Operating system command: cmd /C dir

Parameters for operating system command: /AD /L /B


Operating system command: ls

Parameters for operating system command: -d

3.[x] Additional parameters allowed

4.Check module: FM_ILM_STOR_DIR_CHECK.


Command name: ILM_STOR_DIR_FILES

Operating system:


Operating system command: cmd /C dir

Parameters for operating system command: /AD /L /B


Operating system command: find

Parameters for operating system command: <empty>

3.[x] Additional parameters allowed

4.Check module: FM_ILM_STOR_DIR_CHECK.


If you cannot create these commands with the names as above, create it in your dedicated namespace.

You can run the report RILM_STOR_TEST_SM69 to create these Z commands for the UNIX and Windows NT systems.

Please note : If you are using this report to create the commands, then do after maintaining the origin in step 5. In this report you have to give your origin in the selection.



5. Configuration required for IQ and HANA

For IQ and HANA, there is a secondary database connection required.

In DBCO, this connection needs to be maintained.

The user entered in the DBCON entry needs to have the have the rights CREATE TABLE, INSERT, UPDATE and DELETE.

For IQ set variable ENABLE_LOB_VARIABLES into the public space:
set option PUBLIC.ENABLE_LOB_VARIABLES = ON. Also the UDA license needs to be generated for using BLOBs.

Use report ADBC_TEST_CONNECTION to check for any connection issues.



6. Store Origin Customization

  • Go to Transaction ILM_STOR_ADM_CUST and click on “Create”.
  • Fill the required entries:

  • Click on “Add Operational Origin”.

  • Fill in required details and save.

DB Connection  =  DEFAULT( for same system DB) or

Secondary DB connection name (in case of IQ and HANA DB)

  • Maintain Operational Customizing in transaction ILM_STOR_OPR_CUST.

Enter Client maintained in Administrative Origin client.

Select the namespace SYSTEM and maintain the operating system commands if you have created in your namespace, else you can keep the standard one itself. (Alternatively, you can use the report RILM_STOR_TEST_SM69 for the Z commands as mentioned in section 5.) This is required for the default set up and not needed in case of IQ and HANA DB.


7. Maintain entries in TILMSTOR_CF


8. Maintain entries in TILM_STOR_O_ROUT

Make an entry in TILM_STOR_O_ROUT table as below.

Go to SM30. Table – TILM_STOR_O_ROUT -> New Entries.

SAP System ID : <System ID>

Client: <Client>

Data Source: <Your operational origin>


9. Activate SRS for ILM Stores

To use Storage and Retention Service (SRS) for managing ILM stores, you need to activate SRS in the application system.

To activate SRS, the following options are available:

  • Activate the SRS that runs locally in the application system.
  • Activate the SRS that runs on a separate (remote) system. For this option, you need an HTTP connection between the relevant systems.

Please use the below help link to set this up.


10. Maintain Store in ILMSTOREADM

After you have created the destination, you can enter it in the list of stores that are available for the SRS. Do the below for this.

  • To do so, start transaction ILMSTOREADM.
  • Enter the following values:

ILM Store: An identifying name for the store

Description: Descriptive text

HTTP connection: The previously created RFC destination



11. Testing the Store


Test file system access via ILM Store using Report RILM_STOR_TEST_PF_SINGLE.

Provide RFC destination and execute.

Use report RILM_STOR_TEST_CLEAR to clear previous test entries.

The logs can be seen through SLG1 -> Object = ILM_STOR.



Run the health check reports to check your configurations.

Check the errors and warnings and check if action need to be taken.


  1. RILM_STOR_TEST_HC_SERVER – You use the Health Check for Server Configuration report to validate the configuration settings and the viability of the ILM Store. The report identifies missing configuration settings, which can cause communication errors.


  1. RILM_STOR_TEST_HC_CLIENT – If you also want to check for archiving client also, use the report RILM_STOR_TEST_HC_CLIENT to validate the configuration settings of the archiving client that communicates with the ILM Store.

Enter the following ILM Store connection parameters:

  • Target Host – the name of the application server where the ILM Store is installed and configured
  • Port – the port number through which the two systems communicate using the HTTP protocol
  • ICF Service Path – the service that processes the requests from the client
  • System ID – the ID of the system to which the client connects
  • Client – the client number of the system to which the client connects

All values for the input fields are available in the results of the Health Check for Server Configuration (RILM_STOR_TEST_HC_SERVER) report.

Select one of the following execution targets:

  • Archiving Client (Local Storage and Retention Service (SRS)) – You make this selection if the execution target is an archiving client. In this option, the SRS is set to local on the archiving client. The report verifies the location of the SRS. If the location is local, the Health Check for Client Configuration report checks the SRS configuration directly on the archiving client system.

If the SRS is accessed remotely, execute the report for the client using the External SRS Client option.

  • External SRS Client – You make this selection if the SRS is set up as a remote service. The Health Check for Client Configuration report is executed on the external SRS system. The system skips the checks that are only relevant for the archiving client.


After this to test the archive files stored, create rules in IRMPOL for the required ILM Objects and give the store as the one created in point 10. Now run the archiving process and store the files and check if successful.


Following these steps, you should be able to successfully store your files into the ILM Store. In case of any issues, raise an incident to BC-ILM-STO.

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Former Member

    Excellent article Neenu.

    with this option “(or within the same System DB)” , where are the archive files stored?

    thanks  & Regards,


    1. Neenu Susan George Post author


      Hi Satya,


      When the operational origin is customized with the option ‘DEFAULT’, it is stored in the same system database tables.

      If you want this to be stored in the file system, then the customizing should be done in TILM_STOR_CUS as below.

      Origin Namespace Property Value

      You can see the file via AL11 then.




      1. Former Member

        Hi Neenu,

        I have tried this setup but facing some issues in ILMSTOREADM.

        also raised an OSS incident for the same 162908 / 2018 ILM with file system setup issues .

        Would you please check and let us know what’s missing ?

        Thanks in Advance,

        Best Regards,


  2. Petrica Avdei-Mina


    Thank you for your very valuable information!

    Please help me with some clarifications regarding ILM with IQ.

    We have followed your steps (and the ones from sap portal), until step 9 (Activate SRS for ILM Stores).

    The documentation is confusing regarding the HTTP connection which has to be created in order to maintain store in ILMSTOREADM. 

    Can you please provide us a hint regarding this RFC and http path?

    In your print screen from step 10, I see a ILSTORE_QI3. It is a connection to IQ database, wright? And if so, which path you use for it in RFC?

    Any help will be very much appreciated!

    Thank you once more!


    Peter A.

    1. Neenu Susan George Post author

      Hi Peter,


      In ILMSTOREADM, in the HTTP connection, enter the RFC connection you created in Step 3 . ILSTORE_QI3 is any name you can give to the store. You have to use this same name in the ILM rules in IRMPOL.


      Please let me know in case of any further queries.




      1. Petrica Avdei-Mina


        Thank you for your response!

        I have added the RFC connection in ILMSTOREADM.

        I’m new at this and maybe it is a stupid question, but i am a little confused regarding the sap IQ connection with ILM.

        So, if ILM store is defined on the live system with the RFC created on step 3, let say it is /sap/bc/ilm/ZILM_STOR, we have also a connection to sap IQ in DBCO, the connection between this two are made in Store Origin Customization, where we define Secondary DB connection name, in order the archived objects to be stored in IQ? If not…where?

        Thank you in advance!

        Best regards,

        Peter A.

        1. Neenu Susan George Post author

          Hi Peter,


          Yes the IQ secondary DB connection needed to be given in the operational origin customizing as mentioned in step 6.




  3. Kunal Sahi

    I am facing issue during ILM store configuration. I am trying to use file system as ILM store and followed all the steps as mentioned in the blog.

    But facing below issues while running report RILM_STOR_TEST_AT:

    –> 003)MKCOL /sap 405 Method not allowed

    –> 008)PUT res_0.xml 500 Internal server error

    Also, below error while running report RILM_STOR_TEST_HC_SERVER:

    –> Operating system command ‘ILM_STOR_DIR’ is missing

    –> Operating system command ‘ILM_STOR_DIR_FILES’ is missing

    –> Operating system command ‘ILM_STOR_MKDIR’ is missing

    Necessary customization done in origin for ZILM_STOR_DIR command as suggested in blog but even then these errors are coming.

    Please provide your suggestions and help to resolve these issues.



Leave a Reply