Recipes

Reading a spooled file with SQL

Querying the contents of a spooled file without copying it into a physical file first.

sqlspooldb2

Exporting a file to CSV on the IFS

With the right delimiter and the right encoding, so Excel does not show odd characters.

clifscsv

Converting a CYYMMDD date in SQL

Turning the seven-digit format into a real date with a single expression.

sqldatedb2

Seeing which jobs use the most CPU

What WRKACTJOB shows on screen, but queryable and sortable.

sqljobperformance

Sending mail from a CL program

The shortest command to notify someone when a batch finishes, with no API and nothing to install.

clsmtpbatch

Reclaiming space from journal receivers

They are the first cause of full disks, but deleting them blindly costs you the recovery.

journalspaziobackup

Finding out who holds a lock on an object

The file will not update and the batch is waiting: two commands find the job responsible.

lockjobdiagnosi

Finding out how much space a library uses

And more to the point, which objects inside it are eating the space.

sqlspaziooggetti

Scheduling a job for the last day of the month

Without working out how many days the month has, and without getting leap years wrong.

clschedulazionebatch

The indexes the system suggests, and which to create

Db2 for i records which indexes it would have wanted, one query at a time. Creating them all is the quickest way to slow the database down.

sqldb2performanceindici