DSXchange

If you want to do it using Unix, you can do it using the dsjob command. You will need the log ID for this. You can get this using the -logsum or -lognewest option. Using the log ID, you can get the message using the -logdetail option.

This is a post on behalf of a friend: We have to read 2months of data (approximately 16 million records) from a table. For this we are using 8 Oracle Enterprise stages for faster retrieval and then using a funnel to merge it. We were suggested to use the partition table clause instead of 8 oracle st...

Yes it worked. Thanks all.

The LD_LIBRARY_PATH is not defined, but SHLIB_PATH is defined in $DSHOME/dsenv. I'm pasting the same below: SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC/hotspot:$DSHOME /java/jre/lib/PA_RISC:/opt/oracle/9.2.0.4.0/lib:$SHLIB_PATH:$ORACLE_HOME/l...

No, its on a server dedicated to using DS 7.0 PX. ANd this is a problem on 2 servers, not 1. And one installation is a production server.

I did execute $DSHOME/dsenv before running the commands. This works fine on 6.0 server.

We have some hash files created in 6.1 PX jobs and we need to use them in 7.0. First of all, can we copy hash files from one server to another? Secondly can we use hash files created in 6.0 directly in 7.0 jbs, if copying them is possible.

I am trying to run the uv command from the console, but it is giving the following error: What could be the problem?

We have some hash files created in 6.1 PX jobs and we need to use them in 7.0. First of all, can we copy hash files from one server to another? Secondly can we use hash files created in 6.0 directly in 7.0 jbs, if copying them is possible.

We have a production server, where we can telnet through Unix, but cannot connect with DS. I need to view the performance statistics as shown in designer. Can it be viewed through the log files or any other way? I have all details of the job and project. Please remember that I cannot use Designer, D...

I have created a hash file in a server job. The hash file has the name Vinodh1. Suppose I have created it in the directory /apps/dsadm/Vinod. When I got to the above directory, I see another directory with the name Vinodh1. It contains 2 files: OVER.30 and DATA.30. I want to view this file from the ...

Why does the error SIGBUS occur? There is a job in which I am retrieving data from a table and performing a lookup against a dataset. The dataset has some 16million plus records. I am using a lookup stage for this. When I run the job, it retrieves the data from the table. While fetching the records ...

I want to which are the DataStage specific tables. For e.g, one table I know of is DS_JOBS. Are there any other DataStage specific tables? If so, what are they?

I require info on what the uv and uvsh commands can be used for besides accessing logs. Is there any documentation available on the commands? I am doing some research on the commands, but cannot seem to find any documentation on the commands. Also, what are the tables available in the uv database.

I tried the same, but its not working. Does it have something to do with the .odbc.ini file? But we are not specifying the DSN name in the stage.