David, Allen
I believe the WWN reported by Q DRIVE F=D is the node WWN, not the port WWN
so I would expect it to remain constant.
I too have often wondered why the WWN is not returned by a SELECT on the
DRIVES table since it must be in the database. Assuming you've got
SANDISCOVERY enabled, it is possible to obtain the information from a join
on the DRIVES and the SAN table but, if my system is anything to go by,
performance might be dire. I'm guessing this is because any SELECT on the
SAN table initiates a SAN discovery and this can take a long time to return
if you've got a lot of external disks / tape drives (I've got 188 rows in
my SAN table!). Coupled with this, the performance of joins (at least prior
to v6) was never that hot.
Anyway, try something like this:
tsm: TSMLM1>select dv.drive_name,san.node_wwn,san.port_wwn from drives dv,
san where dv.drive_serial=san.serial
ANR2963W This SQL query may produce a very large result table, or may
require a significant amount of time to compute..
Do you wish to proceed? (Yes (Y)/No (N)) y
DRIVE_NAME NODE_WWN PORT_WWN
------------------ ---------------- ----------------
TDC_F01R01 500507630F15B101 500507630F55B101
TDC_F01R01 500507630F15B101 500507630F95B101
TDC_F01R02 500507630F15B102 500507630F55B102
TDC_F01R02 500507630F15B102 500507630F95B102
TDC_F01R03 500507630F15B103 500507630F95B103
TDC_F01R03 500507630F15B103 500507630F55B103
TDC_F01R04 500507630F15B104 500507630F55B104
TDC_F01R04 500507630F15B104 500507630F95B104
TDC_F01R05 500507630F15B105 500507630F55B105
TDC_F01R05 500507630F15B105 500507630F95B105
TDC_F01R06 500507630F15B106 500507630F55B106
TDC_F01R06 500507630F15B106 500507630F95B106
TDC_F01R07 500507630F15B107 500507630F95B107
TDC_F01R07 500507630F15B107 500507630F55B107
TDC_F01R08 500507630F15B108 500507630F55B108
TDC_F01R08 500507630F15B108 500507630F95B108
TDC_F01R09 500507630F15B109 500507630F55B109
TDC_F01R09 500507630F15B109 500507630F95B109
TDC_F01R10 500507630F15B10A 500507630F55B10A
TDC_F01R10 500507630F15B10A 500507630F95B10A
TDC_F01R11 500507630F15B10B 500507630F95B10B
TDC_F01R11 500507630F15B10B 500507630F55B10B
TDC_F08R01 500507630F15B171 500507630F55B171
TDC_F08R01 500507630F15B171 500507630F95B171
TDC_F08R02 500507630F15B172 500507630F95B172
TDC_F08R02 500507630F15B172 500507630F55B172
TDC_F08R03 500507630F15B173 500507630F55B173
TDC_F08R03 500507630F15B173 500507630F95B173
TDC_F08R04 500507630F15B174 500507630F55B174
TDC_F08R04 500507630F15B174 500507630F95B174
TDC_F08R05 500507630F15B175 500507630F55B175
TDC_F08R05 500507630F15B175 500507630F95B175
TDC_F08R06 500507630F15B176 500507630F95B176
TDC_F08R06 500507630F15B176 500507630F55B176
TDC_F08R07 500507630F15B177 500507630F55B177
TDC_F08R07 500507630F15B177 500507630F95B177
TDC_F08R08 500507630F15B178 500507630F55B178
TDC_F08R08 500507630F15B178 500507630F95B178
TDC_F08R09 500507630F15B179 500507630F55B179
TDC_F08R09 500507630F15B179 500507630F95B179
TDC_F08R10 500507630F15B17A 500507630F95B17A
TDC_F08R10 500507630F15B17A 500507630F55B17A
TDC_F08R11 500507630F15B17B 500507630F55B17B
TDC_F08R11 500507630F15B17B 500507630F95B17B
Regards
Neil Schofield
Technical Leader
DCS Engineering
Yorkshire Water Service Ltd.
----------------------------------------
Spotted a leak?
If you spot a leak please report it immediately. Call us on 0800 57 3553 or go to
http://www.yorkshirewater.com/leaks
Get a free water saving pack
Don't forget to request your free water and energy saving pack, it could save you money on your utility bills and help you conserve water.
http://www.yorkshirewater.com/savewater
The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at
http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House, Halifax Road, Bradford, BD6 2SZ
Registered in England and Wales No 2366682
