IBM Db2 for i

SAP on IBM i – Access to IBM Db2 for i SQL Editor via DBA Cockpit

The SQL Editor allows you to execute freely written SQL-statements. The SQL Editor supports only read statements. UPDATE, DELETE, INSERT statements or DDL (Data Definition Language) statements are not allowed. This new option is available for SAP NetWeaver 7.0 Enhancement Package 2 and SAP NetWeaver 7.30 or higher if the monitored system has been configured to use the data collected by the SAP Database Performance Collector for IBM i (see …

Read More »

SAP on IBM i Reference Architecture – Update 2017

Since many years, the SAP on IBM i Reference Architecture document is available to provide an overview over sample configurations and best practices when running SAP software on IBM i. It is the starting point for planning a complete new installation or enhancing existing systems for certain use cases, such as implementing high availability or adding specific solution components. The document has recently been updated to cover the latest technology …

Read More »

SAP on IBM i: Registration now open for the SAP on Power Summit DACH 2017 in Germany

Two weeks ago, we already informed you about the SAP on Power Summit DACH 2017, which will take place on November 7th and 8th at IBM in Böblingen, Germany (see https://blogs.sap.com/2017/09/07/sap-on-ibm-i-update-week-36-2017-save-the-date-for-the-sap-on-power-summit-dach-2017-in-germany/). In the meantime, the detailed agenda and the registration web page were made available at http://www.ibm.com/events/SAPonIBMPower2017. Register today to get the latest information about: Db2 for i Enhancements for SAP SAP’s Technical Monitoring Cockpit Single-Sign-On Options for SAP Fiori …

Read More »

Ad-Hoc SQL Statement Package Cleanup

Greetings fellow SAP on IBM i advocates, An SQL package, for those who may not already know, are caches the database uses to store data access plans (‘programs’) built for each SQL statement by the database optimizer and executed by the database access engine on behalf of requests from SAP application servers. An SQL package contains 10s, 100s or 1000s of entries similar to this: STATEMENT NAME: STMT00002 SQL Statement: SELECT …

Read More »

SAP on IBM i – Update week 36, 2017: Save the Date for the SAP on Power Summit DACH 2017 in Germany

On November 7th and 8th, 2017 IBM will host the SAP on Power Summit DACH 2017 in Böblingen, Germany. As in previous years, this international event will bring together customers, business partners and developers from SAP and IBM who are using or dealing with SAP on IBM i. You will learn about the latest trends and developments for SAP and IBM i, including some first-hand information about the integration of …

Read More »

SAP on IBM i – Update week 33, 2017: Alerts for IBM i System Limits

As your business is progressing and growing, the amount of data to keep in the database tables of your SAP system is growing as well. Like any other database, Db2 for IBM i has several technical limits that cannot be exceeded, among them the maximum number of rows in a non-partitioned table or a table partition, the maximum size of an index or the maximum amount of variable-length data. A …

Read More »

SAP on IBM i – Update week 31, 2017: Non-disruptive Backup Options

Backing up your SAP system on a regular basis is important to protect your business against any type of damage that can happen to your hardware or software. In today’s globalized world you cannot afford downtime, so you need to find ways to back up your SAP system while it stays up and running. We have learned about customers trying to use the FlashCopy feature of their storage subsystem and …

Read More »

Attention when Upgrading to SAP NetWeaver 7.40

If you are planning an upgrade to a target release of SAP NetWeaver 7.40, make sure that you include SP17 of SAP_BASIS into the upgrade procedure. This may affect you if you upgrade to EHP7 of SAP ERP 6.0 or EHP3 of SAP CRM 7.0, SAP SEM 7.0, SAP SCM 7.0 or other SAP products based on SAP NetWeaver 7.40. If you perform an upgrade, make sure that you include …

Read More »

SAP on IBM i – Update week 22, 2017: Updated Tools and Guides for Installation, System Copy/Rename, and Dual-Stack Split

The new version of the software provisioning manager, SWPM 1.0 Support Package 20, is now available for download: https://support.sap.com/en/tools/software-logistics-tools.html At the same time, the relevant guides for installation, system copy/rename, and dual-stack split have been updated. Note that, with the publication of SWPM 1.0 SP 20, we have removed the guides from our old publication platform on SAP Service Marketplace. Instead, they are available at the following locations: SAP Help …

Read More »

SAP on IBM i – Update week 20, 2017: Access to IBM DB2 for i DB Catalog Browser via DBA Cockpit

The DB Catalog Browser is the entry point for the analysis of the dependencies and usages for tables, views, functions, variables and triggers based on the information available in the system catalog views. This new option is available for SAP NetWeaver 7.0 Enhancement Package 2 and SAP NetWeaver 7.30 or higher if the monitored system has been configured to use the data collected by the SAP Database Performance Collector for …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration