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 [email protected] (785) 296-0631 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Clark, Margaret Sent: Thursday, July 12, 2012 1:03 PM To: [email protected] 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:[email protected]] 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. ***********************************************************************
