• Stored procedures allow you to balance network loads – Part II

    In part two of this series on SQL stored procedures, Ron Turull explores how it can help optimize client/server applications, among other things, without bogging down the server. Isn't that the reason you went to client/server in the first place?  Continue Reading

  • SQL defined database: Enjoy the view

    Paul Tuohy provides a simple example to show you how SQL defined views may be of benefit in an existing environment. The easiest way to start using views is with iSeries Navigator, which is what I will be using in the following examples. I will also...  Continue Reading

  • System i security configuration: Restoring

    Once you've got your system backed up, including all of the security information, what's the best way to make sure that all of that security information is restored correctly when you have to do a full system restore? Missing something or getting ...  Continue Reading

  • Retrieve partition ID

    The submitted RPG code retrieves the number of partions and the partition ID. Partition IDs start at zero. The pgm calls API QWCRSSTS. There is a great deal of system statistical information that is available using this API.  Continue Reading

  • Checking database cross-reference files

    There is a simple way to check if your cross-reference files are in error, or if your system objects are in error -- without waiting for crash. Type GO LICPGM, and then option 5 and select verify system objects. If everything is OK, you should ...  Continue Reading