Search found 71 matches

by evans036
Wed Apr 25, 2007 12:11 pm
Forum: General
Topic: dsjob -jobstatus does not wait on restart
Replies: 15
Views: 14770

dsjob -jobstatus does not wait on restart

when using dsjob to start a sequence like this: /dwhome/Ascential/DataStage/DSEngine/bin/dsjob -run -local -jobstatus DSRPROD Seq_StaffEd i am finding that dsjob will not wait and always issue RC=0 when the sequence is being restarted. Here is sample output: /dwhome/Ascential/DataStage/DSEngine/bin/...
by evans036
Sun Jan 21, 2007 7:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cannot find transformer binaries on 'other' node
Replies: 5
Views: 1322

The Install and Upgrade Guide talks about rsh in the Configuring the Enterprise Edition chapter. And the Advanced User Guide for PX shows these environment variables, perhaps one of them is the one Ray meant: APT_PM_SHOWRSH APT_PM_USE_RSH_LOCALLY Craig, i did find a paragraph that basically says we...
by evans036
Sat Jan 20, 2007 8:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cannot find transformer binaries on 'other' node
Replies: 5
Views: 1322

ray,

i could not find mention of this in any manuals. which manual discusses this? i specifically would like to find out which variable governs this behavior.

thanks,

steve
by evans036
Sat Jan 20, 2007 6:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cannot find transformer binaries on 'other' node
Replies: 5
Views: 1322

cannot find transformer binaries on 'other' node

i find that when i compile a job that contains a transformer, the resulting binary code is not copied to the other nodes defined in my config file. This resultes in an error like this at runtime: node_dwetl01: Warning: the following libraries failed to load: "V0S1_newds_Transformer_1": Cou...
by evans036
Fri Jan 05, 2007 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RE:Error
Replies: 2
Views: 1527

ray.wurlod wrote:Enable receiving of cookies.
ray,

where is this option enabled?

thanks,
steve
by evans036
Fri Oct 27, 2006 10:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: conductor node role questions
Replies: 3
Views: 2205

ray, thnaks for the response. could you expand on 5) ? on 6), ibm will not permit us to take that class until we have been using the product for 6 months. the problem is i that we need to nail our best practices & architecture now and this class is not available to us now. we have already attend...
by evans036
Fri Oct 27, 2006 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: conductor node role questions
Replies: 3
Views: 2205

conductor node role questions

i have some q's regarding the role of the conductor node. i cant find this info in the manuals so i thought id look to this forum for help. presuming a 2 node mpp, node1 & node2, with node1 being the conductor... 1) do sequential files only get created on the conductor? 2) does the '.ds' file (i...
by evans036
Wed Oct 18, 2006 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encrypted pw from parm file to EE oracle stage
Replies: 15
Views: 6163

kumar_s yes i am sure the password is correct (i got it from director in the first place). i actually have not gone to IBM support on this issue. i have been spending way too much time with their support folks these days that my productivity is being seriously affected. i worry also about installing...
by evans036
Tue Oct 17, 2006 8:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encrypted pw from parm file to EE oracle stage
Replies: 15
Views: 6163

Try to print the rc and check for the value. Try to set $DS_ENABLE_RESERVED_CHAR_CONVERT to true. There is a ecase opened for the same reson. Kumar_s: i did display & check the rc values which was 0. i tried setting that environment variable (for the job - not the sequence running the ds routin...
by evans036
Tue Oct 17, 2006 6:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encrypted pw from parm file to EE oracle stage
Replies: 15
Views: 6163

i just ran a test in case there was some kind of bug with our infrastructure. this code produced the same erroneous results... pw='LE9@1;VA=93=0FGI<;N<AOAE' rc = DSSetParam (jh, 'pw', pw) logtxt='setparm errcode=':rc gosub logit ErrCode = DSRunJob(jh, DSJ.RUNNORMAL) Kumar_s, you can see the contents...
by evans036
Tue Oct 17, 2006 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encrypted pw from parm file to EE oracle stage
Replies: 15
Views: 6163

Hope you are using the password that has been encrypted by Datastage. Check the job properties is also enabled with Encryption. Will the job work if the same password is passed from the job when triggered indivudually? Kumar_s, yes, i am using the pw as encrypted by DS. and the job properties have ...
by evans036
Tue Oct 17, 2006 5:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encrypted pw from parm file to EE oracle stage
Replies: 15
Views: 6163

For password params with the type as Encrypted, have diff format in param file. They should be specified as follows: (encrypted)JP_DBASE_PASS=<encrypted password> The value to be mentioned here should be taken from a routine in DS with name - rEncryptString or EncryptString. I do not recollect the ...
by evans036
Tue Oct 17, 2006 5:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encrypted pw from parm file to EE oracle stage
Replies: 15
Views: 6163

Re: encrypted pw from parm file to EE oracle stage

Ultramundane wrote:If the password begins with a number reset the password so that it does not begin with a number.
Ultramundane,

the password already starts with an alpha - but thanks anyway

steve
by evans036
Mon Oct 16, 2006 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: encrypted pw from parm file to EE oracle stage
Replies: 15
Views: 6163

encrypted pw from parm file to EE oracle stage

we have an encrypted password in a file that we read and set with DSSetParam. This parameter has a type of 'Encrypted' in the job. on job execution, we get this error: Oracle_Enterprise_5: Incorrect dboption list; it failed on Expected "," or "}", got: "@", line 1. i be...
by evans036
Sat Oct 14, 2006 6:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: STAGECOM Data structures & Hawk
Replies: 15
Views: 3965

these utilities sound full of promise.

it will take me time to study & absorb the architecture and to decide which parts we can use.

i will definitely get them installed and make an evaluation

once again, thanks all for your input,

steve