Search results

  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

    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...
  3. 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...
  4. Shanmugam T

    Post upgrade DB Performance

    Hi All, I got downtime and performed dump & load successfully. Also migrated to Type 2 storage. there was no performance issue reported from user. Jan month end closing was peaceful :). However i have challenges on resource part as well. 1) RAM utilization is almost 100% for past two months...
  5. Shanmugam T

    DB performance issue with table

    Hello All, Users facing performance issue during month-end with progress database having Type 1 storage areas(all). So, i am planning to do a maintenance for tr_hist table(binary dump and load followed by index rebuild). Table tr_hist is in 25th storage area and its indexes in 26th area...
Top