EDUCAÇÃO E TECNOLOGIA

SAP ILM Store based on SAP IQ Database

Last Changed: 17th of February 2021


SAP ILM Store based on SAP IQ Database

the SAP ILM Store is the “Synonym” for all activities around Data Retention and Archiving Strategies with a SAP Transactional (OLTP) based System.

We will continue to use the Synonym “ILM” (Information Lifecycle Management) as the mayor term.

SAP%20ILM%20Store

SAP ILM Store

While the nearline storage functionality for the SAP Analytical (OLAP) based Systems like SAP BW and BW/4 with SAP IQ Database is well established, the usage of the SAP IQ Database for the general storage of R/3, ERP or S/4 Data is not really a common way at this time.

So let’s optimize the SAP ILM/Archiving Setup with the experiences and strengths of the SAP-NLS Implementation for SAP BW.


SAP ILM Documentation 

SAP%20ILM%20Origins

SAP ILM Origins

SAP ILM HelpSAP ILM Implementation GuideNW ILM Store

must seen Blog from Neenu Susan George (SAP)ILM Store Configuration

Ok, and that’s it. Here we can already add the Note
Note 2780668 – SAP First Guidance – BW NLS Implementation with SAP IQ

despite of SAP ILM or SAP-NLS, it is all about the SAP IQ Database Setup
Note 3017355 – SAP IQ 16.1 SP04 PLx – correct SAPIQDB.cfg settings

Just for the Record: the following SAP Notes are obsolete/not necessary, when the SAP IQ Database is installed in the mentioned way above

Note 2563024 – ILM Store – Collection of Notes
Note 2161052 – ILM Store: Free connection types
Note 2243603 – ILM Store: Utility for adding Connection IDs to Class Factory
Note 2257318 – ILM Store: Lock Exception using IQ
Note 2284492 – ILM Store: Message “Connection limit exceeded” on IQ
Note 2414314 – IQ: PUT succeeds, GET fails with Row not found
Note 2478703 – ILM Store – IQ: Put Succeeds, GET fails with Row not found for the Streaming Case
Note 2705663 – Collective information regarding ILM (Information Lifecycle Management)
Note 2748058 – During ILM storage “DETERMINE_PUT_TARGET” error occurs in SLG1
Note 2785785 – DAP ends with IQ Error SQL-131 Syntax error near ‘(end of line)’
Note 2806115 – Error binary data not supported on data longer than 32767 Bind host variable – SAP ILM and IQ
Note 2942648 – ILM store: error during storage of files with size greater than the streaming size
Note 2969212 – ILM : Error while deleting documents from ILM store set up as remote content repository

these are some correction in relation to SAP IQ

Note 3010127 – Dump CX_ILM_STOR_EXCEPTION during report RILM_STOR_TEST_PF_SINGLE
Note 3017579 – DBACOCKPIT: Monitoring multiple systems using the SQL Statements cockpit action
Note 3020979 – ILM Store : Performance improvements during the file retrieval process


SAP IQ Database Setup

Blog – Q – the easy Installer for SAP IQ
Installation of the SAP IQ Database with three Values, only SDA/ODBC Setup needed.

Report%20ADBC_TEST_CONNECTION

Report ADBC_TEST_CONNECTION

the is one little addition to the DBCO setup of the ILM Store.

DBCO%20Values%20for%20ILM

DBCO Values for ILM

tx.%20DBACOCKPIT%20-%20define%20the%20SAP%20IQ%20Database

tx. DBACOCKPIT – define the SAP IQ Database

tx.%20DBACOCKPIT%20-%20SAP%20IQ%20Database%20availability

tx. DBACOCKPIT – SAP IQ Database availability

tx.%20DBACOCKPIT%20-%20overview%20SAPSQ205%20IQ%20Database

tx. DBACOCKPIT – overview SAPSQ205 IQ Database

tx.%20DBACOCKPIT%20-%20SAPSQ205%20IQ%20Database%20Options

tx. DBACOCKPIT – SAPSQ205 IQ Database Options

tx.%20DBACOCKPIT%20-%20SAPSQ205%20-%20IQ%20Database%20Tables

tx. DBACOCKPIT – SAPSQ205 – IQ Database Tables


Setup SAP Information Lifecycle Management (ILM)

First of all, is to activate the ILM Framework with tx. SFW5 or maintain with tx. SFW2

SAP Help – Prerequisites for Using the ILM Store

Please Note, you have to use a Web based Method to do changes in the Business Framework. you can use the WebGUI for that task.

Note 2563024 – ILM Store – Collection of Notes

activate%20the%20ILM%20Database%20Store%20%28ILM_STOR%29

activate the ILM Database Store (ILM_STOR)

For the ILM Store usage there are several SAP Roles available. For a detailed description and the use of the authorisation objects, you can refer to the ILM Implementation Guide.

Roles%20for%20the%20usage%20of%20ILM

Roles for the usage of ILM


Configuration of ILM

as already mentioned, we are focussing here only on the usage of the SAP IQ Database together with ILM (no Azure BLOB, Hadoop or NFS will be covered).

This is where the official SAP Documentation will get lost …

Note 2243603 – ILM Store: Utility for adding Connection IDs to Class Factory

create an Entry in the Table TILMSTOR_CF for the created SAP IQ Database with the Report RILM_STOR_CF_DBCON

Table: TILMSTOR_CF
Interface: IF_ILM_STOR_DB_OPERATOR
for SAP IQ: CL_ILM_STOR_DB_OPERATOR_IQ

Report%20RILM_STOR_CF_DBCON%20for%20DBCON

Report RILM_STOR_CF_DBCON for DBCON

SM30%20-%20Table

SM30 – Table TILMSTOR_CF

Please Note, the Customizing Settings for the tx. SARI and SARA are only available, when the activation of the ILM Business Framework was successfully.

customizing%20tx.%20SARI

customizing tx. SARI

customizing%20tx.%20SARA%20-%201-2

customizing tx. SARA – 1-2

customizing%20tx.%20SARA%20-%202-2

customizing tx. SARA – 2-2

tx.

tx. AS_AFB (SARA)


Define the Origin Concept for ILM

Origin%20Concept

Origin Concept

The Origin supports the ILM Store in determining the data origin and is a central element of the configuration of the ILM Store. Basically you define in this two Transaction from were the Data is coming from, and were it will be stored. In our Case of course the defined SAP IQ Database.

Details of creation the Origin can be found in the ILM Implementation Guide.
Additional hints can be found in the Blog from Neenu Susan George ILM Store Configuration

  • ILM_STOR_ADM_CUST (ILM Store Administrative Customizing)
  • ILM_STOR_OPR_CUST (ILM Store Operational Customizing)

tx

tx. ILM_STOR_ADM_CUST

tx

tx. ILM_STOR_OPR_CUST

tx

tx SM30 – Table TILM_STOR_CUS

tx.

tx. SM30 – Table TILM_STOR_O_ROUT


Setup and Publishing of the ILM Store

Details of the Publishing of the ILM Store  can be found in the ILM Implementation Guide.
Additional hints can also be found in the Blog from Neenu Susan George ILM Store Configuration

  • tx. SICF (HTTP Service Hierarchy)
  • tx. SM59 (RFC Destination)
  • tx. ILMSTOREADM (access with WebGUI)

to publish the storage system using an ICF node, the SAP Backend must be correctly configured for the HTTP/S usage as described in the Documents

tx.%20SMICM

tx. SMICM

Note 2704178 – The error HTTP 500 “Redirect is not possible” occurs in /sap/public/myssocntl or in /sap/public/bc/icf/logoff

tx.

tx. UCON_CHW

tx.%20SICF%20-%201-2

tx. SICF – 1-2

tx.%20SICF%20-%202-2

tx. SICF – 2-2

tx.%20SM59%20-%20S4H_ILM_STORE

tx. SM59 – S4H_ILM_STORE

tx.%20SM59%20-%20test%20the%20RFC%20connection

tx. SM59 – test the RFC connection

tx.

tx. ILMSTOREADM (access with tx. WebGUI)


Testing the ILM Store

for the testing of the ILM functionality, there are various Report’s available, which moreless show a successful or errors which are not related to the Solution, rather than they are buggy in away … 😉
Additional checks can also be found in the Blog from Neenu Susan George ILM Store Configuration

  • Report RILM_STOR_TEST_AT
  • Report RILM_STOR_TEST_PF_REPEAT_BIG
  • Report RILM_STOR_WD_DEMO

Report

Report RILM_STOR_TEST_AT

Report RILM_STOR_TEST_PF_REPEAT_BIG

Report

Report RILM_STOR_WD_DEMO 1-2

Report

Report RILM_STOR_WD_DEMO 2-2


Done … 

Ok., that was a Hell of a Ride I have admit. It seems ILM Store is another Example of were the Investments went the last years at SAP, like – SAP Secure Login Server – your own CA on Hand …

Nevertheless, this is another proved Example of SAP (Sybase) IQ Multi Purpose Database.
It is true: SAP (Sybase) IQ – the hidden treasure …


Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics
@RolandKramer

“I have no special talent, I am only passionately curious.”