IBM InfoSphere DataStage Designer Client Runs Extremely Slow
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:
- Query the v$session to get the number of active and inactive session
- Query the v$parameter to get the number of session
- Raise the maximum number of connections or disconnect the inactive session
More support for:
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