Search found 4992 matches

by kcbland
Tue Oct 17, 2006 3:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable To Open Job Activity in DataStage Sequence
Replies: 10
Views: 3461

ray.wurlod wrote:What I actually said was "uninstall SP2 [b]OR[/b/ get the patch". Small semantic difference!

:oops: That's what I get for playing secretary.
by kcbland
Tue Oct 17, 2006 2:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable To Open Job Activity in DataStage Sequence
Replies: 10
Views: 3461

This is a known issue I believe. Ray Wurlod (reading the projection screen), stated "uninstall SP2" and apply the patches. We're at the IOD conference now in case you're wondering. :lol:
by kcbland
Tue Oct 17, 2006 1:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: backup of jobs
Replies: 11
Views: 2442

How does your company backup Unix level files now? How about just using cp?
by kcbland
Tue Oct 17, 2006 1:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: backup of jobs
Replies: 11
Views: 2442

Sorry about that, I didn't consider my answer "Premium" but forgot to set it as such.
by kcbland
Tue Oct 17, 2006 1:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: uvregen - Decimal places greater than 15
Replies: 6
Views: 2771

Are you using View Data on the Sequential stage to see the result? Verify your Scale is set appropriately as well. Maybe View Data is wrong but it's correctly being read. Write the output to another Sequential file into two different columns: one as text, the other as DECIMAL with the correct scale....
by kcbland
Tue Oct 17, 2006 1:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: backup of jobs
Replies: 11
Views: 2442

kcbland wrote:If you have data files in the project directory, such as hashed and sequential files, you need to make sure you back them up using the operating system mechanisms, either copies or an actual backup.
by kcbland
Tue Oct 17, 2006 1:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: releasing hung-up files in datastage
Replies: 1
Views: 566

If you have locks on log files, the easiest method to use is the "UNLOCK USER xxxxx ALL" method. You need to look for an RT_LOGnnn entry in the lock table using LIST.READU. Search the forum for more help on that. As for locks on sequential files, you might be able to see the filename in the lock tab...
by kcbland
Tue Oct 17, 2006 1:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: backup of jobs
Replies: 11
Views: 2442

The export in DS Manager only saves design information. If you have data files in the project directory, such as hashed and sequential files, you need to make sure you back them up using the operating system mechanisms, either copies or an actual backup.
by kcbland
Tue Oct 17, 2006 12:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job abort
Replies: 5
Views: 996

Your problem is the T30FILES setting. Search the forum, it's covered at length.
by kcbland
Tue Oct 17, 2006 11:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to create new jobs or copy existing jobs
Replies: 6
Views: 1624

To clear logs of all jobs, re-read my last post.
by kcbland
Tue Oct 17, 2006 9:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Testing For A Valid Date
Replies: 8
Views: 1946

I'm at the IOD conference so I can't check this, but if it's a TRANSFORM that's just a piece of code included at compile time of a job. If you're trying to call one of these from a Function you can't. You just use TRANSFORMs in a job. If you want to see what they do, copy the source code into a func...
by kcbland
Tue Oct 17, 2006 9:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File Delimiter - Project level setting
Replies: 4
Views: 1022

As much as I agree with your standard (it's a great one) and also agree with your desire to "customize" defaults for use when designing jobs, the powers that be have never seen fit to add that flexibility. I know of no method, as I would have been using it years ago. :cry:
by kcbland
Tue Oct 17, 2006 9:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to create new jobs or copy existing jobs
Replies: 6
Views: 1624

Use the mass compile wizard under DS Manager (release 7.1+), or if that's too slow for you get your hands on my Batch utility job in my Members Area on my website. That utility job is about 8X faster and can be ran using multiple instances, allowing you to run it on different folders simulteously, s...
by kcbland
Tue Oct 17, 2006 9:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to create new jobs or copy existing jobs
Replies: 6
Views: 1624

If the job logs also were corrupted, mass compiling often fixes that problem as well.
by kcbland
Tue Oct 17, 2006 9:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Importing Meta-Data from Universe
Replies: 5
Views: 2986

The standard recommendation, also made in your online documentation under the Start menu about connecting to U2 databases is to create an account to house new dictionaries with F pointers to the datafiles in other accounts. You need to setup clean dictionaries that are just A or S items, with I desc...