DSXchange

Thanks very much guys.

Hi All We have a 10 user development license. When I try to login, I often get the message stating all 10 development licenses are already in use. :cry: How do I find out which users are logged into DataStage i.e. is there some kind of log in the DataStage engine (Universe database) where I could si...

What would be nice is a best practice that is categorised e.g. Connectivity --> Oracle, DB2, Sql Server etc could show examples of what should be in the odbc.ini, uvconfig and dsenv files. Pointers to watch out for when setting up connectivity e.g. security issues, database client issues etc. What I...

:D Thanks Vincent, I'll get the DB2 monitoring going.

Loading a flatfile with fixed width columns. We have to use the Bulk Loader Stage, since the normal DB2 stage only loads at 80 rows per second. The Bulk Loader stage reaches up to 800 rows per second. The problem is that the job will load all the records in the DB2 table, but will not Finish. The jo...

Thanks Ray, much appreciated.

:cry: The problem we are experiencing is that every now and then the jobs disappear from the client tools. I can still export them, but they are not visible in DS Manager, Designer or Director. One of the ways to fix this is to do a Rebuild Repository Indices using DS.TOOLS or to recreate the projec...

:idea: I want to create a DS project with jobs/templates that allow one to test performance. This like: how fast does the database spool the data to DataStage? how fast does DS read sequential files? how fast does DS write to sequential files? etc All the above is really to help developers get a bas...

Hi George

Have you tried using the LINK PARTITIONER stage. It will allow a single input stream to be split up to 64 ways thereby utilising the SMP architecture (you need to have the Inter-Process option selected).

Hi Byron

XP is only supported as a client, not a server. This does not seem to be widley documented, because it came out a few times at Ascential World 2004. The Ascential engineers stressed that XP never was a server supported platform and never will be...just so y'all know.

Thanks Ray/Morne. Much appreciated.

I wonder if the Ascential engineers quietly hum Old MacDonald while they work...

:roll: I'm getting this message: DataStage Job 145 Phantom 20687 Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Read operation failure. [EIO] I/O error Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Read operation failure. [EIO] I/O error Program "JOB.143...

[quote="ewartpm"]Hi, I'm experiencing the same problem since I reformated and reloaded Windows 2000 Professional onto my pc. The server (7.5) and Client both reside on the pc. I have tried HostName\User name, just user name, workgroup\User name etc. I can log in with Omit selected, but I c...

Hi, I'm experiencing the same problem since I reformated and reloaded Windows 2000 Professional onto my pc. The server (7.5) and Client both reside on the pc. I have tried HostName\User name, just user name, workgroup\User name etc. I can log in with Omit selected, but I cannot specify the server na...

I'm using Windows 2000 Professional. I have checked all the services, all are running. Just seems strange that I can't specify a user name/password when I login to DS.