ADSM-L

Re: SQL query

2000-07-06 09:02:31
Subject: Re: SQL query
From: "Cook, Dwight E" <cookde AT BP DOT COM>
Date: Thu, 6 Jul 2000 08:02:31 -0500
by "sets" are you implying that you have grouped bunches of archive files
using something like a common "description"  ?

if so you could do something like :

select distinct description from adsm.archives where node_name='TTCSTG02'

and you would get something like

DESCRIPTION
------------------
Archive Date:
Archive Date:
 01/12/00    Time:
 11:00:00
Archive Date:
 01/12/00    Time:
 12:59:46
Archive Date:
 01/12/00    Time:
 12:59:59
Archive Date:
 02/07/00
Archive Date:
 07/03/00
Archive Date:
 06/26/00
Archive Date:
 11/29/99    Time:
 14:47:41

then use that to do
>select * from adsm.archives where node_name='TTCSTG02' and
description='Archive Date: 01/12/00    Time: 11:00:00'
to get something like...
     NODE_NAME: TTCSTG02
FILESPACE_NAME: /home
          TYPE: FILE
       HL_NAME: /dsmadmin/auditocc/
       LL_NAME: nodeocc.Apr98
     OBJECT_ID: 19552074
  ARCHIVE_DATE: 2000-01-12 10:58:48.000000
         OWNER: root
   DESCRIPTION: Archive Date: 01/12/00    Time: 11:00:00
    CLASS_NAME: B7.3_R35.95_A185

     NODE_NAME: TTCSTG02
FILESPACE_NAME: /home
          TYPE: FILE
       HL_NAME: /dsmadmin/auditocc/
       LL_NAME: nodeocc.Aug98
     OBJECT_ID: 19552071
  ARCHIVE_DATE: 2000-01-12 10:58:46.000000
         OWNER: root
   DESCRIPTION: Archive Date: 01/12/00    Time: 11:00:00
    CLASS_NAME: B7.3_R35.95_A185

     NODE_NAME: TTCSTG02
FILESPACE_NAME: /home
          TYPE: FILE
       HL_NAME: /dsmadmin/auditocc/
       LL_NAME: nodeocc.Dec98
     OBJECT_ID: 19552068
  ARCHIVE_DATE: 2000-01-12 10:58:42.000000
         OWNER: root
   DESCRIPTION: Archive Date: 01/12/00    Time: 11:00:00
    CLASS_NAME: B7.3_R35.95_A185

and on and on and on...

Dwight





> ----------
> From:         Loon, E.J. van - SPLXM[SMTP:Eric-van.Loon AT KLM DOT NL]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Thursday, July 06, 2000 7:27 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      SQL query
>
> Hi *SM-ers!
> I'm looking for a SQL query to list all existing archive sets for a
> specific
> node.
> Can anybody help me with this? I'm not very good in creating queries...
> Thanks in advance!!!
> Kindest regards,
> Eric van Loon
>
>
> **********************************************************************
> This e-mail and any attachment may contain confidential and privileged
> material intended for the addressee only. If you are not the addressee,
> you are notified that no part of the e-mail or any attachment may be
> disclosed, copied or distributed, and that any other action related to
> this e-mail or attachment is strictly prohibited, and may be unlawful. If
> you have received this e-mail by error, please notify the sender
> immediately by return e-mail, and delete this message. Koninklijke
> Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees
> shall not be liable for the incorrect or incomplete transmission of this
> e-mail or any attachments, nor responsible for any delay in receipt.
> **********************************************************************
>
<Prev in Thread] Current Thread [Next in Thread>