• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • DB2 For i Scalar Function Performance Considerations

    March 5, 2014 Michael Sansoterra

    I love using user-defined functions (UDFs) in DB2 for i. They encapsulate business logic, provide for code modularity and improve code reusability. But they can also flush performance down the drain. So in this tip, I’d like to use a sample UDF to analyze how it can affect the performance of an SQL statement.

    For this illustration, I’ve exported the Microsoft SQL Server Adventure Works sample data to DB2 for i. There are three main tables to consider in this query; SalesOrderHeader (31465 rows), SalesOrderDetail (121317 rows) and ProductCostHistory (22680 rows; I dumped in some extra randomized data into this

    …

    Read more
  • Use Wireshark To Diagnose IBM i Communications Problems

    March 5, 2014 Ted Holt

    Troubleshooting communications problems is akin to dealing with teenagers. There’s plenty of room for blame and finger-pointing, and resolving a problem sometimes seems impossible. I don’t have anything to help you with teenagers, but I can recommend a free tool for communications problems. It’s called Wireshark, and here’s how to use it with IBM i communications traces.

    First, visit www.wireshark.org to get Wireshark. It is a network protocol analyzer that runs under Microsoft Windows and several operating systems of the Unix flavor. Like the best things in life, Wireshark is free.

    Next, install the QSPTLIB library. This is a library

    …

    Read more
  • Admin Alert: Setting Up IBM i TCP/IP Host Routes

    March 5, 2014 Joe Hertvik

    On an IBM i partition, you may need to route IP traffic for a particular server over a specific IP address. You could be doing this to segment network traffic or because you can only reach a host server through a specific interface (say an interface that has access to a firewall). Here’s the drill for modifying your IBM i TCP/IP routing entries to set up host routing.

    The Situation

    The best way to demonstrate how to set up IBM i host routing is by showing you an example. So let’s start with a single IBM i partition with a

    …

    Read more

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle