I had a PMR open with IBM a few days ago... HL_NAME and LL_NAME in the BACKUPS 
table are not IP addresses/ports.

They had me run SELECT FILESPACE_NAME, HL_NAME, LL_NAME, BACKUP_DATE, 
CLASS_NAME FROM BACKUPS WHERE NODE_NAME='<NameOfNode>'.

It's a long listing, but an example for an Exchange Agent (each column name on 
a row here):

FILESPACE_NAME: <NameOfNode>\First Storage Group
HL_NAME: \data\0000\Mailbox Database\
LL_NAME: Full
BACKUP_DATE: 2012-07-09 09:00:33.0000
CLASS_NAME: Default

Values for Filespace_name would be the device, like C$, or D$?

Values for HL_NAME would be the path to the files, like \Program Files\.

The values for LL_NAME are full, or incr. 

Even with a select on a node_name, you'll get a lot of rows.

------------------------------------------------
Harold Vandeventer
Systems Programmer
State of Kansas - Office of Information Technology Services
Harold.Vandeventer AT ks DOT gov
(785) 296-0631


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Clark, Margaret
Sent: Thursday, July 12, 2012 1:03 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Select or Query help

Yes, I was.  I don't dare to select them from the archives or backups tables to 
see what they really are, so I should have kept my mouth shut!  Sorry about 
that.
Can you supply an example of what is in the HL_NAME and LL_NAME fields?
- Margaret

-----Original Message-----
From: Richard Sims [mailto:rbs AT bu DOT edu] 
Sent: Thursday, July 12, 2012 11:00 AM
To: Clark, Margaret
Subject: Re: Select or Query help

On Jul 12, 2012, at 1:41 PM, Clark, Margaret wrote:

> ...
> 
> P.S.  HL_NAME and LL_NAME  are not what you need... those are the IP address 
> and port number for a client.
> 

Hi, Margaret -

You may be thinking of HL_ADDRESS and LL_ADDRESS.

    Richard

[Confidentiality notice:]
***********************************************************************
This e-mail message, including attachments, if any, is intended for the
person or entity to which it is addressed and may contain confidential
or privileged information.  Any unauthorized review, use, or disclosure
is prohibited.  If you are not the intended recipient, please contact
the sender and destroy the original message, including all copies,
Thank you.
***********************************************************************