¡Caminando hacia el éxito!

Aprende en Comunidad

Avalados por :

Official Naming Conventions for IBM DB2 Databases in the SAP Environment

  • Creado 01/03/2024
  • Modificado 01/03/2024
  • 19 Vistas
0
Cargando...
Database and Operating System compose the foundation on which all SAP software is running. We therefore often talk about the (DB-, OS-)'platform' of an SAP system. Names of database management systems, like names for any product, change over time. In this post I'd like to help you understand the official names for the IBM DB2 databases as well as naming conventions used in the SAP environment. Based on this I will also present an example for database dependent coding in ABAP as well as in Java.

The IBM DB2 product family
Talking about DB2 we need to consider in fact three products with a different codebase. There is one DB2 running on mainframes using z/OS (formerly known as OS/390), one DB2 running on the operating system i5 (aka as OS/400) and one DB2 for Linux, UNIX and Windows. The current official names for these IBM products are:
All of these products were renamed in the past. For DB2 9 for Linux Unix and Windows in particular the names 'DB2/6000', 'DB2 Common Server' and 'DB2 Universal Database' (or 'DB2 UDB') may sound familiar to you. Note that with the latest release a name change took place and the term 'UDB' was dropped. So IBM UDB Version 8.2 became DB2 9 . As with every name change, it takes some time until it arrives in all the written material. This means that you will still find the term 'IBM UDB' in a lot of places.

Database platform names in SAP systems
The SAP basis offers very good abstractions of the underlying operating and database system. If you do your development in OpenSQL which is available for ABAP and Java you don't have to care about specifics of the DBMS. Your coding will be portable between all SAP supported platforms. In most cases this works perfect and you should stay with OpenSQL. Seldom it is necessary to exploit a database specific feature - something which is either available just on one database or on more than one database, but accessed each time in a different way. Typically everything which affiliated to the Database Meta data belongs into this category, although in some cases java.sql.DatabaseMetaData can help here on the WebAS Java. Anyway, the first step if you need to issue a database dependent SQL statement is to find out on which database system your program is actually running, and secondly you need a way to send an SQL statement directly to the database, bypassing OpenSQL.
Let's take a simple example and assume we'd like to find out programmatically on which version of DB2 for Linux UNIX and Windows and on which fixpack level we are running.

For ABAP the following piece of code will do this for us:



The system field sy-dbsys contains a three letter abbreviation for the database system on which we are currently running. Defining such an abbreviation is an interesting task if you take into account that there are three different products named 'DB2'. Here is the outcome that can be understand best if you consider the historical context:
  • 'DB2' is the three letter abbreviation for DB2 for z/OS.
  • 'DB4' was chosen for DB2 for i5/OS. The '4' in DB4 was borrowed from AS/400, the midrange server product line on which this particular DB2 ('DB2/400' integrated into the operating system 'OS/400') was running at the time of developing the port.
  • 'DB6' is the choice for DB2 for Linux UNIX and Windows. The '6' in DB6 was borrowed from RS/6000, IBM's server product line on which this DB2 was available on AIX at the time the development for this port started at SAP.
Pedro Pascal
Se unió el 07/03/2018
Pinterest
Telegram
Linkedin
Whatsapp

Sin respuestas

No hay respuestas para mostrar No hay respuestas para mostrar Se el primero en responder

contacto@primeinstitute.com

(+51) 1641 9379
(+57) 1489 6964

© 2024 Copyright. Todos los derechos reservados.

Desarrollado por Prime Institute

¡Hola! Soy Diana, asesora académica de Prime Institute, indícame en que curso estas interesado, saludos!
Hola ¿Puedo ayudarte?