Search found 726 matches

by zulfi123786
Tue Dec 04, 2012 11:18 am
Forum: General
Topic: Exception handler clarification
Replies: 2
Views: 1229

Thanks Craig :) both, for clarification and for moving it to new thread
by zulfi123786
Sat Dec 01, 2012 10:15 am
Forum: General
Topic: Exception handler clarification
Replies: 2
Views: 1229

Exception handler clarification

Below is and excerpt from Designer Guide: "An exception activity handles the situation where a job in the sequence fails to run (other exceptions in the job sequence are handled by triggers)." I have a question regarding "Fails to run" , does it mean the exception handler is trig...
by zulfi123786
Tue Nov 27, 2012 7:43 am
Forum: General
Topic: datastage logon clause in dsjob command
Replies: 4
Views: 2657

Got it resolved after a lot of trials and errors. domain name and domain port are the same as what we provide in the "Host name of Services tier" and the -Server is the Engine where the project lies (Engine tier) I have tried 9080 as the server port and also tired the domain port here but ...
by zulfi123786
Tue Nov 27, 2012 7:30 am
Forum: General
Topic: datastage logon clause in dsjob command
Replies: 4
Views: 2657

after repeatedly going through number of posts alike I have understood that domain name and domain port number are the same which is provided as "Host name of Services Tier" confused as to what the server name should be? is it the Engine where the project is hosted ?


Thanks
by zulfi123786
Tue Nov 27, 2012 6:55 am
Forum: General
Topic: datastage logon clause in dsjob command
Replies: 4
Views: 2657

I am facing the below error if I skip the domain name and domain port

Code: Select all

ERROR: Failed to open project

Status code = -1010 DSJE_DOMAINLOGTOFAILED
by zulfi123786
Tue Nov 27, 2012 2:59 am
Forum: General
Topic: datastage logon clause in dsjob command
Replies: 4
Views: 2657

datastage logon clause in dsjob command

I have used the dsjob -server <servername> -user <username> -password <password> to log into datastage server and run jobs there in Version 7.5 and is pretty simple but now we are into 8.5 and we have a two tier architecture with Engine and Repository on server usvh2elap1 and services layer running ...
by zulfi123786
Thu Nov 22, 2012 11:21 pm
Forum: General
Topic: scope of USERSTATUS
Replies: 8
Views: 2133

Has anyone seen an API for accessing Universe table via C++ code of a parallel routine. Have searched some posts but did not find any luck at the time of those posts.
by zulfi123786
Thu Nov 22, 2012 11:19 pm
Forum: General
Topic: scope of USERSTATUS
Replies: 8
Views: 2133

Thanks for the information Ray. Since in my situation I have multiple jobs calculating the same variable and the most recent calculated value has to be used across various jobs some of them dont happen to be the successors of the jobs calculating them and I never know which job has executed just bef...
by zulfi123786
Thu Nov 22, 2012 7:03 am
Forum: General
Topic: scope of USERSTATUS
Replies: 8
Views: 2133

No hierarchy of user statuses is supported. If I have a parent job sequence having two sequences each internally have job activity stages like a B-Tree of order 2 then is there any other way of passing a value from a job activity on the leaf node of one sequence to a job on the leaf node of another...
by zulfi123786
Thu Nov 22, 2012 3:37 am
Forum: General
Topic: scope of USERSTATUS
Replies: 8
Views: 2133

Since the topic has come out, I would like to get my understanding confirmed regarding USERSTATUS - RT_STATUSnnn Each job/Sequence (not sure about server routines) have an RT_STATUSnnn hashed file to capture the USERSTATUS. when any job writes to USERSTATUS held by its RT_STATUSnnn the job also gets...
by zulfi123786
Wed Nov 21, 2012 11:26 pm
Forum: General
Topic: scope of USERSTATUS
Replies: 8
Views: 2133

scope of USERSTATUS

I have a situation where there are multiple jobs placed in sequences and these sequeces are further held in parent sequences. I need to have a meathod of holding a paricular value (conversion factor) and this value is calculated in multiple jobs and the most recent value calculated need to be availa...
by zulfi123786
Wed Nov 21, 2012 2:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: info on ds log
Replies: 3
Views: 2077

Datastage expects a numeric value but it is finding a nonnumeric value. There could be multiple reasons like improper datatype converstions or function usage where the argument is expected to be a number etc. Disable Operator combination by setting APT_DISABLE_COMBINATION=True and run the job, this ...
by zulfi123786
Wed Nov 21, 2012 1:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performing total sort
Replies: 3
Views: 1225

what particularly interest me is how the key boundaries are defined per each node, which node gets the keys with least values when the range map is created and so on as this would decide the link ordering during ordered collection when the actual input is not sorted to achieve a total sort. Also won...
by zulfi123786
Wed Nov 21, 2012 12:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performing total sort
Replies: 3
Views: 1225

Performing total sort

I was trying to implement a total sort using Range partitioning and hence as a prerequisite created a range map file using write range map stage. Out of curiosity wanted to see what this file contained but it turned out to be a binary file, any documentation which states what layout/format this file...
by zulfi123786
Tue Nov 20, 2012 7:16 am
Forum: General
Topic: Unix shell script to call datastage job error
Replies: 5
Views: 5121

The most important part

how is

Code: Select all

 $stat
set