Search found 53125 matches

Go to advanced search

by ray.wurlod
Wed Jul 29, 2009 11:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bug found in sequential file stage of Information Server
Replies: 3
Views: 1316

Are you looking at this with View Data (which substitutes "NULL" for the null value) or a text viewer/editor (which doesn't)?
by ray.wurlod
Wed Jul 29, 2009 11:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which is the better File Format
Replies: 8
Views: 2706

That's why I quoted the entry before you edited it! :wink:
by ray.wurlod
Wed Jul 29, 2009 7:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which is the better File Format
Replies: 8
Views: 2706

The one which work better for the codition. I have no idea what "codition" means. Can you please clarify this term, ideally with a reference to a dictionary website or similar? Meanwhile, from a perfomance perspective (and depending absolutely on how good the programmer is) I would prefer...
by ray.wurlod
Wed Jul 29, 2009 5:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Encryption within DataStage
Replies: 11
Views: 16743

This capability was recently introduced into UniVerse database so, if IBM's left hand knows what its right hand is doing (and there may be some dispute about that), it may make its way into DataStage in the fullness of time. UniVerse uses the terms "encryption at rest" to describe data enc...
by ray.wurlod
Wed Jul 29, 2009 5:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Default dscs and dsapi_slave connection
Replies: 7
Views: 2373

All dscs processes are started as child processes of dsrpcd. The dsrpcd process (DataStage RPC daemon) listens on port #31538 for connection requests from DataStage clients, which all request the dscs service. In the dsprcservices file, the RPC daemon determines that the dscs service is implemented ...
by ray.wurlod
Wed Jul 29, 2009 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS_AUDIT
Replies: 7
Views: 3394

This should get you under way.

Code: Select all

SELECT SUBSTRING(DTM FROM 1 FOR 10) AS MOD_DATE, 
       CAST (CURRENT_DATE AS VARCHAR) CONV 'D-YMD[4,2,2]' AS TODAY 
FROM   UNNEST DS_AUDIT ON MODS 
WHERE  DTM IS NOT NULL AND DTM > '' AND MOD_DATE = TODAY;
by ray.wurlod
Wed Jul 29, 2009 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to binary
Replies: 2
Views: 659

Probably. A parallel routine or Build stage would be favourite. I'm pretty sure there's nothing "out of the box" unless you want to use a BASIC Transformer stage and Oconv().
by ray.wurlod
Wed Jul 29, 2009 5:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate report on data movement from source to target
Replies: 6
Views: 2428

Run in Director, press the Print Screen when it's done and paste into MS Paint or similar. I don't know any other graphical report.
by ray.wurlod
Wed Jul 29, 2009 4:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage MVS version to IIS v8.x
Replies: 3
Views: 1512

The fact that you have mainframe jobs is purely a licensing issue. Use the standard documentation for upgrading. IBM will provide an XML licensing file that indicates that you have MVS edition; the installer will read this and enable the relevant components.
by ray.wurlod
Wed Jul 29, 2009 4:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable Create Copy or Save As Job
Replies: 11
Views: 7173

PhilHibbs wrote:DataStage appears to create 6 directories for each job in a project.
For server jobs they are (where nnn is the job number):
DS_TEMPnnn
RT_BPnnn
RT_BPnnn.O
RT_CONFIGnnn
RT_LOGnnn
RT_STATUSnnn

Parallel jobs also create RT_SCnnn
by ray.wurlod
Wed Jul 29, 2009 4:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Improve performance
Replies: 20
Views: 6160

Have you loaded the dimension tables into hashed files? Have you enabled read cache for these?

(You should have loaded the dimension tables into hashed files as part of the processing of dimension data, so there is probably no extra overhead.)
by ray.wurlod
Wed Jul 29, 2009 4:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of DataStage
Replies: 6
Views: 4674

Try re-entering the reference to the encrypted (password) parameter in the Oracle stage. I've found - admittedly in version 8.0.1 - that this (the reference to an encrypted parameter) is sometimes not migrated properly.
by ray.wurlod
Wed Jul 29, 2009 4:40 pm
Forum: General
Topic: Compare two Datastage jobs
Replies: 13
Views: 18944

Minutes rather than hours. Learn patience, grasshopper.
by ray.wurlod
Wed Jul 29, 2009 4:39 pm
Forum: General
Topic: the operator is not parallel
Replies: 3
Views: 1727

We would also need to know if anything else might be affecting the situation, such as the setting of the APT_EXECUTION_MODE environment variable, whether or not the job had been compiled in trace mode, and so on.
by ray.wurlod
Tue Jul 28, 2009 11:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Default dscs and dsapi_slave connection
Replies: 7
Views: 2373

None.

All other processes are optional.
  • dsdlockd - DataStage deadlock daemon

    Job Monitor (Java)
The answer is different on a Windows-based server, still none for dscs and dsapi_server processes but, as well as the above, you will have
  • DataStage Resource Service

    DataStage telnet Service

Go to advanced search