DSXchange

I am looking for what the experiences people have had moving from UDB 8.2 DPF to 9.5 DPF with PX. Any and all gotchas, major bugs, or just words of wisdom appreciated. Thanks much.
ART

Anyone out there using this add on. Any thoughts on it? Is it worth it, is it easy to use, does it really save time....... etc. Starting to look at some ETL from peoplsoft to UDB ESE Partitioned. thanks much.
ART

Quick question. Does the profile stage database have to be cohosted with the profilestage server or can it be remote?

Quick question. Does the QualityStage server get hosted with the Datastage Server?

Tuning kind of falls in to multiple buckets. Ways to write your SQL better (at a higher more DBMS independant level) Ways to write your SQL better for your particular DBMS. Ways to make your DBMS respond better to your query. Ways to make your tables more suitable to your query. There are varying de...

I'll track that down, although I think it is really high.
ART

Anyone have any ideas on this error? We are running on AIX with UDB EEE reading from a mainframe. Just get these errors everyonce in a while and can't seem to track them down. Anyone have any thoughts? thanks much. ART pxLdPCWXLDBS on SERVER100, project cdw_prod stpPCWXLDBS,8: Terminate Point Reache...

Still working on this one. Has anybody seen this before?
ART

Thanks much.
Art

Anyone have any ideas on this error? We are running on AIX with UDB EEE reading from a mainframe. Just get these errors everyonce in a while and can't seem to track them down. Anyone have any thoughts? thanks much. ART pxLdPCWXLDBS on SERVER100, project cdw_prod stpPCWXLDBS,8: Terminate Point Reache...

Quick question. Is Datastage 6 supported on AIX 5.2 with UDB version 7? This would be server and PX. Thanks much.
ART

Anybody here have any links to or thoughts on memory usage by Datastage PX? The problem is this. We are seeing behaivor that indicates that the server is running out of memory from a datastage and os side but it isn't quite showing up on our performance tools. It seems to me that I remember that the...

Anyone run in to any migration tools for datastage that can assist in the process of moving jobs from development environments to production environments. Looking particularly at tools that could integrate with things like Clearcase. Thanks much.
ART

Under version 7 of datastage are there any easy ways to embed links to database passwords rather than hardcoding them. I know that they are hidden but I am looking for a way to point the job to a password link so we don't have to recompile when we change the password. Thanks much. ART

We are starting a rollout of the Datastage tool across multiple development groups. I am wondering how people are doing code reviews for datastage server and parallel jobs. Thanks much.
ART