Page 1 of 1

DataStage Version Upgrade

Posted: Wed Jan 09, 2008 12:21 pm
by asitagrawal
Hi,

My client went for DataStage Server Edition upgrade from 7.5.1A to 7.5.2 on Windows.

The approach followed was this:

Code: Select all

Export all production Projects 
        "Stop Datastage agents and process Schedulers; " 
        Archive a Copy of All Projects 
        "Move and rename all projects directories; " 
Uninstall DataStage Process 
        "IBM DataStage Client 7.5.1A; " 
        "IBM Datastage Server 7.5.1A; " 
Installation of DataSatage 7.5.2 from Oracle 
        "Install Oracle DataStage Server 7.5.2; " 
        On installation process, created empty projects on the same directory. 
        "Install Oracle DataStage Client 7.5.2; " 
        Restart the server. 
        Stop Datastage Services. 
        Move the old (production) projects to the correct directory on DataStage. 
Recompiling and Testing jobs 
        Recompile the jobs on Datastage application Administration. 
        Testing some basic functionality on jobs.


Now, what happened is this:

After installation of DataStage 7.5.2, the windows administrator verified that the DS Server version is 7.5.2,
but, after Moving the old projects to the correct directories on DataStage, the DS Server version is coming as 7.5.1A !!


Can anyone advice waht has gone wrong ??

Thanks

Posted: Wed Jan 09, 2008 12:29 pm
by chulett
Where in the heck did you get that approach? :?

The projects need to remain in place so they can be properly upgraded when the new Server version is installed. If you remove the old Server installation, then you should have imported all of your 'old' jobs from an export and that process will upgrade everything. Moving the directories out and back in again was a mistake.

If you contact Support, I *think* they should be able to give you the UV command that will perform the upgrade steps. Seems to me, your other option at this point would be to reinstall the Server right over the top of the current installation so it can properly upgrade everything.

Posted: Wed Jan 09, 2008 12:29 pm
by ArndW
Sure,
Move the old (production) projects to the correct directory on DataStage
is a step that shouldn't be done, assuming you did an OS-level move.
What you need to do is export the project contents and then import that into the new (and empty) projects.

Posted: Wed Jan 09, 2008 4:25 pm
by ray.wurlod
Given that that's what you have done (and let me state that I disagree with the approach on the same bases as the other posters), log in with Administrator privileges and execute the command UPDATE.ACCOUNT in each project. You can do this from the Administrator client Command window or from a TCL prompt on the server.

Posted: Mon Jan 28, 2008 5:49 am
by asitagrawal
First of all my apologies for a late reply :(

I have issued this command for one of the projects, but still the server version for the project is 7.5.1A ..

please advice, where I went wrong ?

Posted: Mon Jan 28, 2008 8:10 am
by chulett
I seem to remember a command more like DSPROJUPGRADE or at least with UPGRADE in it somewhere. :?

Why not just rerun the installation script? That will 'upgrade' everything.

Posted: Mon Jan 28, 2008 8:37 am
by asitagrawal
After executing UPDATE.ACCOUNT, I also exe uted VVOC (I found it on the forum itself... but to be true, without understanding what VVOC actually does.. )
So, when I ran VVOC, the screen reads:

Code: Select all

There are 1215 records in your VOC file that are not in NEWACC
What does it mean ? I am worried :(

Posted: Mon Jan 28, 2008 9:36 pm
by ray.wurlod
These are all the routines and other things that are in your project but not part of the engine itself. Don't worry about the results from VVOC.

The only way to upgrade the server properly is to reinstall the server software, and not destroy the new engine by restoring the old engine from backups. Projects, yes: engine, no.

You might cheat by changing the RELLEVEL item in VOC in the engine, so that the Administrator client shows the new version, but it's still the old version under the covers.