DSXchange

How many tables have you got (do "select count(*) from syscat.tables"

I encounted this kind of problem I believe when there are more than 32,678 tables (caused my many multiple schemas)

IBM have a patch for this

one issue you need to be aware of is the the default config that is created as an installation - it will 'point' to the engine directory to store DataSets and Scratch Files - this is not a good idea as the installation directory needs to be protected from filling up - as a minimum this should be cha...

I think I know the answer to this already - but is anyone aware of a 'safe' way to remove old versions of jobs from VC I know they can be marked deleted - but still leaves the objects in the repository - ideally would like to purge old jobs as effects performance when promoting / initialising as the...

not sure if this is of use , but watch out for doing a sparse lookup using the db2 enterprise stage (I presume this is how u are doing the next val on the db2 sequence) We found out that if u pump the same lookup values down the lookup stage (i.e. ones used in where a=orchastrate.value) the lookup u...

just an additional angle on this , we experienced these issues on a large implementation of datastage. we managed to mitagate a lot of these timeouts but tuning some of the values in the uvconfig file (in $DSHOME) basically these govern the number of internal universe files that can be open at one t...

I have a very simple data extraction process pulling data from a db2 table and placing in a hash file. The job as worked fine for several days. It is currently failing with 'SQLFetch: Error retrieving results from server'. I can View Data from the db2 stage without a problem. I can also execute the ...

another way that could work - but not exactly tidy is to symbolically link the rsh exe to ssh

e.g. ln -s /usr/bin/ssh /usr/bin/rsh (or what ever paths)

Have seen this implemented before - but still provides the support issues mentioned above

have seen simalar repository issues like this before and is often a sign of a broken index - each datastage project is really a collection of universe tables and if the indexes get scuppered some of the 'structure' can be inaccessable not at a DS machine at moment - but if u seach formum for DS.TOOL...

Doh!!!

Thanks for the quick response - spot on!

I have inherited a job that contains two independant streams both creating hash files. The job is controlled from within a sequence where the triggers are set to 'OK conditional'. One of the two streams failed causing the job to abort which is also reflected in the Sequence log. The sequence itself ...

Thanks ghila - nice to get affirmation sometime - but as mundane said I have also seen this when osh isnt configured to use the LMM would suggest you find if it is the $TMPDIR issue or osh not being configured to large memory model (or both) first check value of $TMPDIR variable on project (seem via...

believe this is temp space used to create memory map file - this is pointed to by the $TMPDIR variable on project - it defaults to /tmp but each file can be quite sizable

best to redirect $TMPDIR to a dedicated directory that has enough 'wiggle room' for these intermediates

as mentioned above this is caused by the engine not being able to invoke the datastage job in 60secs - this is hardwired so the timeout cant be lengthened Once the job is running ur are ok, so one thing to consider is are you trying to invoke lots (100s) of jobs at the same time - if so try staggeri...

apols - just got back from said stag do - so late reply 1) first go to your datastage install directory (the location can be found from examining the file /.dshome - note the . infront of dshome) - something along the lines of /DataStageApp/Ascential/DataStage/DSEngine 2) change directorys to cd ../...

just a quick one, as am off on a stag do in amsterdam tom and need some sleep. But this error can be caused on datastage install, by not specifying the version of db2 (7/8) - this I believe is on datastage v7.5 only basically px ships with two versions of the orchdb2op.something (I believe in $DSHOM...