PM76365: SAEM takes 1 hour to respond back after clicking the edit login menu options.

APAR status

• Closed as program error.

Error description

• SAEM takes 1 hour to respond back after clicking the edit login
  menu options.
  
  Client is using SA v11.4.01087 and using SAEM to edit a user
  loging. When he does this (by double-clicking the icon or using
  the menus) it takes a long time (up to an hour or more). Client
  only has one domain and also it happens for all users.
  
  Workaround is to use SQL Server Management Studio.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The default cache time for database status is 30 seconds.
  If the query to determine database status takes more than
  this then the query is reissued for every database on the
  server.
  

Problem conclusion

• The solution is to increase the cache time to 120 seconds.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TLOGIC SYS ARCH

• Fixed component ID

  5724V68SA

Applicable component levels

• RB40 PSN

     UP