SAP SQL Anywhere

Question

Adaptive Server Anywhere Server Version 9.0.2.3951 How do I get the date time that the database was started? Via sql command / function or something.

Accepted Answer

3

SELECT PROPERTY ( 'StartTime' );

PROPERTY('StartTime')
'2013-09-27 15:21:06.152'

permanent link

answered 27 Sep '13, 15:20

Breck Carter
32.5k●541●726●1050
accept rate: 20%

3

Note that the property StartTime is when the server was started. There is not an equivalent property for when the database file was started as far as I know.

(27 Sep '13, 15:24) Chris Keating

flat view

Answer 2

6	The SYSHISTORY table should have this information. Look for the LAST_START operation. permanent link answered 27 Sep '13, 14:30 Chris Keating 7.8k●49●128 accept rate: 32% Ok...thank you! (27 Sep '13, 14:39) Walmir Taques flat view

Answer 3

0

Note: SYSHISTORY has been introduced in ASA 9.0.1. Generally, and for older versions, you can also query the according server property via

SELECT property('StartTime');

That's even easier IMHO.

permanent link

answered 27 Sep '13, 15:26

Volker Barth
40.2k●361●549●822
accept rate: 34%

1

Very strange, but the system view SYSHISTORY shows yesterday:

   

I. 10/18 10:34:13. Starting database "..." (D:\ ... .db) at Wed Oct 18 2017 10:34

but

select last_time from SYSHISTORY where operation='LAST_START'

2017-10-17 10:48:02.000

(18 Oct '17, 04:46) Ilia63

Replies hidden

For current versions, I think SYSHISTORY entries for "START" and "LAST_START" seem to get refreshed only when a new version has been applied and not for general starts of the database. In my case, a v12.0.1 database has been started a few days ago but the last_time of the "LAST_START" row lists a date in 2016 when the last EBF had been applied...

(23 Oct '17, 03:52) Volker Barth

flat view

SAP SQL Anywhere

Start Date Time

Follow this question

Related questions