Search results

  1. TomBascom

    How to replace entire occurence of a character.

    I think you might find that sub-optimal when ctest is something where your target is a substring of other entries. Like this: "demo,admin1,admin12,system,test".
  2. TomBascom

    Resolved Static or Dynamic

    For what it is worth... IMHO most functionality is easier to write, easier to read, and easier to debug with static code. So unless I have a good reason to prefer a dynamic approach for something I am coding I default to static.
  3. TomBascom

    Semaphore error

    No, it is not a min, max, avg thing. In order, the numbers found in /proc/sys/kernel/sem map to SEMMSL, SEMMNS, SEMOPM, and SEMMNI. This might be helpful: Chapter 8. Setting Semaphores Red Hat Enterprise Linux 5 | Red Hat Customer Portal
  4. TomBascom

    How to replace entire occurence of a character.

    That's totally buggy ;)
  5. TomBascom

    Local database (windows)

    Create a shortcut and in the properties use a command such as: c:\openedge\bin\prowin.exe -1 -db dbname -p c:\appdir\startup.p Where "prowin.exe" is the Progress client executable (prowin32.exe if you are on an old, crusty 32 bit release, _progres.exe if you are running a character...
  6. TomBascom

    Fast and safe way to delete large number of records

    for each oeel_index: if not can-find( oeel where oeel.field1 = oeel_index.field2 ) then delete oeel_index. end. Note: my WHERE clause is made up. I cannot make sense out of your example, it looks like it might have some typos in it. Or it might be that I'm just not much of a SQL guy.
  7. TomBascom

    Fast and safe way to delete large number of records

    Rob is correct. Your requirements are really quite vague and any advice we give will have to make far too many assumptions about what you are trying to accomplish. If you are thinking that grouping deletions into a block and committing the set of deletions as one large transaction rather than...
  8. TomBascom

    Safest way to enable replication for very large 3TB database

    Yes, that is a very workable technique. We used something very similar a few years ago with a customer that had a multi-terabyte db and who needed to setup a replication target at a remote datacenter (so no fast access shared filesystem available). As you mentioned, pre-building and expanding...
  9. TomBascom

    Formula for structure file (.st).

    There are various ways to do it but they all boil down to something like the following: ( Blocksize in bytes ) / ( average rows per block as shown by dbanalys ), then round up to the next power of 2 Example, 8k block average row size of 113: 8192 / 113 = 72; next power of 2 = 128 so put this...
  10. TomBascom

    Partial backup verify returning -1

    If it is something external to probkup that is causing an unknown problem (255 often means "unknown problem") then you might also find a clue in the windows event viewer.
  11. TomBascom

    Partial backup verify returning -1

    I see that "exec returned 255" but it is unclear what exec was executing. Presumably some form of probkup is involved but it isn't clear what the command line was. Do any of the .lg files contain any clues? Probably not at all related except for the error number but I have very recently had a...
  12. TomBascom

    Question BUFFER copy VS dump, load, and index rebuild

    How does either approach accomplish the deletion of 300M records? At one time, with certain (very old) Progress versions and poor disk hardware you could make a case that using 4GL programs and BUFFER-COPY could be faster than a binary dump and load because you can eliminate a lot of...
  13. TomBascom

    Question New To -b2

    Nice analysis, thanks!
  14. TomBascom

    Question New To -b2

    Why 6?
  15. TomBascom

    Swap space?

    This is a very useful tool: https://lintut.com/install-and-use-smem-linux-memory-reporting-statistics-tool/ The "USS" column is "Unique Set Size" - IOW, memory use *without* counting any shared bits.
  16. TomBascom

    Swap space?

    There is a good rabbit hole to dive down here: Linux: find out what process is using all the RAM?
  17. TomBascom

    Swap space?

    Are there lots of Java processes running? Those are also famous memory hogs.
  18. TomBascom

    Swap space?

    Ron has described the old style pessimistic swap reservation algorithm. To a degree this still used on Solaris, HPUX, and AIX. But Linux uses an “optimistic” reservation algorithm that assumes you won’t ever actually need much of that disk space. Linux is correct, you won’t. Rob’s points about...
  19. TomBascom

    loading df file in progress using cmd prompt(load_df.p)

    So you’re asking a new question about a different subject? Instead of polluting a 13 year old thread with off topic rambling you should open a new thread specific to your actual question. Try to provide a clear explanation of what you are trying to accomplish, what resources you have, what you...
  20. TomBascom

    loading df file in progress using cmd prompt(load_df.p)

    What portion of the 13 year old thread above doesn’t work for you?
Top