Technical Articles
SAP-NLS Solution for SAP BW(/4) all Releases
Last Changed: 23rd of November 2022
SAP-NLS Solution for SAP BW(/4) all Releases
Blog Content
- Introduction
- Overview/Roadmap
- Implementation
- NLS Performance
- NLS Partner Solutions
- Additional Blogs
- Blog Comments
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
- New – SAP NLS Solution for BW(4) – Overview 2021
- SAP’s Commitment to On-Premise SAP IQ Customers (May 2020)
- SAP-NLS Solution – Update Q1/2017
- SAP IQ Product Availability in PAM
Find the SAP IQ as a Near-Line Storage Solution on the SAP online documentation:
- SAP BW/4 2021 – Configuring SAP IQ as a Cold Store
- SAP BW/4 2.0 – Configuring SAP IQ as a Cold Store
- SAP BWoH 7.50 – SAP IQ as a Near-Line Storage Solution
- SAP BW 7.40 – SAP IQ as a Near-Line Storage Solution
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
- Note 1737415 – SAP IQ: Enable remote/secondary connect to SAP IQ
- Note 1796393 – SAP BW near-line solution with SAP IQ
- Note 1999431 – SIQ: Setting up SSL for connections to IQ
- Note 2133194 – Can SAP IQ run in a cloud environment?
- Note 3017355 – SAP IQ 16.1 SP04 PLx – correct SAPIQDB.cfg settings
- Note 3094594 – Enable SAP IQ for DBACOCKPIT
- Note 3085053 – Landscape Considerations for NLS and ILM
- Note 3119008 – Configure SAP IQ and HANA for SDA/ODBC
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.
- Note 1025273 – Near-line interface: Technical documentation
- Note 2320378 – Near-line Interface version 1.11 (SAP_BW 7.50 SP05)
- Certified partners for Nearline Storage
- Note 1405664 – DB6: Near-Line Storage Impl. (Supplementary Note)
- Note 1834310 – DB6: Use of DB2 BLU Acceleration with DB2 Near-Line Storage
- Note 2353001 – DB6: NLS Impl – Changes in the Interface IF_RSDA_NEARLINE_CONNECTION
- SAP First Guidance – combining SAP-NLS with the PBS NLS Add-On
- SAP App Center – PBS archive add on’s
- PBS Solution for migration to SAP NLS IQ
- PBS – CBW for SAP NLS with IQ
- PBS Nearline Analytic Infrastructure
- DataVard – OUTBOARD datatiering
- DataVard – shrink your database
- DataVard – BENCHMARKING OF SAP BW NLS SOLUTIONS
- DataVard – How to setup NLS on HADOOP in 3 steps
- DataVard – BW stragglers – NLS read-only problem solved
Blogs/Questions
(refer to other publications on the NLS community)
-
- Blog – How to Capture Historical Database and DB Space Sizes in SAP HANA Cloud, data lake and SAP IQ
- DSAG Blaupause 3-15 – Aus Zwei mach Eins
- Blog – How to keep Enterprise Flash Applications accessible in 2021
- Question – SAP BW4HANA DTO – Delta update not working in Cold Store
- Blog – How to Perform the HANA Archiving Process
- Blog – Data Warehousing Terminology – “Jump Start”
- Blog – Reporting on NLS (Near-Line Storage) Archive
- Blog – Print real backup filenames with SAP NLS events
- Blog – Automating SAP IQ backups using IQ cockpit
- Blog – HANA composite provider (HCPR): Practical Tips
- Blog – Performance killer SAP BW Open ODS view?
- Blog – Data Archiving for SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA
- Evaluation of SAP® IQ 16 Multiplex Performance with Various Storage and Network Technologies
Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics
@RolandKramer
“I have no special talent, I am only passionately curious.”
Hi,
SAP HANA on disk when it comes to warm data is still supported? I thought that only extension nodes are now the option for warm data, i.e. DT.
Thanks for clarification,
Jan
Both options are available. DT is also possible for native HANA scenarios and single node and EN is the preferred option for BW on HANA .
Best Regards Roland
Hello Ronald, great post.
we are thinking on of implementing the NLS for a SAP BW 7.4 on HANA SP14, and we have a question, is it possible to archive in the NLS the advanced DSO or is it only possible with DSO classics / cubes? This for a BW 7.4.
Thanks!
Hi,
using aDSO as NLS objects only works with SAP BW on HANA 7.50, see -
Best Regards Roland
Thanks for the reply Ronald, and for BW 7.4 is there any restriction for classic DSO and cubes? I say this because in the image above it says that the inventory cubes are added.
Thanks again!
Thanks Roland for the informative blog!!
We understand BW/4HANA supports SAP IQ NLS solution. If customer already implemented IQ NLS solution in the existing BW system (non-HANA DB), then customer wants to implement BW/4HANA with green-field approach, and hope to somehow reuse the existing NLS objects in IQ. Is there an option for it? Thanks again for your time!
Hello,
Yes, of course you can use the existing data for reading in the BW/4HANA Greenfield Implementation, but only one System can be the producer of the data.
In your case, the non-HANA BW System has created the historical data and not the BW/4HANA Greenfield Implementation.
Best Regards
Roland
Hi Roland,
Thanks for the reply!! One question to follow on the reading of existing IQ data.
We have concerns on the object type change in BW/4HANA. For example, the IQ object was created based on an infocube in the existing non-HANA BW system. With the BW/4HANA implementation, we will create ADSO to replace the infocube. How to link the existing IQ object with the newly created ADSO in BW/4HANA, from technical perspective? Hope my question is clear. Thanks again!!
Hi
the data would be unchanged and also the structure of the data will not have mayor changes. As already said, my doubt is the initial producer of the historical data.
Please note we are currently looking for customer to pilot the so called "remote conversion"
Best Regards Roland, PM EDW, SAP SE
Thanks Roland!
Hi Roland,
Is there any update on remote conversion?
Regards, Sudheer T
https://blogs.sap.com/2016/10/11/software-application-lifecycle-management-sap-bw/#bw4hana
Hi Roland,
As mentioned Straggler Mgmt. functionality is available with BW 7.5, is it available as 7.5 feature or need to install any Add-On? In case of Add-On’s, what are the available options.
Regards,
Hi,
As already said: from SAP it is only available on Pilot Request from 7.50 SP04 onwards (no Add-On needed)
The Straggler Solution is available from PBS Software from 7.0x onwards without any restrictions based on the CBW NLS Add-On.
Best Regards Roland
Hi Roland,
I've one concern GL, AA, AP, AR, and Inventory data can't be archived? because when I am discussing with my colleagues his claim is since this modules data will be stored in cumulative basis so its not preferable to do data archiving.
can you please share your thoughts on same.
FYI we're on BW 7.4 on HANA landscape.
Regards,
Harish
Hi,
Inventory Cubes can be archived with Nearline storage, but I´m not familiar with GL, AA, AP, AR.
Can you be more specific?
Best Regards Roland
Hello Roland,
Could you please tell me, how to perform NLS archiving for SAP BW7.50 powered by HANA to a HADOOP system?
Regards,
Alejandro
Hi Alejandro, You might want to start with the following note:
Hello Philipp,
Thank you for your answer. I have another doubt, maybe you can help me with this one too.
I have read that the master data can´t be archive and is considered hot data by SAP. In the other hand, in some blogs they said it can be done, but don´t mention the risks implades.
Do you know anything about this?
Thank you in advance,
Regards
Hi, Nope, no clue at the moment. Kr, Philipp
Dear Mr. Kramer,
Dynamic Tiering 2.0 is offering the multi-store table (https://help.sap.com/viewer/e0950e0116e8493d8d4c42762c5d2552/2.00.0.0/en-US/4c842551951e410690804e2b30a3bb16.html).
I can imagine that they could be quite useful in relation with data tiering as the logical table object can be distributed among HANA memory and an extended storage. Is it planned for BW to use these tables one day? IMHO it would allow to bypass some of the limitations of NLS.
Kind regards, Philipp
Hello, Just found this note: 2374459 - DataStore Object (advanced): Dynamic Tiering per partitoin. I will check for the technical background which is used for the functionality which receives a correction with the mentioned note. Regards, Philipp
...And another question: In the new roadmap for NLS (Feb. 2017), you mention for cube like ADSOs on page 7 "in staging mode". Could you please briefly let me know, what the "staging mode" is?
Again thanks, Philipp
Hi,
this means you can switch between aDSO for planning (locked against load) or load modus (locked against planning). The procedure is handled by process chains.
Best Regards Roland
Many thanks for letting me know. Kr, Philipp
Hi,
we have recently installed sybase IQ as Near Line storage. It will be linked with Quality System of BW. While searching for license of type CP under test system in SAP marketplace I couldn’t found any. It is showing License Type as DT. Can anyone please tell me which license type we have to use for quality server and what kind of installation needs to be done. will it be of type CP or DT.
Thanks
Hi
the easiest way is to use the license which is mentioned in the
Note 2372218 - Requisite IQ licenses for SAP-NLS solution - SAP BW with SAP IQ Nearline-Storage
as also mentioned in the SAP First Guidance – SAP-NLS Solution with SAP IQ
Best Regards Roland
Hello Roland, this question is a bit not exactly linked to this blog but somehow related. The customer currently has PBS addon and has been using this solution for NLS IQ for years and now recently migrated to the SAP NLS solution. Would now like to get rid of the ABAP addon PBSCBW and the namespace /PBS/ .. how do we go about such a cleanup?
Hi,
Actually if you have the PBS Add-On, you have more Functionality than SAP would ever deliver.
Furthermore PBS has tools, to migrate the data to the SAP Notation, which is independent from the Software Namespace.
In addition the PBS Add-on is upgrade compatible
Best Regards Roland Kramer
Hello everybody,
I have some concerns regarding to SO version:
So the questions is...
Which are the special requirements that must be achieved to run NLS (Sybase IQ)? or Where could I find them?
Thank you
Read the BLog above -
Hi Roland,
In the roadmap document it states
Please check the Roadmap mentioned in this Blog above
http://go.sap.com/documents/2016/06/f6fdb616-767c-0010-82c7-eda71af511fa.html
Best Regards Roland
Hi Roland,
we are facing an issue when we are adding the one field to NLS enabled ADSO.
Is there any prerequisite to follow.
Regards,
Prasad V
Hello Prasad
As always, use the Launchpad to search for potential corrections for your release as stated in the following Blog:
https://blogs.sap.com/2015/11/17/increasing-the-sap-nls-performance/#sapcorrections
Best Regards Roland
Hi Roland,
Once the data is archived in NLS, it is said that we can have an SDA connection to read the data, But what does SAP recommend, should we create a virtual table on NLS table and use it in calculation view and a new report on top of it or is there a way that the virtual table created using SDA can be used with existing info-provider?
Thanks
Hi,
If SAP-NLS is implemented via SDA there is nothing in addition to do, and of course you can use virtual providers to access the data
https://help.sap.com/viewer/2e90b26cf7484203a523bf0f4b1bc137/7.5.8/en-US/4c2c60d7477f51e6e10000000a42189b.html
Best Regards Roland
Hi Roland,
Might be I am reiterating the question :).
Kind Regards,
Mohit
Hello Mohit
1. The Pilot Program for "Straggler Support on aDSO for SAP BW 7.50 on HANA" was stopped recently.
2. At this time there is no adequate solution from SAP available.
3. using a partner solution from PBS-Software for Straggler Support on classical objects like DSO
Best Regards Roland
Hello Roland,
thanks for this valuable Blog. Helped me already quite a few times.
I`m currently in the planning phase at a customer who is leveraging BW 7.50 on Oracle with NLS on IQ. Next year they will move with their BW to BWoH 7.50 running on IBM Power. We have various surrounding Systems like DS, SLT, BI Platform etc. Repositories for those Systems will be hosted on DB2.
As we can see from this Blog, DB2 is also supported as storage for NLS. I got two Questions where i hope you can help me:
Thanks and Regards
-Seb.
Hi Roland,
We've enabled SDA option and we could see improvement in query runtime when NLS data is read. However report runtime degraded when Online (HANA) data is read, in RSRT I could see query is reading NLS where 80% of time spent ( 0 records are selected/transferred), since all the data is in memory only. Any suggestion/advise would be of great help.
Regards,
RK
Hi,
Please check the following BLOG: Increasing the SAP-NLS Performance
for additional Performance Hints
Best Regards Roland
Hi Roland Kramer,
Good Day!!
There is a requirement that the data models and reports are in SAP BW 7.5 SP7 on DB2 and also data was archived through NLS in DB2.
Now want to migrate this to SAP BW on HANA/BW4HANA with NLS option as Hadoop or SAP IQ.
How to handle the migration of currently enabled NLS in DB2 to SAP BW on HANA/SAP BW4HANA for archived data?
Appreciate your quick help on this.
Regards
Suresh
Hello Suresh
our Software Partner PBS Software can handle this requirement
Their Software Add-On which allows to convert from any NLS Archive to SAP IQ based Archive
https://blogs.sap.com/2016/10/12/sap-nls-solution-sap-bw/#nlspartners
Best Regards Roland
Thanks Roland for the quick reply.
Is the PBS Software also valid for migrating to SAP BW/4HANA ?
i.e., Migration of currently enabled NLS in DB2 to SAP BW/4HANA for archived data?
Hi,
please refer to the Information above
https://blogs.sap.com/2016/10/12/sap-nls-solution-sap-bw/comment-page-1/#nlspartners
At this time there are no Partner Add-On's available for BW/4HANA
This could be changed in the Future.
Best Regards Roland
Hi,
we are planning to implement a NLS to reduce our BW database.
Is there a recommendation for a hardware sizing (number of CPUs / RAM / HDD)?
Thanks and best regards
Uli
Hello
Everything which is related is mentioned in the Document - SAP First Guidance – SAP-NLS Solution with SAP IQ
We also have an IQ Database Installation routine available which includes all relevant sizing settings. This can be provided on demand
Best regards Roland
Hello Roland,
thanks, the document is very helpful. There's only one question I couldn't get answered clearly: if we decide to build our NLS in a virtual environment, is it necessary to reserve fixed CPU resources? Or can it be handled dynamically?
Thanks and have a good weekend.
Uli
BW Straggler:
Are the any roadmap for the problem with the BW stragler for archived data in NLS ?? If an delta record is loaded to a target and the records to updated has been archived the delta load will fail. The only option is then to 1) reload the archived data 2) update the delta load 3) archived the data again.
Hi,
see the comments above.
the Pilot availability ist stopped, which the Software Partner PBS can handle these requests
Best Regards ROland
No restrictions, everything is possible ...
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
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
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
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
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
Hi,
loading back data from the NLS archive to the primary database uses the same DAP settings
Best Regards Roland
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?
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
Hi Patrizia,
Were you able to resolve this issue? If yes, could you please share?
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?)
Everything to know in the Document - SAP First Guidance – SAP NLS Solution with SAP IQ
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
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
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
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
Hello Roland,
Are there the option to use a third party database instead of SAP IQ with NLS and BW?
Thanks in advance.
Regards
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
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

Hello Satoshi Tsuruya
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
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
Hello Satoshi Tsuruya
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