How to check last savepoint?

[Former Member]

Hi,

Please provide me information on how to check last savepoint.

I know, it can be checked in knldiag file. Is there any other way than this?

Please help.

Thanks in advance.

Regards,

Sandeep

[lbreddemann]

>

> Hi,

>

> Please provide me information on how to check last savepoint.

>

> I know, it can be checked in knldiag file. Is there any other way than this?

>

How about this ?

dbmcli on db770>db_executenice select * from restartinformation
OK

BADINDEXCOUNT                  = 0
RESTARTCONVERTERVERSION        = 774
LASTSAVEPOINTID                = 765
LASTSAVEPOINTREASON            = '3'
LASTSAVEPOINTDATE              = '20100422131043000000'
OPENTRANSACTIONCOUNT           = 0
OPENTRANSACTIONFILEROOT        = 45654
HISTORYDIRECTORYROOT           = 61684
FILEDIRECTORYROOT              = 14888
LOBDIRECTORYROOT               = 2
RESTARTIOSEQUENCE              = 155735
RESTARTOFFSETOFPAGEONVOLUME    = 2208
RESTARTOFFSETOFENTRYINPAGE     = 24
RESTARTENTRYTYPE               = 'FinishOpenTrans'
RESTARTENTRYDATE               = '20100422131042000000'
CYCLERELATEDENDOFFSET          = 6397
LASTKNOWNSEQUENCE              = 155734
LASTKNOWNOFFSET                = 2207
DATABASEIDENTIFIER             = 'XXXXXXXXXXXXXXXXX...:DB770_20100105_153543'
LASTSAVEPOINTRELEASEVERSION    = 'Kernel    7.7.07   Build 012-123-226-582'
INSTALLSERVERDBVERSION         = 'Kernel    7.3.0    Build 054-100-097-885'

Just taken off the documentation...

regards,

Lars

[Former Member]

Hi,

Thanks for your reply.

It is not working for me.

dbmcli on L11>util_execute select * from restartinformation

ERR

-24988,ERR_SQL: sql error

-4004,Unknown table name:RESTARTINFORMATION

---

dbmcli on L11>version

OK

version,os,dbroot,logon,code,swap

"7.5.0","UNIX","/sapdb/L11/db",True,ASCII,1

---

Can you please help.

Thanks,

Sandeep

[lbreddemann]

> It is not working for me.

>

> dbmcli on L11>util_execute select * from restartinformation

> ERR

> -24988,ERR_SQL: sql error

> -4004,Unknown table name:RESTARTINFORMATION

>

> ---

> dbmcli on L11>version

> OK

> version,os,dbroot,logon,code,swap

> "7.5.0","UNIX","/sapdb/L11/db",True,ASCII,1

That's because you're using a ancient database version!

The system tables were improved meanwhile!

For 7.5 I don't know how to figure this out in a supported way.

regards,

Lars