• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Table/Row Locks

jgersic64

Active Member
I want to verify that we are setup properly on our system for
transaction processing and am a little worried from what I have found that
it has not been configured properly. On the enterprise server we have:

LOCK MANAGER]
Server=WAS_JDE_ENT
AvailableService=NONE
RequestedService=NONE

And on the clients:


[LOCK MANAGER]
Server=WAS_JDE_ENT
RequestedService=NONE

From what I understand, shouldn't the server have available service and
requested service set to 'TS' and on the client the requested service set to
'TS'. Could there be problems with table or row locks if the above are the
current settings? Would you recommend (as I believe) to change the .ini
settings and bounce the services as soon as I can?

John

Xe, SP14.2, NT, SQL/SP3, WTS/Metaframe 1.8


----------------------------------------------------------------
John Gersic
Financial Systems DBA
703.744-6057
1861 International Drive
McLean, Virginia 22102
MicroStrategy-Best in Business Intelligence
http:/www.microstrategy.com/ <http:/www.microstrategy.com/>
-----------------------------------------------------------------
 

Larry_Jones

Legendary Poster
John,

on the client jde.ini file RequestedService should be TS.
Putting it on the Enterprise Server .ini is not neccessary and may even slow down batch processing.

Regards,

Larry Jones
ljones@wagstaff.com
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials
 
Top