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

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 ?

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.

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 | ‑awwn | ‑iscsi | ‑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 | ‑file

list [‑name ] [‑v]

list ‑type : | | < , ...>>] | port [‑dirport

: ] | initiator [‑wwn | ‑iscsi ]> [‑name ] [‑detail | ‑v]

list devinfo [‑ig ]

list view [‑name ][‑v][‑detail]

list chap [‑dirport

: ][‑v]

show ‑type

show view [‑ig ]

Hope this helps

Message was edited by: Paul Martin

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 ?

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.  .

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.

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 ***

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

In Sha Allah,

I would email the script on Monday

Allah Hafiz

Sent from my iPhone

ASAK Raja,

Thanks for your reply…I will wait till Monday.

Allah hafiz

Can I have the script please. you can share on below mail ID

Masudahmad.shaikh@gmail.com

From: Shaikh, Masud

Sent: Monday, December 02, 2013 10:05 AM

To: 'jive-1245983941-9anb-2-goty@emc-ecn.hosted.jivesoftware.com'

Subject: RE: - Is there any tools or simulator can handle exported VCMDB backup file

ASAK Raja,

Thanks for your reply…I will wait till Monday.

Allah hafiz