Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP-NLS Solution for SAP BW(/4) all Releases

RolandKramer
Active Contributor
‎10-12-2016 4:55 PM

Last Changed: 23rd of November 2022




SAP-NLS Solution for SAP BW(/4) all Releases


Blog Content






Page - Sybase solutions strategic for data management

Blog -  SAP (Sybase) IQ – the hidden treasure …
new Blog - SAP ILM Store based on SAP IQ Database




Introducing the real world and best practice use case with nearline storage (NLS)




And now: Introducing the Hasso's View at SAPPhire 2019






Introduction


Improve decision-making capabilities by bringing unprecedented performance to SAP Business Warehouse with SAP HANA for current data and SAP IQ for historical data – achieving the perfect balance of cost and performance. The adapter for SAP IQ as a near-line solution is delivered with the BW system. The Integration of SAP IQ makes it possible for you to separate data that you access frequently from data that you access rarely, thus making less demand on the resources in the BW system. The near-line data is stored in compressed form. You can thus reduce the costs incurred by data that is accessed less frequently.

With the current Release of SAP BW 7.40 Feature Pack 02 (based on 7.40 SP08) some interesting improvements and updates were released for the SAP-NLS Solution based on SAP IQ SP10. Also including the latest SAP-NLS Features for SAP BW 7.50 and 7.50 SR1 (based on 7.50 SP04)

Please Note that the SAP-NLS Solution can be used with all supported database version supported by SAP BW 7.3x and onwards. Together with NLS Partner solutions, Nearline storage for SAP BW can also be enabled from SAP BW 7.0x releases onwards.





Overview and Roadmap





Find the SAP IQ as a Near-Line Storage Solution on the SAP online documentation:





Installation and Implementation


Blog - Q - the easy Installer for SAP Sybase IQ
Blog - enable SAP IQ for DBACOCKPIT
Blog - demystifying NLS/ILM error messages …


 


IQ simplex server architecture - SAP IQ database


 
sq1adm@hostname:/usr/sap/SQ1/data/db> 

dbisql -c "uid=SAPSQ1USR;pwd=Sybase4me;DSN=hostname_SQ1_11" -nogui



(SAPSQ1USR)> sp_iqlmconfig;

Property                             Value

--------------------------------------------------------

Licence Notice

Edition                              EE

License Type                         CP

Application Type                     null

IQ_CORE License Count in use         80 (CPU core based)

Optional license in use : IQ_UDA     Yes(Allowed)

Optional license in use : IQ_LOB     Yes(Allowed)

Optional license in use: IQ_SECURITY No (Allowed)

Optional license in use: IQ_MPXNODE  No

Optional license in use: IQ_VLDBMGMT Yes(Allowed)

IQ_VLDBMGMT License Count in use     1 (Max Allowed : 4)

Optional license in use: IQ_UDF      No (Allowed)

Optional license in use: IQ_IDA      No (Allowed)

Optional license in use: IQ_URIDA    No (Allowed)

Email Severity                       NONE

SMTP Host                            smtp

SMTP Port                            25

Email Sender

Email Recipients



(19 rows)



(SAPSQ1USR)>

SAP License for NLS and ILM usage



SAP IQ SDA/ODBC configuration


 



Find the detailed installation of the SAP IQ as a Near-Line Storage Solution in the
End-to-End Document - SAP-NLS with SAP IQ which refers to

Note 2780668 - SAP First Guidance - BW NLS Implementation with SAP IQ

SAP First Guidance – SAP NLS Solution with SAP IQ
https://archive.sap.com/documents/docs/DOC-39627 => points to the Document above.


Installing and Configuring SAP IQ as Extended Storage for SAP HANA
you will see, that the implementation is exactly the same as implementing SAP-NLS

SAP IQ "How-To" Video Tutorials
the tutorials giving you a nice insight how IQ works ...

How to Archive Data from SAP NetWeaver BW to SAP Sybase IQ as Near line Storage
SAP Help - Creating Data Archiving Processes (DAP)
Wiki - Archiving Business Data in BW

Note 2551457 – SAP IQ 16.1 SP 03 Supported Operating Systems and Versions
Note 2669590 - SAP IQ 16.1 SP 04 Supported Operating Systems and Versions
Note 3060790 - SAP IQ 16.1 SP 05 Supported Operating Systems and Versions

Notes for Installation and Implementation


Note 3196447 - troubleshooting an existing SAP IQ 16.x Implementation for NLS/DTO and ILM

Additional Information can also be found in the Blog Section





Since SAP BW on HANA 7.50 SP04 Hadoop as NLS Storage is possible as well.
Note 2363218 - Hadoop NLS: Information, Recommendations and Limitations
SAP Help: Hadoop as a Near-Line Storage Solution
Blog: Apache Hadoop as NLS solution for BW/HANA - Part 1 - Part 2 - Part 3

See also - Set Up Hortonworks Hadoop with SAP® Sybase® IQ





Optimizing the SAP-NLS Performance




BLOG: Increasing the SAP-NLS Performance
BLOG: SAP BW on SAP HANA & SAP HANA Smart Data Access
BLOG: Monitoring Nearline Storage Tables and Partitions from BW
BLOG: SAP Sybase IQ 16 sets Guinness World Record with 34.3TB per hour for Big Data Loading





NLS Partner Solutions


Please note that the Partner Interface for Nearline Storage is only supported in SAP BW and is not available in BW/4HANA (SAP NLS IQ and SAP NLS Hadoop are supported). See also the SAP-NLS Roadmap referenced above for more information.

IBM

PBS Software

DataVard






Blogs/Questions
(refer to other publications on the NLS community)







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

 

“I have no special talent, I am only passionately curious.”
73 Comments
UH1
Discoverer
‎04-16-2018 2:01 PM
0 Kudos
 

Hi Roland,

is it useful for any reason to implement also a "test"-NLS conntected to the DEV system?

Or is the regular way to have only a productive NLS?

I'm asking because of planning an additional hardware invest or not.

Thanks and have a good day.

Uli
RolandKramer
Active Contributor
‎04-16-2018 5:14 PM
0 Kudos
Hi,

a test NLS connection is needed to define the DAP processes, as they will be transported to the productive BW System which is connected to the productive SAP IQ database

Best Regards Roland
former_member378806
Discoverer
‎01-29-2019 2:53 PM
0 Kudos
Hi,

Can Data Tiering based on temperatures (hot, warm, cold) be applied to aDSO's in "BW on HANA" (7.5 SP11)? When I check the aDSO in our system, I only see the checkbox “SAP BW Data Tiering” and no setting for temperartures… Is there documentation available for temperature settings when using “BW on HANA”…

Best regards, Frank
RolandKramer
Active Contributor
‎01-31-2019 9:47 AM
0 Kudos
Hi,
DT is only available with BW/4, but you can always do SAP-NLS despite BWoH or BW/4 leading to the same result

Best Regards Roland
former_member243202
Explorer
‎07-18-2019 4:31 PM
0 Kudos
Hi Roland,

Thanks for the blog! This is a one stop shop for Archiving using NLS.

One question when loading data back from NLS to the infoprovider is there a way we can specify filter and load only data for a specific condition.

Thanks

Saranya

 
RolandKramer
Active Contributor
‎07-19-2019 11:16 AM
0 Kudos
Hi,

loading back data from the NLS archive to the primary database uses the same DAP settings

Best Regards Roland
g1_chilukury
Newcomer
‎09-04-2019 8:59 PM
0 Kudos
Hi Roland,

 

We are on BW/4HANA with SAP IQ for NLS(cold store). We did not enable any warm store( extension node). What are the best practises for warm store/extension node?
patrizia
Member
‎10-17-2019 12:35 PM
0 Kudos
Hi Roland,

we have a problem when trying to archive data from an ADSO (corporate memory) into the NLS. During phase 35 we get a job termination / shortdump TSV_TNEW_PAGE_ALLOC_FAILED.

It seems that the request is too big, but have no chance to add some filters,as it is a request-based archiving.

If we reduce the request size to a few days, it works, but this is no practical solution, because we have a lot requests and also some big initial requests.

We use BW 7.50 / SP15 (HANA 2.0 / Stack 4) and SAP IQ 16.

Do you have any ideas / suggestions, how we could solve the problem?

Thanks in advance and best regards

Patrizia

 
sudheertallam
Explorer
‎04-01-2020 9:49 AM
0 Kudos
Hi Roland,

Is there any update on remote conversion?

 

Regards, Sudheer T
former_member184682
Participant
‎04-08-2020 9:16 PM
0 Kudos
Hi,

which are the dbspaces required to be used for a SAP NLS solution (IQ_SYSTEM_TEMP, IQ_SYSTEM_MAIN and <user_dbspace1>, <user_dbspace2> etc depending on the number of SAP systems archiving into this NLS server?

i could not find a command in the guide which explains creation of IQ_SYSTEM_MAIN. how is this db space created (at the time of install?)
jadhavni
Explorer
‎04-21-2020 1:56 PM
0 Kudos
Hi Roland,

We are implementing NLS newly in our BW landscape. We created DAP and transported successfully from Dev to Quality. After import, DAP  shows inactive in quality. Is there any way or any program by which we can activate these DAP in quality.

 

Nitin  Jadhav
RolandKramer
Active Contributor
‎04-22-2020 9:08 AM
0 Kudos
Everything to know in the Document - SAP First Guidance – SAP NLS Solution with SAP IQ
RolandKramer
Active Contributor
‎04-22-2020 9:22 AM
0 Kudos
Hello Nitin/Raymond
every DAP needs a target DB to verify.
either you create a new user in the SAP IQ for the Test System (which automatically creates a new Schema in the Database, which is sufficient to test), ot you setup for every BW System in the Landscape it's own dummy Database connection to use.

nevertheless, you will need at least two SAP IQ Databases in your SAP BW Landscape

Best Regards Roland
former_member669846
Discoverer
‎05-13-2020 1:47 PM
0 Kudos
Hi Patrizia,

 

Were you able to resolve this issue? If yes, could you please share?
sigi
Discoverer
‎05-26-2020 11:46 AM
0 Kudos
Hello Roland,

thanks for the good information. I'm working with BW 750 SP13 and NLS. By executing a query and with use of the NLS-variable it is possible to decide whether to read or not to read data from NLS. Is there another possibility to read NLS data only if it is necessary without using the NLS variable? A "dynamic" decision without knowing, if it is necessary to read NLS or not?

Best Regards

Sigi
RolandKramer
Active Contributor
‎05-26-2020 12:00 PM
0 Kudos
Hello Sigi

when you open the query you have to decide whether you will read the historical data or not. I cannot imagine a functionality which decides this for you.

if the NLS archive is broken, you can change the settings in tx. RSDANLCON to "emergency mode" to prevent the query for failing. this would lead to the behaviour that the query is used without the reading of the historical data despite if the connection to NLS is available or not.


then you could use the NLS variable to switch on the reading or not, but there is always a user decision

best regards Roland
STM23
Explorer
‎06-22-2020 3:10 PM
0 Kudos
Hello Roland,

Are there the option to use a third party database instead of SAP IQ with NLS and BW?

 

Thanks in advance.

Regards
RolandKramer
Active Contributor
‎06-22-2020 3:22 PM
0 Kudos
If you use the Software Add-On for BW(/4) from datavard, you can use additional third party databases without the support from SAP. you are completely dependent from the support of datavard, as they are not using the standard Interface from SAP.

Anyway: the Certification for any NLS Add-On was phased out anyway since SAP BW/4HANA, as the Interface is frozen now and all software works with BW and BW/4

SAP only supports SAP IQ and Hadoop as secondary data target for SAP-NLS.

Best Regards Roland
kairi2210
Explorer
‎11-28-2022 7:08 AM
0 Kudos

Hello Roland,
Thank you for your awesome blog.Really appreciate your time and effort.

We've install and manage to setting the SAP IQ.
And we are now been trying to move our data to our cold storage.
Its been 3 days but the data has not been moving at all, so we checked RSDANLCON and found out about this error.

Do you know how can we expand this PITRLog?

Regards

RolandKramer
Active Contributor
‎11-28-2022 1:48 PM
0 Kudos
Hello kairi2210

you should completely deactivate the PITR Functionality on IQ as it is not necessary anyway, see also the Document - SAP First Guidance – SAP NLS Solution with SAP IQ 16.x

Best Regards Roland
kairi2210
Explorer
‎12-12-2022 7:59 AM
0 Kudos
Hello Roland,
Thank you for your replies.
Really appreciate it.

I just want to confirm with you few things if we deactivate the functionality for PITR.
1. if we do so , how do we restore our back up to certain time of period if theres any disaster happen?
2. In the guide book , i did not find any guide on how to deactivate the PITR function and also why is it not necessary to do so?

I am sorry i am confused about this, hopefully u can answer me.
Really appreciate your hardwork.

Satoshi Tsuruya
RolandKramer
Active Contributor
‎12-12-2022 11:00 AM
0 Kudos
Hello kairi2210

1.) nothing will happen in a disaster situation als for NLS and ILM, you have clear guidance an failover once the Backup is written. As said -  SAP First Guidance – SAP NLS Solution with SAP IQ 16.x => Chapter 3.2.5 and 5.2.3.2

2.) En/disabling PITR  => 'off'

You don't have to be confused about this. PITR was developed for IQ in the need of dynamic tiering with HANA, and this solution is more less deprecated, as it had more disadvantage then the way around.

Best Regards Roland
Labels in this area
Popular Blog Posts