Start a Conversation

Unsolved

This post is more than 5 years old

1737

January 21st, 2009 10:00

listing device/Host/Storage Port/Host PWWN

We have a tool, Sanscreen, that produces a report that lists for a given frame a masking report. The report shows the LunID, Host attached, FA the Lun is mapped to, and the Host PWWN. IE:
LUN SERVER FA WWN
1234 SERVERA 7A:0 50060b0000111111
1234 SERVERA 10A:0 50060b0000222222
1235 SERVERB 8A:0 50060b0000444444
1235 SERVERB 9A:0 50060b0000555555
I have been tring to find a symdev or symmaskdb command that it is using to get this data, but can't seem to come up with one. I never trust a GUI so I would like to be able to run directly against the vcmdb. "symdev -sid list" will show all the devices, but not the server/fa/wwn. "symmaskdb -sid list database kind of shows it but not really. I really can't find one that preduces the same output.

9 Legend

 • 

20.4K Posts

January 21st, 2009 11:00

i am not sure if this is exactly what you want but could you for example run something like this:

symmaskdb -sid 123 list capacity -host oracle_SMS

and the output would be look something like :


Symmetrix ID      : 0000000000123
 
Host Name         : oracle_SMS
 
Identifiers Found : 20000005e600b5c2
                    21000005e600b5d6
                    21000006e600b5c6
                    21000007e600b5d6
                    21000008e600b5c6
                    21000009e600b5d6
                    21000001e600b5c6
                    21000002e600b5d6
 
Device  Cap(MB)  Attr  Dir:P
------  -------  ----  ----
0083      69052   (M)   8A:1, 9A:1, 8C:0, 9C:0
008B      69052   (M)   8A:1, 9A:1, 8C:0, 9C:0
0093      69052   (M)   8A:1, 9A:1, 8C:0, 9C:0
009B      69052   (M)   8A:1, 9A:1, 8C:0, 9C:0
00A3      69052   (M)   8A:1, 9A:1, 8C:0, 9C:0
00AB      34526   (M)   8A:1, 9A:1, 8C:0, 9C:0
00AF      34526   (M)   8A:1, 9A:1, 8C:0, 9C:0
00B3      34526   (M)   8A:1, 9A:1, 8C:0, 9C:0
blah 
blah 
blah
-----------------------------
 
MB Total:20784713
GB Total:20297.6



so if you have your systems named in the vcm database you could generate this report per host. Not sure if that's what you are looking for.

111 Posts

January 22nd, 2009 01:00

I remember hearing about this product.
From what I remember that it scans you SAN switches and gets all zones.
From the zone name pattern it can find the hostname.
After you have the hostname and its PWWN, it's pretty easy to parse the rest of the info from the 'symmaskdb list database'.
Or it can just connect to your ECC to get it...

4 Operator

 • 

2.1K Posts

January 22nd, 2009 07:00

Hey, isn't ECC a "dirty word" here in the SE Forum? ;-)

It's like talking about GUIs to the poor saps that manage our mainframe environment *lol*

6 Posts

January 26th, 2009 08:00

Dynamox, you are correct that symmaskdb .... list capacity will show the FA:P the lun is assigned to, it does not show which wwn is assigned to each FA:P. Sure I can go get that. i was just hoping there was one command so I could scrape the output and script the lun removals.

1 Rookie

 • 

12 Posts

April 21st, 2009 03:00

symmaskdb -sid 123 list capacity -host oracle_SMS


Dynamox - just stumbled across this posting when searching for other information and tried this command out - I am loving that command - so simple - but really affective.

Cheers.

154 Posts

April 21st, 2009 07:00

Seems we have some useful info here, marking appropriately.

BTW:
"Hey, isn't ECC a "dirty word" here in the SE Forum?"

Yes, it is.;\



"It's like talking about GUIs to the poor saps that manage our mainframe environment *lol*"


Everyone knows that gui is something that should be on the inside of a chocolate bar, and nothing to do with computers! :D

The Benevolent Mainframe Forum Moderator.

1 Message

July 5th, 2010 10:00

symmaskdb -sid xxx list capacity -host yyyyy

symmaskdb -sid 385 list capacity -host smchpmaessbasep

symmetrix id     : 000190100385

host name        : smchpmaessbasep

identifiers found :1000000c93d40fa

                        1000000c93d426c

Device      CAp (MB)     Attr     Dir:P

13ec         302104       (M)       3c:1,14c:1

140f          302104       (M)       3c:1,14c:1

1432         138105       (M)       3c:1,14c:1

1442         138105       (M)       3c:1,14c:1

1452         138105       (M)       3c:1,14c:1

MB  Total  :1165259

GB  Total : 1137.9

first  rename  wwn  for    host name

symmask -sid 385  -wwn 1000000c93d40fa rename smchpmaessbasep/1000000c93d4fa

symmask -sid 385  -wwn 1000000c93d426c rename smchpmaesbasep/1000000c93426c

No Events found!

Top