Ask HN: Anyone using proprietary Unix at work?

194 points by wassenaar10 ↗ HN
I was born in the late 90s so by the time I got involved in technology, my introduction to Unix and Unix-flavored systems was limited to Linux and MacOS. However, I've read about the history of Unix at Bell Labs, the BSD systems derived from research Unix, and the eventual commercial releases of Unix System V from AT&T themselves. I also see that HP-UX, AIX, and Solaris are apparently still maintained and get releases, which suggests that they are still being used in production in some places.

I'm curious if anyone here currently works (or has very recently worked) somewhere where proprietary Unix is still used for production. If so, can you tell me what they're used for and why those deployments haven't been moved to an appropriate Linux distribution?

Not suggesting Linux is necessarily better for all use cases, just wondering what keeps these small number of entities clinging to closed-source Unix with presumably pricey license costs.

220 comments

[ 5.1 ms ] story [ 239 ms ] thread
I use mac which is a proprietary unix.
Technially, the Darwin Kernel it uses is OSS

https://github.com/apple/darwin-xnu

Can you actually recompile your kernel on Mac? And its functional?

I'll bet this isn't even the source code Apple uses, but rather they have a private fork with extra patches (similar to how Microsoft publishes OSS VS Code, but then uses their own proprietary version for releases).

Yes. However, many kernel modules needed to boot on a modern macOS machine are proprietary.
If an os is partially oss but functionally closed, what do you call that?

If I run windows with apache web server, is windows now open source?

rMS is a zealot, but it doesn't mean he's wrong...

You can, or at least could 5 years ago or so (and I bet you still could now).

However, it involved finding some random blog post on how to do it, and then even once I got it up and running there were some issues like the fans being pegged at 100%. Still, it was mostly functional.

I can speak to that via scuttlebutt from ex-apple friends. Apparently the intel power management code running in macos includes proprietary code from intel that they weren't comfortable opensourcing, for weird reasons.
Not proprietary, but Oxide Computer uses a niche (open source) Unix called illumos: https://illumos.org/
Illumos is open source Solaris.
illumos has a Solaris heritage, certainly -- but has evolved quite a bit in the last ~12 years. For details of the history, see my LISA 2011 talk.[0]

[0] https://www.youtube.com/watch?v=-zRN7XLCRhc

I know next to nothing about OSs, but I'm a big fan of your talks by the by.

"Coming of Age" and the "Don't Anthropomorphize Larry Ellison" talk are especially great.

Not for almost 20 years. HIGP/SOEST used SunOS.
Yup. SCO OpenServer 5.0.something, for some partner's accounting department. Neither the OS nor the application software have been updated since the late 1990s, but if it works, it works, I guess... (to be honest: the application software is only used to run reports in response to requests from the legal department, but apparently still can't be shut down -- I ask once a year, next upcoming 'query date' in my agenda is March 2023).

This used to run on a Compaq Proliant server (huge noisy Intel 486 tower) until the end of the millennium or so, then was converted into a VM. First on VMware, then on Hyper-V, where it has been running comfortably on various hardware (Intel Dell PowerEdge, AMD SuperServer) since.

Access is the biggest issue, as the OS only supports telnet, and serial access. So ever since this has been converted to a VM, it runs on a dedicated VLAN (666, just to make sure nobody ever misunderstands the true evil underneath...), with an AD-authenticating-HTTPS-to-Telnet bridge (coded up in Visual Basic.NET using some long-long-deprecated libraries) connecting it to the outside world.

That VB.NET kludge was recently upgraded to .NET 6, in order to get TLS 1.2 support. This was surprisingly uneventful, and I'm pretty sure this abomination gets to live another decade or so.

Ah, yes, a career in IT... Always on the forefront of cutting-edge tech...

(Later edit to, like, actually answer the question: licensing costs are nonexistent: SCO is gone anyway, and we don't require any support/updates. Migrating to Linux might be an option, but is most likely going to be hugely painful, and the existing VM scenario Just Works for everyone involved. Security and such is not a real issue: only a handful of internal users have highly-restricted access via a proxy)

Will it all blow up in 2038? Do you have a plan (to kill it, upgrade it, or retire) if so? :)
That is an excellent question, one I should investigate using a VM clone one of these days. The accounting data is frozen in time, so it should not be affected, but if the system starts refusing logons or just crashing, that would not be great (and I'm pretty sure the SCO licensing management thingy would fall over, as that was a previous source of, eh, entertainment).

The plan is definitely to retire the system Real Soon Now, but with the subjects of the underlying data springing new generations with new lawyers, ensuring some kind of Y2K38 compliance might be wise...

Rewind the system clock by 100 years and add 100 years to the data output :)

It should buy you another 100 years.

This is the way. Just make sure the hypervisor isn't jumping the clock forward.
> Access is the biggest issue, as the OS only supports telnet, and serial access.

OpenSSH works on it. This page has links to precompiled packages:

https://scosales.com/knowledge-base/how-to-install-ssh-for-s...

links:

ftp://ftp2.sco.com/pub/skunkware/osr5/vols/openssh-3.4p1-VOLS.tar

ftp://ftp2.sco.com/pub/skunkware/osr5/vols/prngd-0.9.23-VOLS.tar

ftp://ftp2.sco.com/pub/skunkware/osr5/vols/zlib-1.1.4-VOLS.tar

Probably better to grab the sources and compile them yourself if you can, though.

> Migrating to Linux might be an option, but is most likely going to be hugely painful.

Probably. At least it sounds like you only have a few users for it, so getting them to adapt to a change of software might be easier.

Maintaining access to a 20 year old ssh server will not be trivial. A modern client would usually fail to agree on encryption protocols in my experience.
It's pretty trivial. Some things are disabled by default, but still available on the latest versions of clients. For the OpenSSH client, it will tell you what specifically the client and server failed to agree on, and you can just add the option to enable on the client one of the ciphers, kex algos, or whatever that the server accepts. I've had no trouble with neither the latest version of the OpenSSH client nor Putty to connect to such servers.
Using ancient ciphers and kex algos can end up being just as secure as telnet.
I mean, if they can compile the latest version of sshd to run on SCO OSr5, that's great! If they can't because it's no longer compatible or whatever, are you saying they may as well stay with telnet? Obviously, not using legacy software is best, but it's not like people can just snap their fingers. Software needs to be ported, people need to be trained, etc. Work and time is needed. In the meantime, using sshd seems like an easy upgrade.

On "ancient", the ciphers and kex algos used by the OSr5 sshd above were deprecated like 4 years ago. I'd like to think that among the select group of probably-not-technical people that have access, it's not exactly the same bar of technical ability to inspect the contents of a plaintext connection as that to inspect the contents of an encrypted connection that uses ciphers and kex algos deprecated a few years ago.

Considering the other options you can add the deprecated ciphers and key exchange mechanisms with a few lines for the host in your SSH client config on the newer system.
> A modern client would usually fail to agree on encryption protocols in my experience.

I run into this issue frequently. Usually its a "client soft disabled, alter config", but sometimes... Just sometimes its "spin up an old VM to use its ssh client".

You SSH to sibling VM running under the same VMM, connect the serial port of the SSHVM to the application VM, clear text only runs over that virtual serial connection traveling through the VMM.
Wow, I had the same setup with Compaq Proliant in another galaxy long time ago...
This takes me back! This was roughly 25 years ago so I’ll do my best to remember.

My first job in high school was at a company with the entire business running on SCO Unix. I want to say OpenServer 3, maybe? It was essentially a terminal server with dozens of Wyse 60 terminals attached.

Anyway, as a Linux enthusiast I promptly setup a RedHat 7 install on some old hardware they had lying around. IIRC correctly it was a low-end Pentium but it could handle a PCI 100mbit ethernet card just fine.

Anyway, the goal was to get data to/from the SCO system to something with a TCP/IP stack (RedHat machine) so it could go somewhere - samba shares on the rapidly growing ethernet network, maybe even the internet!

We ended up using UUCP over serial, scripting, and cron jobs to push/pull from directories on each side. The RedHat machine was promptly connected to a 56k modem to do dial on demand and IP masquerading for the ethernet network and uploads of specifically formatted files from the SCO system via FTP to vendors and partners.

Fun times!

(comment deleted)
(comment deleted)
Why?
Fair question, although the basic answer should be obvious: the users still need access to the data! So, the question becomes more like "why not upgrade", or more specifically "why not migrate the data to something that is not so shockingly obsolete", since it's probably clear that there is no real upgrade path here (both SCO and the vendor of the accounting system are long gone).

Usually with systems of this vintage, "just dump all the data to Excel or PDF and get it over with" is a good option, but in this case both the volume (with the requirement to run queries on it) and the limited options available for export (the system can only print predefined reports, and they don't contain everything required for filtering) prohibit that.

So, next stop would usually be "reverse engineer the application data format and convert it", but the unholy collection of binary files used by the accounting software here has defied analysis: it's not Btrieve or MS-ISAM (popular semi-database formats for COBOL and BASIC apps of the time), and decompiling the binaries only yielded some generated-by-another-set-of-tools braindamage that didn't clarify anything either.

The choice then became spending huge amounts of money, or wallpapering over the tirefire and keeping it running. Unsurprisingly, the outcome was the latter, which is perfectly OK in this case, as the system is not exactly load-bearing, and actually sort of fun to maintain.

(comment deleted)
It's not Informix-4GL, is it? If it is, the DB should be available via `dbaccess`. If you don't have that executable to verify, I imagine the binary files are probably of extensions `.4ge` and `.frm`. Then, the DB is likely a directory with the extension `.dbs`, that has a pair of files per table with the extensions `.dat` and `.idx`.
No, it's definitely not Informix, Progress, Magic, or anything else commercially available that I'm aware of, although it does have all the "sure, let's disaggregate a single record across 26 files" hallmarks of a "4G" tool. But there was a lot of vendor-specific crud around at the time...
Surely only legacy data? No new data going into it?
Since you're accessing it via telnet, could you just scrape the screen? Then you could have a script that pages through the data, copying it out a screenfull at a time.
(comment deleted)
Maybe it's a multi-step migration.

From the highly obsolete format, to a stepping stone in-between which can be converted to a modern format.

With the constraints described by OP, converting to a stepping stone would still require you to fully reverse engineere the binary format.
> with an AD-authenticating-HTTPS-to-Telnet bridge

Apache Guacamole supports AD auth and (surprisingly) telnet.

Man, that brings back memories. When I kept a tile store/distributor running on SCO with their whack ass Keymark darabase.

Good times

That's an interesting account of evolutionary biology.
Hey, you took the tools you had and combined them into something new to solve a problem. That's literally what technology is, even if it isn't sexy.
Looks like OpenServer 5 is still being marketed by UnXis/Xinuos, so you might be on the hook for any ongoing licensing costs. They released the latest update in 2018.
(comment deleted)
Not since 2002. Irix, HP/UX, Solaris.

Correction: It has been pointed out to me that I'm currently using macOS which, Darwin non-withstanding, is technically a proprietary UNIX.

I've seen huge AIX installations maintained on contract by IAM at financial institutions.
Back when I worked at OmniTI (from like 2015 to 2017), we had an in-house Illumos neé Solaris distro for cloud servers named OmniOS. I didn't use it too much myself as it was somewhat legacy but all the other devs who used it for prod debugging loved all the dtrace/zfs stuffs on it.
I wouldn't call that proprietary. It was freely available, and I worked with it for a bit, until switching that project to SmartOS, which is also... not proprietary.

Both were excellent systems to work on in dev and prod.

LOL, small world. I was at OmniTI from '10-'13; I was around for the transition from Solaris 10 to OmniOS. It was an interesting system and I do wish the rest of the freenix world would learn some of the lessons that could be learned from it. (I guess in fairness they're starting to re: openzfs, ebpf, some of the smarter service management tools, et al.) That was the last time I touched proprietary unix at work, though. Even working at Oracle's AWS competitor later, everything internally was Oracle Enterprise Linux (which is to say, RHEL with the serial numbers filed off).
Pobox also had a few racks of hardware running Illumos/SmartOS as parts of their older stack. it was a pleasure to use once I wrapped my head around it, which was little enough because it was so reliable.
I use OmniOS - its actually not that rare to use if you want a good ZFS server. I am about to do a fresh install on new hardware of it as well. Its not legacy at all.
In ‘05-10 timeframe we had a selection of Sun machines around the engineering department running various software and were even evaluating new Sun hardware for file servers when ZFS was new.

Later on in eh, 2015 or so I worked at a company providing backup software that was tested and worked with every niche unix hardware under the sun. Usually to support large legacy industrial companies, think defense, materials, etc. who still used the hardware.

Banks will also use these things mostly for legacy reasons. The software got written once and has been working and validated for decades, no reason to rewrite it for a different OS just because.

Price is usually not a major factor when compared to the size of the business and number of employees.

> I also see that HP-UX, AIX, and Solaris are apparently still maintained and get releases, which suggests that they are still being used in production in some places.

When I worked for $(LargeDefenseContractor) we used Solaris for a defense system we were developing. Over time the older units (based on older hardware) would be passed down to the national guard. I would not be surprised if Solaris was still being used in obscure places in the military.

Solaris 7 was a pretty awesome OS as I recall, but pretty soon Intel and AMD started supporting linux as a workable OS option for their server chips. Then linux on the cloud took off and the rest is history.

Dated info (2001/2002?) but there was Solaris use at the NSA around that time too. Seems like the military and associated organs like to use it.
I worked on a system deployed on AIX for a few years. We used it to distribute batch workloads in parallel across a cluster of machines - no other software and OS did such a thing, maybe still doesn't. The machines themselves were PowerPC RS6000's which only ran AIX. The company already had a close relationship with IBM because they'd been running mainframes for decades. They made tons of money so saving money on licence costs was not important.
> distribute batch workloads in parallel across a cluster of machines - no other software and OS did such a thing, maybe still doesn't

What am I missing?

One of my college courses ages ago was about working with MPI which we got to run on the hpc cluster.

The last time I needed to run N copies of something I asked kubernetes to do it. The time before that, I asked $cloud_vendor for N identical VMs with the same cloud-init script.

Supposedly Google's in-house stuff that kubernetes and map-reduce (the product, not the concept) are public versions of, is all about running stuff well on huge groups of machines.

I can't speak for OP or their particular use case (because I don't know about it), but kubernetes is not a panacea for large scale batch processing.

For example, large banks need to securely, reliably, and very efficiently process an unfathomable amount of transactions[1]. In this case, kubernetes would be a giant waste of resources and complexity. The former one hampers throughput, the latter one means security and reliability suffer.

For people not familiar with it (me included, actually), it can be mind-boggling what throughput is achieved, and what mechanisms for reliability are in place. Not just in software, in actual hardware; this goes way beyond ECC memory.

[1] Transactions in the bank sense, not in the computer sense, because I don't want to confuse matters more. In the mainframe world for example, there is a difference between "batch processing" and "online transaction processing", but both could be applied to bank transactions. Note that I'm not advocating for the mainframe world here.

Interesting, can you give rough order of magnitude for the txn/s throughout achieved? Would also be really interested on more info or pointers to the hardware reliability mechanisms!
(comment deleted)
MPP was the acronym for the pattern. It let us take a binary executable which would normally just be a single PID on one node and it would distribute the PID and all its resources including files across however many nodes you had configured. The software that managed this was heavily dependent on RISC processor architecture which basically meant only AIX RS6000. Googles solution is designed for commodity processors. The modern equivalents let you do something sort of similar, but you have to design for that and as far as I know you’re not sharing resources like open file handles across the cluster. We took C programs and ran them as is.
Hey there! It depends on exactly how transparent you're talking, but I rewrote some Fortran and Honeywell assembly to 'C' on lowest-cost-bidder unix workstations on behalf of NASA in 91 or 92? We used NQS [1] to distribute the workload across the nodes and it worked pretty well. Well enough for NASA to retire the mainframe. The idea is hardly unique or novel - I believe DEC's clustering software allowed something similar? [2]

[1] https://gnqs.sourceforge.net/docs/papers/mnqs_papers/origina...

[2] https://www.parsec.com/wwwDocuments/ClusterLoadBalancing.pdf

Popular cross platform proprietary tooling for this is Control-M, but I didn't work personally with it. There are now also batch systems with executors on k8s or Mesos, and in a simplified sense apache airflow is often used for this
Not myself directly, but about 5 years ago I was doing some work for one space agency and there were some Solaris clusters which were older than me.

I’m pretty certain most if not all are still running.

Yep, still running Solaris 11 on a Sun server for SDH/SONET network management. I mean it fits the bill, since both technologies are now ancient.

I can't say bad things about the whole Sun/Solaris combo though. It's rock solid and requires practically no maintenance whatsoever.

Also, since it's completely off the internet, it's not like it could be compromised in any way.

Yeah internal networks never get breached /s
A friend has his own computer business, and some of his work involves tending to AIX systems. I don't remember now what his AIX customers use their machines for, but one might have been a biology lab.
We have a number of financial services apps running on Solaris. The cost of the licenses and hardware is insignificant compared to the cost of porting those apps to something else. You'll find that as the reason most folks stay on these platforms.

We also apparently still have some AIX, but I'm not sure what it supports. AIX is still somewhat popular in financial services; probably others as well.

I know of a couple large HP/UX shops left.

> The cost of the licenses and hardware is insignificant compared to the cost of porting those apps to something else

That’s an understatement!

Earlier this year I helped our final Solaris SPARC customer move over to X86/Linux. Every year for the last 5+ years they’ve asked us to extend support for just one more year; they were almost done with the migration! In the end, we had to compile them a few pieces of software with weird configurations because they took the standard AWS Linux and, well, I have no idea what on earth they did to it.

Yep, SCO Unix that hasn't been up dated in forever for a 1990's text based ERP system
Allied Irish Banks is still using Solaris, AIX, and HP-UX at the same time, according to a job posting I've seen.
The last "proprietary Unix" I worked with was AIX, way back in 2006. And that was only because their primary customer was an AIX shop. The code itself would actually run on Linux.

Previous to that (late 90's, early 2000's) it was mainly Solaris. One place was fairly heterogeneous, and had Solaris, HP-UX, Digital Unix (aka OSF/1, Tru64), and a couple others.

I think that last bit might have been somewhat common at the time. I had a small job as one of the unix-y guys at a software company dealing with a very similar collection of OSs. In their case, it was simply because the software they made ran on a lot of popular (and some not so popular) OSes, so the boxes running them (and, in most cases, building the software) had to be there.
As an intern in the mid 90s I babysat a similar mix. We also had some older SunOS boxes and some Irix, but mostly Solaris. I remember the HP as being the worst to work with of the bunch - for whatever reason if one of the tests was going to be broken it was on the HP.
We had AIX at my last job in 2021 and it was the least actively terrible part of our tech stack.
There is genuinely nothing wrong with a lot of the old stuff, in many cases its simply better than the latest and greatest React/Mongo/Whatever webshit stack that modern devs seem to emit.
(comment deleted)
This is running Solaris.

https://www.usa.philips.com/healthcare/solutions/radiation-o...

Last I heard they were desperately trying to get it on Linux. Why it isn't is because its a huge legacy application with some very horrible hacks specific to the OS.

The last time I got an MRI, the control room had one of those iconic purple SGI O2 workstations on the desk. I guess they were pretty popular with medical imaging products.
Yes, because SGI could do the "3D stuff" before PCs
Indeed. I remember we got two of those at a TV station I worked at in 1997-1998, used mostly for fancy weather 3D effects. The weather guy was so in love with the system. Meanwhile we were still using 3/4” Beta tapes in the editing bay for reporter packages and network footage…
Lots of MRIs and Cats still run Unix as well, even new ones. If it ain't broke etc etc, plus as a medical device it's a whole separate set of rules, testing, validation.
Indeed. Irix on an sgi o2 was the standard recon box until about 2005.
AIX on POWER hardware, because it runs SAP, and between IBM and SAP they provide all-encompassing certification and support. Swapping out the OS would invalidate those assurances. Yes, modern SAP runs on Linux. Yes, it would be a good idea to migrate off AIX. But the system has been in place for 20 years and it will be another 5 years at least before that migration happens.

There’s a bunch of enterprisey technology that is not yet dead, but dying very slowly.

I have a client (banking sector) which "recently" (5 years ago) started with AIX since they already had POWER systems running IBM i (i.e. modern AS/400), and had to select a Unix for a new vendor's EFT system; it was reasonable to use the (almost) same hardware and provider.

Another similar client is using Solaris (Sparc) for an analogous application; they are using it since 1996, I think because Sun (Oracle) always provided an easy migration path, so the applications didn't need to be ported.

As in most medium/big enterprises, in both cases the hardware/software price is not the main decision driver, but (IMO) it is the support/SLA, compliance checklists, and overall risk management.

BTW, in these cases Linux is also used for more "internet oriented" applications.

AIX on POWER here too but planning to move to Linux on POWER everywhere as part of the P10 refresh cycle.

HANA is already Linux on POWER so it will be nice not to have the AIX/SUSE split once we fully migrate over.

We tend to run pretty up to date config wise so it's helped quite a bit while planning upgrades. Only AIX 7.3 and SLES 15 SP3. Already moved from P7 => P8 => P9.

Here as well. Because of a customer using AIX, though it'll be phased out (as planned - they went with IBM/AIX because IBM could give them up to 20 years of guaranteed support and maintenance). In the not-so-far past there were also customers with all the well-known *nix platforms, IRIX, Solaris, Tru64, but that was some years ago. AIX is still alive though. Definitely not a bad Unix, and it has some unique features for large scale systems. IBM added a lot of Linux compatibility to AIX over the years, after all they were one of the earlier supporters of Linux. Which means it's relatively easy to develop and test on Linux before moving to the main AIX system.
In 2010-2011 I worked for (major American semiconductor firm), which had some test and validation teams on Sparc workstations running Solaris, and some design, test, and validation teams on Windows workstations with remote desktop clients for virtualized RedHat.

There was a common set of cshell based tools used between those two environments, among other 90s style Unix tools, like software written againt the SunOS Open Look widgets, and tools written in Tcl/Tk.

I wonder if those machines are still in use!

I worked for the DOD, and we used hardened RH servers, accessed through jump boxes/Putty, and Windows machines, and at least one Solaris box, though I never had a handle on what that was for.
In around 2004 I worked for a big five company. They were using some AIX, Solaris and HP-UX next to Linux which was still seen as that new thing. I remember having a training on some software where HP UX workstations where wheeled in. But those were really getting old at that point.

I worked at an ISP in 2007 which was running mostly on Sun hardware and Solaris. This was because of huge discounts provided by Sun. Most devs ran Linux on their workstations. In 2014 I got to work with some guy whose previous project had been at that ISP, who was at that point desperately trying to move off Solaris because they had to start paying list price for the OS and it was much too expensive.

I used to work for Sherwin-Williams. The in-store computers run some custom *nix OS. The software that company runs on is a text based ui that hasn't changed since it was introduced in the 90s.

They released a major update in 2020 that allowed you to move windows around the screen. It was groundbreaking.

But let me tell you, this system was absolutely terrible. All the machines were full x86 desktops with no hard drive, they netbooted from the manager's computer. Why not a thin client? A mystery.

The system stored a local cache of the database, which is only superficially useful. The cache is always several days, weeks, or months out of date, depending on what data you need. Most functions require querying the database hosted at corporate HQ in Cleveland. That link is up about 90% of the time, and when it's down, every store in the country is crippled.

It crashed frequently and is fundamentally incapable of concurrent access: if an order is open on the mixing station, you cannot access that order to bill the customer, and you can't access their account at all. Frequently, the system loses track of which records are open, requiring the manager manually override the DB lock just to bill an order.

If a store has been operating for more than a couple of years, the DB gets bloated or fragmented or something, and the entire system slows to a crawl. It takes minutes to open an order.

Which is all to say it's a bad system that cannot support their current scale of business.

That does sound like an absolute clusterfuck of software. But just in case it wasn't clear, I don't think that "custom *nix OS" is to blame at all. And as for text based UIs, they're still fantastic for things like data entry and lookup.

It just seems that the actual software running on the OS, with the text UI, seems to be profoundly terrible in your case.

Yeah, the OS itself was passable. It had the absolute bare minimum required to work, so not much could go wrong.

The ancient software also wasn't bad. After a few months learning the hotkeys and menu structure, the speed with which you can enter and process data was absolutely incredible. It had problems, but usually minor and patched in a reasonable time for corporate IT.

The real problem was their database management. I don't have any information, so I'm assuming here, but my impression is that they're using some positively ancient database software. Doing a backup of the local cache took multiple days, though it didn't lock the DB. Requests to HQ were incredibly slow, about 30 seconds to pull an account record. Larger queries like neighboring store inventory took a minute or two. Running a report on local inventory would regularly take tens of minutes, and it only had to read the local cache.

The database was a few tens of GB on disk. Granted, I don't know much about databases, but if running something like "SELECT * FROM inventory WHERE sales < 100 ORDER BY lastSaleDate" on a 30gb database takes 15 minutes, something is wrong.

There were a lot of problems we ran into on a daily basis, and almost all of them related to database functions. Particularly when a record failed to unlock, sometimes we'd have to reboot the local server, which caused all terminals in the store to reboot. That usually took a good 15 minutes.

Personally, I rather enjoyed not having Windows at work. For the most part, everything Just Works, and given the hardware, it ran ten times faster than windows would have.

My current job is a Windows development shop, and I don't have enough curses to describe the pure rage I feel every time windows does something stupid (which is approximately every three hours).

Ugly. This makes me seriously wonder whether they just did not put an index in, and unfathomably many hours have been wasted on useless full table scans for something that would have been fixed with a handful of CREATE INDEX statements? Though that's a lot of conjecture, and the real answer is probably more complex. But your examples do make me wonder...
Likely wasn't a RDBMS at all, but flat files with maybe one key index (or perhaps none).
I really doubt that a schema like that would survive at the kind of scale SW operates at. I'm about 80% sure I saw mention of database operations in the startup/shutdown logs, but I could be misremembering.

My guess is that they bought whatever database software was popular in the early 90s and never changed.

I do know they've been slowly changing the schema over the years, increasing the number of digits in the account number, adding email fields, that kind of thing. But I doubt there's been any major upgrades.

Well early 1990s database sofware wasn't awful. Talking about stuff like Sybase 4.x, roughly equivalent to early MS SQL server, also Oracle, Informix, DB/2, etc. Indexes, query planning (perhaps with hints), cursors, concurrency, were all adequately solved problems by then.
I remember running some very large reports over multiple years of inventory movement. Disk access on the server was totally saturated for a good 20-30 minutes.

Thinking about it now, it had to have read out the entire database multiple times.

Oh yeah, these reports weren't processed on the server, either. The network link on the terminal I used would be pegged at the max rate the server could read from the disk. I never really figured out what that's about.

I guess it's trying to stream large chunks of the DB to the terminal and running the query locally? No clue.

Some genius probably thought processing queries locally would be faster than on the database server. Fail.
(comment deleted)
I worked for a vendor that SW was a customer, and we were asked about integrating with some SW systems...what you are describing resonates
Was it EDI? I had a problem with a vendor where my store ordered something in 2015, marked it as not received, then received it later and sold it without correcting inventory.

The vendor went into a cycle of refunding and re-billing my store for that part every few months for years.

Fortunately both our books came out even in the end, but Jesus what a stupid thing to happen.

It was ultimately all of SW. Before the Valspar purchase, SW used SugarCRM, and my team there (TAMs) were with the account and regularly out in CLE. I really like the team there from SW. One of the best customers I ever dealt with overall.
I know of a small shop that made a good living buying software packages like that, rewriting/modernizing the technology, and selling the new version back to all the existing customers. It was kind of a win for everyone -- the customers got updated, secure software, the owners of the old tech who were getting nothing out of it (this stuff is not SaaS) got some money, and some developers got work.
That explains why they had me drive across town only to find out another store very close had the color I need.
Oh no, that's an entirely different problem. Because of supply chain issues, stores are allocated product based on how much of that product they sell. That sounds like it makes sense, but really what it means is that smaller stores slowly get less and less product until they can no longer meet local demand. There is no way to break the cycle.

This is half of the reason everyone who worked at my store walked out on the same day. The other half is that the only people who worked there were me and the manager, and it had been that way for six months.

My advice is to avoid SW these days and go to Lowe's. SW is contractually obligated to ensure that Lowe's always has inventory. But do spend a little extra money for their mid-teir product. The cheapest stuff is trash and you will regret it.