Search results

Good morning, I have a 10.2bSP8 database on AIX and I need to move a table to a new storage area, I have tested it and it works fine but I want to be able to monitor the progress of the move so I can estimate when it will complete when I run this in production. I have seen from the progress...

Hello, I am currently on OE 10.2bSP8 on AIX and I was going over my startup parameters and started thinking about my connections. I am monitoring for the -n parameter to ensure I don't get close to my max connections (-n 3280), however the majority of my connections are through my primary...

Hello! I recently upgraded from 10.0B to 10.1B (on AIX) and have had issues with the dbanalys report ever since. I think a lot of it has to do with the chain analys being added, I would only get information from some of the tables in the db and the index analys wouldn't give me any...

I am getting the following error: SHUT 139: User progress cannot disconnect user xxxxxxxxx. (2258) I am using the proper user to do the disconnect, it is the user that created the database and the user that starts the database. It seems to have started happening out of nowhere, we use this...

Sorry, it's a little urgent for me obviously not for anyone else. I got the following error today on my Production OpenEdge 10.0B database: You have attempted to connect to a database with too many users connected to it. Retry the connection later, or increase -n on the server. (5291) I know...

OpenEdge version 10.0B on AIX. I got a call saying some users could not log into the application. All I see is where the user id tried to login and then immediately logged out, no error messages at all. They do not get the message "Userid is now xxxx", it is exactly like this: Login usernum...

Should ai files be variable, fixed, or a combination? Currently I have 12 extents on our prod database and all are fixed except the 12th one, which is variable. Every three hours we switch our ai files and copy the "full" ai files to another filesystem. This has worked fine for us, until this...

I have a question about SQLTempDisk. First off let me say I am running Open Edge 10.0B on an AIX server. Here is the question: Where is the temp space for SQLTempDisk allocated? Is there a way to verify where it goes? I know it is probably /progress/wrk. Also, the setting for this...

I am going to be doing a binary dump and load, and I was wondering if anyone knows if the size of the .bd file is the same as what the dbanalys says the size is for that table, or if it will be larger and if so is there a rule of thumb on how much larger to be prepared for?

I saw an earlier post about doing a time change while the database is up and I know that is fine, but what about a dump and load? I plan on doing a dump and load this weekend and I don't see why the time change would cause a problem but I want to verify it. I am running progress 10.0B on an...

I am trying to read and figure out what size records per block I should use and I want to verify what I came up with. This is for a storage area that has one table in it. The record mean size from tabanalys is 3240, size of storage area is 74.9 gb. The database blocksize is 8k, there are...

Is there any way to do a dump and load specifying the storage area instead of each specific table? I am on Progress 10.0B database. A few of my storage areas have multiple tables and I don't want to forget any tables while doing a dump and load. Thanks. Brian

I am running progress 10.0B on an AIX server, and I would like to know if there is a way to clear out the .lg file while the database is online? I know in 10.1A you can truncate it, but as far as I know the only way for 10.0B is to bring down the database. We have tested the following "cp...

Sorry, I accidenty posted this by mistake, please see my first post.

We have two progress databases, one for production and one we use for running reports, this database is READ ONLY. We have been doing a restore of the report database every night from the prod database, but we decided we wanted to try and save time by using the ai log files and rolling forward...

I need to be able to look at data in a table but I have no way of getting to the data except a binary dump. I have Progress 10.1B, on an AIX server. I am testing rolling forward the ai files on a new test database that was restored from another database, but the app. I am using is not set up...

I just downloaded and extracted PROTOP, and I'm not real sure where to go from here. It is on my C: drive. The Progress database is on an AIX box. I'm new with Progress, and fairly new with UNIX as well. I found a command in the readme file (mpro sports -p protop.p -param "i;10|d;UIO"), I...

I am very new to Progress, and have only been a DBA (DB2) for 11 months, I just wanted that out there to start. I was assigned the task of building a temporary test database and would like to know how to go about doing it. I have the .st file saved to my C: drive as a text file. The reason for...