Home / SAP MaxDB (page 2)

SAP MaxDB

SAP MaxDB Database Studio

After configuring the workcenter or the landscape in your newly installed SAP MaxDB Database Studio and when you want to close the Database studio, never close the highlighted explorer tab if you do so you will not be able to see or bring back your configuration, instead you close the …

Read More »

SAP MaxDB Expert Session – IO Concept

Hi folks, next week we will have the next SAP MaxDB Expert Session – the session is as always free of charge but registration is necessary. SAP MaxDB: Introduction into I/O concept – May, 13 2014 10:00 – 11:00  CET Registration: https://websmp109.sap-ag.de/~sapidb/011000358700000191362014E Non-S-Users: 2014_05_13_SAP MaxDB: Introduction_10CET_EN – Adobe Connect Please …

Read More »

Content Server Training Material download available

Hi folks, we had 3 expert sessions related to the SAP Content Server. You can download the recording and slides of these sessions for free: Session 23: SAP MaxDB & SAP Content Server Architecture Recording: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Content_Server_Architecture.mp4 Slides: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Content_Server_Architecture.pdf Session 24: SAP MaxDB & SAP Content Server Housekeeping Recording: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Content_Server_Housekeeping.mp4 Slides: …

Read More »

SAP MaxDB Online Training: Kernel – IO Concept

Hi folks, in May we will offer again a SAP MaxDB Expert Session with focus on the SAP MaxDB database kernel. This session is free of charge burt registration is necessary. In this expert session the architecture of the I/O concept is explained. Some aspects will become clearer when the …

Read More »

SAP MaxDB Software Download Area now via SAP Store

Hi folks, Information for all NON-SAP Customers who do not have access to SAP SWDC (Software Download Center): Please notice that the software download area has changed. You can download the SAP MaxDB software now via SAP store https://store.sap.com/sap/cpa/ui/resources/store/html/StoreFront.html  (use search entry SAP MaxDB or Link in Our Offerings->Database and …

Read More »

Recording/Slides of Expert Session 23 Download available

Hi folks, the recordings and slides of Expert Session 23: SAP MaxDB & SAP Content Server Architecture are available now: Recording: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Content_Server_Architecture.mp4 Slides: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Content_Server_Architecture.pdf The recoding and slides of all available sessions can be found here: SAP MaxDB: The SAP Database – Training Regards, Christiane

Read More »

SAP MaxDB Online Trainings in 2016

Hi Folks, Next SAP MaxDB Online Training – so called Expert Session: 10. March 2016 1pm – 2 pm CET Registration link: https://psd.sap-ag.de/psd-registration/index.html#/event/847c8d9037562edef798927fdc80f20467477a057d2e793ce5eff1fcd8849c45dbd8eab60ac5ef545e293f96c6734cacf0776f2f1874d83b4a94479b812b536bNext If you are not registered so far, use your S-User to LOGON to https://psd.sap-ag.de and follow the instructions. When you are logged on search for MaxDB. These …

Read More »

How to delete sap* from database level in Maxdb/sapdb

This document tell you , how to delete the sap* user from Maxdb/sapdb database level. Logon to database server1. switch to sqd<SID> user (e.g. sqdyak) under UNIX or2. logon as <sidadm> under Unix/Windows Start the SQL mode with the command:dbmcli -d <SID> -u control,<password> -uSQL <db_schema>,<password>sql_execute <sql statement> alternatesqlcli -d …

Read More »

Expert Session: Recording of database Analyzer Session is available for download

Hi folks, the recording and slides of November’s MaxDB Expert Session about Database Analyzer is now available for download: Download Recording: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Database_Analyzer.mp4 Download Slides: http://maxdb.sap.com/training/expert_sessions/SAP_MaxDB_Database_Analyzer.pdf This session gives basic information about how to start/stop the Database analyzer, how to display collected data and shows the software components of the Datbase …

Read More »

MaxDB Database Creation !

Dear All, As I have communicated you in my previous post “MaxDB Studio Installation !“, here I am creating new document for MaxDB Database creation. This document is meant to created for creation of MaxDB Database only. I assume that you have already installed MaxDB Software and MaxDB Studio. Now …

Read More »

MaxDB Studio Installation !

! MaxDB Studio Installation ! <<As I have communicated in my document “MaxDB Software Installation !“, here is document for MaxDB studio installation>> This document is meant to created for installation of MaxDB studio only. I assume that you have downloaded the software from market place and keep it somewhere …

Read More »

MaxDB Software Installation !

! MaxDB Software Installation ! This document is meant to created for installation of MaxDB database software only. I assume that you have downloaded the software from market place and keep it somewhere in your system. (My Case I kept it “C:MaxDB”) To understand what exactly change in Registry File, …

Read More »

SAP System Refresh Based on MaxDB database

SAP system refresh based on MaxDB Database SAP refresh is a combination of 3 parts 1.       Pre-refresh work 2.       DB restore and recovery 3.       Post Refresh work Every step has its own responsibility and every step should be considered critical. This document meant to prepare ESPECIALLY for MAXDB restore part. …

Read More »

Next MaxDB Expert Session in August

Hi folks, don’t forget to register to the next free of charge MaxDB online Training Concept of the SAP® MaxDB™ Remote SQL Server (x_server, Global Listener) This session will take place at : Tuesday 27.08.2013 ,  10:00 h CET Registration is possible until 25.08.2013 unsing one of the following links …

Read More »

maxDB Log Messages for MS Windows

If you have to work on the command line, it might be handy to know what each log file stands for. The older Database manager had this overview that is missing from the newer Management tools. This is the Index of files used:

Read More »

Why does a restore fail with error message ‘LogAndDataIncompatible’?

It’s not failed, but in this case log doesn’t match the restored database dbmcli on R03>db_online ERR -24988,ERR_SQL: SQL error -9407,System error: unexpected error 3,Database state: OFFLINE 20028,DBIdentifier of DataVolume (myhost:R03_20131117_011716) and LogVolume (myhost:R03_20190902_147628) does not match 8,Log- and data area are not compatible because ‘The DB Identifiers are not …

Read More »

MaxDB: Nice to know about Check Data

Hi, Optimize runtime of Check data SAP recommends to run the check data on a system copy to avoid negative influence on the parallel productive work. SAP systems are getting larger and not each customer can create a system copy only for check data. So customers more and more decide …

Read More »

MaxDB Upgrade Back Out Plan

Revert back Planning for MaxDB Upgrade This Document is useful for the project, who work on MaxDB database and wants to upgrade the Database with revert back plan in hand. You will find the Upgrade document everywhere (SMP) but you could not find the back out plan for MaxDB upgrade. …

Read More »

SAP MaxDB Classroom Training in 2013

Hi folks,     SAP offers SAP MaxDB Administration classroom trainings ‘ADM515’ as well in 2013. SAP customers will find more information using the following link: https://learningportal.wdf.sap.corp/sap(bD1lbiZjPTAwMSZkPW1pbg==)/bc/bsp/sap/z_lso_center/trainingtype.htm?plvar=01&otype=D&objid=70062160 Visiting this classroom training will give you the basis know how which is useful for the SAP MaxDB online Expert Sessions. Regards, Christiane

Read More »

SAP MaxDB Online Training Sessions in Q2, Q3 and Q4 / 2013

SAP MaxDB Development Support team offers new free of charge Expert Sessions (online training session) in English. Each Session takes only 60 minutes of your time – You’ll get a chance to deepen your MaxDB knowledge and ask questions. Registration is necessary. You can use the following links: April 2013: …

Read More »

Recording and Slides of SAP MaxDB Expert Sessions

Hi Folks, the MaxDB Team has done a lot of trainings which were free of charge. Now the recordings and slides of all SAP MaxDB Online Training sessions are published and available for download http://maxdb.sap.com/training/ Session 27: SAP MaxDB Multi Tasking Session 26: SAP MaxDB  Introduction into I/O Concept Session …

Read More »

SAP MaxDB Online Training Sessions in 2012

SAP MaxDB Development Support team offers new free of charge Expert Sessions (online training session) in English. Each Session takes only 60 minutes of your time – You’ll get a chance to deepen your MaxDB knowledge and ask questions. Registration is necessary. You can use the following link.: June 2012: …

Read More »

Small changes with big effects

For many BW performance relevant DB-features, it’s really all about the details of usage and implementation when it’s about the effect of those features. The following are two examples of rather small things that went wrong which had a big impact on the system performance. Two examples for BW on …

Read More »