Startup times

For Oracle:

col INSTANCE_NAME FOR A10;
col VERSION FOR A10;
col STATUS FOR A10;
select instance_name,version,status,to_char(STARTUP_TIME,’MON/DD/YYYY hh24:mm:ss’)startup_time from v$instance;

 

For Sql Server:

USE master;
GO
SET NOCOUNT ON
DECLARE @crdate DATETIME, @hr VARCHAR(50), @min VARCHAR(5)
SELECT @crdate=crdate FROM sysdatabases WHERE NAME=’tempdb’
SELECT @hr=(DATEDIFF ( mi, @crdate,GETDATE()))/60
IF ((DATEDIFF ( mi, @crdate,GETDATE()))/60)=0
SELECT @min=(DATEDIFF ( mi, @crdate,GETDATE()))
ELSE
SELECT @min=(DATEDIFF ( mi, @crdate,GETDATE()))-((DATEDIFF( mi, @crdate,GETDATE()))/60)*60
PRINT ‘SQL Server “‘ + CONVERT(VARCHAR(20),SERVERPROPERTY(‘SERVERNAME’))+'” is Online for the
past ‘+@hr+’ hours & ‘+@min+’ minutes’
IF NOT EXISTS (SELECT 1 FROM master.dbo.sysprocesses WHERE program_name = N’SQLAgent – Generic
Refresher’)
BEGIN
PRINT ‘SQL Server is running but SQL Server Agent <> running’
END
ELSE BEGIN
PRINT ‘SQL Server and SQL Server Agent both are running’
END

For Mysql :

\s

For DB2:

db2 get snapshot for dbm | grep -i start