ABAP for newbies: MaxDB: Database Manager and SQL Studio

With the new build of the SAP NetWeaver 2004s ABAP trial version (SP11), you may need to update your ABAP developer skills (beginners and experienced) to understand the new version. By the end of this tip series, you should have a good understanding of what's going on in the ABAP application server. In part 16, Mandfred Lutz shows us the 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 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.

Dig Deeper on SAP ABAP