Product Information
ILM Store Configuration
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
- HADOOP
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.
[[ https://help.sap.com/viewer/product/SAP_INFORMATION_LIFECYCLE_MANAGEMENT/7.0/en-US ]]
Also refer the help documentation for more details. https://help.sap.com/saphelp_nw74/helpdata/en/27/017835919640619f07e7fc3e6ef599/frameset.htm
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: *
Program: CL_ILM_STOR_DATASET===========CP and RILM_STOR_PUT_WORKER
The following activities added to the authorization object:
06 = Delete
33 = Read
34 = Write
-Authorization object S_DEVELOP for temporary table creation
OBJTYPE = ‘TABL’
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:
- ILM_STOR_DIR
- ILM_STOR_MKDIR
- ILM_STOR_DIR_FILES
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:
1.WINDOWS NT:
Operating system command: cmd /C mkdir
Parameters for operating system command: <empty>
2.UNIX:
Operating system command: mkdir
Parameters for operating system command: -p
3.[x] Additional parameters allowed
4.Check module: FM_ILM_STOR_MKDIR_CHECK
Command name: ILM_STOR_DIR
Operating system:
1.WINDOWS NT:
Operating system command: cmd /C dir
Parameters for operating system command: /AD /L /B
2.UNIX:
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:
1.WINDOWS NT:
Operating system command: cmd /C dir
Parameters for operating system command: /AD /L /B
2.UNIX:
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.
In case, you want to use the File System as storage media, change the entries as below in SM30 for table TILM_STOR_CUS.
Origin | Namespace | Property | Value |
adk | DB | DBCON.TILM_STOR_BLOB | SAP_CONN_DEF |
adk | DB | CONSYS.SAP_CONN_DEF | SAP_SYS_FILE |
7. Maintain entries in TILMSTOR_CF
In transaction SM30, Table – TILMSTOR_CF -> New Entries.
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 REPORT
Report RILM_STOR_TEST_PF_SINGLE can be used to test the store functionality.
For this, the test origin archeb is used.
In table TILM_STOR_CUS (use transaction SM30), create the entries for archeb similar to how you have maintained for your origin.
In the report selection, provide the 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.
HEALTH CHECK REPORTS
Run the health check reports to check your configurations.
Check the errors and warnings and check if action need to be taken.
- 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.
- 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.
STORING ARCHIVE FILES
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.
Excellent article Neenu.
with this option "(or within the same System DB)" , where are the archive files stored?
thanks & Regards,
Satya
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.
You can see the file via AL11 then.
Regards,
Neenu
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,
Satya
Good Informative Blog Neenu !! Most helpful !!
Hello,
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!
Regards,
Peter A.
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.
Regards,
Neenu
Hello,
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.
Hi Peter,
Yes the IQ secondary DB connection needed to be given in the operational origin customizing as mentioned in step 6.
Regards,
Neenu
Hi Neenu,
Thank You so much for your replay!
I have some errors on RILM_STOR_TEST_HC_SERVER test:
- Logical file name 'ILM_STOR_FILE': assigned logical path 'ILM_STOR_PATH' is invalid
- Logical file name 'ILM_STOR_REQ_SHARED_FILE': assigned logical path 'ARCHIVE_GLOBAL_PATH' is invalid
- Origin 'archive': namespace 'SYST.PLACES': missing property 'ILM_STOR_FILE'
But in the documentation does not says how the path should look in case of SAP IQ. ILM_STOR_PATH is <P=DIR_TEMP>\<FILENAME>. where should be the dir_temp, on sap server or on IQ database? what the string should look like? Can you please give me an example?
Thank you in advance!
Best regards,
Peter
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.
Thanks.
Hi Kunal,
For the error in RILM_STOR_TEST_HC_SERVER, check if note 2584029 is implemented in your system.
Regards,
Neenu
Hi Neenu,
Thanks for your help. The issue is resolved after note implementation as suggested.
Best regards,
Kunal
Hi Neenu,
Thanks for your suggestion and help. After note implementation, the issue is resolved.
Could you please further help to resolve below issue.
Store job is getting canceled.
Please find below job log:
500: Internal error in data archiving service or in lower-level server components
DA Service Message: Problem occurred while inserting data via facade
500: Internal error in data archiving service or in lower-level server components
Job cancelled after system exception ERROR_MESSAGE
Also, below error message is coming while running report RILM_STOR_TEST_AT:
–> 003)MKCOL /sap 405 Method not allowed
–> 008)PUT res_0.xml 500 Internal server error
Best regards,
Kunal
Hi Kunal,
The MKCOL 405 is because the collection already exists at the store. You can use report RILM_STOR_TEST_CLEAR and rerun to resolve the MKCOL error.
For the PUT error, check in SLG1-> Object ILM_STOR, the errors for PUT command.
Regards,
Neenu
Hi Neenu,
Thanks for your guidance. MKCOL error resolved.
I have tried to find solution for PUT error but could not find any SAP help documentation on these issues.
Could you please help and provide your guidance to resolve below issues.
Please find below PUT error from SLG1 transaction:
Best regards,
Kunal
Hello Neenu ,
I am trying to establish connection to existing HDFS storage via ilmstoreadm but am facing the generic error message . Am able to connect http connection via SM59 and customization has been performed based on https://help.sap.com/http.svc/rc/c7ec00060b1946ada9e6898100250c77/7.0/en-US/HadoopConnectorConfigurationGuideSP13.pdf
It would be great if you share some lights on fixing this case.
598: Input or output error (triggered during access to file system, WebDAV, or data stream; see long text)
CX_XADK_DAS_SERVER
DA Service Message: _DEFINE_ARCHIVE_STORES: Store HDPRM Does Not Support the WebDAV Log
I opened OSS note for this case 329471 / 2018 We are trying to connect HADOOP store via ILM store
Thanks
Satya
Thanks for the great blog Neenu, FYI: The links for the SRS config in step 9 are broken.
Hello Nate,
Thanks for the feedback. I have updated the new link.
Regards,
Neenu
Hi Neenu,
Thanks for your Blog.
Could you please help to resolve below issue.
Store job is getting canceled.
Please find below job log:
500: Internal error in data archiving service or in lower-level server components
DA Service Message: Problem occurred while inserting data via facade
500: Internal error in data archiving service or in lower-level server components
Job cancelled after system exception ERROR_MESSAGE
Regards,
Harshit
Hi Neenu ,
Thanks for your Blog.
I had performed all configuration steps as per your blog & test result for Report RILM_STOR_TEST_PF_SINGLE is good , however I am still getting below error in SLG1
"Requested URI does not exist"
"Parameter HANDEL was not provided"
Also report RILM_STOR_TEST_HC_SERVER was not completely green. please see below screen shot.
Could you please help to resolve above error.
Thanks & Regards
Sanjiv Kumar
Hello Neenu,
Kindly help to resolve above error please.
Thanks & Regards
Sanjiv Kumar
Hello,
Did you managed to resolve your issues?
Regarding ILM_STOR_FILE and ...REQ_SHARED... you must change in file the logical path. must be like this:
Logical File: ILM_STOR_FILE
Physical file: <space>
Data format: DIR
Applicat. Area: BC
Logical Path: ILM_STOR_FOLDER
Logical File: ILM_STOR_REQ_SHARED_FILE
Physical file: <space>
Data format: DIR
Applicat. Area: BC
Logical Path: ILM_STOR_REQ_SHARED_FOLDER
If you have a solution for URI error and SYST.PLACES...please provide the solution you have found.
Thank you!
Regards,
Peter
I'm getting similar error and same options I tried but getting same error.. Please suggest the error soln
Hello,
I'm not sure if this is the same issue, but one SAP consultant told me to change the value as below, in sm30, table TILM_STOR_CUS. It worked for me.
Regards,
Peter
thanks, this one resolved
but while running test cases getting
what I need to look. I'm using IBM tivoli server where they're saying its on tune process then what should i do to complete this test case in 10 sec..
We are setting ILM with file system storage and when we perform the test ILM DB Store Performance Test (Simple), we are getting the error “PUT 500 Internal Server Error” (/sap/tst/pf/single/res_01.bin). Can you provide some assistance on what is the missing element to correct this error?
SAP_BASIS 740 – SP15
RILM_STOR_TEST_PF_SINGLE Log.
AL 11 Log file.
Hi Edward,
Check the customizing in TILM_STOR_CUS table.
Neenu
That was updated as shown below.
Hi @all,
Neenu, thank you for the good blog!
We try to implement ILM with HDB as store. Our System is ERP 6 EHP 7 with NW 7.4 SPS 17. Application server is on Windows, DB is HANA.
I implement already some note, also 2377873, 2675643, 2629808
We are facing some problems.
First:
in report RILM_STOR_TEST_HC_SERVER we do get this error:
As mentioned in some replies above I used the value ILM_STOR_FILE:
If I try to set the value to ILM_STOR_FOLDER with transaction ILM_STOR_OPR_CUST an error occurred:
ILM_STORE_FOLDER is not a valid value for property ILM_STOR_FILE
I can change the value in sm30 directly in table TILM_STOR_CUS to value ILM_STOR_FOLDER. In RILM_STOR_TEST_HC_SERVER the same error occurs.
So I don’t know, what the right value is and how to set it.
Second:

When we execute report RILM_STOR_TEST_PF_SINGLE, the results looks like this:
In slg1 these errors
are displayed:
Third:
If we try to archived one item with transaction sara, we do get an error in joblog and slg1:
Logical file path is not completely maintained: See long text
But we do maintain in transaction FILE the logical path. The folder exists on server and is not read-only. sidadm and SAPServiceSID have read and write access.
So please can someone give us a hint?
Thank you so much!
Best regards Petra
Dear Neenu Susan George,
great blog - thanks.
Our SAP ERPs are running with Ehp7 (740) or Ehp (750).
Which SAP version and SPS level is needed to have the choice between file system, same system DB, HANA, IQ and HADDOP as storage media ?
Thanks and kind regards,
Arnd
Hi,
A min version of NW740 Sp15 or NW750 Sp3 is recommended to use these store options.
Please check the Q&A section with tag NW Information Lifecycle Management or https://answers.sap.com/tags/480041978550045079567539109400636
You would find these information.
Regards,
Revathi
Hi Neenu,
Thanks for the very informative blog. As per the blog, currently following storage media are supported by the ILM store.
Is there a recent update to the list ?
Is OpenText supported by the ILM store ?
Please share the SAP Note with this information if any?
Hi Preethish Shetty,
Apart from these 4 options, ILM certified Webdav servers can also be used as stored.
The certified stores list is available in the link:
https://www.sap.com/dmc/exp/2013_09_adpd/enEN/#/solutions?search=BC-ILM
You can also check Q&A with tag NW Information Lifecycle Management.
Regards,
Revathi
Hi just to clarify my understanding about Archive file storage.
Thank you the response in advance
Hi,
We are having a non unicode ECC EHP7 system where we would like to activate ILM and store archived data on Sybase IQ. Could you please let us know if it is possible to do it directly or we need to install a sap netweaver unicode system in Between ECC and Sybase IQ. In case we need to install a netweaver system in between what steps needs to be carried out in which system.
Below is reference diagram for 2nd scenario
Hi Again,
Sorry my first message was truncated. Here it is again.
WS