Recent content by baddos

It appears that sometimes after doing an online backup using probkup that my secondary broken will no longer accept sql/odbc connections. I have the database setup using Progress Explorer tool and have separate brokers for 4gl and sql connections using different TCP port numbers. Currently...

I just wrote a script to check the file size of the last dynamic extent. Thanks for the help guys.

Running Progress OpenEdge 10.1A SP2 on a Windows server using the workgroup license. I need to monitor the extent space usage to ensure I have allocated enough space properly as the database grows over the days/months/years. Because I'm using workgroup license, I have a 2gb file limit which...

Ok that makes sense. I'll try it out and let you know how I do.

I've read this in the probkup documentation and wondering what you guys think. "When restoring a backup, the target database must contain the same physical structure as the backup version. For example, it must have the same number of storage areas, records, blocks, and blocksize." I'm...

Nope, just progress and thats it.

Thanks! I'll check this out tomorrow.

How would I go about performing a progress backup and restore? Got any links? Right now how the database is backed up, is essentially the progress service is stopped and the files are backuped up. :( Also, something to note about the records in this table. The software only stores 999 days...

The vendor is far from helpfull getting any knowledge let alone what should have been setup several years ago when the system was implemented. The whole system is a joke beyond belief, if I didn't work here I'd be laughing for days.

Is there a way to move these extents back into 1 file or a couple of large files? The database in question only has 1 table, but that table currently has a little over 41 million rows.

Also, several months back our vendor tried to increase performance of the database by creating extents. dbname.d1 through dbname.d75 all at exactly 102,400 kb. After doing this performance seemed to remain about the same. It seems crazy to me since they are all on the same disk. Before splitting...

The server has a single raid5 disk using 4 spindles I beleive with a hot spare. The progress license is workgroup. The settings are default based upon what the progress explorer tool sets. They are as follows: # Blocks in DB Buffer: 0 # Hash table entries: 0 # Lock table entries: 8192...

I've added the -B command and the process is using more memory, however it doesn't seem to be doing anything usefull. I ran a SELECT Count(*) query on a table and it continued to take 20 minutes before and after the change, even after running it multiple times.

I can't upgrade 10.1a to a new version. The application that uses this database was made with progress and is compiled to that version. Until I get a new version of the software I have to run this version of progress, at least that is what my vendor told me.

Awesome thanks for the help. I added that argument to the defaultConfig and it's using more memory. This database is used by an application we have made by another company, so I don't much about it's layout and such.