Recently we implemented the use of RPG beans on the iSeries. Some of us like it, some of us hate it. I think it’s great because I have some exposure to C# and Java.

We also benchmarked it for performance and didn’t find any problems in the iSeries side. We are planning on instantiating the RPG beans from VB apps. Do you know if there are any performance issues from instantiating the RPG beans from a VB application?

Do you know if someone has done any research related to this topic?

–Frank

Hi Frank,

You pose two very good questions:

The Run SQL Scripts function–a.k.a. the SQL Script Center or Script Center–is an easy-to-use option in System i Navigator that allows you to interactively create and execute one or more SQL statements and/or batch CL commands. One of the most frequently asked questions I get is: How do I access or find my tables and views using the Script Center?

Accessing Tables and Views

There are two options for finding or accessing your tables, views, and other database objects from the Script Center. One option is to qualify the object name with the library name in your SQL statement or

One company I deal with has two different high-availability setups that mimic production partitions for its main systems. They’ve been running this configuration for two years, and it’s amazing how many high availability issues occur that have little or nothing to do with basic replication. This week, I’ll look beyond basic replication in building a Capacity BackUp (CBU) system and how these issues can affect failover processing.

The CBU in One Paragraph

A CBU is a specially configured iSeries/System i/Power i machine that communicates with your main production partition to replicate production data and applications by using high availability software