LMDB Stuck - CL_LMDB_CIM_PERS_DB===========CP

[former_member256208]

Hi,

I have done a fresh installation for solman 7.1 sr1 SP8. But i have stuck in sync LMDB Phase ..and the background is running since 24 hrs.

and when i am executing solman_setup its giving time out error.

OS- Windows - 2012

DB - Sybase

Regards,

[Former Member · Accepted solution]

hi,

Please check the below note. Most of the times we have seen issues because of stat.

One of the blogs.

http://scn.sap.com/thread/3294503

1829335  - SYB: Slow performance or timeouts in prerequisites check phase during solman_setup.

Note 1642917 - SYB: Parallel UPDATE STATISTICS WITH CONSUMERS

Try to increase the below parameters also.

icm/conn_timeout; for example: 20000

Thanks

Rishi abrol

[former_member256208 · Accepted solution]

Dear Rishi,

Solved by following your notes mentioned. Thanks

Regards,

Mujeeb

[hasanajsh]

Please have a look at:

1839384  - SOLMAN_SETUP time_out ABAP dump or hang

Note 1555955 - SAP Solution Manager 7.1 - Performance Checks for LMDB

[former_member256208]

Yes I have check those notes..but my database is Sybase, the note 15550955 is specifically for Oracle DB.

[hasanajsh]

Yes, but please read carefully the end of the note:

Note on database statistics

Symptoms like the one described for the Oracle database are not known on  other database platforms. Nonetheless you should check and update database statistics as well on other database platforms if you  experience LMDB performance issues that have no obvious other  explanation. When checking database statistics, it is recommended to  also include the database schema of the Java stack given that SAP Solution Manager is a dual stack system.