Hi All,
I have created an ODBC connection in Oracle and trying to validate same connection while connecting to IA under Configuration/Analysis settings but it is taking too much time to validate settings. Finally I am receiving timeout connection. When I tried to enter same credentials in Oracle it is connecting in seconds.
Please let me know how to proceed on this.
Analysis Database settings taking too much time
-
- Premium Member
- Posts: 57
- Joined: Tue Jun 30, 2009 9:38 am
-
- Premium Member
- Posts: 57
- Joined: Tue Jun 30, 2009 9:38 am
-
- Premium Member
- Posts: 57
- Joined: Tue Jun 30, 2009 9:38 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's what I'd expect. Your DataStage Workload Management system uses queues to prevent jobs from running if the system is too heavily loaded.bhargav_dd wrote:Whenever i tried to run a new rule and see DataStage Director shows PXValidation jobs Queued.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 57
- Joined: Tue Jun 30, 2009 9:38 am
Describe your server CPUs and memory. Are your server resources near, at, or below the minimum system requirements?
Try changing the Workload Management system policies. At least one of the settings should be highlighted in red while you jobs queue. If you are really low on memory, then change the memory usage setting, and so on.
Try changing the Workload Management system policies. At least one of the settings should be highlighted in red while you jobs queue. If you are really low on memory, then change the memory usage setting, and so on.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Lets first insure that the connection is configured correctly.
Try this to insure it is configured correctly:
Testing ODBC connectivity
https://www.ibm.com/support/knowledgece ... tions.html
Try this to insure it is configured correctly:
Testing ODBC connectivity
https://www.ibm.com/support/knowledgece ... tions.html