Steve Riedmueller sriedmue79
forstie
/ frca_info.sql
Created
February 7, 2024 12:01
The path to achieving improved security on IBM i is sometimes a winding road. SQL can help to get you there on time. In this installment, FRCA is raised from obscurity to something understandable. #SQLcandoit,
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Subject: HTTP Servers and FRCA | |
| -- Author: Scott Forstie | |
| -- Date : February, 2024 | |
| -- Features Used : This Gist uses SQL PL, qsys2.object_statistics, qsys2.syspartitionstat, | |
| -- SQL aliases, SQL built-in functions, UDTF, qsys2.ifs_read, and pipe | |
| -- | |
| -- HTTP Server configuration detail resides in the IFS. | |
| -- The HTTP Server instance file (QUSRSYS/QATMHINSTC *FILE) | |
| -- points to the IFS path to use for each specific server. |