Search found 2288 matches

by roy
Thu Jul 21, 2005 4:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: find/replace(Parameters) utility to promote to production
Replies: 10
Views: 3366

Hi, Just wanted to point out that if you used encripted passwords you'r out of luck there since you can't search/replace them!!! the only thing I can think of capabale for mass updating your project/s wide paramters might be parameter manager (or hacking the repository to get it). Having that said, ...
by roy
Thu Jul 21, 2005 4:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exclaimation Mark in the job activity stage in Job Sequence
Replies: 3
Views: 1452

Hi,
Better yet point your mouse on the exclamation mark and.... presto !!!!
you'll see the reason apear before you !!!
It is one of the cool things in this product ;)

you should get a list of all the things not handled in order for this activity to work.

IHTH,
by roy
Thu Jul 21, 2005 3:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleted a Project in DS Admin but &PH&,&COMO&
Replies: 4
Views: 1372

Hi, Usually when files/directories fail to be deleted there are 2 reasons: 1. used by something else. 2. no privilages to delete them. Once the reasons are delt with and the no longer exist you should have no problem. Do you still see the project in your DS administrator? you might need to fix the r...
by roy
Thu Jul 21, 2005 3:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is Phantom
Replies: 3
Views: 1110

Hi,
1. use of the search this forum offers should have poped up the answer hence your post was redundant.
2. sever posts are better posted in the server forum.

3. phantom is the name you'll see for DS jobs as background processes running on your machine.

IHTH,
by roy
Tue Jul 19, 2005 11:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC on AS400 - the query gets stuck(?)
Replies: 6
Views: 1829

Solved !

Hi All,
AFAIK from onsite report:
A new downloded DataDirect driver seems to have resolved this problem.

All's well that ends well :)
by roy
Tue Jul 19, 2005 6:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Designer vew Vrs. actual run
Replies: 2
Views: 686

additonal info

I must admit the user defined sql there looks like something from HELL!!! subqueries, from parts from select results , cases and so on I prefer simplifying things anyway ( not running a 3k+ character strings of sql quesries ) So I'd like any input you might have with similar experiances. I'll start ...
by roy
Tue Jul 19, 2005 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Designer vew Vrs. actual run
Replies: 2
Views: 686

Designer vew Vrs. actual run

Hi All,
I'm in a wierd situation.
I've got a job that gives no rows returned when viewing the data via designer, but returns rows when the job runs via director :shock: .

Navigator returns no rows as well.

Any Ideas :?: :shock: :?:
Thanks in advance,
by roy
Mon Jul 18, 2005 6:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Working with Fixed width files
Replies: 4
Views: 1135

Hi,
What exactly didn't fit the fixed width format?
was it empty fields being 1 space instead of n spaces?
was it strings were not extended to full length specified?

IHTH,
by roy
Sun Jul 17, 2005 9:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Import error
Replies: 5
Views: 1284

Hi, Your mentioned files might be locked some how, hence you can't import new designs with the same name. Or your dsx file is messed up. Search this forum for LIST.READU to find the locks or use the DS.TOOLS interface. Another thing might be permitions issue. Try to see if the aleged files exsist un...
by roy
Sun Jul 17, 2005 9:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Telnet Service Not starting
Replies: 4
Views: 1303

Hi,
"Wierd" as it may be there are several places that intentionaly disable this process all together for security purposes.
There is no real problem working with this service disabled.

It's probably some PX fire wall or security configuration issue.

IHTH,
by roy
Sun Jul 17, 2005 5:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple input tables and one target table
Replies: 11
Views: 2573

Hi,
If your doing the 1k records inside your time frame you need not put too much effort in improoving it IMHO.

IHTH,
by roy
Sun Jul 17, 2005 4:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exec DOS questions
Replies: 11
Views: 3027

Hi,
You might be able to do it with the ftp stage using the telnet options.
Beyond that why are you relactant to use a batch? (you can build it on hte fly using a ds job if that is what your worried about.

IHTH,
by roy
Sun Jul 17, 2005 4:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read only objects
Replies: 6
Views: 1119

Ray, He's Caps were down He ment: Really Extreemly Valuable (and that is you I must admit :D ) Really As Ray (this forum's Warlord) said you should install plugins not export/import them. Besides that when you export and you want read only objects exported as well check the apropriate check-box in t...
by roy
Sun Jul 17, 2005 4:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple input tables and one target table
Replies: 11
Views: 2573

Hi, To try understanding a potential performance issue we need more info. How many rows are expected in each file/table? What is the time taken by updating of the target table? Will there be any benefit in combining more then 1 file to reduce numbrof updates? In any case if the number of records is ...
by roy
Sun Jul 17, 2005 3:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP from Unix to Mainframes
Replies: 4
Views: 767

Hi, The thing is that most MF guys will never let you do it to begin with. So what you'll usually have is: MF ftps the file to the DS server, then invokes a dsjob script that runs the DS job to process the data. you'll find this scenario far more easy to get going then the one you thought of. IHTH,