Search found 94 matches

by DSDexter
Thu Apr 17, 2008 7:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file
Replies: 7
Views: 1703

Welcome aboard . There is a difference in ' ' and NULL. So in transformer you need to check for ' ' and not NULL. Also If your target is Nullable No then do you need to retain those records or reject them? Please give some sample records,With the metadata definations.
by DSDexter
Thu Apr 17, 2008 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help To delete a job
Replies: 11
Views: 2783

Craig This is what I am getting >LIST.READU EVERY Active Group Locks: Record Group Group Group Device.... Inode.... Netnode Userno Lmode G-Address. Locks ...RD ...SH ...EX 63208824 533 0 45 7 IN 2800 1 0 0 0 63208720 668 0 35601 12 IN 1000 1 0 0 0 63208807 1006 0 57503 28 WR 4000 0 0 0 0 63208824 39...
by DSDexter
Thu Apr 17, 2008 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help To delete a job
Replies: 11
Views: 2783

It shows the job in active locks category.
by DSDexter
Thu Apr 17, 2008 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help To delete a job
Replies: 11
Views: 2783

You don't need admin rights to unlock if you can log on as the user that holds the lock... can you? ... Craig, I am using the same user-id against which the lock is is, But still when I try to unlock the job, It throws a message Insufficient privileges to perform lock maintenance . So does the theo...
by DSDexter
Thu Apr 17, 2008 5:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help To delete a job
Replies: 11
Views: 2783

At the Shell ------------ - Execute the following commands: cd $DSHOME . dsenv bin/uvsh - If the job is locked, execute the following: UNLOCK RECORD jobname ALL Then go in the repository and delete the job I dont have Admin rights as mentioned earlier in my post.So the above procedure will not work...
by DSDexter
Thu Apr 17, 2008 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help To delete a job
Replies: 11
Views: 2783

Need Help To delete a job

Hi All, I am struggling to delete a job. Error Message I get is It's being accessed by another user. When I veiw the process in DS Administator I am able to veiw the job that is locked at record level. I took the PID,UserNo and Inode No. from DS Administrator. When I view the process in Unix. I dont...
by DSDexter
Thu Apr 17, 2008 5:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is there count without using aggregator
Replies: 18
Views: 7260

When is the Interveiw?
by DSDexter
Fri Apr 11, 2008 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp issue inserting into Oracle table
Replies: 18
Views: 9084

Please post some sample records, So that everyone will understand where the problem lies. Also describe the job description, what the job is doing and In which stage are you getting the Null field length warning?
by DSDexter
Sun Apr 06, 2008 10:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer_1: Input dataset 0 has a partitioning method oth
Replies: 9
Views: 5071

I am using SUN OS, still I am getting this warning. Is there a patch available for SUN OS also? Currently I have Message handler taking care of it.
by DSDexter
Fri Apr 04, 2008 9:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help to debug the DUMP_SCORE
Replies: 5
Views: 1511

The scores you've posted are for license checking, not for job execution. With more operators, there is more license checking to do. ... Thanks ray, I was looking at the unappropriate log line. Well the jobs dump seems fine now :) , Ray can I operate the XML input stage in parallel mode? Sequential...
by DSDexter
Fri Apr 04, 2008 2:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help to debug the DUMP_SCORE
Replies: 5
Views: 1511

The scores you've posted are for license checking, not for job execution. With more operators, there is more license checking to do. ... Thanks ray, I was looking at the unappropriate log line. Well the jobs dump seems fine now :) , Ray can I operate the XML input stage in parallel mode? Sequential...
by DSDexter
Thu Apr 03, 2008 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer_1: Input dataset 0 has a partitioning method oth
Replies: 9
Views: 5071

Just search on Disable memory Sharing. You need to specify AUTO partioning in the transformer stage.
by DSDexter
Thu Apr 03, 2008 9:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help to debug the DUMP_SCORE
Replies: 5
Views: 1511

Need Help to debug the DUMP_SCORE

Hi Gurus, I have a job design like this (2 - Node System) Extersource------>XML I/P------>Transformer------->OracleTbl | | | | Transformer Transformer | | SequentialFile SequentialFile The reject transformers are used to abort the job if I identify any reject. The job is taking to much time to execu...
by DSDexter
Thu Apr 03, 2008 3:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help reagrding External source stage
Replies: 7
Views: 1516

Hi All,

I have resolved the issue, I was specfying the XMLdocument, rather than a URl path.

Thanks all for the inputs :lol:
by DSDexter
Thu Apr 03, 2008 2:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Help reagrding External source stage
Replies: 7
Views: 1516

I have created a Server job for the same, I have used source as a folder stage, I was able to extract the data from the xml file. Now I am using the same xpaths in the parallel jobs, But still the problem persists. In folder stage I have two columns viz. Filename (Varchar 25) and record (LongVarchar...