Skip to Content
author's profile photo
Former Member

MAX DB CLI backup

Dear All,

I'm new to max db and we have SAP DMS server in AIX 7.1 with /sapdb/SDB/db /sapdb/CDB/db

I created a backup template using HowTo - SAP MaxDB Backup with Database Manager CLI guide and

managed to take the SDB & CDB backup to a external NAS.But the backup file is 3.5 MB .

This is same for Dev,Qty, and production.

Our production DMS aserver SDB db is around 40 GB, backup is 3.5 MB.

What's wrong with this backup...?

Please help...

backup_template_create SDB_backup to FILE

/mnt/backup/BACKUP/SDB_prd_backup CONTENT DATA

dbmcli on SDB>backup_start SDB_backup


Returncode 0

Date 20150202

Time 00140829

Server bobjdms2

Database SDB

Kernel Version Kernel 7.8.02 Build 026-121-243-456

Pages Transferred 432

Pages Left 0

Volumes 1

Medianame SDB_backup

Location /mnt/backup/BACKUP/SDB_dev_backup


Label DAT_000000003

Is Consistent true

First LOG Page 420

Last LOG Page

DB Stamp 1 Date 20150202

DB Stamp 1 Time 00140829

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 409

Devices Used 1

Database ID bobjdms2:SDB_20150130_155905

Max Used Data Page 0

Converter Page Count 10

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Feb 18, 2015 at 01:37 PM


    from the attached backup log I do not see any error, although I agree that there has not been much backed up. What was the exact backup statement - maybe you have performed just a 'save pages'?

    Have you tried to do a recovery test on a different system with that backup?

    If you want me to look further, please create a 'diagpack' archive of the MaxDB log files (dbmcli -d <db_name> -u <user,pwd> diag_pack) and upload it via:


    Add comment
    10|10000 characters needed characters exceeded