DSXchange

In case of huge volume of data
the first one will have a bit more advantage than the second one.

Hi, The problem is as followed: After logging to the command prompt of the Datastage Administrator when i am execute the command: LIST.READU all after getting the user id when i am trying to execute the following command UNLOCK USER <USERID> ALL it is giving me the error Verb "UNLOCK" is n...

chulett wrote:One suggestion would be patience. Clear it from the Status view, not the log view and then... wait. That or CLEAR.FILE RT_LOGnnnn if you know the job nnnnumber, but then you'll need to reestabl ...

as mentioned how to find the job nnnnumber so that i can use it in
CLEAR.FILE RT_LOGnnnn

if using the UNIX then use the CRONTAB to set on hour or minute basis.
if using mainframe(OPC) make it a time dependent job.

ray.wurlod wrote:I just did, eight minutes prior to you re-posting your question. Was there anything about my answer that was unclear? ...

my apology for posting it twice. 2 sessions were open by that time and i submit in both the session which get reflected in this.

what happen in case when required to do operation to database.
let say if the database is "Teradata" and if the partition is set to Auto then how do DSEngine will decide as because the information about the database activities like collect statistics or join index had been performed or not.

The parallel jobs leverage the paralellism by using the pipelining and partitining mechanism. During partitioning the Reference records might be distributed accross the nodes. But if the input records are looked up to the wrong node then the output might be problemetic. Entire partition copy the co...

The parallel jobs leverage the paralellism by using the pipelining and partitining mechanism. During partitioning the Reference records might be distributed accross the nodes. But if the input records are looked up to the wrong node then the output might be problemetic. Entire partition copy the co...

i guess it is purely the resource problem, im my case 100% of the jobs run successfully in a re-run.
but what get write in &PH&. please suggest

SET-FILE UV UV.ACCOUNT UV.ACCOUNT creates a pointer to the UV.ACCOUNT table, which pointer does not exist in your project by default. ... but in both of the tables UV_TABLES(schema) and UV.ACCOUNT ( acccount) have the entry for that project . then what is missing in this. since i query on all the p...

Simply, "permanent storage" means the data files of Data Sets, File Sets and Lookup File Sets. "Temporary storage" covers files created during (and removed after) certain processing, such as sorting. ... let say in case of sorting and remove duplicate stage the intermediate/temp...

open the join stage
in the Link ordering tab of the Stage page you can see the left and the right one.

Hi Ray, i checked with the UV_TABLES , the project name is there. i cannot get the last few words . is it the following SET-FILE UV UV.ACCOUNT UV.ACCOUNT SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT or SET-FILE UV UV.ACCOUNT SELECT @ID FMT '20L',PATH FMT '56L' FROM UV.ACCOUNT what will this p...

Hi All,
can anyone please suggest weather DS_AUDIT will list the occurrence of the exported job from that project.
as import of the datastage object information is available.

thanks Ray, i realize after posting the thread that it had already been raised. The issue with the project is when i am trying to run the command prompt in the administrator its throwing the error. even i cant do the reindexing of it. even i thought to export and import might solve the problem but i...