About markmumy

markmumy · 08-10-2023

Hey all!

markmumy · 01-20-2023

Over the years, many customers have asked for the ability to copy or move logins from one SAP IQ instance to another as part of the normal development progression. Times arise when you want to maintain the same password. Fortunately, there are meth...

markmumy · 06-03-2022

SAP IQ has a built in audit feature that is well documented in the manuals and in other blogs. On the operational side, however, knowing how to process the audit data and what to do with it is just as important. If you simply use the dbtran util...

markmumy · 04-07-2022

With the 2022 Q1 release of SAP HANA Cloud, the SAP HANA Database (HANA DB) features included the ability to read and write from SAP HANA Cloud, data lake files (HDLFS). The manuals contain a lot of valuable information, but it is spread between both...

markmumy · 11-19-2021

Let us note, first, that this blog and code applies to both SAP HANA Cloud, data lake (cloud IQ) and SAP IQ (on-premise IQ). For many SAP IQ use cases, customers have custom written scripts and various jobs to capture information about SAP IQ, includ...

markmumy · 05-05-2022

Aporup,Can you explain a bit more about what you want to do with DI and the source systems? How are you capturing changes? This is important as we released the Replication Management Service with DI Cloud recently. If you are using that to capture...

markmumy · 04-22-2022

When HDLRE/IQ parses the statement to pull data from the proxy table, it attempts to parallelize the fetch process so that performance can be improved. Each parallel thread logs into HANA to pull a subset of the data. During that process, the data ...

markmumy · 01-21-2022

Given that ASE 11 has not been supported in a VERY long time, there won't be much support for it. In fact, ASE 11 was end of life 20 years ago in 2002. You may find that PowerDesigner has older, deprecated definition files that would allow it to re...

markmumy · 11-19-2021

I would be remiss if I didn't mention the newly added monitoring views. Check out this link to the SAP IQ 16.1 SP05 views. The monitoring views were added to SAP IQ 16.1 SP04. They give quite a lot of the same information that you can get from sp_...

markmumy · 11-19-2021

Yes, I completely agree. Many customers use sp_iqsysmon, and other utilities, and extract relevant information either to the catalog or to external stores so that it can be used for historical analysis. This event could be augmented to include that...

User Statistics

User Activity

Hi

Copying a Login From One SAP IQ or SAP HDLRE Instance to Another

SAP IQ Audit Process (SAP ILM, SAP BW NLS/DTO, and Standalone SAP IQ)

Using SAP HANA Cloud, data lake files with SAP HANA Cloud, SAP HANA database

How to Capture Historical Database and DBSpace Sizes in SAP HANA Cloud, data lake and SAP IQ

Re: Loading Data from SAP DI to HANA Data Lake Files

Re: The fastest way to load data from HANA Cloud, HANA into HANA Cloud, HANA Data Lake

Re: Export only table definition including constraints and indexes in Sybase AS v 11

Re: How to Capture Historical Database and DBSpace Sizes in SAP HANA Cloud, data lake and SAP IQ

Re: How to Capture Historical Database and DBSpace Sizes in SAP HANA Cloud, data lake and SAP IQ