IBM Support

IBM InfoSphere DataStage Designer Client Runs Extremely Slow

Technote (troubleshooting)


Login into DataStage Designer takes several minutes (more than 10). After login trying to import jobs can take several minutes to hours depending on job complexity.

The database error meesages may be similar to the following:

ORA-00018: maximum number of sessions exceeded. 


Oracle used for XMETA database

Resolving the problem

Check with DBA to see database is stable. Some recommendations are below:

Document information

More support for: InfoSphere DataStage

Software version: 8.0.1, 8.1, 8.5, 8.7

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1443488

Modified date: 26 July 2012