Search found 28 matches

by sysmq
Mon Mar 08, 2010 8:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Internal Error (40018) The Given Clink is not valid for any
Replies: 2
Views: 3137

Internal Error (40018) The Given Clink is not valid for any

Hi
I got this error while trying to re-open a job sequence
I can Copy the Job , but i cannot delete it.
i searched the posts and found a case that mentiond disk space as a possible reason.
there is enough disk space.
what can i do to get it deleted from the project ?
SYSMQ
by sysmq
Mon Mar 08, 2010 7:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal error 40018 :the given CLink is not valid
Replies: 3
Views: 2885

DataStage 8.1 Server Edition
OS: windows 2003

Hi
I also got this error
I can Copy the Job , but i cannot delete it.
There is enough disk space
what can i do to get it deleted from the project ?
SYSMQ
by sysmq
Sun Jan 17, 2010 10:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Java stage preformance issues
Replies: 0
Views: 1351

Java stage preformance issues

Hi I'm looking for some help regarding the Java stage preformance issues. i have several Server Job that uses the Java api stage to perform a call to an external Jar. i want to know how to get a better performance out of it; how can i controll the creation of the jvm if possible. and how to prevent ...
by sysmq
Sun Jan 17, 2010 10:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Import routine from dsx file
Replies: 16
Views: 11481

Hi
i had the same problem.
i talked to our local IBM representative and was told to use the Information Server Manager to perform the imoprt / export
i tried it and it solve the case for me

cheers.
by sysmq
Thu Apr 16, 2009 7:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Ver 7.5.2 with 4 Quad Core CPU
Replies: 9
Views: 4138

hi nothing else is consuming the memory we use performance monitor the whole project loads more then 16 uvsh process each with 400 mb memory after the job finishes the memory is reduced to 812 mb total. the main differance between the server is : on is 2 cpu P4 3.0 GHz and the new is Quadcore 2.8 GH...
by sysmq
Thu Apr 16, 2009 7:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Ver 7.5.2 with 4 Quad Core CPU
Replies: 9
Views: 4138

hi nothing else is consuming the memory we use performance monitor the whole project loads more then 16 uvsh process each with 400 mb memory after the job finishes the memory is reduced to 812 mb total. the main differance between the server is : on is 2 cpu P4 3.0 GHz and the new is Quadcore 2.8 GH...
by sysmq
Thu Apr 16, 2009 1:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Ver 7.5.2 with 4 Quad Core CPU
Replies: 9
Views: 4138

HI I know that my server went out of memory The question is why. let me elaborate: In the old server with the same Os and RAM running the same project against the same DB finishes the job on time (2-3 hours) with no errors the CPU is at 50-70 % and memory is within OS limitation (less then 3.5G) The...
by sysmq
Mon Apr 13, 2009 6:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Ver 7.5.2 with 4 Quad Core CPU
Replies: 9
Views: 4138

Data Stage Ver 7.5.2 with 4 Quad Core CPU

Hi I have a job that create a hash file and then loads it to the memory for manipulation the output is written to DB on the old server (2 cpu) windows 2003 sp1 3.5G Ram, it works great and the cpu is 50-70% work during the job execution we bought a new server with a 4 quad core CPU with windows 2003...
by sysmq
Wed Mar 11, 2009 1:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Basic question from a basic user
Replies: 4
Views: 2418

hi
a question: what version should i download ?
9.5, 9.6, or maybe 10.3 ?
i have Datastage Server edition V7.5.2

10x again....

Sysmq
by sysmq
Wed Mar 11, 2009 1:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Issue with Big HASH File
Replies: 10
Views: 6234

Hi All After talking to IBM i got a recomandation to edit some values in the uvconfig file here are the new values: T30FILE to 500 or 600 GLTABSZ 120 (change to 160) RLTABSZ 120 (change to 160) MAXRLOCK 119 (change to 159) I've tried to figgure out what will be the effect and how can i fine tune it ...
by sysmq
Mon Feb 23, 2009 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Issue with Big HASH File
Replies: 10
Views: 6234

Re: Performance Issue with Big HASH File

... RLTABSZ from 75 to 300 MAXRLOCK from 74 to 299 Where did you get the recommendations to change these values? Unless you have specific problems that are addressed by this change it is unwise to change these, as they can have an impact on performance. our local vendor recomanded this due to probl...
by sysmq
Sun Feb 22, 2009 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Issue with Big HASH File
Replies: 10
Views: 6234

Re: Performance Issue with Big HASH File

...we encounter a performance issue all of tha HASH files are taking over the entier RAM and pageFile (6.6 gb ) and than crashes with the error of :unable to alocate memory... Have you measured memory usage by process, or how have you determined this? Do you have just one DataStage job or many? Wha...
by sysmq
Sun Feb 22, 2009 5:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Issue with Big HASH File
Replies: 10
Views: 6234

Is the database on the same machine. A quad processor might be able to consume more resources IN THE DATABASE, leaving less for the hashed file that the dual processors on the development machine could provide. Hi The source DB and Destination DB of the project is not on the same machine. respectfu...
by sysmq
Sun Feb 22, 2009 2:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Issue with Big HASH File
Replies: 10
Views: 6234

Hi I did monitor the system and the only major consumer was the uvsh.exe of that same project and the reason why i know this for sure is that we've aborted the project the system performance monitor was quiet down immidiatly. on the production server it was the only project running since it is a new...
by sysmq
Thu Feb 19, 2009 3:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Issue with Big HASH File
Replies: 10
Views: 6234

Performance Issue with Big HASH File

Hi I have a problem we have a JOB that loads large amount of hash files into memory in one server (w2k3 sp1 dual core 3.5 gb RAM) it works great this is the DEV computer on the production computer (same os but stronger CPU (4 quad) with 3.5 gb RAM) we encounter a performance issue all of tha HASH fi...