DSXchange

Hi, I have few jobs(sequence jobs) which are always running(in loop),so for its mentanence i am planning to write a script which will stop these jobs and reset and then retrigger. But when i am retriggering a job i am getting message like + /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -user ...

Hi,

RPhani has mentioned that he is using "Transformer's Surrogate Key" i.e. as per my understanding he want to generate sequence in Transformer stage using surrogate key feature added in version 8x.

Hi,
There will gap in your sequence number if input records to your transformer stage is not evenly distributed to all nodes,that you have to make sure otherwise you need to run transformer in sequential mode.

Add APT_DISABLE_COMBINATION environment variable to your job and then run your job,you will come to know that which Stage is throwing error.

Just i wanted to add my observation,even your block size is 1 and partition is not round robin,you will land up in getting gap in your sequence number.

Pass this 10000 value as a parameter to Initial value in the transformer and run the job.

Hi,
There is no such option in Transformer.In Transform it will generate unique number but never guarantee that it will be higher then your last max value.

Hi,

Why are you putting constraint:-

IsNull(<field>) Or Trim(<field>) = "" Or IsValid("timestamp", StringToTimestamp(<field>, "%yyyy%mm%dd%hh%nn%ss"))

Hi Ray, After investigation i found that xmetasr user is missing (/home/xmetasr) from the server.When i tried to login to server using xmetasr user i got below error:- Could not chdir to home directory /home/xmetasr: A file or directory in the path name does not exist. xmetasr@ait-etl01dev:/ $ Then ...

Hi Ray,

Should i look for db2inst1 password expire? If password would have expired,then xmeta database also should not have worked but it is working fine.

I think you need to restart datastage server. Check the output of ldd ldd /opt/IBM/InformationServer/DSComponents/bin/libccora10g.so this should provide a list of the libraries that are required by the oracle 10g connector nd I think that there may be some libraries that it can not find. If it resul...

Your file is probably not in a correct format. According to your definition given in sequential file (Delimiter=Comma and Quote=Double) your result should go to same column. Your correct format is :- "77° - 9° 10","R0403" Remove quote=double and see what is your result.

In this case all records from the left will move to output link with matching records from Intermediate1 ,Intermediate2 and right link.

Try to manully run the procedure and check if it is working fine.I thing your procedure is failing due to data type issue.

Hi,
Which stored procedure is this...source,target or transform.