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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.