DSXchange

i have a big aix machine with 12 cpu machine 80 GB ram and traditionally used 3rd party sort utilities which gave outstanding speed. but there is a need to understand when we have to use datastage sort w.r.t 3rd party sort due to maintenance and resource skill issues . I tried to use datastage sort ...

I must have hallucinated writing something... that or I just can't find it. However, this did turn up: http://www.dsxchange.com/viewtopic.php?t=82785 You can also do an exact search on one of the hashed names to find other posts, some with even more low level detail. For example, try searching for ...

Ug. An upgrade is the simplest thing in the world. Other than taking a backup, as you did, the process is to simply install the new version right over the top of the old one. It handles everything automagically. Did you uninstall the old version or do something that caused the Projects to need to b...

I am converting our datasstage ser5ver from 7.5.1A to 7.5.2 and the method I am following is take a backup from the Datastage Manager and importing back the Jobs after 7.5.2 server and corresponding projects are created. This seems to be working good except for the Version Control Project. If I do t...

Having restored DSEngine and the projects, try reinstalling the server. This should go into maintenance mode. If there is a hidden file in the root directory its pathname would be .dshome - check for hidden files in the root directory ls -al /.* -- I checked , there is no file like that in root dir...

If you go into the UV shell and issue the command "COUNT DS_JOBS" what do you get? Perhaps your restore settings were such that existing files in the project directories were not overwritten. I dont have project any more , as I was restoring both server and projects again in a hope that i...

If you re-installed the DataStage server, then created empty projects with the same names and absolute locations as before, then overwrote those directories from a restore you should have been able to see the jobs. If you attach to the directory from UNIX you should see a number of files - i.e. RT_...

we have a datastage 751a server on aix , which needs to be restored from the unix backup, as we missed to take the backup ( from the datastage manager) before uninstalling the DS as a part of upgrade to 752 strategy . I requested the entire datastage server file system and datastage project file sys...

Ok, that message means that your DSParams file is actually in the project directory. Can you explicitly set the permissions on the file to allow all access to everyone and see if your error message goes away? I changed and tried to login, I get the same message while logging in . Even the different...

Ok, that message means that your DSParams file is actually in the project directory. Can you explicitly set the permissions on the file to allow all access to everyone and see if your error message goes away? I changed and tried to login, I get the same message while logging in . Even the different...

If you start a dssh session or go into the Administrator, what is the output when you issue the command "LIST &UFD& DSParams"? this is what I get -------------------------- LIST &UFD& DSParams 01:42:36pm 01 Oct 2007 PAGE 1 OS filename................... DSParams 1 records ...

I suddently got the similar problem in a project while login but I still see DSParams File in the project directory. " Cannot find parameter file record DSParams in UFD_" I checked another project which also runs with same userid and has file size, permissions, date of update, but works fi...

I know the datastage 8.0 or hawk edition is different from servers edition w.r.t architecture, but not sure of how much different it is . Does ds_jobs , ds_jobobjects hash files /tables are supported (i.e. has the correct design time information what it used to contain pre 8.0 versions ) in datastag...

Did you try using configuration file with a single node? If so is there any improvement in the performance? yes , with single node , it is 5000 rows/sec input and output is 2000 rows/sec output. you can use fileset stage to write instead of sequential file stage we tried , Not much improvement No e...

Our unix machine is 4 pysical (8 logical CPU) machine with 32 GB RAM . I had a simple job Reading from the input sequentual file and one loopkup stage ( lookup from seq, file with 1000 rows ) with and writing into sequential file. input stage was able to read 15,000 rows/ sec , but the output stage ...