Recent content by Shanmugam T

  1. Shanmugam T

    How to calculate additional resources for new users

    We have MFG/Pro eB2.1 application running with OE 10.1B RDBMS on AIX 6.1 system. Currently we have around 700 users (self service clients) for this application. In future we are planning to add 100 to 150 users for this application. Now i have to calculate/estimate additional resources...
  2. Shanmugam T

    Progress error (PREPARE): Insufficient Memory. Memory allocation failed at 9456 in /vobs_sql/sql/src

    Today this error disappeared after setting AIX kernel parameter ulimit -D to unlimited and db restart. Got some background information from development team that they did upgradation to cyberquery app resulted in the above error and this error was reoccuring even after rollback. I want to...
  3. Shanmugam T

    Progress error (PREPARE): Insufficient Memory. Memory allocation failed at 9456 in /vobs_sql/sql/src

    Reports are scheduled in a reporting tool called cyberquery application. We see this error in application log file.
  4. Shanmugam T

    Progress error (PREPARE): Insufficient Memory. Memory allocation failed at 9456 in /vobs_sql/sql/src

    Hi Team, Please help to understand the root cause of this error. We have OE 10.1B running on AIX 6.1 server. User connecting to Progress OE db via odbc connection to generate report from one of the largest table (tr_hist - MFGPRO) and it failed to produce expected report. Progress error...
  5. Shanmugam T

    After image roll forward performance

    Yes, i have already gone through that article. Thanks for your reply. Front-end is MFG/Pro application so not sure will i get approval for version upgrade.
  6. Shanmugam T

    After image roll forward performance

    Hi All, Yes on DR server we have cheaper and slower storage than the production. Not sure about the current version upgradation or purchasing license for OE replication. On OS minperm is set to 3% and maxperm is set to 90%. │ Memory...
  7. Shanmugam T

    After image roll forward performance

    Hello Experts, After Image is enabled on Production database and Log switch happens once the AI extends becomes full. Archival of these full AI extends are taken care by our scripts and shipped to DR server automatically. On DR server, AI files are applied to hot-spare database which takes...
  8. Shanmugam T

    Post upgrade DB Performance

    Attached snapshot taken from nmon t where are _progress are client process. I have 6 MFG/Pro applications / db's running on this server with different startup / client parameters and different lang setup. We don't have any appservers or other services running. Sum of -B of all 6 db's = 14 GB...
  9. Shanmugam T

    Post upgrade DB Performance

    Uploaded nmon memory output. Please check and let me know ur suggestions. Thanks.
  10. Shanmugam T

    Post upgrade DB Performance

    All OS parameters are set correct. minperm% = 3 maxperm% = 90
  11. Shanmugam T

    Post upgrade DB Performance

    All the databases are running on single LPAR. Yes it is dynamic.
  12. Shanmugam T

    Post upgrade DB Performance

    I'll capture the data in coming month end when the system is busy. Now i have posted below samples with 5 mins interval Activity - Sampled at 02/25/15 12:57 for 58:32:57. Event Total Per Sec Event Total Per Sec Commits 9691756 46.0...
  13. Shanmugam T

    Post upgrade DB Performance

    Hi Tom, Yes it is LPAR setup, created logical partitioning using VIO server. Hardware: P7+ Processor Clock Speed: 3500 MHz Application : MFG/Pro eB2.1 Database: Openedge 10.1B OS: AIX 6.1 Total RAM:50 GB Total CPU: 14 We have six different site's database running on same server. Total...
  14. Shanmugam T

    DB performance issue with table

    I agree. Thank you all once again.
Top