Slow DataStage performance
Posted: Wed Nov 29, 2017 10:11 am
Hi everyone,
So I have been wondering how to present this question to IBM and figured I would ask here first. A quick summary is that DataStage Designer and all other applications that relate to DataStage (administrator, director, etc) will periodically tweak out and become incredibly slow. There are two scenarios in which this happens.
1. If my fellow ETL developer and I are both in DataStage Designer, working our separate jobs, and one of us decides to run a job, DataStage will then crunch for both of us until that job has completed. Meaning if he runs his job, I then cannot open any stages in my job without DataStage going "Not Responding" until his job has completed. This seems very odd to me.
2. Various scenarios can occur where DataStage Designer simply starts hanging up for one of us for no obvious reason. Notably yesterday I highlighted about 8 jobs that were backup copies and attempted to delete them. My DataStage stopped responding and as soon as that happened my coworker's DataStage started working incredibly slow. I waited an hour and ended up killing the process and disconnecting all of my sessions via the admin console. The slowness issue however did not resolve and persists even today. We have had this happen before with no obvious rhyme or reason and we've had to reboot the server to correct this.
We have a development environment on one server, we'll call it Dev1 and our web services for infosphere on another server, we'll call Svc1. These servers both run fully patched windows sever 2012. We have monitored the system performance and resources of both servers during both the above scenarios and there are no persistent spikes of any resources (CPU, Memory, Disk, or even Network). We are using Fat clients, not terminal services so the bog down of DataStage Designer when another individual is even running a job confuses me.
Does anyone have any suggestions on where to start with this?
*EDIT*
We have multiple projects on this development server and I have confirmed that the performance issue is persistent among the projects, pointing to the server as the common denominator.
*UPDATE*
We were able to get some improvement by closing the log pane in Designer. Thus we cleared some of the logs, which retention is set to the last 3 runs of a job, and this also helped some. Opening a stage in a job and looking at its properties for example now seems normal. However, saving a new job and compiling still take far longer than a freshly booted server. A job as simple as SRC---TRXFM---DEST would normally take 30 seconds or so to compile, now takes nearly 10 minutes (6 minutes as of last clocking).
So I have been wondering how to present this question to IBM and figured I would ask here first. A quick summary is that DataStage Designer and all other applications that relate to DataStage (administrator, director, etc) will periodically tweak out and become incredibly slow. There are two scenarios in which this happens.
1. If my fellow ETL developer and I are both in DataStage Designer, working our separate jobs, and one of us decides to run a job, DataStage will then crunch for both of us until that job has completed. Meaning if he runs his job, I then cannot open any stages in my job without DataStage going "Not Responding" until his job has completed. This seems very odd to me.
2. Various scenarios can occur where DataStage Designer simply starts hanging up for one of us for no obvious reason. Notably yesterday I highlighted about 8 jobs that were backup copies and attempted to delete them. My DataStage stopped responding and as soon as that happened my coworker's DataStage started working incredibly slow. I waited an hour and ended up killing the process and disconnecting all of my sessions via the admin console. The slowness issue however did not resolve and persists even today. We have had this happen before with no obvious rhyme or reason and we've had to reboot the server to correct this.
We have a development environment on one server, we'll call it Dev1 and our web services for infosphere on another server, we'll call Svc1. These servers both run fully patched windows sever 2012. We have monitored the system performance and resources of both servers during both the above scenarios and there are no persistent spikes of any resources (CPU, Memory, Disk, or even Network). We are using Fat clients, not terminal services so the bog down of DataStage Designer when another individual is even running a job confuses me.
Does anyone have any suggestions on where to start with this?
*EDIT*
We have multiple projects on this development server and I have confirmed that the performance issue is persistent among the projects, pointing to the server as the common denominator.
*UPDATE*
We were able to get some improvement by closing the log pane in Designer. Thus we cleared some of the logs, which retention is set to the last 3 runs of a job, and this also helped some. Opening a stage in a job and looking at its properties for example now seems normal. However, saving a new job and compiling still take far longer than a freshly booted server. A job as simple as SRC---TRXFM---DEST would normally take 30 seconds or so to compile, now takes nearly 10 minutes (6 minutes as of last clocking).