Search results

  1. D

    ODBC setup

    I need quick assistance user is requested to get progress database connections.using ODBC tool. They are using sievo data extractor tool to connect to our progress databases. Whether we need to install Progress client on this machine to setup ODBC connections to progress database ? Please...
  2. D

    QUICK Help : Shared memory utilization

    yes Rob i did but not able to find on server
  3. D

    QUICK Help : Shared memory utilization

    HI Rob, as per your suggestion i verified in database log file 4:13:56 BROKER 0: Created shared memory with segment_id: 262191 (9336) 04:13:56 BROKER 0: Created shared memory with segment_id: 262156 (9336) 04:13:56 BROKER 0: Created shared memory with segment_id: 262175 (9336) 04:13:56...
  4. D

    QUICK Help : Shared memory utilization

    Hi team, our database went down due to memory violation error.I checked in promon > 1> Status: Shared Memory Segments It shows all memory utilized. I tried to kill Seg id with ipcrm -m id to free it but still it is showing utilized. what action i need to take to resolve this issue.If reboot...
  5. D

    Promon report

    Thanks Rob, yes Database path is wrong. I made changes to script. Now i able to receive all the input information. $DLC/bin/promon /progdata/prd/rey -NL </dbawork/hit_amon>> /dbawork/rey.rpt User Control: Usr Name Type Wait Trans PID Sem Srv Login Time 0 pgresdba BROK...
  6. D

    Promon report

    HI Rob, yes, Our database running on v9. Actual Activity option from promon should be Input file : m 1 9999 q 1 1 q 5 q x DB Size 64 GB BI Size 4095 MB AI Size 691 MB FR chain 6636 blocks RM chain 12732 blocks Shared Memory 418900 K Segments...
  7. D

    Promon report

    Thanks Rob, But still i'm not able to get required information. Input file: *p-10035*:/dbawork: more hit_amon m 1 9999 q 1 1 q I tried Manually checked using the above option it is showing all the user list, but when i ran using input file it is showing only below user lists And also i...
  8. D

    Promon report

    Need Help on generating promon report i'm working on Database analysis report using Promon.But i'm not able to get details properly for each option. $DLC/bin/promon -zn $DBPATH/$DB -NL </dbawork/hit_amon>> /dbawork/ input file: more hit_amon echo " " echo "m 1 99999 1 1 q 4 1 q 4 1 q 4 1 q 4...
  9. D

    Wrong port identified

    yes Rob they are using default brokers.we will add minport and maxport. I had a discussion with my leads they suggested us to fine tune these parameters before any connectivity issue comes. we have defined -n as 1050 based on that what values we need to define for -Ma,Mi , Mn,-Mpb and max/min...
  10. D

    Access Denied(authentication Failed) (7512).

    Hi Today some of the user will connect to our database using SQLlink.. error it is showing access denied. We not found issue on database they are up and running fine. Our Progress version very old 9.1d . Is there any option in Progress where we can provide table access for particular user...
  11. D

    Checkpoint Count

    Dear Team, One assignment is assigned to our DBA team . "when transaction is running how to get the details for any changes in cluster count. But I not able to get any information from any knowledge base or prokb. Kindly help me on this. Openedge 11.2 IBM Aix 7.1 servers and Enterprise...
  12. D

    Bi Threshold

    Hi Chris, Thanks for quick update. We don't have any disk space issue. My idea is if any schema updates or any long running transactions happening BI file grows.To avoid such things Bithold is helpful for our database not getting shutdown. And also kindly help me how to setup starting value...
  13. D

    Bi Threshold

    Hi All, We are planning to setup Bithold for our databases . These are things i getting confused 1)How will we decide the starting Bithold value (As per document : The recommended threshold is between three and one hundred percent (3-100%) of the largest possible recovery log file size...
  14. D

    Oem Tool.

    Hi Team, we are presently working on OEM tool setup. We added successfully all Version 11 production servers in OEM tool everything is working fine. But our client requested me to check script presently running in prod server whether we can take Database backup or not using in OEM tool .And...
  15. D

    Bkiowrite:insufficient Disk Space During Write

    today also we faced the same issue. We are able to figure out what the issue.user running program to pull data due to this create a large file used up the disk space. After that it starts shut downing databases. Cause:Application code error.
  16. D

    Bkiowrite:insufficient Disk Space During Write

    Hi Rob, Thanks for quick update. We enabled large file so i thinking it is not error due to variable extent flow. available space in /data partition is 26gb. Is this issue due to -T temp directory. FYI.... more iCABS.pf -db /data/oe/db/iCABS -ld core -db /data/oe/db/iCABSReport -ld report...
  17. D

    Bkiowrite:insufficient Disk Space During Write

    Hi All, We faced today database shutdown due to insufficient disk space this information we got from database log file(already i attached log file).in log file it mentioning due to bkioWrite:Insufficient disk space during write, fd 13, len 16384, offset 204816, file /data/oe/bi/iCABS.b3.When...
  18. D

    how much database is growing?

    Hi TomBascom, Actual question is for ex: if i taken full backup last month,up to know how much database is grown till now? how to find it any formula is their or by checking in Promon we can find it or not.
  19. D

    how much database is growing?

    Hi, This is durgaprasad, Presently we are using progress 9.1d version.platform AIX server version 5 release 7. How to know how much database is growing after taking full backup(database size is 4gb and block size is 8192). (or) We can find any option in Promon or how to calculate exact...
  20. D

    Broker

    can anybody tell me about what is a broker? what is the use of a broker.how they will work as back ground processes?
Top