Search found 5168 matches

by kumar_s
Tue Jun 13, 2006 12:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error
Replies: 4
Views: 1313

Hi Sumit,
Can you explain the structure of the job you have designed with the individual stages listed.
And also let us know what was the circumstance you are getting this error? Was your job running ok atleast for a single time.
by kumar_s
Mon Jun 12, 2006 11:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Efficient way of design
Replies: 4
Views: 918

Or use folder stage if all the 5 files were in same folder/directory.
by kumar_s
Mon Jun 12, 2006 11:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: memory consupmtion and band width
Replies: 3
Views: 675

May I know what is run monitor ? stage and links, status,no of rows,start at,elasped time,row/sec can be found withing datastage functions like DSLinkInfo or tweaking with logs. Memory consupmtion and band width and CPU usage% should be externalized by its respective OS commands. And log it in to a ...
by kumar_s
Mon Jun 12, 2006 11:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comparing timestamps in a PX job
Replies: 6
Views: 2091

And here is one

Code: Select all

SecondsSinceFromTimestamp
Returns the number of seconds between two timestamps in seconds.
by kumar_s
Mon Jun 12, 2006 10:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: date
Replies: 17
Views: 4570

In the job sequnce, Call the job in though the jobactivity stage, and pass the value OCONV(@DATE,'D-DMY[2,24]') in the derivation to the job through TS (parameter specified in the job). So that it gets the current time when it get triggered.
by kumar_s
Mon Jun 12, 2006 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Update eror
Replies: 14
Views: 3783

Is the "Including Project Setting" under Execution tab of Job property is what Ray reffering about?
by kumar_s
Mon Jun 12, 2006 9:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: password encrypted
Replies: 15
Views: 7613

The way you define in you job property. If you assign the PW as string, you may need to pass on the just the plain test, if you marked it as encrypted, datastage expects a string which it would try to decrypt during the run time.
by kumar_s
Mon Jun 12, 2006 9:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_loadlibrary: error in dlopen - Dynamic Error
Replies: 10
Views: 4243

Craig - I guess first decent solution obtained for "ds_loadlibrary: error in dlopen" issue in our site.

May I know whether the following refereing to 64 bit by default?
LD_LIBRARY_PATH=$ORACLE_HOME/lib
by kumar_s
Mon Jun 12, 2006 8:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aborting a job on a single warning
Replies: 9
Views: 2158

Or call each job through a Command Activity stage in the job sequence, with

Code: Select all

dsjob -warn 1 -run...
option
by kumar_s
Mon Jun 12, 2006 8:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export of jobs
Replies: 5
Views: 1492

Even when "Whole Project" option is selected, I could see the lock is held on Job wise and not project wise. As ray mentioned, unless due to some big objects present in the project which may likely to create coinsedence of the lock of both export at a time, it should be ok if both where triggered to...
by kumar_s
Sat Jun 10, 2006 11:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Installation on Win 7.5x2
Replies: 9
Views: 3389

I gues error is due to the reason that, it can't find my C++ compiler
Or has the Visual studio.net has been installed properly?
Is the version correct? For 7.5x2 Windows EE it should be NET 2003 C++.
by kumar_s
Sat Jun 10, 2006 11:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning on sequential file
Replies: 17
Views: 8587

Iam wondering how you manage to give null field value='' to COMM field which is decimal(7,2).
by kumar_s
Sat Jun 10, 2006 1:32 am
Forum: Site/Forum
Topic: Congratz Craig!!!!
Replies: 5
Views: 2440

Congratz Craig!!!!

Another milestone!!!
Crossed 6K silently... 8) Competeting with Ray to give value added posts.
Keep going Craig.. :D
by kumar_s
Sat Jun 10, 2006 1:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Stage Input/Output
Replies: 9
Views: 2239

Hi Ray, below is file which I am using as a input. This file contain 2 main blocks and one sub block. First Block is 1) <JobMetaData> 2) <HPCCMetaData> this block have one sub-block named </HPCCPrinterDetails> <JobMetaData> <METLJobId>HPFFXULDXML</METLJobId> <TargetSystem>LIVE</TargetSystem> </JobM...