Search results

If you are starting the database using "Progress Explorer Tool" you will find the details in Progress Installation Directory\properties\conmgr.properties file If you are using some script to start the database, it will have complete path for the .pf file. .pf file contains the parameters for...

Hello Tom, The issue looks related to Busy Disks. Please find the complete sar -d output. 01:15:15 device %busy avque r+w/s blks/s avwait avserv md3 32 2.4 83 2712 0.0 28.7 md13 29 1.3 83 2712...

Many Thanks Tom.. I will gather complete sar output tomorrow and provide you with details. Regards, Vageesh

Hello Tom, Please find the details: As per our developers we have some application dependency for upgrade to OE. We are using Solaris 10, Databases are hosted on SAN with RAID 10 Screen caps of Checkpoint & Summary screen (tried to get it as close as possible to ckpt) are pasted below...

Please find the details: I am checking this information on the PROMON Checkpoint screen. There are more than 15000 Flushes per checkpoint. We are using Progress 9.1E04. As per our admin team there is no strain on disk subsystem part of sar -d output during the issue is pasted below...

Hello Everyone, We are observing Flushes during Checkpoint. Tried increasing APW but no improvement. The BI cluster size is 48MB and the time difference between checkpoints is around 4 Mins. Should Increasing the BI Cluster size resolve the issue? Thank you, Vageesh

Hi Tom, Could you please advise the optimal value for -spin parameter in case the CPUs are Hyper threaded. Thanks, Vageesh

Hi, Table & Index are in their own areas. Summary screen showed couple of Blocked sessions apart from this there were no abnormal displays. We have 13 Physical Disks, this is the reason we have started 14 APW. Thanks, Vageesh

Hello Everyone, We are facing intermittent performance issue with one of our database. ProTop screen indicates "Latch Waits" to be large (around 4000). Reads on one table are also huge. Please advice. Details: Version 9.1E / -B 250000 / -spin 30000 / -aibufs & -bibufs 100 each / AIW & BIW...

Hello Everyone, Is there is way of identifying the User / Process causing BKSH? Thank You Tom for PROTOP From _connect-wait1 we have the users waiting for BKSH. If we could get information about the User causing one, then the query can be tuned to avoid Large Waits for other users. Thanks...

Thanks Tom, Arshad. We scanned through history of commands used and could not locate KILL -9. We also observed that there were lot of User Sessions abnormally terminated. This might be because of network issues. Could this be the cause for the shutdown? Also the LOG file indicates the User #...

Hello Everyone, Yesterday one of our DB was brought down abnormally. The following information was present in the LOG file: SYSTEM ERROR: Memory Violation User 650 Died with holding Latch id 2 Begin Abnormal ShutDown Scanning through the LOG file shows that User 650 had logged in at...