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
IBM i system management: FAQ and Howto (Part 2 - EN)
9 February 2020
A second collection of FAQs and Tips on managing the IBM i system:
– Control of the JOB QSZASOINIT
– Charset conversion in the IFS
---
Roberto De Pedrini
Faq400.com
PTFs and PTF Groups: Are you up to date? Let's check via SQL
14 December 2019
Which PTFs or PTF Groups are installed? Are there new updates available to install?
And is the firmware updated?
These questions can be answered with a few SQL statements
