DSXchange

All, I have read from here some environment variable will give/display the stage name in the director (if the stage name is not showing in the director log ). I have searched here again to recollect the name. But i am unable to find it. Actually if some issue was raised in the job, sometime we can't...

what i have learned from here is "state file " is a file which will maintain the sequence number kind of values. (again not sure) where as the extension of this file is .sk is it correct? if yes, where can i see that .sk file? note I have modified the partition mode to "Sequential&quo...

All, I have designed a simpe job to get familiar with surrogate key generator stage. seq file --> surrogate_key_generator --> seq_file columns: name --> --> seq, name surrogate key properties: source_type = flat file source name = path of my input file with the file name. Generated Output column nam...

All, How to create a new environment variable from unix/linux. I don't have the access to Datastage Administrator. so i would like to create a new env variable without using that tool. I just tried to add a new env variable as below click --> "Add Environment Variables" under "Job Pro...

do you mean

sdk -->KeyMgt --> KeyMgtGetNextValue & KeyMgtGetNextValueConcurrent

ray.wurlod wrote:A good example of an account-based hashed file is the SDKSequences hashed file, which is created and updated by the key management routines in the SDK.

SDKSequences hashed file ?

is it a stage ? or propety? or routine?

Because BASIC-Transformers cannot operate in parallel. Therefore jobs using BASIC-Transformers are usually not scalable and very often a singnificant impact on performance will be visible. My bad..we are using server routine in parallel job(s). As you said the performance impact is very less. To do...

BI-RMA wrote:You might of course create a server-routine and use it in a BASIC-Transformer in Parallel-jobs, but this is not advisable.

can you tell me why?

All,

is it possible to execute a simple select * from DS_JOBS query from linux?

i just connected the linux box through putty.

got it... $ . ./dsenv earlier i used ./ instead of . ./ what is the difference between ./ and . ./ ? $ cd bin $ ./dsjob Command Syntax: dsjob [-file <file> <domain> <DataStage server> | -domain <domain> -user <user> -password <password> -server <DataStage server>] <primary command> [<arguments>] Val...

i have already sourced it. but no use. $ pwd /opt/IBM/InformationServer/Server/DSEngine $ ls -ltr dsenv* -rwxr-xr-x 1 xxxx xxxx 8710 Sep 10 2008 dsenv.single.u -rwxr-xr-x 1 xxxx xxxx 8260 Sep 10 2008 dsenv.multi.u -rwxr--r-- 1 xxxx xxxx 2307 Feb 23 2009 dsenv.orig -rw-rw-r-- 1 root root 133 Apr 9 20...

What is the "this folder" that you are looking for? i would like to see where these folder exists? What are you trying to accomplish? The link you have is for ODBC setup. can you open the below link? http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r0/index.jsp?topic=/com.ibm.swg.im.ii...

qt_ky wrote:Are you going to be creating a lot of hashed files with server jobs and/or migrating to parallel jobs?

Yes. i am going to create around 100 hash files with server jobs.

I have tried the below one.

$ echo $LD_LIBRARY_PATH
:/opt/IBM/InfoSphere/Ascential/DataStage/DSEngine/lib/
$

But i am still getting the same error message.

$ ./dsjob ./dsjob: error while loading shared libraries: libvmdsapi.so: cannot open shared object file: No such file or directory $ ls acct.restore dcfreest dsjob format.conv lduv mkload pi.prepisys rszmv tiindex UVfile vcatalog analyze.shm ddm dslictool fpath listpid.sh mkschema pi.t1conv runpriv ...