1 2 3 4 Previous Next

SAP on IBM i

53 Posts

Dear fellow SAP on IBM I enthusiasts,

A common way to run ADS is as a standalone service. An ADS hub provides Print Services and Interactive Forms to all SAP NW systems in your landscape.


ADS as a standalone hub

Because ADS components require a Windows, Linux or Unix installation, SAP entitles you to free-of-charge MaxDB licenses for running ADS as a standalone hub. All SAP NW Java installations provide a wizard for configuring ADS for use by other SAP systems:


SAP NW Java - ADS Wizard


For detailed information see SAP Note 2039539

Do you know how much your SAP performance is affected by your disk response times? If your overall SAP response times are good, you probably do not care much, but there are still reasons why this could be an interesting question, for example if you want to know if new storage technology (Solid State Devices or Flash Storage) can help your performance, or if you are looking for specific application areas that can be improved for better performance. The SAP and IBM performance tools can give you average values of disk response times and numbers of I/O operations, but you need to put that in relation to SAP response times in order to understand what the actual impact is.


When you look at the SAP response time in transaction ST03, you need to keep in mind that it consists of many components: GUI time, wait time, roll wait time, load and generation time, enqueue time, processing time and database time. Many of these components are not affected by disk response time, the biggest impact is probably in the database time. However, even the database time is not pure disk I/O, but there is also some – sometimes significant – processing time or lock wait time involved. Finally, when you look at the I/O requests themselves, you must consider that mainly disk read requests have an impact on the performance. Most disk write requests are processed asynchronously, so the application does not have to wait until the data is actually written, but can continue immediately, while it has to wait for most read requests to complete first. In addition, new storage technology (Solid State Drives or Flash Storage) is showing bigger performance gains on read requests than on write requests.


Example to calculate benefit of Solid State Devices or Flash Storage:


To estimate the possible gain of new storage technology, you can combine the data of the IBM i Performance Tools with the performance data of SAP (transaction ST03). In a first step, you get the number of disk read requests and the average disk response time for a specific day from the IBM i Performance Tools by creating a resource report for section “Disk Utilization”. The resulting spooled file is showing you the average numbers of read requests per second per interval (to be multiplied by the number of intervals per day) and the average service times for each disk unit. In a customer case that we had looked at, we got a total number of read requests in one day of 297,181,440, and an average disk service time of 3.5 milliseconds. Measurements have shown that Flash Storage would result in average disk service times of 0.5 milliseconds, so switching from spinning disks to Flash Storage would save 3 milliseconds per read request.


To put those numbers in relation to the SAP response time, we counted the number of dialog steps for all types of work (dialog, background and so on) in all SAP instances on that server. This resulted in a total number of 9,833,504 SAP dialog steps on the same day. A simple calculation told us, that we had an average of 30 disk read requests per SAP dialog step, so we can save in average 90 milliseconds per dialog step if we switch from spinning disks to Flash Storage. If your average response time was 600 milliseconds, this saving would reduce that to 510 milliseconds – a certain improvement, but maybe not the big break-through that you may have hoped for. We have seen very different results in real customer systems, so you may want to do the math in order to get a feeling for the impact of disk operations on your average SAP response times.


Tools provided by SAP and IBM:


SAP and IBM provide some tools to help you understanding the impact of disk I/O performance. On the SAP side, you can find the following tools:


ABAP SQL Monitor – SAP Note 1885926


The ABAP SQL Monitor is available for all SAP NetWeaver Releases from 7.0 onward. You can analyze specific SAP applications to find performance hotspots and also potential for optimizations.


I/O share in SQL statements – SAP Note 1869494


With this SAP Note, an ABAP report named ZDB4GETIOTIMESHARE is provided that produces an SQL plan cache dump and lists expensive SQL statements with their I/O share. This list can give you an idea whether your expensive statements are CPU bound or I/O bound, so that you can see if faster storage can help your performance.


IBM is providing the following tool:


SSD Analyzer Tool for IBM i


This tool evaluates the disk read times collected by the IBM i Performance Monitor and is giving you a recommendation based on the collected data.

In this update for SAP on IBM i we would like to inform you that SAP Solutions on IBM i are certified for IBM i 7.2 since Friday, May 30th 2014.

This certification is limited to SAP NetWeaver 7.x and SAP Business Suite solutions based on SAP NetWeaver 7.x that have been in Mainstream Maintenance or Extended Maintenance at the beginning of 2014 (see http://www.service.sap.com/pam and http://www.service.sap.com/maintenance for details). For additional information please refer to SAP Notes 2011710 and 68440.


IBM i 7.2 has been announced by IBM late April 2014 and is generally available since May 2nd 2014. For details about this release we would like to point you to the recent posting in the IBM blog "You and i" (see You and i: Announcing IBM i 7.2).

In our BLOG posting in October last year, Highly Available SAP on IBM i - Technical Reference, we described SAP on IBM i High Availability configurations using Power HA on hand of a technical reference. The reference explained how Power HA manages and monitors the database, file system, and SAP applications to provide switch-over and fail-over capability in the events of maintenance or failure.


The article today describes an extension to the HA architecture; namely, new integration of Power HA awareness into SAP management infrastructure. The enhancement is delivered by way of the latest SAP Kernel and SAP Host Agent patches according to SAP Note 1899637: "IBM i: PowerHA saphalib Integration".


SAP instances under management of PowerHA are clustered resources (CRG). A clustered SAP instance is one that can migrate between the member nodes of a high availability cluster. At the heart of the new integration resides a connector with which SAP-Start-Service (SAPSTRSRV) communicates with PowerHA to recognize and control the state of clustered SAP instances.


The integrated PowerHA awareness provides the following new features:

  • GUI Support for Clustered SAP instances via SAP MMC or SAP MC
  • SAP Command Line control of Clustered SAP instances (sapcontrol)
  • Consistent SAP instance Start and Stop

The picture below shows the architecture of the new support. The left of the picture shows typical management commands being issued by way of command or GUI. The issued commands are processed by a SAP-Start-Service agent as seen in the center of the picture. The SAP-Start-Service agent either communicates directly with its associated SAP instance (top right of the picture) or with PowerHA (middle right of the picture).


SAP Management of Clustered Instances

Both the SAP Microsoft MMC GUI and the Java based SAP MC provide menu items for observing and managing clustered SAP instances; the sapcontrol command line program offers the same features.


The screenshot of the SAP MMC in bottom left of the picture above shows the extended menu items enabled when SAP-Start-Service recognizes a clustered SAP instance. The table below explains how to use each of the methods.


SAP Microsoft Management Console

  -> Tab Software Downloads
  -> Search for Software Downloads
    -> Search Term: MMC

To enable the SAP MMC to monitor an IBM i instance, right click on the SAP Root branch of the MMC, select properties, then manually add the specification of at least one SAP instance for the <SID> (e.g. Central Instance: <sid> <host> <inst>: I70 as0090 09 [Add] + [OK]).

JAVA based SAP Management ConsoleThe java version is available by browser at http://<ibm_i_host>:5<inst>13/
Command Line sapcontrol Interface

The command line interface for sapcontrol is available by 5250 terminal as <sid>adm and issuing:

==> sapcontrol PARAM('-nr <inst> -function <command>')

or via QP2TERM or ssh shell as <sid>adm and issuing:

> sapcontrol -nr <inst> - function <command>

The primary sapcontrol commands that are affected by the integration are:

StartStart an SAP instance
StopStop an SAP instance
HAFailoverToNodeMove a clustered instance to another node
HAGetFailoverConfigRetrieve status of a clustered SAP instance
HACheckFailoverConfigVerifies software, checks PowerHA Licences


Consistent SAP Instance Start and Stop

Some typical automated SAP logistic operations use the ability to fully start and stop all SAP instances including the SAP Central Services instances (ASCS/SCS). With the integration patch, SAP-Start-Service is aware of those instances under influence of the PowerHA cluster manager. In such a case, SAP-Start-Service issues a state-full start-up and shutdown sequence; interacting with PowerHA to bring the SAP instance up or down. Short of this support, an instance shutdown might result in an SAP instance failover to anther node.



Highly Available configurations are complex in nature; the benefit is flexibility for maintenance and protection against system failure. Because the IBM i operating system integrates High Availability support for database, file system, and SAP applications, implementing a SAP HA solution on IBM i is basically as simple as it can be. The extended integration of PowerHA into SAP Landscape management described in this article brings SAP HA on IBM i even closer to seamless.

Welcome back to our blog series from the development team. Here is something you might have waited for.


nZDM for Business Suite on IBM i ...

Starting with SL Toolset 1.0 SP10 our platform supports the near Zero Downtime Maintenance option for SAP Business Suite. Basic idea of the option is to import content for application tables that comes from SAP already into the shadow system.

As big pieces of this workload used to be handled in downtime phase TABIM_UPG, we expect significant reduction of phase TABIM_UPG. In our lab tests we confirmed this, and not being surprised, we also observed increased overall runtimes.


... already used in the field


Two early adopting customers already gave us their feedback and were more than happy about the outcome: The process ran smooth and in fact, they found their overall runtime even similar to that of reference upgrades w/o nZDM. Minimum downtime was reduced by roughly 50% and, as expected, TABIM_UPG was reduced from 5-7h to roughly 2h.

So, if you want to give nZDM a try in your own environment, go into the details of the Further reading sections. Activation is as easy as chosing Advanced mode in the dialogs of module Configuration and click the check box for nZDM. And don't forget to share your experience with us so we can improve further ;-)



Further reading


In this update for SAP on IBM i, we would like to call your attention to an issue that we have recently discovered in the SAP kernel releases 7.40 and 7.41. Note that this only applies to you if you have configured ES/TABLE=SHM_SEGS. If you are running with the default ES/TABLE=UNIX_STD, you will not experience this problem. While ES/TABLE=UNIX_STD is the default and used to be significantly faster in IBM i releases prior to IBM i 6.1, the alternative ES/TABLE=SHM_SEGS can be significantly faster in IBM i releases 6.1 and higher when hardware with a large number of processors is used.

If you follow our blog, you may remember that we introduced the memory model ES/TABLE=SHM_SEGS for SAP on IBM i through the update in July 2013: SAP Memory Model on IBM i. At that time, the switch was enabled and tested for SAP kernel release 7.20 at patch level 220.

With SAP kernel release 7.40, SAP has introduced a new paradigm for memory management in SAP. Prior to 7.40, a large set of memory management related profile parameters had hard-coded default values, while with 7.40 and beyond, these default values will be calculated based on the size of the main storage available (PHYS_MEMSIZE). The details of these changes are documented in SAP Note 1864189.

Even though not listed in this SAP Note, profile parameter ES/SHM_MAX_SHARED_SEGS will also be calculated in 7.40 and show values between 1 and 9 depending on the available main storage. When ES/TABLE=SHM_SEGS is configured and ES/SHM_MAX_SHARED_SEGS is calculated to a value larger than 1, your SAP instance will not come up because the dispatcher discovers a conflict between the parameters ES/SHM_MAX_SHARED_SEGS, ES/SHM_MAX_PRIV_SEGS and ES/SHM_PROC_SEG_COUNT. We are going to provide a kernel patch for release 7.40 and 7.41 in the near future. Until the patch becomes available, you can follow the instructions of SAP Note 1998233 to work around that problem.


Update per April 17:

Meanwhile the patches are available on the SAP Software Download Center. The problem is solved with SAP kernel release 7.40 patch level 63 or release 7.41 patch level 29.

We would like to inform you about the following offerings by IBM for the SAP on IBM i community.  They will take place in the United States and Germany, but the presentations will be given in English language and are open to anyone around the world who is interested.


SAP on IBM i Summit Customer Event (May 15th-16th in Rochester, MN)

The first ever SAP on IBM i Summit customer event will be held on May 15th and 16th in Rochester, MN.  The event is exclusively focused on those customers that run SAP workloads on IBM and will include topics such as:


  • IBM i 7.2 and POWER8 announcements
  • IBM i and DB2 for i enhancements for SAP
  • SAP strategy and roadmap for IBM i
  • Leveraging advanced DB2 for i technology for SAP workloads
  • Eliminating downtime for SAP Software Update Manager functions
  • DB2 for i optimization and administration with SAP
  • Integration of PowerHA into SAP resiliency solutions
  • Leveraging the SAP on IBM i Center of Excellence

Speakers include SAP on IBM i experts, including developers and experts from the IBM i Development Lab in Rochester and from the SAP on IBM i Porting Team in Germany.

Business partners and IBMers are welcome to attend along with their clients.  There is no cost for attending the event.

For more information and to register, please go to the following website: http://www.ibm.com/partnerworld/page/stg_com_sys_ibmi-sap-summit.

SAP on IBM i Database Education (April 1st-4th and April 8th-11th in Rochester, MN)

Two upcoming SAP on IBM i classes have been scheduled that you might be interested in.  Both classes will be held in Rochester, MN.

The first class is scheduled for April 1st to 4th and is SAP NetWeaver on IBM i: Database Administration.  This is exact same class as SAP's ADM525 course and is part of SAP's NetWeaver administrator curriculum.  The IBM course code is DB2iSAPADM.

The second class is scheduled for April 8th to 11th and is SAP on IBM i DB2 Optimization.  This course focuses on optimizing and tuning DB2 for IBM i for SAP workloads.  The course code is SQLOPTSAPoni.

You can register for both workshops at http://www.ibm.com/systems/power/software/i/support/workshops/enrollment/form.html (select the workshop from the drop-down list on top of the screen under “Workshop summary” and then select “Enroll Now”).

DB2 – SAP on i Technical Forum (April 28th-30th in Frankfurt, Germany)

This technical education class for customers and IBM Business Partners is primarily focused on SAP on i System Administrators and Basis Consultants and will explain how to position and optimize the performance of an SAP on i implementation in comparison to other databases.  It will include topics such as:


  • Overview of generic database storage, access and processing problems and solutions
  • Overview of specific database management systems
  • Why the entire stack matters - or: Why moving to a new DBMS means moving to a new stack
  • Best Practices for SAP on i
  • Best Practices for DB2 for
  • iTools, techniques and next steps for proactive and reactive analysis and tuning

This class has a more technical focus and is different to the Rochester Summit Event (May 15th to 16th) which
provides a strategic positioning and roadmap for SAP on i customers.

Speakers are developers and experts from the IBM i Development Lab in Rochester.


Attendance fee: 2,500 €.

For more information and to register, please go to the following website: http://www.cancom.de/cn-713--ci-712--DE-WFS-de_DE-EUR.html?aid=754. Please note that the website is only available in German, even though the presentations are given in English. If you do not speak German but need more information or want to register, please send an e-mail to kristina.diesem@cancom.de.

Welcome in SAP on UBM i update! This time we will describe how to use ssh to do simple administrative tasks.

There are situations when one wants to access the SAP system on IBM i in the same way as a SAP system on UNIX, e.g. someone without IBM i knowledge needs to test the effect of modifications of SAP-Profiles.


SAP-Note 1966316 describes the steps necessary to set up a UNIX-like Environment for <SID>adm. This updates the paseinlpgm and the startsap/stopsap programs and creates/updates some UNIX-profiles in /home/<sid>adm.


You need an SSH-Client for your Windows-PC in order to use these features. A popular one is PuTTY, a free Telnet/SSH client maintained primarily by Simon Tatham.

Then log on to your IBM i System as user <sid>adm: After starting PuTTY and entering the host name you are presented with the 'login as:'-Prompt where you type in the user-name, hit <ENTER> and type in the password and hit <ENTER>.


Then you are at the mercy of the minimalistic '%'-Unix prompt and may start working --- but only if you know what you are doing.


To stop the SAP-System use the 'stopsap' command and to start it the 'startsap' command.


To leave the SSH-Session type 'exit'.

Customizing the UNIX-Environment:


The file .login_shell in the home-directory <sid>adm determines which UNIX-Shell is used for login. Standard shells are the preset C-Shell (/QOpenSys/bin/csh) or the Korn-Shell (/QOpenSys/bin/ksh93).


You can customize these shells by editing the .login (for csh) or the .profile (for ksh93). See the appropriate Unix documentation on how to do this.

Welcome at the SAP on IBM i update! This time we will focus on the new features of the CONVUSRCPT tool:


The current situation

All SAP Kernels in maintainance support the new userconcept

System installation and system copy tools (SWPM, Software Provisioning Manager) always create new SAP systems and instances with new userconcept

System upgrade and system update tools (SUM, Software Update Manager) require start releases >=7.0 to be on the new userconcept

After upgrading from start releases <7.0 an immediate switch to the SAP Kernel 7.20 and the new userconcept is strongly recommended

With the first SAP Product release that will not support an upgrade path from start releases <7.0 we will technically disable the classic userconcept


So there is no way to circumvent the conversion from the classic to the new userconcept!

...but we know the obstacle

In collaboration with customers and consultants we learned about two constantly growing directory classes.

The transport directories

The j2ee directories below the instance directories


Having at least one of these directories populated with many files slows down the conversion and drastically increases the downtime.

From this finding we invented a new conversion method ADVANCED consisting of three steps with two uptime and one shorter downtime step, while the former method now called STANDARD consists of one single large downtime step.


The three new steps creating the ADVANCED method are:

PRE_ADV  (uptime)       Conversion of the transport directories and preparation of the j2ee instance directory trees (if existing)

ADVANCED (downtime) Conversion of the remaining part (not transport or j2ee directories, but with the kernel lib and user profiles)

POST_ADV (uptime)      Conversion  of  the j2ee instance directory trees (if existing)


During our inhouse tests and the pilot phase on customer side we made the experience using the new ADVANCED method can shorten the remaining downtime step ADVANCED in comparison to the former conversion (now called STANDARD conversion ) by a factor of 5-10.


For more information, please see the rewritten SAP Note 1149318 'User concept conversion using the tool CONVUSRCPT' .


Stay tuned...

As the development team intends to maintain a consistent format, editions of the series will continue to be published.

On November 15th 2013, IBM i 7.1 technology refresh 7 became generally available. It can be ordered from IBM as PTF group SF99707. For an overview of the new features and enhancements in TR7, see the announcement letter at IBM i 7.1 Technology Refresh 7 offers performance, usability, and integration enhancements. More detailed technical descriptions can be found at IBM i Technology Updates.


If you are running SAP on IBM i, the following enhancements may be of special interest for you:


  1. IBM i 7.1 Technology Refresh 7 offers support for several new hardware features, such as solid-state drives (SSDs). For a complete list, see the anouncement letter that we link to above.
  2. The maximum size of an SQL index has been increased to 1.7TB. Non-partitioned tables could already grow up to 1.7TB, but for indexes, the size was still limited to 1 TB. This limit has now been increased.
  3. Phase 2 of the tracking of important system limits has been shipped. In our blog entry of October 25th 2013, we had already announced that: SAP on IBM i - Update week 43 2013: Proactively monitoring table size limits on IBM i. The following article provides a very good and detailed overview over the concept: OnDemand Tracking of Important System Limits on IBM i. In the meantime we found out, that you will only see an entry with SIZING_NAME = 'MAXIMUM NUMBER OF VARIABLE LENGTH SEGMENTS'  in view QSYS2/SYSLIMITS if you have a table that actually has more than 100 variable length segments. So if you don't see such an entry after applying the technology refresh, do not worry: You just don't have a table that is coming close to the critical limit.


The database enhancements in IBM i 7.1 technology refresh 7 are mostly available through DB2 PTF group SF99701 level 26 as well. Those enhancements will also be made available for IBM i 6.1 through DB2 PTF group SF99601 level 31, which is scheduled to become available on December 6th 2013. However, other features of IBM i 7.1 TR7, in particular the support of certain hardware components, may not become available for IBM i 6.1 at all.

Welcome to the SAP on IBM i update! I'd like to draw your attention to an upcoming event.


Meeting of the “SAP on IBM i” workgroups of the German SAP User Group (“Deutschsprachige SAP Anwendergruppe e.V. / DSAG”) and the German IBM User Group (“COMMON Deutschland e.V.”)


The DSAG is an SAP customer forum for German speaking customers in Germany, Austria and Switzerland and it is the largest SAP user group worldwide. For details please refer to https://www.dsag.de/dsaghome/dsag.html.
The COMMON Deutschland  is an IBM customer forum for Germany and is member of COMMON Europe. For details please refer to http://www.common-d.de.

On November 14th 2013, the “SAP on IBM i” workgroups of the DSAG and COMMON Deutschland get together for a one-day meeting packed with interesting presentations and discussions around SAP on IBM i. For details on the agenda and for registration purposes please refer to https://www.dsag.de/dsaghome/veranstaltungen/uebersicht/details/veranstaltung/dsagveranstaltung/20131114/list-88/kalender/AG_SAP_on_IBM_i_Treffen-4.html or http://www.common-d.de/index.php/component/eventlist/details/14-arbeitskreis-sap-on-ibm-i?Itemid=435 respectively.


Have a good time and see you later!

Like any other database, DB2 on IBM i has certain limits for maximum object size, maximum number of rows and many more attributes of database objects, such as tables and indexes. The limits are not always the same, some of the limits are being raised with newer releases of IBM i. The current SQL and database limits for IBM i 7.1 are documented here: SQL limits.


As you can see in the infocenter documentation, the maximum size of a non-partitioned table and the maximum size of a data partition are shown as 1.7 terabytes. However, we recently discovered another limit that should be proactively monitored on tables containing columns with variable length data, such as BLOB, CLOB, DBCLOB, VARCHAR and VARGRAPHIC columns. When the variable length data makes up a significant share of the overall table data, the maximum number of variable-length segments may be exhausted before the size limit of 1.7 terabytes has been reached.  It should be very rare that one encounters this limit, however it can be checked to ensure that this limit, and hence an error SQL0904 type 6, is avoided.


How do I know if my largest tables are affected?


On October 7, 2013 IBM has announced IBM i 7.1 technology refresh 7 (see IBM i 7.1 Technology Refresh 7 offers performance, usability, and integration enhancements). General availability for IBM i 7.1. TR7 is planned for November 15, 2013. With this technology refresh, the tracking of important system limits (catalog view QSYS2/SYSLIMITS) will be enhanced to show when tables reach the maximum number of variable-length segments. You can see more details here: Tracking important system limits. This function will also be made available for IBM i 6.1 at a later time.


We recommend installing IBM i 7.1 TR7 to be able to check these limits in an easy way.


If you wish to check these limits prior to installing IBM i 7.1 TR7, you can still find out if you have any tables which may be close to the limit by performing the following steps on tables that are close to or above 1 terabyte in size by following the manual steps below.


  1. Identify large tables in your SAP application server ABAP by using transaction DB02 or DBACockpit -> Space -> State on Disk. Select Object Details, leave the wildcard character '*' for the Table Selection and select the Update function. To see the largest tables on top of the list, select the column labeled as Size (KB) and sort the data in descending order.
  2. To map the SQL name(s) of the largest table(s) to the object name(s) at the operating system level, you can use interactive SQL (STRSQL or the System i Navigator) and execute the following query:
    WHERE TABLE_NAME = '<SQL name>'
  3. With the object name, enter the following command at a command line:
    This will create a spooled file named QPSRVDMP in your job.
  4. Use command WRKSPLF and option 5 to display the spooled file QPSRVDMP. Search for a string *QDDS using function key F16 repeatedly until you see the following text:
    OBJECT TYPE-           DATA SPACE                                      *QDDS
    NAME-        <object>  <object>              TYPE-          0B   SUBTYPE-          90
    CREATION-    09/30/05  15:03:57              SIZE-          0052060000
    OWNER-       <SID>OWNER                      TYPE-          08   SUBTYPE-          01
    ATTRIBUTES-          0800                    ADDRESS-       146D46E631 000000
    Make sure that you see the 0B as type and 90 as subtype - the search will also find other places where the object type is *QDDSI  instead of *QDDS. Note the value to the right of the text ADDRESS, or copy it into the clipboard (in the example: 146D46E631 000000).
  5. Use the command STRSST to start the system service tools and sign on with a service tools user. Select the following menu items in the given order:
    1. Start a service tool
    4. Display/Alter/Dump
    2. Dump to printer
    1. Machine Interface (MI) object
    11. Data space (0B)
    2. Find by object address
  6. Type or copy the address that was found in the previous step (in the example: 146D46E631 000000) and hit Enter. On the next screen ("MI Object Found") press Enter again.
  7. On the screen "Select Format", select option 2. Base structure. Specify a dump title (free text) and hit Enter. After that, you will see a message "Dump to printer successfully submitted" at the bottom of the screen. The created spooled file has the name QPCSMPRT.
  8. Leave the system service tools by using function key F3 multiple times.
  9. Use command WRKSPLF and option 5 to display the spooled file QPCSMPRT. Search for a string #AUXS using function key F16. You will see a text similar to the following:
    LAST1            000000000000AAAA        AUXT@            146D46E631 000DF
    #AUXS            00000040                #AXSL            00000057
    #AXEN            00000000000C0785        AXLUB            0B8DF2796E 70F60
    The hexadecimal number to the right of the text #AUXS indicated the number of variable-length segments currently in use, in the example 00000040. If this value approaches 0000FFFD, you are likely to hit the described table size limit.


What do I do if I approach or reach the limit?


If the critical table contains a lot of deleted rows, you may be able to free up space by reorganizing the table as described in SAP Note 84081. Please note that the space occupied by variable-length data can only be freed completely during an offline reorganization. While the offline reorganization is running, you may temporarily need twice the space of the table available on disk.


If reorganizing the table does not help, you can either archive some of the data and delete it from the table, or you can use table partitioning in order to distribute the data over multiple partitions that can each have the limit of one non-partitioned table. Background information about table partitioning in BW systems can be found in SAP Note 815186. Partitioning of non-BW tables should only be implemented after consulting the SAP on IBM i porting team. If you are planning to do that, please open a ticket for component BC-DB-DB4.


The above information will also be made available through SAP Note 1930962.

Hello fellow SAP on IBM i people,


I'd like to point out a newly published technical reference of a large scale SAP HA on IBM i implementation at Al Mansour Holding Company.



SAP on IBM i installations are often designed with Disaster Recovery (DR) in mind. Many DR configurations are based on having the database and file system in an independent mirrored storage pool (iASP) or mirrored by logical replication. By configuring an SAP system to also use replicated central services according to the SAP HA standard, the SAP system can be switched between hosts in near zero downtime for maintenance or in the case of failure.


The reference describes the technical details of how Al Mansour Holding Company operates three Highly Available SAP clusters for ERP, SCM, and BW based upon application HA with replicated SAP central services, database and file system mirroring with iASP, and managment by PowerHA for IBM i.


Click the following link to be directed to the IBM site where the reference is published: http://www.ibm.com/software/businesscasestudies/us/en/corp?synkey=S421730F77400A98; alternatively, click here to be directed to the PDF itself: https://ibm.biz/BdDzQL


By the way, if you are also considering installing or converting an SAP system to an Highly Available one based on SAP central services, or have further questions, we'd like to know; please open a ticket to BC-OP-AS4 and tell us.



    ... Eric

Welcome at the SAP on IBM i update! This time we will focus on the replacement of the ASCII NW RFC SDK in ILE by a UNICODE version:


Many of you already have recognized that there are several versions of the NW RFC SDK available for OS/400, while there is normally only one version for all of the other platforms. This standard version is a UNICODE one which we also ship (NWRFCU_xxx.SAR). Because most of you are not familiar in writing PASE c-Programms to link against this standard version we also ship some ILE versions of the NW RFC SDK.

The easiest version to use is the EBCDIC one (NWRFC_E-xxx.SVF). It allows to simply write a native ILE PGM to link against this version. But this version has many restrictions. It only accepts the latin characterset specified by the SAP Codepage 0120. For this reason we also supported an ASCII Version (NWRFC_A-xxx.SVF) as we are used to from the classic RFC SDK. Unfortunately this does not really work for the NW RFC SDK. So we were urged to ship an additional UNICODE Version (NWRFC_U-xxx.SVF).

This version has to be used in any case where the SAP Codepage 0120 is not sufficient. The ASCII version is now obsolet and will never be patched again.

Unfortunately the UNICODE version requires a full UNICODE handling of the SDK library interfaces. Every imported/exported string to the library must and will be UNICODE and the RFC Programm has to handle this.


For more information, please see SAP Note 1097997 'Installing SAP NW RFC SDK on IBM i' .


Stay tuned...

As the development team intends to maintain a consistent format, editions of the series will continue to be published. Set feeds accordingly if you are interested in following the series

Over the years this IBM i event at SAP TechED has become a tradition.


Save the date  (Monday October the 21st.)  and register now free of charge and reserve your seat for our annual IBM i and SAP Annual Solution Update and Dinner at TechEd 2013 Las Vegas.


IBM and SAP experts will provide the latest news and solution updates for IBM i and SAP environments. Attend this session and learn about IBM PureFlex Systems, SAP solution updates, and exciting new possibilities with cloud computing and In-Memory Computing. Don't miss this opportunity to have your questions answered by experts and to engage in lively discussions with your peers.


The business meeting will be followed by a group dinner.


For further details please follow the link




Filter Blog

By author: By date:
By tag: