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.

asked 27 Sep '13, 14:21

Walmir%20Taques's gravatar image

Walmir Taques
640293147
accept rate: 13%

edited 27 Sep '13, 14:22


SELECT PROPERTY ( 'StartTime' );

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

answered 27 Sep '13, 15:20

Breck%20Carter's gravatar image

Breck Carter
27.0k444614889
accept rate: 21%

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

The SYSHISTORY table should have this information. Look for the LAST_START operation.

permanent link

answered 27 Sep '13, 14:30

Chris%20Keating's gravatar image

Chris Keating
3.2k1956
accept rate: 29%

Ok...thank you!

(27 Sep '13, 14:39) Walmir Taques

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%20Barth's gravatar image

Volker Barth
31.5k318461676
accept rate: 33%

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, 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, 03:52) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×12

question asked: 27 Sep '13, 14:21

question was seen: 704 times

last updated: 23 Oct, 03:52