ABAP for newbies: MaxDB: Database Manager and SQL Studio

ABAP for newbies: MaxDB: Database Manager and SQL Studio

This tip explains how to do the very first steps with the tools of the MaxDB that are shipped with the ABAP Trial Version download.

In the download of the ABAP Trial Version there are two tools, one for database administration (Database Manager) and the other one for having a look at the tables and the execution of SQL statements (SQL Studio) on tables of interest. Both tools have a GUI as well as a CLI (Command Line Interface) - in this tip only the GUI is used. The database itself (MaxDB) is installed during the installation of the ABAP trial version; the tools however must be installed manually. You can find them in the directory 'maxdbtools' of the tree structure of the download.



After installing the tools you will find two new icons on your desktop.



Double-click on the Database Manager icon to start this tool.



The Database Manager comes up with its entry screen.

At first you have to select the database you'd like to administrate.



Click on the 'Add' button.



The system will give you an overview of the databases that are on the selected machine (your PC). In my case, there is only the NSP database from my ABAP Trial Version. Select the database of your choice and press the 'OK' button.



Now the selected object will appear in the upper right window. Click

    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

on the Connection icon (red) to get connected to the database.



You have to enter the name of the database manager user for this database and his password. The user is set by the ABAP Trial Version installation to 'control'. The password is the one you entered during the installation process for the database. Press OK.



Since in my case the NSP database is not running, there are red balls at the database icons. Click on the online-icon (highlighted in red) in the menu bar to start the database. If the database is running, there will be a process 'kernel.exe' in the processes list of the task manager of your PC. In addition to that, a service 'MAXDB: NSP' will be started.



Now it's done - the database is up and running and we are connected with the Database Manager tool to it. The entry screen gives you an overview about the database size and the sessions that currently running.
Yet you can have a closer look at the different items. For example, click on the 'Information' button on the left menu, a submenu will appear, and then select 'Data Area'.



Here you can see the physical locations where the data is stored. If more storage is needed you can add another volume (Configuration).
Since with the new ABAP Trial Version SP12 the online documentation for the Database Manager is not available, you can get the information from  here .

Click on the 'Tools' button in the menu bar and select 'SQL Studio' or just double-click on the 'SQL Studio' icon on your desktop. The SQL Studio will be started. Be sure that the database is running, if you come by way of the desktop item.



Click on the key button on the left side of the button bar.



Enter the server name where your MaxDB is running,
Database = 'NSP',
User = 'SAPNSP',
Password is the one you entered during the installation of the ABAP Trial Version for the database.

Press 'OK' button.



This is the entry screen of the SQL Studio.

If you like to see for example which tables are in the ABAP Trial Version, just click on 'Tables' and scroll down. For example, searching for the structure of the SFLIGHT table that is well known from our demos, enter 'SFLIGHT' into the field below button bar and open up the tree beyond 'Tables (SFLIGHT)'.



Here you can see all elements of table SFLIGHT.
If you are eager to know what is inside the table, just go back to the dialog window and enter the open SQL statement 'select * from sflight'.



Manfred Lutz is in NetWeaver Product Management with focus on Application Servers.


This content is reposted from the SAP Developer Network.
Copyright 2007, SAP Developer Network

SAP Developer Network (SDN) is an active online community where ABAP, Java, .NET, and other cutting-edge technologies converge to form a resource and collaboration channel for SAP developers, consultants, integrators, and business analysts. SDN hosts a technical library, expert blogs, exclusive downloads and code samples, an extensive eLearning catalog, and active, moderated discussion forums. SDN membership is free.

Want to read more from this author? Click here to read Manfred Lutz's Weblog. Click here to read more about ABAP on the SDN.


This was first published in August 2007

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Back to top