Friday, March 16, 2018

New Technical Refreshes released today

ibm i 7.3 tr4 7.2 tr8 made available

The latest IBM i Technical Refreshes for version 7.2 and 7.3, that were announced in February, were released earlier today.

The information about the PTFs can be found here:

One thing to be aware of is that these probably do not contain the PTFs for the latest changes to RPG, these will be released on Monday March 19. These PTFs are listed here.

Wednesday, March 14, 2018

Creating a list of journaled files

make list of files being journaled

"How do we know what files are journaled in library x?" one of the programmers asked me. A straight forward question, but where to find the information?

I could not find reference to journals in either the Db2 for i Views SYSTABLES or SYSTABLESTAT.

I could find a fields for journal information using the Display File Description command, DSPFD, but only in the types of information that I can display or print, not in those that create an outfile.

I might have used an API, QUSLOBJ with format type OBJD0500 or QUSROBJD format OBJD0400, if I only wanted to know about one file, but I want a "list" of files.

Wednesday, March 7, 2018

Creating your own commands, part 2

creating command validation program, help for the commands, and return value to calling program

In the last post, Creating your own commands, part 1, I wrote about a lot of the basics in creating your own IBM i commands. In this post I am going to show how to write a validation program for the command, how to add help, and return a value from a command.

I am going to create a validation program for the command with the file and library I showed in the previous post.

                   File & library (TESTCMD)

Type choices, press Enter.                                  

File . . . . . . . . . . . . . .                Name
  Library  . . . . . . . . . . .     *LIBL      Name, *LIBL

My validation program will check if the file entered exists. Like the program the command calls the validation program is passed one parameter for each parameter the command has. This command will pass a parameter, 20 characters long, that contains the file and library name.

Wednesday, February 28, 2018

Creating your own commands, part 1

creating your own ibm i commands part 1

We have been able to create our own commands, I believe, since the AS400 was first launched. Why would I want to create my own commands?

I create them just for ease of use. In my opinion it is easier to remember:


Than this:


Saturday, February 24, 2018

Searching RPGPGM.COM

I was surprised this week to have received communications asking how to search this website for various words and phrases. I am writing this post so that I can refer people to it, if I am asked this question again.

I can think of three easy ways to find information on this site:


Wednesday, February 21, 2018

Having the source for suggested indexes created for you

using sql to created advised indexes for you

Last year I wrote about using the Db2 for i index advisor to suggest indexes that would improve the performance of your SQL statements. I showed how you could copy data from its results to use to create for SQL statements to create the suggested Indexes. Recently I found a Db2 for i Procedure that makes this so much easier as it will create source members for the suggested Indexes.

I can use the Index Advisor View to see what Indexes are suggested for the FILE1 in the library MYLIB.

02           SYS_TNAME AS TABLE,
08      AND SYS_TNAME = 'FILE1'

Wednesday, February 14, 2018

Making IP connections easier between IBM i partitions

ddm server authority entries

I have mentioned in previous posts regarding using DDM files and configuring remote database connections that there is a difference in using SNA and IP for the connection protocol.

When you use SNA to connect everything performed on the remote IBM i is performed as the user profile QUSER. It is impossible to discriminate between valid requests for the files/tables and others trying to get at data they should not be authorized to.


Tuesday, February 13, 2018

IBM i 7.3 TR4 and 7.2 TR8 announced

ibm i 7.3 tr4 and ibm i 7.2 tr 8 announced

I find it interesting that the announcements of new Technical Refreshes are always made on a Tuesday. After finding empty pages for the new TRs last week it was obvious that the announcement would happen soon. What does the latest announcement contain:

The biggest announcement are the new Power9 chips are coming.

Wednesday, February 7, 2018

Configuring database connection between two IBM i

configuring database connection to another ibm i

In my day job I work in an environment where there are multiple PowerSystems servers, and many of them have multiple IBM i partitions. I was tasked to gather information from most of the partitions into one location. I decided to use SQL to fetch the information from the various sources.

I used the following two methods to connect to the other partitions using the partition name:


When debugging my program I found that when I tried to connect to some of the partitions I received a SQLCOD value of -950 and the following message:

Tuesday, February 6, 2018

New Technology Refreshes are coming

are ibm i 7.3 tr4 and 7.2 tr8 coming soon?

In the past the twice yearly Technology Refreshes updates for the current releases of IBM i were announced in the middle of February and the beginning of October, to coincide with Common USA events.

While Common does not appear to have a Spring conference this year (at the time I am writing this post their website is unavailable), the announcement of IBM i 7.3 TR4 and 7.2 TR8 could still be on track for this month as I have found empty pages for them in IBM developerWork's website.