Veritas-bu

Re: [Veritas-bu] Move EMM Database to another host?

2009-06-09 09:41:57
Subject: Re: [Veritas-bu] Move EMM Database to another host?
From: "Preston, Doug" <dpreston AT LANDAM DOT com>
To: <VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU>
Date: Tue, 9 Jun 2009 09:38:48 -0400
Never mind I found it,  thanks.

Doug Preston
Systems Engineer
LandAmerica Financial Group, Inc. - 
1123 South Park View DR, 
Covina CA 91724 
Phone 626-339-5221 Ext 1104 
Email  dlpreston AT landam DOT com

------------------------------------------------------------------------------
NOTICE: This electronic mail transmission may constitute a communication that
is legally privileged. It is not intended for transmission to, or receipt by,
any unauthorized persons. If you have received this electronic mail
transmission in error,  notify the sender by reply e-mail so that our address
record can be corrected, then please delete it from your system without copying 
it.
-------------------------------------------------------------------------------


-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Preston, 
Doug
Sent: Tuesday, June 09, 2009 6:25 AM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: Re: [Veritas-bu] Move EMM Database to another host?

Ok so I am not so bright,  Where do I find the password for the database?  I 
don't remember setting a password when I installed or upgraded.

Doug Preston
Systems Engineer
LandAmerica Financial Group, Inc. - 
1123 South Park View DR, 
Covina CA 91724 
Phone 626-339-5221 Ext 1104 
Email  dlpreston AT landam DOT com

------------------------------------------------------------------------------
NOTICE: This electronic mail transmission may constitute a communication that
is legally privileged. It is not intended for transmission to, or receipt by,
any unauthorized persons. If you have received this electronic mail
transmission in error,  notify the sender by reply e-mail so that our address
record can be corrected, then please delete it from your system without copying 
it.
-------------------------------------------------------------------------------


-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of 
backupgirl
Sent: Monday, June 08, 2009 9:59 AM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: [Veritas-bu] Move EMM Database to another host?


Can you give us more details on the process of moving the EMM database ( the 
command associated ) ??


Sure... We migrated from an AIX to Windows Master and the DBA discovered it was 
not as simple as unloading and loading the media tables. The database schema 
was different between the two versions. Some of the commands used to create 
tables and load tables are listed below.  

SYBASE:
Unix:
. /usr/openv/db/vxdbms_env.sh
dbisqlc -q  -c "CS=utf8;UID=dba;PWD=xxxxxx;ENG=NB_servername;DBN=NBDB" xyz.sql

interactive use esc+F -->File menu
dbisqlc  -c "CS=utf8;UID=dba;PWD=xxxxxx;ENG=NB_servername;DBN=NBDB"

Windows:

Go to:
D:\Program Files\Veritas\NetBackupDB\WIN64 Execute dbisqlc.exe Login tab:
User id: dba
Password:xxxxxx
Database tab:
Server name: NB_servername
Database name: NBDB
Uncheck stop database


unload table EMM_MAIN.EMM_Media to '/tmp/ EMM_Media.unl'; unload table 
EMM_MAIN.EMM_MediaGroup to '/tmp/ EMM_MediaGroup.unl';

dbunload -n -c "CS=utf8;UID=dba;PWD=xxxxxx;ENG=NB_servername;DBN=NBDB"
vi reload.sql

EMM_Media
EMM_AllocationStatus
EMM_Allocations
EMM_DeletedMedia
EMM_Media_MediaAffinityGroup
RB_MDS_Allocation
RB_MDS_Reservation

load table EMM_MAIN.EMM_Media (MediaKey, DriveKey, MediaGuid, MediaId, 
PartnerKey, PartnerId, LegacyMediaType, MediaTypeName, MediaGroupName, 
DensityName, DensityCode, VerificationFlag, AssignedAppType, MediaFlags, 
MediaTypeFlags, MediaDescription, Barcode, PartnerBarcode, LastWriteHostKey, 
AssignedDateTime, FirstMountDateTime, LastMountDateTime, ExpireDateTime, 
ImageExpireDateTime, AllocatedDateTime, LastWriteDateTime, LastRestoreDateTime, 
LibraryNumber, LegacyRobotType, LibraryGroupName, SlotNumber, OpticalSide, 
ControlHostName, CleaningsLeft, TotalMounts, MaxMounts, MediaRunTimeStatus, 
TotalWriteKBytes, NumberOfImages, NumberOfValidImages, RetentionLevel, 
NumberOfRestores, OpticalHeaderSizeBytes, OpticalSectorSizeBytes, 
OpticalLastHeaderOffset, OpticalPartitionSizeBytes, AdammGuid, RsmGuid, 
OriginHostKey, UpgradeConflictsFlag, PoolNumber, PoolName, PrevPoolName, 
VltFlags, VltContainerID, VltOffsiteLocation, VltOffsiteSlotNumber, 
VltOffsiteSessionID, VltOffsiteSentDateTime,
  VltOffsiteReturnDateTime, AcsAcs, AcsLsm, AllocationState, ManufacturerName, 
SerialNumber, CreatedDateTime, LastModifiedDateTime, MasterServerKey, 
ServerGroupKey) from 'D:\Program Files\Veritas\NetBackupDB\WIN64\EMM_Media.unl'

ALTER TABLE "EMM_MAIN"."EMM_Media"

                ADD FOREIGN KEY "FK_EMM_MEDI_R_MEDIAGR_EMM_MEDI" 
("MediaGroupName") 

                REFERENCES "EMM_MAIN"."EMM_MediaGroup" ("MediaGroupName")

go


CREATE TABLE "EMM_MAIN"."EMM_AllocationStatus"

(

                "AllocationStatusKey"   unsigned int NOT NULL DEFAULT 
autoincrement  CONSTRAINT "CKC_ALLOCATIONSTATUSK_EMM_ALLO" 
check(AllocationStatusKey >= 1),

                "AllocationKey"                                unsigned int NOT 
NULL DEFAULT 0 ,

                "MediaKey"                       unsigned int NOT NULL DEFAULT 
0 ,

                "DriveKey"                          unsigned int NOT NULL 
DEFAULT 0 ,

                "JobId"                                                 
unsigned int NOT NULL DEFAULT 0 ,

                "StatusCode"                     unsigned int NOT NULL DEFAULT 
0 ,

                "Operation"                       unsigned int NOT NULL DEFAULT 
0 ,

                "MediaServerKey"          unsigned int NOT NULL DEFAULT 0 ,

                "Data1"                                                unsigned 
int NOT NULL DEFAULT 0 ,

                "Data2"                                                unsigned 
int NOT NULL DEFAULT 0 ,

                "String1"                              varchar(128) NOT NULL 
DEFAULT '' ,

                "CreatedDateTime"       timestamp NOT NULL DEFAULT current utc 
timestamp , 

                 CONSTRAINT "PK_EMM_ALLOCATIONSTATUS"  PRIMARY KEY 
("AllocationStatusKey"),

                

) IN "EMM_DATA"

go

+----------------------------------------------------------------------
|This was sent by azenon AT yahoo DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

<Prev in Thread] Current Thread [Next in Thread>