Raylei
1 Copper

Is there any tools or simulator can handle exported VCMDB backup file

I have bunch of VCMDB backup files on the local file system, and I would like to update some info such as node name inside VCMDB and generate some reports based on it, don't really want do this on production because lots of reasons. 

My questions is if there is any tools or simulators let symmaskdb or symmask handle the backup VCMDB files on local file system, so I can change and report freely. Thanks very much for any clues.

Tags (3)
0 Kudos
13 Replies
8 Krypton

Re: Is there any tools or simulator can handle exported VCMDB backup file

you can install symcli in offline mode on other server and play with it.

look at this thread.

https://community.emc.com/message/399662#399662

0 Kudos
Raylei
1 Copper

Re: Is there any tools or simulator can handle exported VCMDB backup file

Thanks, Boom. So the SYMCLI_OFFLINE will do this trick, but how could the symmask / symmaskdb locate the backup VCMDB file locations ? And could I update VCMDB backup file in offline mode ?
0 Kudos
8 Krypton

Re: Is there any tools or simulator can handle exported VCMDB backup file

Hi,

Please check this thread.

https://community.emc.com/message/452070#452070

There is solution availalbe.

you have to create backup file and point command to the backup file.

you can list the database but not sure abt change.

you cannot run some configuration command like symcongifure.

0 Kudos
8 Krypton

Re: Is there any tools or simulator can handle exported VCMDB backup file

Raylei,

you can run query type commands against a backup of your VCMDB

e.g.

symmaskdb ‑sid XXX backup -file vcmbackup03052010.txt

symmaskdb ‑sid xxx ‑file vcmbackup03052010.txt -v list database

There is no need to set offiline mode since you are already specifying that you are running against a file.

You can not edit this file, but is is useful for troubleshooting or auditing purposes and should fullfil your needs.

The number of commands you can run against the database backup is restricted to the following

list database [‑dir all [‑p all] | ‑dir <#> [‑p <# | all>]][‑wwn <wwn> | ‑awwn <awwn> | ‑iscsi <iscsi> | ‑aiscsi <aiscsi>]

-v option is available with all the above options.

A similar function exists in the VMAX for symaccess database.  Syntax for this is below.

symaccess ‑sid <SymmID> | ‑file <backup_filename>

list [‑name <GroupName>] [‑v]

list ‑type <storage [‑dev <<SymDevStart>:<SymDevEnd> | <SymDevName> | <<SymDevName>,<SymDevName>...>>] | port [‑dirport <Dir>:<Port>] | initiator [‑wwn <wwn> | ‑iscsi <iscsi>]> [‑name <GroupName>] [‑detail | ‑v]

list devinfo [‑ig <InitiatorGroupName>]

list view [‑name <ViewName>][‑v][‑detail]

list chap [‑dirport <Dir>:<Port>][‑v]

show <GroupName> ‑type <initiator [‑detail] | port | storage>

show view <ViewName> [‑ig <ChildInitiatorGroupName>]

Hope this helps

Message was edited by: Paul Martin

Raylei
1 Copper

Re: Is there any tools or simulator can handle exported VCMDB backup file

Thanks, Paul. As we mask disks centrally using wwn  and didn't have SE installed on each server, so the node name is actually wwn, but we would like to generate host allocation statistics by symmaskdb -sid nn list capacity -host xxxx command, so there is need to update old node name from wwn to server host name like symmask -sid nn  -wwn xxxxxxxxx rename hostname.

We have dumped the host name to wwn relationships list from SAN health report, but not sure if it's 100% accurate, that's another reason we don't wanna touch production. Do you know some utility can update VCMDB backup file offline like this ?

0 Kudos
8 Krypton

Re: Is there any tools or simulator can handle exported VCMDB backup file

Raylei,

you don't need to have SE installed on every server, just on your management hosts.  There is no tool that can update this file offline for later use.  (it would make auditing a nightmare)

You could build a script to make changes which is what a lot of cusotmers actually do for provisioning.

Once you have you script together you can do a bulk rename.   (once you've checked and doublechecked that your name to WWN associations are right).

Another thing you could look at is storagescope which is part of ECC which will allow you to do capacity reports and present them in neat tables which you can use for chargeback later.  .

0 Kudos
Raylei
1 Copper

Re: Is there any tools or simulator can handle exported VCMDB backup file

Hi, Paul:

  I have no problem to do script, but just don't want update production VCMDB with inaccurate info and plus all management procedure have to follow, explanation of risk, etc. The reason I mentioned SE on every host is that you can always run symmask -sid nn discover hba -rename to have node name populated automatically and which is more accurate.

  Our ECC is in upgrade, and very slow to get unix/intel resource for help on some master agent issue, so storagescope is not available for awhile about host info. Anyway, thanks for your information, looks like we need find other way to figure out this.

0 Kudos
Highlighted
Rajavulla
6 Indium

Re: Is there any tools or simulator can handle exported VCMDB backup file

Here is the script for backing up the configuration

*** Begin Script ***

REM Backup of VCMDB

@echo off

echo Backing up VCMDB ...

cd "C:\Program Files\EMC\SYMCLI\bin"

symmaskdb -sid XXX backup -file C:\SAN_Scripts\VCMDB\vcmdb_backup.txt -nop

echo Renaming file to inlcude date stamp

FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set date=%%a%%b%%c)

ren C:\SAN_Scripts\VCMDB\vcmdb_backup.txt "%date%_vcmdb_backup.txt"

echo VCMDB backup complete

exit

*** End Script ***

0 Kudos
BP-SAN
6 Indium

Re: Is there any tools or simulator can handle exported VCMDB backup file

Hi Raja,

Thanks for the script...As i dont have that much hands on scripting..can you please help me to understand below two lines

FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B

For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set date=%%a%%b%%c)


Regards,

Masud

0 Kudos