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.
> **********************************************************************
>
|
|
|