Users have faced that the login to Dimensions web client takes a long time sometimes (2-5 mins). Running the login on the server itself in both web client and dmcli shows the same lag but it varies in time, also running commands like getpoolstats dramatically vary in response times.
At getpoolstats command on the DM application server indicates the a process is not assigned each time this occurs. Issue found in Release: 9.1.3 Install the attached ZOS 9134Hotfix.
To generate Oracle trace for a given Dimensions client session, first launch the client (Desktop Client/Web Client/dmcli) and establish the process ID of your connection by running " getpoolstats ". Next, connect to SQL*Plus as the system user to establish the Oracle session being used for the connection: sqlplus sys as sysdba/<password>
3. Connect to Dimensions using the Desktop Client 4. Run the command " getpoolstats " in a Windows Command Prompt on the Dimensions server and get the Process ID of the user that's connected with Desktop Client. 5. Use the "procdump64" command (https://docs.microsoft.com/en-us/sysinternals/downloads/procdump) to capture dump file on exception, for example:
It is also possible to obtain the connection pooling statistics via a command line: getpoolstats -host <servername:port> If the port is not specified it will default to 671. Full details of the Connection Pooling Statistics are in the Dimensions CM Administrator's Guide (dmcm_admin.pdf)
The absence of a login dialogue is not indication to the contrary. You should use getpoolstats and a connected Eclipse session to see that the old session has been removed and a new session created when an operation is attempted in Eclipse.
