Audit SQL usage in front-ends
The Central Service group is retiring Sybase at the end of this year. Several front-ends make SQL queries and will need to be migrated to PostgreSQL. Denise also asked us to audit all services that front-ends use, like
Scanning the startups script located in the boot area shows the following systems are loading
dbdown.out, which has the SQL API in it. It doesn't mean these systems actually use it; some people cut-n-paste example start-up code from others without fully understanding what each module does. A quick test would be to comment out
dbdown.out from the script and then reboot. If there are unresolved symbol errors from any other module, then it's being used.
These are systems where there was a clear link between the startup script and the node that uses it. A "clear link" means either the name of the startup script contained a valid ACNET node name or the contents of the script indicated which front-end uses it. There were a lot of strangely named scripts whose contents didn't refer to its node (maybe they are used by multiple nodes?), so this list is probably not complete.
Not sure if these are still in use, but they load
Out of Service Systems¶
These systems probably shouldn't exist anymore1.
These systems should probably also be removed1.
These directories were in the boot area and it wasn't clear which front-ends use the resources. So this table contains the directory name and the account that owns it.
1 It could be that only the ACNET node table entry remains for these systems. But whatever resources remain should be reclaimed.