RPGPGM.COM - The IBM i blog

When you are building SQL DDL Indexes to improve performance it is also imperative to find Indexes that are not being used. Having identif...

I am sure we have all used the Display Database Relations command, DSPDBR , to establish any file's or table's dependent objects. ...

Maintained Temporary Indexes, MTI , are SQL Indexes that have been created automatically by the Db2 optimizer, without any outside interve...

Earlier this year I described a way I could retrieve the schema/library and table/file that a SQL Alias had been built over . over the las...

The task came in: I needed to take many spool files from an output queue and convert them into just one PDF. I have written about converti...

This is a question I am asked enough for me to want to write this so I can direct the askers here. The question is: How can I discover ...

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 ...

When the announcement for IBM i 7.5 was made we were introduced to Merlin . This was made available for IBM i 7.4 TR 6 too. I do not ...

Those of you who have used the SYSCOLUMNS and SYSTABLES views must have noticed that there is a column called LONG_COMMENT . On the part...

September last year IBM announced the first of the Power servers that included the Power10 chips, the E1080 . Today more Power10 based s...

New release IBM i 7.5 and the corresponding Technology Refresh for 7.4, TR 6 , has given us a SQL Table Function that allows us to see in...

It is always a danger that someone will accidentally drop (delete) the wrong file, not maliciously just accidentally. 01 CREATE TABLE...