here you have a number of options

• 0: Server + Client - select this option to install the entire MaxDB server software
• 1: Client - installs all software except server utilities, database kernel and APO LiveCache apps
• 2: Custom - gives you an option on what components you want to install
• 3: None - don't install anything

Select option 2

here you have a number of options available

• 0: Runtime for SAP AS - install NetWeaver AS on the server
• 1: DBAnalyzer - only install the DBAnalyzer it also installs Base, Messages, SAP Utilties and DBAnalyzer
• 2: JDBC - installs Base, SAP Utilities and JDBC
• 3: Server - only installs the server components
• 4: Loader - installs components for loading large data volumes via python
• 5: ODBC - install components that are required for ODBC communications
• 6: All - all components are installed
• 7: None - cancel the installation

Select option 3

The installation will now ask a series of questions regarding below, you can change any of the above to suit you own requirements

• group name (default: sdba)
• owner name ( default: sdb)
• independent data path (default: /var/opt/sdb/data)
• independent program path (default: /opt/sdb/programs)

The installation will go and do some stuff and come back requesting information regarding the database kernel preparing

• dependent path (default: /opt/sdb/7603)

The MaxDB Database Manger GUI when open should look something like below

To create the instance you can either select instance -> create or select the create instance button (as seen in above picture), you will be asked to select one of the templates, have choose custom

• Desktop/PC - idea for a laptop development database
• Custom - use this to change default values, memory size, number of cpu's, etc
• My Template - you can even create your own custom template

Here we can give the Database Instance a name of our choosing, notice that you can connect to an external MaxDB server and create Databases

If you have a specific set of parameters that you wish to use then you have the option to use them here, i am just going for the defaults

Again I am going with the default, OLTP database. LiveCache by the way is a objected-oriented model that also uses the memory more

here I tweeked a number of parameters, memory, CPU's and MaxlogVolumes. You can change these settings at a later date but the instance will require a reboot

By default a data volume and a log volume will be created adjust these to what you planned above,

NOTE: One word of warning if you have selected to install the tutorial you must increase the size of the log volume otherwise the installation hangs, increase it to at least 1,024MB

we need to create a password for the dbadmin account

Some more advanced settings to adjust, if this is a development database i always like the tutorial data to play around with

Finally we get to the summary page, check everything then select next to create the database instance

You will now see the creation of the database instance

Finally you get the finish page confirming that the installation was successful.

Once the installation has finished you should see the below in the database manager

#Database Creation
create_v5_db

# User creation
create_v5_users

Start the database manager GUI, and select instance -> configuration -> log settings, you get the log configuration settings menu up

Select log mode, then next, the menu will ask which log file to mirror

Double click on the single log file and notice the bottom of the configuration screen, the mirror part should have been filled in with default values, you can change these if so desired

When you named the mirror file you should see it back in the log settings screen

You will be asked to confirm the creation of the mirror log file

To confirm that the log is mirrored select instance -> configuration -> volumes -> select the log volumes button, you will notice that the "mirrored location" and "mirrored type" are filled in

First you need to create a log backup file select instance -> backup -> backup medium -> right click in the window and select new medium, fill in the details as you see fit

Select instance -> backup -> backup wizard,  Select the Activite/Deactivite automatic log backup

Select the critrea that you need, normally i active a log backup when the log is full

Select on to start the automatic backup log

Select instance -> configuration -> volumes, select the next volume on the list and right click and select new volume

Select OK to create the additional data volume

the commandline option is as follows

7.6:
  dbmcli> param_addvolume 1 DATA DATA_0002 F 50000
  dbmcli> param_getvolsall

7.7:
  dbmcli> db_addvolume DATA DATA_0002 F 50000
  dbmcli> param_getvolsall

Select instance -> configuration -> volumes, click on the log volume button to display the log volumes, select the next volume on the list and right click and select new volume

Note that because we have selected mirror log volumes (see above) the mirror will also be created

the commandline option is as follows

7.6:
  dbmcli> param_addvolume 1 LOG LOG_0002 F 6400
  dbmcli> param_getvolsall

7.7:
  dbmcli> db_addvolume LOG LOG_0002 F 6400 PATITION 1
  dbmcli> param_getvolsall

select instance -> backup -> backup history

using the database manager gui select instance -> backup -> backup medium, right click in the main window an select new medium

fill in the details giving a name to the backup and stating the filename, etc

As you can see I have a number of backup mediums, including a log file meduim

using the database manager GUI select instance -> backup -> backup wizard

Select the backup medium

Comfirm that you are happy then click on start, the backup will start

After a period the backup should be completed

you can also use a commandline version

dbmcli> medium_getall
dbmcli> util_connect control,control
dbmcli> backup_start Full_Backup RECOVERY DATA

second session monitor the backup
dbmcli> backup_state

First deactive the automatic log backup feature select instance -> backup -> backup wizard

The select the log backup

Then just follow the steps as in the data backup

you can also use a commandline version

dbmcli> medium_getall
dbmcli> util_connect control, control
dbmcli> backup_start "LogBackup" LOG

to check your backups select instance -> check -> backup

here you can select to check your last backup, a previous backup or select a backup medium, i have select to check the last backup

MaxDb will now go and check the backups, a tick will be displayed against

the instance must be in the admin state, select instance -> recovery

Here you have a number of choices, you can even specify a specific time. You then select the backup that you want to restore

Once the data has been restored you then need to apply the log backups

MaxDB will then display a summary screen indicating a successful restore or not

you can of course use the commandline

dbmcli> db_admin -f
dbmcli> util_connect
dbmcli> backup_history_list
## start the first recovery
dbmcli> recover_start "CompleteBackup" data

## start a initialization recovery
dbmcli> db_active recover "CompleteBackup" data

## import all the incremental backups, one after the other
dbmcli> recover_start "IncrementalBackup" pages

## Import the first log backup
dbmcli> recover_start "LogBackup" log 002

## Import any more log backups
dbmcli> recover_replace "LogBackup" "MaxDB_LOG" 003
dbmcli> db_online

First the instance must be in the ADMIN state, then select instance -> backup -> create snapshot

select OK and the snapsjot will be created

you can also use the commandline to create a snapshot

dbmcli> db_admin
dbmcli> db_execute create snapahot
dbmcli> db_online

Again the database must be in an admin state, then select instance -> snapshot, select delete snapshot

you can also use the commandline to delete a snapshot

dbmcli> db_admin
dbmcli> db_execute drop snapshot
dbmcli> db_online

Again the database must be in an admin state, then select instance -> snapshot, select revert to snapshot

This may take sometime depending on the number of chanes to the database since the snapshot was taken

you can also use the commandline to revert a snapshot

dbmcli> db_admin
dbmcli> db_execute restore snapshot
dbmcli> db_online

To see when the last snapshot was taken see the main database screen, look in the bottom right hand corner you will see a snapshot section

select instance -> check -> database structure

choose the one you want to run, you can speed things up alittle by not checking the indexes

after a while you should get a summary page

you can also use the commandline, here are some examples to check the consistency

## online checks
dbmcli> db_execute check data
dbmcli> db_execute check data except index

## offline checks
dbmcli> db_execute check data with update

## online check but specified tables
dbmcli> db_execute check table schema.table catalog
dbmcli> db_execute check table schema.table with long check