Re: [ADSM-L] Select or Query help
2012-07-12 14:41:29
Hi Margaret,
See some examples below (on a TSM 6.2 Server) :
- Columns from the backups table :
tsm: TSM62>select colname from columns where tabname='BACKUPS'
COLNAME
---------------------------------------------------------------------------------------------------------------------------------
BACKUP_DATE
CLASS_NAME
DEACTIVATE_DATE
FILESPACE_ID
FILESPACE_NAME
HL_NAME
LL_NAME
NODE_NAME
OBJECT_ID
OWNER
STATE
TYPE
- Columns from the archives table :
tsm: TSM62>select colname from columns where tabname='ARCHIVES'
COLNAME
---------------------------------------------------------------------------------------------------------------------------------
ARCHIVE_DATE
CLASS_NAME
DESCRIPTION
FILESPACE_ID
FILESPACE_NAME
HL_NAME
LL_NAME
NODE_NAME
OBJECT_ID
OWNER
TYPE
- Some files or directories (ll_name) under a directory path (hl_name) :
tsm: TSM62>select HL_NAME,LL_NAME from backups where HL_NAME='/grub/'
HL_NAME: /grub/
LL_NAME: device.map
HL_NAME: /grub/
LL_NAME: e2fs_stage1_5
HL_NAME: /grub/
LL_NAME: fat_stage1_5
HL_NAME: /grub/
LL_NAME: ffs_stage1_5
HL_NAME: /grub/
LL_NAME: iso9660_stage1_5
HL_NAME: /grub/
LL_NAME: jfs_stage1_5
HL_NAME: /grub/
LL_NAME: menu.lst
HL_NAME: /grub/
LL_NAME: minix_stage1_5
HL_NAME: /grub/
LL_NAME: reiserfs_stage1_5
HL_NAME: /grub/
LL_NAME: splash.xpm.gz
- from the operating system
[root@tsm62 ~]# ls -l /boot/grub/
total 258
-rw-r--r-- 1 root root 63 juin 9 2011 device.map
-rw-r--r-- 1 root root 7584 juin 9 2011 e2fs_stage1_5
-rw-r--r-- 1 root root 7456 juin 9 2011 fat_stage1_5
-rw-r--r-- 1 root root 6720 juin 9 2011 ffs_stage1_5
-rw------- 1 root root 606 juin 5 23:23 grub.conf
-rw-r--r-- 1 root root 6720 juin 9 2011 iso9660_stage1_5
-rw-r--r-- 1 root root 8224 juin 9 2011 jfs_stage1_5
lrwxrwxrwx 1 root root 11 juin 9 2011 menu.lst -> ./grub.conf
-rw-r--r-- 1 root root 6880 juin 9 2011 minix_stage1_5
-rw-r--r-- 1 root root 9248 juin 9 2011 reiserfs_stage1_5
-rw-r--r-- 1 root root 55808 mars 12 2009 splash.xpm.gz
-rw-r--r-- 1 root root 512 juin 9 2011 stage1
-rw-r--r-- 1 root root 104988 juin 9 2011 stage2
-rw-r--r-- 1 root root 7072 juin 9 2011 ufs2_stage1_5
-rw-r--r-- 1 root root 6272 juin 9 2011 vstafs_stage1_5
-rw-r--r-- 1 root root 8872 juin 9 2011 xfs_stage1_5
So, ll_name (file name or directory name) is relative to hl_name (a path of one
or more directories), itself relative to filespace_name (/boot in my example).
Erwann
----- Mail original -----
De: "Margaret Clark" <MClark AT SDDPC DOT ORG>
À: ADSM-L AT VM.MARIST DOT EDU
Envoyé: Jeudi 12 Juillet 2012 20:02:58
Objet: 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
|
|
|