DSXchange

Before starting to work on the production project I decided to first try on DEV. The method I chose was an OS copy of the TST project's hashed files to the DEV project. Both TST and DEV projects are on the same DataStage server. I analyzed the TST project's content and came up with a list of wildcar...

Sorry for the delay in answering. What I am interested in is just the hashed files and a few control files from the PeopleSoft warehouse. Their TST names match the PRD names and that is why I was thinking about a restore of the PRD project's folder to the TST server, in a temp directory. That way, w...

Hello Ray, PROD and TEST are on different servers that are on different network segments. Since the project copy is ruled out it sound like the best option would be to take an OS backup of the PRD project's folder and restore it on the TEST server. At that point we can either copy the files to the T...

Hello, I am looking for suggestions on the shortest way to refresh our TEST environment with PROD data. Apart from the DB side which is easily taken care of by a backup of PROD and a restore to TEST, in our PROD DataStage project we have lots of hashed files that need to be moved as well (we use CRC...

Ray, Instead of fixing the project I did not need and then deleting it through Administrator I decided to do an OS rename of the project's directory, fix the SQL Catalog tables and fix the UV.ACCOUNT table. Before going ahead I verified the method by recreating the same conditions with another set o...

Thanks Ray, I will proceed with the repairs and post the results.

There had been a previous attempt by a consultant to delete, among other projects, also project MB_WHRCS89_90_DEV and during that activity the development project was wiped out. I thought that he had made a mistake and deleted the wrong project but now I am more inclined to think that the delete of ...

Ray, Here it is for project MB_WHRCS89_90_DEV: >VERIFY.SQL SCHEMA /appl/xxxxxx/Ascential/DataStage/DSEngine/projects/MB_WHRCS89_90_DEV Checking permission. * Possible moved or duplicate schema. ** /appl/xxxxxx/Ascential/DataStage/DSEngine/projects/MB_WHRCS89_90_DEV is a duplicate schema. It cannot h...

Hello, I wanted to delete an obsolete project (MB_WHRCS89_90_DEV) but as I started gathering some info it looks like that project is somehow pointing (see WHO command below) to my current development project (WHRCS89_90_DEV). I ran the following TCL commands for project MB_WHRCS89_90_DEV: >SELECT * ...

Thank you all for your help.

Ray, apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine> . ./dsenv apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine> bin/dsjob -server apux19 -lprojects apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine> Same behaviour. Craig, FROM PROD: apux165::/data51/app/asudtstg/As...

Ray, apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine> . ./dsenv apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine> bin/dsjob -server apux19 -lprojects apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine> Same behaviour. Craig, FROM PROD: apux165::/data51/app/asudtstg/As...

Ray, Here is the what I am doing: apux19::/appl/asudtstg/Ascential/DataStage/DSEngine> . ./dsenv apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine> cd bin apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DSEngine/bin> dsjob -lprojects apux19:ASUPMDEV:/appl/asudtstg/Ascential/DataStage/DS...

Hello, I was running some dsjob commands (-linkinfo, -stageinfo, etc.) from the /bin directory when I performed a bad copy/paste into the command line (last good command was a dsjob -report). I got a whole list of command rejected errors messages. Now when I try to run a dsjob command all I get is t...