Search results

Tamhas, I am the DBA, lol.... I just don't have very much experience with Progress in general, SQL Server is my forte. Some time back in late 2005 the company had a Progress Consultant come out and tune the database in order to increase performance and all the reports were running just fine...

Tamhas, Thanks for the info. I'm reading solution 20143 right now. However my database does have a _user table. I've logged into SQL Explorer as myself in order to Grant the user in question rights to query the table that we want to create the view on. The problem is that I'm getting an...

Hey all, We have a problem with out reports taking much longer then they should to run. So the plan is to get rid of the reports and replace then with SQL Views instead and present the views to the users. Anyway I'm trying to set up an ODBC Connection to the our OpenEdge 10.0 database that...

Hey Tom, Thanks for the reply. I will definately check into the details of the SAN configuration. -- Quote-- There may also be issues with the application configuration -- is it possible that something there was missed? (Is it a purchased application? If so which one?) -- End Quote -- Yes...

Hey Joey, The reports are 4gl reports I believe. The conversion was done by me using the Proutil conv 910 conversion tool. I did a backup of our production 9.1c database, restored it to a server that was running Progress 9.1c and OE 10. Then I ran the conversion, and after the DB was...

Hey All, Just looking from some idea as to what is going on. We just completed a conversion of our database from Progress 9.1c to OpenEdge 10.0b05. Now I'm getting complaints from our nightly operators that the nightly reports are taking up to twice as long as they did running under the 9.1c...

Hey Curly, Thanks for the tip. DBMan works for part of what I'm trying to accomplish, it does stop and start the database and PET does recognize the fact whether or not the database is up and running. However I can't use it in a batch file because DBMan terminates the command after it is run...

Hey all, I just finished settin up a server for testing OpenEdge 10.0b05. This server is going to replace out current production server once the IS department is done testing our application against the database. I used the Progress Explorer Tool to initially start the database and I have a...

Hello All, I have a quick question about hardware requirements for Open Edge 10.0B03. We are going to upgrading our Progress Db to OE 10.0 but when we do this, we will also be getting a new server for it. What I'm trying to find out is the number of processors OE 10.0 will support and the...

Hey Casper, Thanks for the help. I think the article pointed me in the right direction.... Thanx, Pete J.

Hey all, Need a little help since I don't know the progress 4GL language. Can anyone give me some code that will list out all the table with in my Progress 9.1c DB and a total count. I'm working on a new stroage are schema and I've got a VB script that is going to create my binary dump and...

Hey Guys, I'm trying to re-desgin our 9.1c Progress DB. We're going to be upgrading our system to OE 10.0x and I need to re-design the storage areas (move thing around), add in more space for the DB files, AI extents and so on. Currently I've got a 20GB database split amongst 15DB files each...

Also, I forgot to ask but will the database start up in multiuser mode using dbman to start the db.

Hey ddavis, As far as nightly backups are concerned, I use an online backup on a nightly basis and only backup the database via offline backup once a week per company specs. I'm not really the best when it comes to Progress in general, but I'm using the _mprosrv command to start the database...

Hello All, I've got a quick question regarding the Progress Explorer tool. I've got a test server running OE 10.0B02 on it. I'm currently testing OE 10.0 so that the company can make the switch from Progress 9.1c to OE 10.0. I'm using the Progress Explorer tool in order to start the...

It looks like I'm using port 20931 which was the default port assigned when I installed OE 10.0. I believe that my 9.1c is also using that port from what I can tell. Is there anyway that I can change the starting port number with out re-installing OE or Prog 9.1c. Thanks, Pete J.

Hey Casey, I have the AdminServer set to start automatically when the server is booted via windows services. Yes there is another version of progress running on this machine. I have Progress 9.1c running on this server also since I still need to convert my 9.1c test db that I created of...

Hello all, My company is planning on upgrading from Progress 9.1c to Openedge 10.0b. I have a test OpenEdge 10.0 server that I've built. It's running Win 2003 with Service pack one and the latest Windows updates. I'm having a problem getting the AdminServer Service up and running on my...

Hey Dmitri, Thank for the code, however the output does not provide the actual database size in a usable format like MB or GB nor can I find out which extent I am actaully in, only that it is currently 85% full. Thanks, Pete J.

Hey Guys, I've got a 17GB progress database that I'm running or I should say that I've got 17GB worth of space allotted for this database. What I'm trying to find out is how can I go about getting the EXACT SIZE of the database and which extent it is currently using. Please note that I need...