IBM Support

Oracle listener/tnsnames setup for (SDU/TDU) through SQLNet TCPIP: DCS performance reduction/slowdown

Troubleshooting


Problem

Oracle listener/tnsnames setup for (SDU/TDU) through SQLNet TCPIP: DCS performance reduction/slowdown

Symptom

Oracle listener/tnsnames setup for (SDU/TDU) through SQLNet TCPIP: DCS performance reduction/slowdown

Cause

Resolving The Problem

The first thing to check for a DCS menu slowdown is if the SDU and TDU parameters are set on the server and the client side (if sqlnet is being used i.e. the protocol is TCP). These parameters should be set for the services in tnsnames.ora (client side) and listner.ora(server side) and should be set to 8k (8192) . Else the default value of 2k will be assigned to these pipes. As the data flow in DCS during queries is more that 2k, the resultant fragments will slow the system down.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI48015

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21539937

Page Feedback