Search found 53125 matches

by ray.wurlod
Tue Sep 22, 2009 2:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Changing isadmin,wasadmin,dsadmin Passwords in IIS 8.1
Replies: 3
Views: 2360

Login separately as each user to Web Console. Change Password is in the top right of the page, along with Log Out and a couple of other options.

Or you can choose to Administer Users/Groups and change the password for each user there. You need to be a Suite Admin for this option to work.
by ray.wurlod
Tue Sep 22, 2009 2:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File upload
Replies: 3
Views: 1220

Another method is to use a Sequential File stage to read each line as a single VarChar field then a Column Import stage or a Transformer stage to parse the different record types.
by ray.wurlod
Tue Sep 22, 2009 2:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: where is a DS job stored in the unix server
Replies: 9
Views: 3408

The DEFC2E76D84 part is a unique identifier (of the server licence) so yours will almost certainly be different.
by ray.wurlod
Mon Sep 21, 2009 6:03 pm
Forum: General
Topic: Sorted output Sequential File
Replies: 1
Views: 1250

The Sort/Merge collector only works if the data are already sorted on those keyse upstream of the Sequential stage. If this is not the case, you need to add sorting to the input stream of the Sequential stage.
by ray.wurlod
Mon Sep 21, 2009 6:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TD MLOAD truncating 11th character of CHAR(11) input -- why?
Replies: 5
Views: 2138

1. Verify that it really is Char(11), not Char(10). (I have to ask.)
2. Verify that there are no non-printing characters in the data.
by ray.wurlod
Mon Sep 21, 2009 5:47 pm
Forum: IBM QualityStage
Topic: Dealing with a Complex Mix
Replies: 6
Views: 3266

Can't you use a pattern like ^ | I = "X" | ^ | I = "X" | ^ ? Based on this pattern, the "middle part" would be token [3].
by ray.wurlod
Sun Sep 20, 2009 4:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project Deletion Unsuccessful
Replies: 14
Views: 3446

Particularly on weekends you need patience. Some of us actually have a life. Deleting a directory is not the same as deleting a project. There are entries in the repository and entries in the DataStage "system tables" UV_SCHEMA and UV.ACCOUNT that describe the existence and location of eac...
by ray.wurlod
Fri Sep 18, 2009 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CONFIG_FILE
Replies: 2
Views: 1284

One node will still fill, but no longer catastrophically until all four have filled.
by ray.wurlod
Fri Sep 18, 2009 3:21 pm
Forum: General
Topic: monitor
Replies: 1
Views: 1114

The job monitor application is a Java application and needs to be started from an operating system command line (or startup script). It does not run as a service on Windows operating systems.
by ray.wurlod
Fri Sep 18, 2009 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem while using LookUp stage and Join Stage
Replies: 5
Views: 1568

Your "Lookup Failed" rule in the Lookup stage is probably set to its default value, which is "Fail" (= abort the job). Change the rule according to your requirements - there are three other possibilities.
by ray.wurlod
Fri Sep 18, 2009 6:58 am
Forum: General
Topic: Datastage MVS Edition
Replies: 2
Views: 1171

Are you paying maintenance on the software? If so, the upgrade(s) will be at no cost. Version 8.any will incur hardware costs - it needs rather more than versions 7 and earlier. You will need to go through an intermediate upgrade - your support provider will advise. My guess is that version 7.5 prob...
by ray.wurlod
Thu Sep 17, 2009 3:29 pm
Forum: General
Topic: Sequential file stage - mass change to incomplete column?
Replies: 3
Views: 2007

I'm with Craig - I don't know a mass-change technique. I usually work from the bottom up (therefore up-arrow).
by ray.wurlod
Wed Sep 16, 2009 9:35 pm
Forum: General
Topic: Reusability - HELP WANTED
Replies: 3
Views: 1081

Typically you turn anything that may differ between instances into parameters. Why not a Parameter Set with a different "values file" for each instance?
by ray.wurlod
Wed Sep 16, 2009 5:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Curious about IIS Server, WAS Server and others...
Replies: 7
Views: 4269

ASB = (WebSphere) Application Server Backbone - it is the bus over which services are delivered. ASB agent is only required if the DataStage Server and WebSphere Application Server (WAS) are on separate machines. IIS (IBM Information Server) provides support for the XMETA unified metadata database -...
by ray.wurlod
Wed Sep 16, 2009 5:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warnings with Join stage.
Replies: 1
Views: 3748

Search for "Propagate" - it's been answered in various guises often.