IDMS Server ODBC connection to the IDMS mainframe has very slow response time. What is causing this delay?
If ODBC transaction connections to the IDMS Mainframe have very slow response time, then check the following settings:
- Verify that all the IDMS SERVER Client Tracing options are turned off (unchecked).
- Bring up IDMS Server ODBC Administrator on your PC.
(START->Programs->CA->CA IDMS Server->ODBC Administrator)
- Select the appropriate Data Source. Double-click the data source name to edit it.
- Take the "Log Options" tab.
- De-select all of the "Client Trace" check boxes.
- Click on the "Apply" button.
- Click OK on all dialog boxes to get out.
Note: If a user installs a new release of IDMS Server, and hasn't done a full uninstall (the default is to leave the data sources and options intact), then the client trace settings will be as they were previously. If any client trace options were turned on (checked), they will still be turned on after the install.
- If the ODBC driver manager trace is on that can seriously slow performance as well. To check this, bring up the IDMS Server ODBC Administrator, but before double-clicking a data source, choose the Tracing panel.
- Other possibilities are that tracing could be turned on within IDMS (like a Pterm trace) or in CCIMVS. Typically these traces should only be turned on when directed by Level 2.
- Test response time from the CCIPC client to CCI on the mainframe. If the slowness is in CCI (response time should be within 1 tenth of a second); check for messages in these MVS systems (CCS390 (Common System Services); CAIENF; CAICCI).
On your PC; in Computer Associates/CAICCI/PC/CAICCI-PC Configuration, go to the 'Test' tab and see how long it takes to respond. Again response time should be within 1 tenth of a second.
- Verify that IDMS, CCIMVS and TCPIP are all in a high performance group on the mainframe. See CA IDMS System Operations Guide, Appendix A.3 Performance Considerations for information on assignment of the IDMS system as a high priority.
- Test response time to the mainframe using the ping command. On your PC, from the START/Run prompt (DOS Command Prompt); issue a 'ping <IP address|hostname>'. An example of the 'ping IP address' is 'ping 123.456.78.90'. The hostname is the TCP/IP name of the mainframe logical partition name (LPAR) where the IDMS Central Version or Region is executing. The output from the command will show the response times in microseconds. If the response time is greater than expected, this is probably due to a problem in the network itself. In this case, check with your Network Administrator.
CA IDMS Server User Guide
Chapter 3: Setting Up Your System.
CA IDMS SQL Reference Guide
Appendix C.3 SQLSTATE Values.
Support Online Knowledge Base articles
TEC430731 How should I Configure my "Timeout" Parameters when using the CA IDMS Database Server Option Product?
TEC500186 DTS Error: "TD0C - F/e physical connect error rc = -41" during an attempt to connect to CA IDMS using the CA IDMS ODBC driver.
TEC497671 CA-IDMS/Server ODBC connection attempt fails - CCI trace shows CCI9040.
QI43460 CAICCI Error Messages and Advantage CA-IDMS Database Server Option.