Search found 5168 matches

by kumar_s
Thu Jan 18, 2007 5:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Start TIme and Job End Time
Replies: 3
Views: 1234

Find the list of jobs in Jobsequence, and use

Code: Select all

dsjob -report <project> <jobname> BASIC
. Or simple use the Popular EtlStatus from KimDuke homepage.
by kumar_s
Thu Jan 18, 2007 4:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting List of job names from script.
Replies: 5
Views: 1019

Hi Tom,
It has been discussed lot many times. There are several ways of doing it.

Code: Select all

dsjob -ljobs  <project> - from command prompt.
SELECT NAME FROM DS_JOBS WHERE NAME NOT LIKE '\\%' - from TCL prompt.
by kumar_s
Thu Jan 18, 2007 4:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FILE SET CREATION PROBLEM
Replies: 3
Views: 913

Check if the file has reached 2GB limit. It its not, check with different Config file which has less number of nodes.
Was there any transformation that forces records to not match with the given metadata in fileset?
Check it by replacing a sequential file stage.
by kumar_s
Thu Jan 18, 2007 4:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Maximum number of Concurrent Job
Replies: 2
Views: 1411

There is not. But the limitation is from the server, where the maximum number of process that can run per user simulteneously. If you make a search, you can get more info.
by kumar_s
Thu Jan 18, 2007 4:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DW Certifications
Replies: 14
Views: 3742

IBM's DS Certification is PX certification. Exam 415, the link that been posted.
by kumar_s
Thu Jan 18, 2007 4:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: User control for commit or rollback
Replies: 3
Views: 997

Dont you find any Transactional handling parameter in SP stage?
by kumar_s
Thu Jan 18, 2007 4:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to unpack a packed decimal in Parallel job
Replies: 2
Views: 999

Hi Prudhvi,
Welcome to Dsxchange :D !!!!
Datastage will do it for you, if you have the metadata specified correctly. If its Mainframe Ebcidic file, Specify the COBOL copy in the CFF stage to extract that.
by kumar_s
Thu Jan 18, 2007 4:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restart ABortd Sequence
Replies: 6
Views: 1650

Ray has asked for a information and infact waiting for your reply.
Asked you to check the log and generated Jobcontrol for Check point information for each iteration.
by kumar_s
Thu Jan 18, 2007 4:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file vs dataset in performance
Replies: 2
Views: 901

There are two sequential read that you are planning to optimize. If you approach the dataset conversion and reading the generated dataset, you again have to do one sequential read (To convert that into Dataset). The other read should be compromised with the two dataset read. Again Dataset access won...
by kumar_s
Thu Jan 18, 2007 4:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DW Certifications
Replies: 14
Views: 3742

Hi Hema, Exam 705 is for DW and 415 is for DS available in IBM. If you do a search in this site, you can get lot of pointers on DS certification. Apart IBM, there are some other DW certification available as mentioned by Ray. Even Infiormatica, Teradata, Cognos, Microsoft and SAS also offers BI cert...
by kumar_s
Wed Jan 17, 2007 7:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command stage
Replies: 33
Views: 5922

kduke wrote:It is a Custom Stage. Correct?
If this is the case, it should be PX job. Isn't?
by kumar_s
Wed Jan 17, 2007 7:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Find Jobs which Use a Particular Env Variable.
Replies: 6
Views: 1123

That shows how popular Kim and Kim's code are. 8)
by kumar_s
Wed Jan 17, 2007 6:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: decimal_from_string dosent work ?
Replies: 8
Views: 1756

What doesn't work? Got any error or got any unexpected result?
You can use Basic Transformer as well. You can use the functions available.
BTW: What forced your to use Basic transformer?
by kumar_s
Wed Jan 17, 2007 6:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Protected project : Is this a bug??
Replies: 21
Views: 8035

Whale - I was waiting for you to give the welcome address.