Month: September 2022

Posted on

SQL equivalent of WRKSPLF, faster way of getting information about my spool files?

One of the first commands we all learn with IBM i is the Work with Spool Files command, WRKSPLF. With IBM i releases 7.5 and 7.4 TR6 comes a new SQL Table Function that is the equivalent of WRKSPLF.

The new Table Function, SPOOLED_FILE_INFO is found in library QSYS2, has parameters that match those of the WRKSPLF command. The syntax for the Table Function is:

SELECT * FROM TABLE(QSYS2.SPOOLED_FILE_INFO(
USER_NAME => ‘*CURRENT’,
STARTING_TIMESTAMP => CURRENT_TIMESTAMP – 6 MONTHS,
ENDING_TIMESTAMP => CURRENT_TIMESTAMP – 2 DAYS,
STATUS => ‘*READY *HELD’,
JOB_NAME => ‘*’,
OUTPUT_QUEUE => ‘*LIBL/MYOUTQ’,
USER_DATA => ‘SQL’,
FORM_TYPE => ‘*STD’,
SYSTEM_NAME => ‘DEV750’))

These parameters and their WRKSPLF equivalents are:

Read more »

Posted on

How Using Deduplication With Replication Improves Your IBM i Backup Strategy

In this free educational recorded webcast learn how to improve your IBM i backup strategy by incorporating deduplication and replication. We cover how virtualizing backup operations greatly simplifies your ability to save data to a DR site and/or the cloud, and supports streamlined recovery of your data.

We also take a live look at how one virtual tape solution works using deduplication and replication with a technical demo of LaserVault ViTL, a virtual tape and tape library solution for IBM Power Systems.

Verified by MonsterInsights