April 11, 2012 Paul Tuohy
|
In part 1 of this series, I introduced you to the basic functionality of Index Advisor. In this article, we will take a look at more of the options and functionality available with Index Advisor for Systems Director Navigator for i. More Options Apart from the obvious information (table and schema names), the Index Advisor window also gives us some pertinent information, such as:
|
April 11, 2012 Ted Holt
|
Once again, the alert and astute readers of this august publication have proven true the old adage that multiple methods exist for removing the outer covering of a feline animal. Several of you wrote in response to my article, Interpreted CL Members, to share other methods of running CL commands in interpreted mode. Here are some of the comments I received. I use REXX to handle scripting for CL commands. While I’m not an expert, I’ve found it useful for tasks that you do at a command line to set up something, do over and over, and forget the |
April 11, 2012 Hey, Joe
|
I set up a QFileSvr.400 connection for accessing AS/400 Integrated File Systems (AS/400 IFS) objects on another IBM i machine. I use it several times a month to transfer files. All of a sudden, the connection stopped working and I have no clue why. Do you have any idea what could happened and how I can fix it? –Bob As I’ve written before, I love using QFileSvr.400 for accessing, modifying, and copying or moving files between two IBM i systems (Power i, System i, and iSeries). A QFileSvr.400 link is incredibly easy to set up. All you have to do |
April 10, 2012 Alex Woodie
|
VAI last month announced a new release of S2K, its line of IBM i-based ERP software. S2K Enterprise Release 5.0.4 brings dozens of enhancements and fixes across all functional areas of the package, including order entry, purchasing, warehouse management, and CRM. The New York company has also signed the Complete IT Store as its latest reseller. S2K Enterprise Release 5.0.4 (or PTF04 for Release 5.0) is the fourth minor release since VAI shipped the monumental S2K version 5.0 back in 2008. With a brand new GUI, a new portal framework, and support for smart phones, version 5 marked a major |
April 10, 2012 Alex Woodie
|
Connectria Hosting, a longtime provider of IBM i server outsourcing services for some very big names, last week announced that it’s making the leap to hosting public and private IBM i clouds. By early June, the St. Louis, Missouri-based company expects its first IBM i cloud offering, dubbed the Silver Cloud, to be ready for new clients, with rates starting at $495 for one/tenth of a processor on a brand-spanking new Power Systems Model 720 running IBM i 6.1 or 7.1. Connectria Hosting knows a thing or two about running production IBM i environments. For the last 14 years, |
April 10, 2012 Alex Woodie
|
IBM i shops that use more than one Help/Systems tool to automate data center operations can now view the status of multiple Help/Systems products from a single screen, called the Product Metrics Dashboard, which shipped last month with Robot/NETWORK version 11. The company also unveiled a new release of its cross-platform job scheduler, Robot/SCHEDULE Enterprise, that can control batch jobs running on Microsoft SQL Server. Robot/NETWORK is the digital glue that unites various Help/Systems products running on one or multiple IBM i severs. From one instance of Robot/NETWORK, administrators can send out instructions to–and receive feedback from–multiple IBM i servers, |
April 10, 2012 Alex Woodie
|
If you’re in the market for systems management software, but can’t swallow the big license fees and long implementation times of the Big 4, you might want to check out ManageEngine, which purports to offer 80 percent of the functionality of its larger competitors at about 20 percent of the cost. But one functional area where ManageEngine may have an advantage is in the adoption of new technology, such as social media and mobile computing, which ManageEngine is embedding into its products. IBM i shops may know ManageEngine for Applications Manager, which offers the capability to monitor a range |
April 10, 2012 Alex Woodie
|
Application integration is one of those IT disciplines that is begging for simplification. Since the early days of networked business computing, the task of keeping data flowing between applications has been a big pain in the IT department–and a giant source of revenue for service providers. It’s also an area that business process service provider Hubspan sees as a big opportunity to address with its cloud-based integration offering. Hubspan’s flagship platform is a cloud-based integration service called the WebSpan SaaS Integration Platform. The product can be thought of as a hosted EDI translator on steroids. But WebSpan goes beyond moving |
April 10, 2012 Dan Burger
|
Database expertise begins with the ability to analyze database performance and scalability, create new features and functionality, recognize what not to change, and identify where changes are appropriate. And for RPG and COBOL application developers who haven’t already done so, learning SQL and using it to access the DB2 for i (DB2/400) database, is one of the skills that separates the modern programmer from the legacy folks. It’s a foregone conclusion the IBM i shops of the future will have these tools in the shed. It’s with this in mind that System i Developer put together a two-day technical conference |
April 10, 2012 Alex Woodie
|
Information Builders last week unveiled new features in its flagship WebFOCUS business intelligence software that are designed to help it run in a software as a service (SaaS) environment. WebFOCUS deserves special attention by IBM i shops for two reasons. First, it’s one of the few tier-one business intelligence applications that actually runs on the IBM i server. Secondly, it forms the basis of DB2 Web Query, which IBM sells into the IBM i customer base. Many (but not all) features that first appear in WebFOCUS eventually make it into DB2 Web Query, where they can be utilized by a |
