Search results

I should probably clarify that I'm only stopping the aiarchiver (rfutil [db] -C aiarchiver disable), not after-imaging altogether. I'm glad you brought that brought that up, though!

If I disable AI archival before generating a new database backup, will the next archived AI files belong to the new backup file, even if their actual changes occurred before the new database backup was generated? In other words, will the next archived AI files roll forward onto the new backup...

Yes, I ran that list command on every library I had, but I still didn't find it. Looks like I was missing some libraries. I downloaded the 10.2B SP07 Development Source Code. The fn file was under the wrappers folder. Once I added the wrappers folder to my source directory and added...

Thanks, Tamhas. I'm having trouble finding fn's procedure library. Where can I look this up? Is there any documentation that lists libraries and their procedures?

That's odd... The tty folder exists, but the fn file isn't there. Is there something we need to reinstall?

PROPATH=.:/usr/dlc/src My current directory is the compile directory. I don't need to compile _dmpuser.p itself, but I do need to run it from within another program like this: dump_tables.p: ....... { /usr/dlc/src/prodict/user/uservar.i "new" } { /usr/dlc/src/prodict/dictvar.i "NEW" }...

Progress: 10.2b SP7 OS: SUSE Linux Enterprise Server 11 I've tried to run the following script in _progres: compile [DLC_path]/src/prodict/dump/_dmpuser.p save into [some_other_dir] And I get the following error: │ ** "fn" was not found. (293) │...

Thanks, Rob! I'm excited about using that ProTop program.

Thanks, Rob. Since I also assign Security Administrators and table/field level permissions, I'll need to dump and load the _File and _Field tables as well. I see two programs called $DLC/src/prodict/dump/_lod_fil.p and $DLC/src/prodict/dump/_lod_fld.p, but I don't see any corresponding dump...

Good point! I'm glad you brought that up. I use Progress utilities (prodict/dump_df.p, prodict/dump_fd.p, prodict/dump_d.p, prodict/load_df.p, and BULKLOAD) to dump and load my databases. It seems these utilities don't dump or load hidden tables or sequence values, at least by default...

We'd like to get a better understanding of how individual programs affect databases from a read/write perspective in order to identify any programs that need to be rewritten or could benefit from an improved index. Is there any way to get individual user or program read, write, and lock...

Thank you both for your advice. Based on other forum posts, I knew these changes were important, but I didn't know all the reasons why. You've been an invaluable help! Since these changes are necessary, what issues should I anticipate during the conversion? I plan on coming in over a weekend...

Tom, would you also say that placing AI files on physically separate drives from the database is a basic requirement?

Progress: 10.2b SP7 OS: SUSE Linux Enterprise Server 11 We're transitioning to from 9.0 to 10.2b, and we're considering changing our databases from Type I to Type II, separating indexes, schema, and data into different areas, and using after-imaging. Our largest database is about 1.7 GB, and...

Sorry, Rob. I wasn't sure where to find this information on a Linux machine. Using the "free -m" command, I got the following: total used free shared buffers cached Mem: 1887 1768 118 0 100 1480 -/+ buffers/cache...

Sorry for the long delay. Our largest database is 1.5 GiB. We have 96168 kB of shared memory. Our OS shared memory settings are below: ------ Shared Memory Limits -------- max number of segments = 4096 max seg size (kbytes) = 4194303 max total shared memory (kbytes) = 1073740800 min seg size...

Sorry, I meant the -B (buffer) parameter. Okay, I added one more. Why should we have at least four? Thank you both so much for your help!

Progress: 10.2b SP7 OS: SUSE Linux Enterprise Server 11 This is a followup a previous post of mine. I'm converting our databases to Type II. Our old database preference files used a block size of 20000 and the following data structure: db.st d [DIR]/db.d1 f 500000 d [DIR]/db.d2 f 500000 d...

Just in case anyone else out there has the same question as I did: I found a very helpful article called "Create, Update and Delete Records Using Dynamic Buffers." Thanks again, everyone.

Thanks, that's very helpful. I think I misunderstood what widgets are. I thought of them as GUI pieces that only drew on existing OpenEdge features; it seems they're much more than that!