Search found 53125 matches

by ray.wurlod
Wed Jun 15, 2011 3:04 pm
Forum: General
Topic: Error in a sequencer job in Grid Env.
Replies: 2
Views: 1836

Did you Search? This question has been asked many times. Grid-enabled is not relevant.
by ray.wurlod
Wed Jun 15, 2011 5:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see performance stats for particular project
Replies: 10
Views: 3146

Then it would appear, despite your assertion, that JobMonApp is not in fact "running correctly" or that your job is failing to start.
by ray.wurlod
Wed Jun 15, 2011 5:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQLConnect error: Status = -1 SQLState = IM976 Natcode
Replies: 8
Views: 8855

LOGTO a valid account name. They're case sensitive.

Code: Select all

SELECT SCHEMA_NAME FROM UV_SCHEMA WHERE SCHEMA_NAME <> 'CATALOG';
by ray.wurlod
Wed Jun 15, 2011 5:18 am
Forum: General
Topic: unable to see job parameters
Replies: 9
Views: 2394

Click on Help > About in Designer to get the actual (full) version number.
by ray.wurlod
Wed Jun 15, 2011 5:17 am
Forum: General
Topic: Developer users to change their passwords
Replies: 2
Views: 1525

Any user can log in to the Web Console for Information Server and change the password in their DataStage credentials. It is not necessary to log in as an administrator for that. Are you using the internal user registry in Information Server? Have you tried a non-administrator user logging in to the ...
by ray.wurlod
Wed Jun 15, 2011 1:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see performance stats for particular project
Replies: 10
Views: 3146

Welcome aboard.

Is "Display performance statistics" enabled in Designer in this project?

Can you use Monitor in Director in this project to view the statistics?
by ray.wurlod
Wed Jun 15, 2011 1:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQLConnect error: Status = -1 SQLState = IM976 Natcode
Replies: 8
Views: 8855

Try doing it from a project rather than from DSEngine.
by ray.wurlod
Wed Jun 15, 2011 1:27 am
Forum: General
Topic: unable to see job parameters
Replies: 9
Views: 2394

What version are you running? There is no such thing as version 7.2.
by ray.wurlod
Wed Jun 15, 2011 1:26 am
Forum: General
Topic: unable to see job parameters
Replies: 9
Views: 2394

Where is this "insert parameter" control? Do you get any drop-down at all (even one just containing "New...")?
by ray.wurlod
Tue Jun 14, 2011 8:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error with lookup stage
Replies: 2
Views: 2990

Look at the value of APT_CONFIG_FILE used when the job ran.

Then look at this configuration file.
by ray.wurlod
Tue Jun 14, 2011 3:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IIS-CONN-ORA-001003, ORA-24381
Replies: 13
Views: 16437

Almost the anniversary of the original question!

Are your system settings identical to those? If not, please begin a new thread.
by ray.wurlod
Tue Jun 14, 2011 3:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Round Robin Partition Can be used in Join Stage ?
Replies: 2
Views: 1814

What answer do you require? You can use the Round Robin partitioning algorithm anywhere there is an input to a stage operating in parallel mode. But you are unlikely to get correct results out of the Join stage, as you're unlikely to achieve key adjacency using Round Robin as the partitioning algori...
by ray.wurlod
Tue Jun 14, 2011 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Query on Hash Partitioning
Replies: 7
Views: 2201

Potentially a different hashvalue will be created for every key. That is divided by the number of nodes and the remainder is the node number on which that key will be located.
by ray.wurlod
Tue Jun 14, 2011 3:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Export/Import of jobs with Finished status not working
Replies: 1
Views: 768

Does it happen if you import into a non-protected project? What does that tell you?
by ray.wurlod
Tue Jun 14, 2011 3:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key Generator State File Issue
Replies: 5
Views: 5512

The state file can not generate random values. What are you actually seeing? Is the remainder of the job running in sequential mode?