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
  • 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.

https://help.sap.com/saphelp_pobuilder10/helpdata/en/49/1ccd91d83d4a7f846788f36bd01013/content.htm?no_cache=true

 

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.

 

  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.

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.

To report this post you need to login first.

22 Comments

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,

    Satya

    (0) 
    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
       <origin>  DB  DBCON.TILM_STOR_BLOB  SAP_CONN_DEF
       <origin>  DB  CONSYS.SAP_CONN_DEF  SAP_SYS_FILE

      You can see the file via AL11 then.

       

      Regards,

      Neenu

      (0) 
      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,

        Satya

        (0) 
  2. Petrica Avdei-Mina

    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.

    (0) 
    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.

       

      Regards,

      Neenu

      (0) 
      1. Petrica Avdei-Mina

        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.

        (0) 
        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.

           

          Regards,

          Neenu

          (1) 
          1. Petrica Avdei-Mina

            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

             

            (0) 
  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.

    Thanks.

    (0) 
  4. Kunal Sahi

    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

     

    (0) 
    1. Neenu Susan George Post author

      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

      (1) 
      1. Kunal Sahi

        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:

        • Master entry missing in root table for TILM_STOR_AUDIT.archeb.005056AC02AF1ED89ED7EB62EA993A9F.DELETE.005
        • No data connection entered for table ZILMSTORRDF88DD4
        • No data connection entered for table ZILMSTORRDF88DD4
        • A program status that should not occur has occurred
        • An exception with the type CX_ILM_STOR_RUNTIME occurred, but was neither handled locally, nor declared in a RAISING clause

        Best regards,

        Kunal

         

        (0) 
  5. Satya Ramakuri

    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

    (0) 
  6. Harshit Kothari

     

    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

     

     

    (0) 
  7. Sanjiv Kumar

    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

     

     

    (0) 
      1. Petrica Avdei-Mina

        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

        (0) 

Leave a Reply