Usage of UVBackup and UVRestore

boppanakrishna · Post by **boppanakrishna** » Mon Sep 01, 2008 6:09 am

Hi All,

We are using the version 7.5.1 Server edition. In the process of upgradingto DS8, we have lost the back file for the last two days.

and also we have uninstalled the DS7.5 and loaded DS8.

Before upgrading to DS8 we took the total backup of the server in which DS7.5 is installed.

Is there any possibility that if we restore the complete image backup of the server ( in which 7.5 was installed) to other machine, we can get the complete DS repository with the jobs.

If so, What steps should i follow to restore the jobs in to the new server

Thanks in Advance,
Boppana

DS_SUPPORT · Post by **DS_SUPPORT** » Mon Sep 01, 2008 6:28 am

yes , it is possible. Follow the following steps

Code: Select all

1) Install Datastage 7.5 in Server2 in the Same Path as it is installed in Server1. ie Datastage Home should be same in both the servers
2) Create the Project which needs to be copied, in the same path where it is installed in Server1. For ex In Server1 if the project is
installed in "C:\Ascential\DataStage\Projects\PRJxxxx", then in server2 also it has to be created in the same path. Datastage is case-sensitive,
so Project name and path should be exactly same
3) Stop the Services in Server2 and delete all the contents in the newly created project folder
4) copy and paste all the contents of the project folder from the server1 to server2
5) Restart the services in Server 2
6) Logon to Administrator client in Server2 and execute DS.REINDEX ALL for the newly created project
7) Now all the jobs should be accessed from Server2 Project

Please search the forum , for the issues that can occur because of this, and wait for the gurus replies.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 01, 2008 6:29 am

Restoring from a complete backup should re-create all the components including the jobs. You ought not to need to do anything else.

chulett · Post by **chulett** » Mon Sep 01, 2008 7:07 am

They are restoring a 7.5.1 installation on an old server and then want to import the contents into their new 8.x installation. Use export/import to accomplish that.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 01, 2008 7:22 am

Yes, a full restore to a clean system will reinstate whatever it was that was backed up - in your case the 7.5 system.

The move to version 8.0 involves many things but, as far as DataStage projects are concerned, export/import is the method of choice.

boppanakrishna · Post by **boppanakrishna** » Tue Sep 02, 2008 5:41 am

Hi All,

Thanks for your valuable suggestions.

Unfortunately backup of the server didn't happen as expected but i was able to copy the original project folder.

I have followed the following steps :

1.I have installed DS7.5 on our new server ( excatly in the same path which we have installed on the original server)

2. Created the new project with the same name and same directory and replaced the new files with the old files

3. I have restarted the datastage services and when i tried to connect to Administrator, i got the following error message

The directory you are connecting to either is not a UV account or does not exist(39125))

Please suggest me the measures i can follow to resolve this error message?

Regard,
Boppana

ray.wurlod · Post by **ray.wurlod** » Tue Sep 02, 2008 6:55 am

Search the forum for the following topics. You will need them all.
UV.ACCOUNT
VERIFY.SQL
SET.INDEX
DS.REINDEX

boppanakrishna · Post by **boppanakrishna** » Tue Sep 02, 2008 7:26 am

Hi Ray,

Thnaks for the update.

I found from one of the posts and fired the following query from the DS command promt

SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT

From the output of the query i am able to view the new project which i have created.

but i am not sure how to go ahead from this step to make it work.

Can you please advise on this

Regards,
Boppana

boppanakrishna · Post by **boppanakrishna** » Tue Sep 02, 2008 9:10 am

Hi,

I traced out the problem to some extent.

The problem is that my new project doesn't have its entry in "UV_SCHEMA".

But my new project exists in "UV.ACCOUNT".

How can we add new project's entry to the 'UV_SCHEMA'

ray.wurlod · Post by **ray.wurlod** » Tue Sep 02, 2008 3:31 pm

VERIFY.SQL

Keep searching.

boppanakrishna · Post by **boppanakrishna** » Wed Sep 03, 2008 3:19 am

Hi Ray,

I have tried working with the following commands

1.VERIFY.SQL SCHEMA ProjectName

I got the following error message

NO SQL Catalog data for schema 'Project Name' in UV_SCHEMA

I have alos tried running the follwing query

SELECT @ID, PATH FROM UV.ACCOUNT WHERE NAME LIKE 'DataStage%';

I got the list of projects in my server along with their paths

But still i am not able to figure out the exact method to resolve this issue.

FYI: I am exeting these commands from Administrator Component

ray.wurlod · Post by **ray.wurlod** » Wed Sep 03, 2008 3:40 am

Forget UV.ACCOUNT for now.

VERIFY.SQL has told you something you were able to establish by other means - that there is no record for the project in UV_SCHEMA (and therefore none in other system tables).

Try specifying the pathname of the project.

Code: Select all

VERIFY.SQL SCHEMA C:\path\projectdir

This is still a safe command; it will tell you what's fixable.

boppanakrishna · Post by **boppanakrishna** » Wed Sep 03, 2008 4:17 am

HI Ray,

I have tried the following query

VERIFY.SQL SCHEMA D:\DATA_DS_Repository\DATA_DEVE

where DATA_DEVE is my Project Name and D:\DATA_DS_Repository\ is the path.

Ignoring Unknow Key word 'DATA_DS_Repository'
Ignoring Unknow Key word 'DATA_DEVE'

Checking Permission.
** 'D: ' is not a datastage account

1 verify operation discontinued

Please correct me if i am wrong

ray.wurlod · Post by **ray.wurlod** » Wed Sep 03, 2008 5:12 am

For some reason it is reading the backslash characters as escape characters. Use forward slashes. Windows doesn't care.

Code: Select all

VERIFY.SQL SCHEMA D:/DATA_DS_Repository/DATA_DEVE

boppanakrishna · Post by **boppanakrishna** » Wed Sep 03, 2008 5:18 am

Hi Ray,

I have executed the same query

VERIFY.SQL SCHEMA D:/DATA_DS_Repository/DATA_DEVE

I got the error message as

'D:/DATA_DS_Repository/DATA_DEVE' is not a datastage account

1 verify operation discontinued

Can you please let me know the next resolution method