db backup

[adamtsm2005]

hi all

can any one tell me how the to check time taken to comlete db backup ?
is there any command to check?

 

[Samuel]

q volh t=dbb or q volh t=dbs (snapshot)

 

[adamtsm2005]

hi samuel

it shows the time when we took db backup. iwant command to know the time taken (period) for db backup

 

[hogmaster]

Search for ANR2280I in the actlog this tells you when the backup started
ANR4550I tells you when it ended.
q act begint=-12 msgno=2280
q act begint=-12 msgno=4550
or you can play around with select command.
select process,msgno,message,DATE_TIME from actlog where process>0 and msgno in (4550,985) order by process

 

[adamtsm2005]

thanks hogmaster

can u tell me the command to check how many objects expired/expiration ?

 

[nenifled]

You want this

SELECT Cast(START_TIME AS DATE) AS "Date", -
Cast(START_TIME AS TIME) AS "Start", -
Cast((END_TIME-START_TIME)seconds/60 AS Decimal(8,2)) As "Minutes", -
Cast((BYTES/1048576) AS Decimal(9,2)) AS "DB MB", -
Cast((BYTES/1048576)/Cast((END_TIME-START_TIME)seconds AS Decimal) AS Decimal(5,1)) AS "MB/Sec", -
SUCCESSFUL AS "Succ." -
FROM SUMMARY WHERE activity='FULL_DBBACKUP' AND -
START_TIME>=(CURRENT_TIMESTAMP-25 days)