Power10 Entry Machines: The Power S1022s IT Jungle
Guru: Regular Expressions, Part 1 – IT Jungle
Guru: Regular Expressions, Part 1 IT Jungle
Configuring IBM i DB2 SYSTOOLS HTTP User-Defined Functions for TLS/HTTPS Secure Communications
This document will provide information on how to configure TLS/HTTPS secure communications with the IBM i DB2 SYSTOOLS HTTP Java User-Defined Functions (UDFs).
Large number of record locks held impacts system performance
This document explains how to determine what job(s) are holding a large number of record locks.
Access System Directory information via SQL
I was asked for a list of all the enabled user profiles that are enrolled in the system directory on a partition. I know I could use the Display Directory Entry command, DSPDIRE, to create an outfile of the information:
DSPDIRE OUTPUT(*OUTFILE) OUTFILE(QTEMP/WOKFILE)
DETAIL(*FULL) OUTFILFMT(*TYPE1)
Surely I would only want to retrieve the information for enabled profiles, or perhaps have a way to validate if a single user profile is enrolled in the system directory.
After some poking around I found a number of files in the library QUSRSYS that would give me the information I wanted. As the data is in files I can use SQL to get data and format the results in a way I would want, in real time.
