Changing password level (QPWDLVL system value) from 0/1 to 2/3 with the help of USER_INFO view
4 September 2021
The only one of my customers with password level (QPWDLVL system value) still set to 0 has finally decided to improve the system password complexity by introducing the distinction between upper and lower case and by increasing the minimum length (from 8 to 10). Better late than never!
Cloning IBM i: Resetting Multipath
13 June 2021
When you IPL an IBM i clone, one of the tasks to perform is to reset the paths to the disks. The reset can be performed from Dedicated Service Tools (DST), during manual mode IPL, from System Service Tools (SST), or using the QYASSDMO API. In this post, we will discuss the latter method, useful to automate LPAR cloning.
WRKJOBJS (IBM Advanced Job Scheduler for I)
2 April 2021
Note: You must have license 5722-JS1 (Job Scheduler for iSeries) to use this command. The Work with Jobs using Job Scheduler (WRKJOBJS) command allows you to work with a single job, groups of jobs or…
QNTC - Access information on remote servers
28 July 2020
Introduction The IBM i operating system provides the IBM i NetClient file system (QNTC) which allows access to data and objects stored on remote servers. Properly configured it allows access to Windows NT 4.0 or…
IBM i System Management: FAQ & Howto (Part 4) IT
16 May 2020
This is the third part of the IBM i system management FAQ & Howto collection: you can see the other collections here from these two links: IBM i system management: FAQ & Howto (Part 1)…
---
Roberto De Pedrini
Faq400.com
IBM i system management: FAQ & Howto (Part 3) EN
28 March 2020
This is the third part of the IBM i system management FAQ & Howto collection: you can see the other collections here from these two links: IBM i system management: FAQ & Howto (Part 1)…
---
Roberto De Pedrini
Faq400.com
SQL - Audit trigger ... who moved my cheese!
13 March 2020
How to create a simple trigger to AUDIT a table: who and when to insert, delete and modify certain fields of my table?
We activate the trigger even if the file is in use, with this trick by Scott Forstie.
---
Roberto De Pedrini
Faq400.com
