DSXchange

Hi,

Is it possible to COUNT hash file records created not in account but in a specified path?.Does not work for me even if I LOGTO uv.

There is no sorting in the hashed file stage, unless you specify it as a "selection" phrase. Can you advise what you had in mind here? Investigate the CoSort plug-in. It absolutely flies, even compared to the UNIX sort. DataStage sort stage comes a bad last. Thanks Ray..How do I get hold ...

Hi, We have set up a Sun Solaris server 400 x 4 Mhz, 4Gb ram, with Solaris 2.9 (with latest patches) and DataStage server 7.1. We have cases where the jobs have 1000 to 2000 columns in the source stage.There is no complex logic in the job.But the compile time goes to 40-50 minutes for such a job (th...

Well, that option is always there.
I was hoping for some help on PORT.STATUS command with RUNNING option or some similar one line command.
Thanks anyways.

I have multiple projects on my DS server.How can I check the jobs that are running via the cmd line? I tried the PORT.STATUS RUNNING option.But I get a message RUNNING option is only valid after issuing SUSPEND.FILES ON What does this mean? Even if I try PORT.STATUS USER XYZ, it shows all the users ...

Hi,
Is there anyone who can answer my query?

Thanks

Can anybody please reply on this one soon.

Thanks

Hi guys, Its about the environment variables that you have in administrator.I have DS server running on NT. Right now I have these three under the General..Customize category: DS_ENABLE_RESERVED_CHAR_CONVERT, DS_TDM_TRACE_SUBROUTINE_CALLS, DS_TDM_PIPE_OPEN_TIMEOUT. I know that more can be added in t...

A typical error message when you first start using the plugin. It usually means that either the settings are incorrect or the QualityStage job has not been correctly deployed to the server. In this case since the qsrtmngr log file is empty it is likely to be the datastage settings for host and port...

Hey guys, I have been trying to run a qualitystage job within datastage.I have started this real time manager on the QS server.But i get the following error when i run the job. Failed to open QSRT connection: check qsrtmngr is running, job is deployed No error tcp_open: can't connect to server I can...

Hi guys, I am getting the following error when I try to connect from Datastage client to Datastage server on Unix.This was working fine previously.Havent even done any changes to any file. Failed to connect to host: 172.19.1.72, project: UV (The connection is broken (81002)) I am able to start and s...

That is done too !..but no progress. I noticed one more thing...The import Orchestrate schema itself fails when tried via the Database option.This throws a similar error: *** Error executing command: orchdbutil show DWUSER.EMP -dbtype oracle -dboptions ********* ##I TFCN 000001 07:43:37(000) <main_p...

Hi Ray, My $ORACLE_HOME points to /opt/orasw/app/oracle/product/9i.As you can see that the LD_LIBRARY_PATH has the /lib directory and the PATH has the /bin directory. The TNSNAMES.ORA also has the entry for connecting to the Oracle server. Thanks One that jumps out immediately is that LD_LIBRARY_PAT...

Hi TJ, Ia m running oracle 9i.Below is the copy/paste from my Director's second line: Environment variable settings: APT_ORCHHOME=/opt/dsadm/Ascential/DataStage/PXEngine DSHOME=/opt/dsadm/Ascential/DataStage/DSEngine HOME=/ LD_LIBRARY_PATH=/opt/dsadm/Ascential/DataStage/Projects/DSPX/RT_BP10.O:/opt/...

Hi guys, Presently I have just one Oracle Server I need to conect to and it resides locally.And even when I give the Remote Server value, get the following error: >##E TDOR 000000 01:29:43(001) <Oracle_Enterprise_0> connect failed for env: PX, user: dwuser, password: ***** > >Oracle error: -2127 > >...