In my prior tip, I covered some guidelines on when to use scalar user defined functions (UDF) and the potential performance hit they can impose on a query.

In this tip, I’m going to follow up with a few additional guidelines about user defined table functions (UDTFs) in DB2 for i and show how they may impact query performance.

Once again, I’m using data from the Microsoft AdventureWorks sample database that has been exported to DB2 for i. Shown below is a sample UDTF named “Transactions” that combines the data from the transaction history and transaction history archive tables:

Life was so much simpler when terminals and printers ran on twinax, Java was an island or coffee, and all my data was structured in records. I don’t have to fool with wiring at present, and the Java programming language is to me only an occasional, plodding nuisance, but data is a different story.

Unstructured, non-relational data comes at me from all directions at an ever-increasing velocity, and no wonder, as stream I/O is the standard for much of the computing world. (For the benefit of anyone who’s interested, I’ve added a second article to the end of this article.

I read your article on setting up IBM i TCP/IP host routes. But the article only contained green screen commands for host routing. Is there a way to graphically set up IBM i routes?

–Jose

You can graphically work with TCP/IP Host Routes by using the System i Navigator program that comes with IBM i Access for Windows (OpsNav).

To get to a partition’s host routes for IPv4 configurations in OpsNav, open the Network→TCP/IP Configuration→IPv4→Routes node under your target partition. To work with a partition’s IPv6 host routes, open the Network→TCP/IP Configuration→IPv6→Routes node. Your OpsNav tree will look something