Home / SAP MaxDB

SAP MaxDB

SAP MaxDB System Copy Script

Hello, my name is Florian and I have been working in the SAP Basis since 2004. Due to my activity I have created some scripts which I would like to present here. Most of the time I was a SAP Basis Consultant at various companies with different systems and databases. …

Read More »

SAP MaxDB System Copy Script

Hello, my name is Florian and I have been working in the SAP Basis since 2004. Due to my activity I have created some scripts which I would like to present here. Most of the time I was a SAP Basis Consultant at various companies with different systems and databases. …

Read More »

SMTP/SCOT SAP Mail Configuraton

Step by step procedure for SAP mail Configurration…   First of all, Enable the Protocol through parameter. Parameter : icm/server_prot_2.  Value : PROT=SMTP,PORT=25000,TIMEOUT=600.  Then Restart the ICM by using the T-code SMICM. Now Activate the Host services in T-code SICF. Then Created one SMTP NODE and set the default Domain and port …

Read More »

Best practices for SAP on SAP MaxDB

 SAP MaxDB Highlights SAP MaxDB 7.9.09 is now available SAP MaxDB 7.9.09 is now available for download. Version 7.9.09 now supports a database size of up to 32 TB (see SAP note 2179510 and keep in mind not to cross the 16 TB limit with database versions below 7.9.09). SAP …

Read More »

C *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:Database name is missing))

When you get the following error in MAXDB: C  *** ERROR => Connect to database failed, rc = -10709 (Connectionfailed (RTE:Database name is missing)) Please logon as user SAPService<SID> and check the xuser list and see if the Dbname is wrong. xuser -c SAPSERVICE<SID> -U DEFAULT -u SAP<SID>,PASSWORd -d <SID>                                        …

Read More »

Virtual Round Tables – SAP Content Server

Take advantage of this opportunity to discuss the topic “SAP Content Server” with SAP Experts in a virtual round table. Bring your questions and doubts, and also feel free to share your experiences with other Content Server users during the session. This session will cover best practices for SAP Content …

Read More »

Recording MaxDB Expert Session 29: Improvements in IO Handling/Prefetch 7.9

Hi Folks, the slides and recording of Expert-Session number 29: Improvements in I/O Handling 7.9 and Prefetch Mechanism are available for donwload now. Please use the following links: slides: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_IO_Handling_Prefetch.pdf Recording: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_IO_Handling_Prefetch.mp4 Regards, Christiane

Read More »

New SCN-Section about SAP MaxDB User Concept

Hi, there is a new SCN Section which gives information about the SAP MaxDB User concept. You’ll get information about the different database user types, OS user in an SAP environment and configuration files which store user information ( upc-Container, xuser, SSFS) https://wiki.scn.sap.com/wiki/x/ZBZiGg Hope this information is helpful for you. …

Read More »

SAP MaxDB Interfaces – SQLDBC,ODBC,JDBC and Precompiler

Hi Folks, there is a new section in SCN which gives information about the SAP MaxDB Interfaces which are used in SAP-Systems.. You’ll get information about the Precompiler, SQLDBC,ODBC and JDBC.Links to the Interface Manuals and information about trace options of the several interfaces are located there as well. http://wiki.scn.sap.com/wiki/x/hoVYGg …

Read More »

Feature list for SAP MaxDB 7.9.08.32

Since MaxDB 7.9.08.32 is finally available for download via SAP Store, here is the updated Feature list starting with 7.9.08.27 (taken from SAP note 1444241): SP 8 Patch 32 (7.9.08.32) (July 13, 2015) (14 Features, 21 Patches) Kernel default value for database parameter UseAlterTableAddColOptimization changed to YES (PTS 1253928). Database …

Read More »

SAP MaxDB Expert Sessions: News 2015

Hi Folks, you know the SAP MaxDB online Training sessions – so called Expert Sessions – for SAP MaxDB Experts and Administrators? The Session information can be downloaded for free.You find the recording and slides of the past Expert Sessions here -> http://maxdb.sap.com/training/ Now the SAP MaxDB Development team delivered …

Read More »

MaxDB: index queueing during system copy

Hello MaxDB specialists, may be you are familiar with the index queueing feature while using R3load methode for migration / system copy. Sometimes this sequential methode is not really performant when the needed data is not in the data cache anymore. During migration / system copy you are facing the …

Read More »

SAP MAX-DB Backup using command line tool

We can use command line tool DBMCLI to take backup of MAX-DB database. If you are facing problems while taking backup from MAX-DB GUI tools you can opt this option. Steps:                1. Open DBMCLI from commandprompt                          dbmcli -d <SID> -u superdba,<password>                2. Stop Database (For Offline backup) …

Read More »

New OEM for SAP MaxDB

7P Infolytics AG and SAP SE have concluded an Original Equipment Manufacturer agreement. The agreement entitles Infolytics to provide the SAP database SAP MaxDB as OEM product outside the SAP world. Cologne-based software house Infolytics offers the SAP database bundled with its own software Mobile DB Monitor. This offer opens …

Read More »

SAP MaxDB 7.9 – Upgrade to 7.9.08.23 recommended

Hi Folks, Because of a potential MaxDB issue in MaxDB versions 7.9.08.18 – 7.9.08.22 an upgrade to 7.9.08.23 is recommended. Other versions are not affected. Symptom: You create an index (CREATE INDEX) for a subsequently added table column that has been given a default value (SQL statement ALTER TABLE ADD). …

Read More »