Thanks, I thought it was not so complicated..
I red the 6.5 administrator's guide and in page 721, there is the chapter :" Moving the NetBackup database from one host to another". I will try this for moving the 6.5.3 EMM database from a Solaris to a Linux redhat. If someone else has experience about that, their ideas are welcomed. Gilles. -----Message d'origine----- De : veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu]de la part de backupgirl Envoyé : lundi 8 juin 2009 18:59 À : VERITAS-BU@MAILMAN.ENG.AUBURN.EDU Objet : [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 aze...@yahoo.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +---------------------------------------------------------------------- This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this in mind if you answer this message. The information in this e-mail is confidential. The contents may not be disclosed or used by anyone other then the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, please notify Airbus immediately and delete this e-mail. Airbus cannot accept any responsibility for the accuracy or completeness of this e-mail as it has been sent over public networks. If you have any concerns over the content of this message or its Accuracy or Integrity, please contact Airbus immediately. All outgoing e-mails from Airbus are checked using regularly updated virus scanning software but you should take whatever measures you deem to be appropriate to ensure that this message and any attachments are virus free. _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu