Accessing Backuphistory by sql

[Former Member]

Hello,

is there a way to access the backuphistory by sql?

We are using maxdb 7.5.00.34.

I can´t find any hint in the docs.

ragards,

Michael

[lbreddemann]

HI Michael,

check the following SUPERDBA "Tables":

CNDETAIL, CNHIST, CNMEDDEF, CNMEDIA, CNREPRT...

If you find these tables empty you probably have to activate the maintenance of these information by the DBMServer first:

see note <a href="http://service.sap.com/sap/support/notes/872157">#872157</a> if you're an SAP customer.

Or (for the non-SAP-customers):

Check if the relevant setting is already active:

dbm_configget DBADTL

result should be 1.

To change the setting use

dbm_configset DBADTL 1

From then on, the tables should be maintained.

KR Lars

[Former Member]

Hi Lars,

I´ve tried this and made a incremental backup.

Even if I restart the database, all vies but CNMEDIA still remains empty.

regards,

Michael

[lbreddemann]

Hi Michael,

please try to run the load_r3tab from the dbmcli.

After that the tables should be filled and also updated when new backups are performed.

BTW: as of 7.6.00 the tables had been moved to the SYSDBM-Schema. Just in case anybody with a current version wants to see the same information.

KR Lars

[Former Member]

Sorry,

but it seems, that I have to execute load_r3tab every time before accessing the tables.

New backups are only visible in CNHIST after executing load_r3tab again.

Is there a way to update the tables automaticly?

regards,

Michael