Search results

Thanks Tom. We haven't added space yet because we never had a problem until now. I will be downloading the powerpoint viewer so I can view the presentation. Thanks again!

I forgot, this is on version 10.0B.

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...

Thanks Casper! I think you just verified that this was what caused our problem. Our /progress directory (where the wrkdir is located) is only 5gb, with the SQLTempDisk able to reach 4gb and the other minor things in this directory we reached 100% full, and yet we were baffled because we...

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...

Thanks Tom.

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?

Thanks Tom.

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...

Thanks Tom!

The min size is 76 the max is 4075. The fragmentation: Count = 24821989, Factor = 1. Scatter factor is 1.1, just in case you needed that too.

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

Thanks Arshad!

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 am really a DB2 DBA, and I don't do much with Progress except ensuring backups are done, adding storage areas when needed, and keeping an eye on space. I have no way of writing a program, and I can't query the table because the only tool I know of is SQL Explorer, that the developers have...

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...