Search found 4992 matches

by kcbland
Wed Mar 16, 2005 2:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: import and export
Replies: 11
Views: 1958

kollurianu wrote:Can you tell me what is difference in Transform Function and
Function from Routine Category.

What is the main difference between Transforms and Routines?

Please Asap.

Thank you

]


Please don't double post. :( You already have a thread for discussing this.
by kcbland
Wed Mar 16, 2005 2:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: transforms functions and routines
Replies: 4
Views: 927

Transforms are just 1 line DS BASIC logic that can be used inside your job in a derivation or constraint expression. When pre-compiling, the Transform name is expanded to the full logic expression stored. This means that if you change the logic in a Transform, all jobs using it must be recompiled. A...
by kcbland
Wed Mar 16, 2005 2:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job control
Replies: 2
Views: 647

It's a bad idea to use an after-job routine to run another job. You have limited error checking or recover abilities. You're probably attempting to build a "chain" of jobs, where A runs B, which runs C, which runs D. This is exactly why you should build a Batch job and use your job control logic the...
by kcbland
Tue Mar 15, 2005 9:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: debugging client has discontected
Replies: 3
Views: 1079

Probably something to do with active database cursors and such and timeouts. I've never seen the problem if just doing sequential and hash i/o.
by kcbland
Tue Mar 15, 2005 8:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is the error "Fault type is 11"
Replies: 7
Views: 2136

Craig, you should have kept quiet. :lol: I was quite impressed with your ability to transmit thought to the poster and also have the right solution, as odd as the solution is.
by kcbland
Tue Mar 15, 2005 1:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Project Exports from Same DS Project
Replies: 1
Views: 596

Probably not, as the export requires exclusive access to an object when it is being accessed. There is a chance both processes will collide on the same object.
by kcbland
Tue Mar 15, 2005 11:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is the error "Fault type is 11"
Replies: 7
Views: 2136

Is this a new installation? Have you been successful at importing metadata in DS Manager?
by kcbland
Tue Mar 15, 2005 11:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RT_CONFIGxx error
Replies: 17
Views: 3137

I have LOTS of these. In fact, one per job. Don't worry about these. You have a status, config, log, bp, bp.o, and temp file for every job. Leave them alone. Any time you import a job, these are wiped out and created fresh under a new job number. Anytime you compile a job, some of these are automat...
by kcbland
Tue Mar 15, 2005 11:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RT_CONFIGxx error
Replies: 17
Views: 3137

Triton46 wrote:What about DS_TEMPxx?


Every job has one of these. Don't worry about them.
by kcbland
Tue Mar 15, 2005 11:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RT_CONFIGxx error
Replies: 17
Views: 3137

Triton46 wrote:Is there a list anywhere on the board of files/directories to be routinely cleaned up?


In your uvconfig file there is a temp directory configuration. There's also the "&PH&" directory in every project. During an operational downtime, maybe once a week, clear these directories.
by kcbland
Tue Mar 15, 2005 11:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RT_CONFIGxx error
Replies: 17
Views: 3137

Sainath.Srinivasan wrote:If you want to go further, try giving a 777 permission to all files and folders under the DSEngine and Project.



DON'T EVER DO THIS, YOU WILL CRIPPLE YOUR INSTALLATION OF DATASTAGE.
by kcbland
Tue Mar 15, 2005 10:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RT_CONFIGxx error
Replies: 17
Views: 3137

Of all of the bad things that can happen, running a project out of disk space IS THE WORST POSSIBLE THING . Jobs executing can corrupt their logs, configuration, and status files because of insufficient disk space. If ONE SINGLE DEVELOPER has a job open for design and is saving the job, it can corru...
by kcbland
Tue Mar 15, 2005 9:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while trying to retrieve text for error ORA-12154
Replies: 21
Views: 7316

"Bounce" means either reboot a server, shutdown software and restart its services, etc. "Bounce" like a ball, go down then come back up.
by kcbland
Tue Mar 15, 2005 9:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RT_CONFIGxx error
Replies: 17
Views: 3137

Did your project run out of disk space on the filesystem?
by kcbland
Tue Mar 15, 2005 9:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Target Table gets locked after 27000 records get inserted
Replies: 16
Views: 4169

ArndW wrote:Oh, and then your license will run out and the new key is 10,000 characters and numbers and your Cut-and-Paste buffer is disabled...


That truly would be hell