Hi Vincent,
Sorry for the slow response.
No, I don't know a way to access the
real tables but I saw somebody else
suggested using ODBC.
Best regards,
Alexander
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> On Behalf Of Vincent RATAJSZCZAK
> Sent: Monday, June 26, 2006 5:13 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Réf. : Re: [ADSM-L] tape content with backup date
>
> Thank's Alexander for your help
>
> Do you know a solution to have direct access to the TSM
> tables, or do I
> have to forget it ?
>
> Any IBM tech guy around here to confirm if it is or not
> possible to get
> the results ?
>
> Regards
>
> Vince
>
>
>
>
>
> Alexander Verkooijen <alexander AT SARA DOT NL>
> Envoyé par : "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 26/06/06 16:02
> Veuillez répondre à "ADSM: Dist Stor Manager"
>
>
> Pour : ADSM-L AT VM.MARIST DOT EDU
> cc : (ccc : Vincent RATAJSZCZAK/INFOGER/GRT/FR)
> Objet : Re: [ADSM-L] tape content with backup date
>
>
> If you had access to the *real* tables that
> reside in the TSM databse then, yes, it would
> be possible. Since the SQL interface only
> provides access to *pseudo* tables I don't
> think it's possible.
>
> Please correct me if I'm wrong. In the
> past there have been times when I could have
> used a list like this.
>
> Regards,
>
> Alexander
>
> ------------------------------------------------------------
> Alexander Verkooijen
> Senior Systems Programmer
> High Performance Computing
> SARA Computing & Networking Services
>
>
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> > On Behalf Of Vincent RATAJSZCZAK
> > Sent: donderdag 22 juni 2006 18:07
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: tape content with backup date
> >
> > Dear lovely TSM World,
> >
> > I have a special request for you...
> >
> > I would like to list the content of a specific tape
> (destroyed) with a
> > column with the backuped date of the objet.
> >
> > ==> "Q content XXX" is poor
> >
> > ==> "select * from contents where volume_name=XXXX" give me
> > Node_name/File_name, but no backuped date
> >
> > ==> "select * from backups" give me Node_name/File_name
> and backuped
> > date, but no tape affectation
> >
> >
> > Between the 2nd and 3rd, I can't find a common field to join
> > the tables
> >
> >
> > Anyone could help me please ?
> >
> > Do you think it's possible ?
> >
> > The restore GUI show you the file name and backuped date, so
> > I think YES,
> > but....
> >
> > Thank's
> >
> > Vince
> >
>
|