Search results

Thanks atopher1. That clicked.

Hi All, We manage to do ODBC connection and when I try to connect from MSAccess to a sports2000 DB table (customer), it throws error "Reserved error (-7748); there is no messsage for this error". Where as if I connect to any SYS* table it connects. How can I view records from "customer"...

Heavy thanks RHD! It might also be not possible to run any DML / DDL statements using procedure editor for table created in data dictionary or SQL. Also, what info do _SYS* table contain. Regards.

Hi Experts, Is it possible to create primary key for a field during database design in Progress using data dictionary. Or, is it possible to create it by using dataservers or ODBC/JDBC. Using VSTs can I query which table(s) contain primary key or foreign key or unique constrainst created...

Thanks RHD. I read in a presentation on the web that we can manage BI buffer size. I think I framed the question in a wrong way initially. BTW, Oracle supports mutiple DB blocksizes and buffers. Thought may be the latest version of OE might include that feature as well. Regards.

Thanks Tom for the reply. With regards to BI buffers, we can define BI buffers with -bibufs. Can we set the size of BI buffer just like BI blocksize? TIA

Hi experts, How to find out what are DB buffer & BI buffer sizes. Are they tunable? If so how & when. TIA

Thanks Brandt. When I click Resource, I gett Resource Functions. Then I have to click CPU. I select the default plan and the save it. I always see " not checked" with yellow light and no data on CPU general frame. I guess I am missing some thing.

Hi all, I am setting up first time OE management. When I create default resource plan for CPU, I dont see any data. It say "not checked" and on the right side it displays " no data" for all users, system and total. Anyone who has done setup can please guide me how to monitor CPU for local...

Thank you both Tamhas & Tom.

There was an excellent explanation by Tom Boscom on this topic. I tried to search but couldn't find. Try searching all the archives and if found please paste the URL.

Hi DBAs, Progress 9.1E, Windows 2003. We wish to install virtualisation application in our windows intel server. Can any one please recommend any hypervisor (preferred is VMWare) to install in windows 2003 server. Is anyone using VMware with Progress 9.1e on windows? If so what are the...

Hi experts, I want to copy full ai files and rename to a different folder in a dos batch script. It could be like : proenv>rfutil sports2000 -C aimage full the output will be c:\test\sports2000.a3 How to copy this file & rename it with date & time attatched as extensions or with any...

Thanks RHD, I read some where in a post that begining with 10.1C we can trace reports or procedure or lines of program that causes performance. I was curious to know where exactly in promon or protop the option to find this. If I recall correctly then in Promon R&D there is the option to see...

Hi All, Has any one tried to find out which user and / or which problem is causing bottleneck in OE 10.1c? Which option in Promon or Protop we can find out which line of source code is causing the performance problem. Thanks in advance

Hi, If temp tables are used to pass as parameters in an n-tier application, then how is concurrency maintained. I mean, if user A modifies records of a table and those records are passed as temp tables and at the same time another user B modifies same record at the same time then which one is...

Hi, Progress 9.1E, Solaris 5.10 One of our client's in-house devloped database has 60 indexes ( 60 !!!) for a table. Now they would like to disable some of them. One way of identifying non-used / least used indexes is to browse through all source code. But this approach is time consuming...

Hi, Can any one clarify weather bi file is also backed up during an online backup? I read some where that bi is not backed up in the 10.2a and the bi file is zero when restored in a different place. Thanks in advance.

Hi, Has anyone migrated to OpenEdge 10.1x or currently working on OpenEdge 10.x along with Mfgpro eb 2.1 or 2009. Kindly share your experiences about the performance of the DB or any issues encountered. Thanks in advance.

1. You dont need ODBC if you simply plan to dump your data as is obvious from your post. On unix run pro <yourDBname> -p dict.p . You should see data dictionary. 2.The easiest way to dump data is by using the data dictionary you see by running the above command and go to '"admin" and first...