› ›
Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.

Michael

About

Username
Michael
Joined
Visits
148
Last Active
Roles
Member

Comments

  • So I wrote the MFS and it works to prevent deletion in SYSPROCS. But if someone deletes from the OI main window, it leave the SYSPROCS record but deletes the rest and it's no longer considered a "stored procedure." To make it work again, one would…
    in Preventing program deletion Comment by Michael September 11
  • Thanks anyway, sir
    in Preventing program deletion Comment by Michael September 3
  • I'm definitely open to better!
    in Preventing program deletion Comment by Michael September 3
  • Got it. But the authorities want to lock it down. Do I need to just write an MFS to block deletes?
    in Preventing program deletion Comment by Michael September 3
  • The problem isn't GFE's. I need to compress the tables. I'm archiving 20+ years of data and the tables will need compressing badly. They actually already do.
    in Fix_LH Comment by Michael August 8
  • Thanks Jared.. If I can get it working, can it be run while the tables are in use? Other option is to run RTI_REMAKETABLE, which will Not work while in use. Thanks!
    in Fix_LH Comment by Michael August 8
  • So trying out the theory.. Fix_LH doesn't seem to work at all. It returns an error code of FS. Anyone run into this? Is there a workaround? Thanks!
    in Fix_LH Comment by Michael August 5
  • Back gnawing on this bone. I'm developing a process to archive or purge a lot of data (20 years' worth). The purge will not be a problem; but I know afterward the tables purged will be "flabby" (lots of wasted space). Plan A was to use RTI_Rema…
    in Fix_LH Comment by Michael August 5
  • Thank you sir! Sprezz was my next stop, but thanks for the direction.
    in Volume MFS Comment by Michael July 24
  • Thanks Don.. Do you know how the Writes would be coded? Would table handles, etc. still be the same? I'm sure we've all done MFS's out the wazoo, but this is new ground for me.
    in Volume MFS Comment by Michael July 24
  • Thanks. I think it's a non-issue for now. RTI_LOCK_OWNER doesn't work at all. In fact it abends OI altogether. Anyone have a workaround? Again, off-topic: the client has upgraded several of the workstations to Win10. OI still "runs", but more…
    in Problem with record locks Comment by Michael June 24
  • Actually RTI_Lock_Owner doesn't seem to work now. Quick off-topic question: We started getting a msg FS291: List over 64k bytes in BTREE.SUB operations or RELATER routines I thought the 64k issues were a thing of the past? Is this just a hold…
    in Problem with record locks Comment by Michael June 12
  • Thanks.. Most everyone who was involved at the time has moved on to other things. I'm not finding a lot of reference to it in the code, so I'm assuming not a lot was actually done with it. I'll see if I can get them to re-engage with y'all. Not a…
    in Problem with record locks Comment by Michael June 10
  • Hi Don, Will look into populating the username as you specified. The control you mentioned: does it involve the SRPMONITORCONNECT API? Thanks!
    in Problem with record locks Comment by Michael June 10
  • Was hoping there was some less-complicated.. maybe a SRP or RTI utility that could kick station-x or session-x off remotely. Something a monitor person could run w/o getting onto the server console. I'll bat those ideas around a bit. Thanks!
    in Problem with record locks Comment by Michael June 7
  • Thanks Barry. RTI_Lock_Owner does indeed get me the station ID. But the username is always Sysprog. And field 10 of Syslogins is null. The dictionary only goes to FMC 3. The client had some code that populated F10 with the user's ID, but I gu…
    in Problem with record locks Comment by Michael June 6
  • Hola all, The conventional wisdom among some of the "old-timers" with my client is that FIX_LH can actually be run while a table is in use. I know that RTI_MAKETABLE absolutely cannot, and I thought FIX_LH was the same. Does anyone know if FIX_LH…
    in Fix_LH Comment by Michael March 29
  • So hopefully-stupid question.. Are engine sessions on the engine service only created by the createengine functions, or also by the desktop application? How/should the eserver.cfg be tweaked if OI is running nearly always from the desktop? We have…
    in Orphaned OEngines Comment by Michael March 12
  • Looking up some of the posts on here, it seems that there are occasions when multiple OEngines can be spawned, and that in some cases the engines aren't closed when they should be. Are there settings in eserver.cfg that can/should be tweaked? All …
    in Orphaned OEngines Comment by Michael March 11
  • The one table has been fixed and is fine. Now I have another that is Completely hosed, and it's constantly in use. Am I safe to use the GFE Fix option from Database Manager on an active table? Thanks!
    in RTI_Remaketable Comment by Michael February 22
  • I have A list of keys from a manual "index." Probably not complete but it's a start. Running now. Thanks!
    in RTI_Remaketable Comment by Michael February 20
  • Tried that. With group 0 being hosed, I can't even Readnext through the table. Selects, Counts, etc. all return 0. I can try to restore from backup but the backup likely has a GFE too.
    in RTI_Remaketable Comment by Michael February 20
  • ok, I was able to Finally get Fix_LH to work. But due to network errors last night, group 0 of the table in question is corrupt now. Doing a Select returns a zero, even tho a Count returns a couple million records. I think the data is all there.…
    in RTI_Remaketable Comment by Michael February 20
  • It does indeed! Do you know where Fix_LH will try to create the "dump table" when fixing? I'm getting the FS255 error, which I assume means it can't create said file. I'm thinking there are access rights at work. Thanks!
    in RTI_Remaketable Comment by Michael February 19
  • Thanks Don
    in Batch.Indexing Comment by Michael February 16
  • Thanks Barry!
    in Resizing/compressing tables Comment by Michael February 8
  • Does anyone happen to have the docs for how to use RTI_REMAKETABLE? All we have here is the object code. Thanks in advance!
    in Resizing/compressing tables Comment by Michael February 8
  • Thanks Jared. Are you familiar with the inner workings of the Fix_LH utility? Does it do a record copy or some sort of OSBwrite or ?
    in Resizing/compressing tables Comment by Michael January 31
  • Thank you sir!
    in OI 9.4 + Win Server 2022 Comment by Michael January 2
  • We ended up copying off the original big files, creating a new OI table and copying the DOS files into the volume. Everything is fine now! That was just weird that having a big file like that would blow the LH service. But now we know. The mora…
    in LH Service issues Comment by Michael December 2023