Re: Two questions
1998-09-07 11:29:26
Replying to: "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT NL> (Mon, 7 Sep
1998 14:19:52 +0200)
>Hi ADSM-ers!
>I have two questions:
[...]
>2) How do I query ADSM for the tape label of the most recent database
>backup?
Try:
select volume_name from volhistory \
where date_time in ( \
select max(date_time) from volhistory \
where type = 'BACKUPFULL')
--
Rui Malheiro,
Rui Malheiro,
6 Mil - Tecnologias de Informacao
URL: <http://www.6mil.pt/>
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Two questions, Loon, E.J. van - SPLXM
- Re: Two questions, Lambelet,Rene,VEVEY,FC-SIL/INF.
- Re: Two questions,
Rui Malheiro <=
- Re: Two questions, Trevor Foley
- Re: Two questions, Loon, E.J. van - SPLXM
- Re: Two questions, Trevor Foley
- Re: Two questions, Loon, E.J. van - SPLXM
- Re: Two questions, Loon, E.J. van - SPLXM
- Re: Two questions, Trevor Foley [mailto:Trevor.Foley
- Re: Two questions, Trevor Foley [mailto:Trevor.Foley
|
Previous by Date: |
Re: Two questions, Lambelet,Rene,VEVEY,FC-SIL/INF. |
Next by Date: |
Re: Tape Management, Rui Malheiro |
Previous by Thread: |
Re: Two questions, Lambelet,Rene,VEVEY,FC-SIL/INF. |
Next by Thread: |
Re: Two questions, Trevor Foley |
Indexes: |
[Date]
[Thread]
[Top]
[All Lists] |
|
|