• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Startup Delivers Database Tools for OS/400 HA Environments

    November 16, 2004 Alex Woodie

    One of the challenges of running an OS/400 high availability environment is ensuring that data and objects are always in synch. If you let them get out of synch, it exposes your business to the possibility of downtime and can take hours to track down and fix. Two former employees of an HA software vendor recently founded Shane Software to provide graphical tools to help administrators ensure that their HA environment is in synch, and track down and fix the problem if it’s not.

    Shane Software is an IBM business partner located near Irvine, California. The company was founded in June by two former Vision Solutions employees, Randy Adamski and Billy Molintas.

    “A lot of the HA vendors guarantee that the underlying data is correct, but they don’t really look at the object-level stuff,” Adamski says. “The HA vendor might come out and say, ‘You’re in synch.’ But we’re offering you a third option . . . to provide you with peace of mind.”

    Specifically, Adamski says, the major HA packages that he knows of don’t check things like referential integrity and physical/logical database relationships in determining whether objects are in synch or out of synch. While there are IBM utilities and commands to find this information, they are based in the green-screen world, limited in their scope, and are not easy for non-programmers to use.

    “A lot of customers didn’t understand what constraints were. They just trusted you to know what you were doing,” Adamski says. “My partner and I developed these tools to help people like that to find this information on their own.”

    THE J. WIZARD SUITE

    Shane Software currently offers three products in its j.Wizard suite, including jConStraints, JDBR, and jReOrg. The first two products, jConStraints and JDBR, help administrators with referential constraints and database file relationships and are being targeted at administrators in OS/400 high availability shops, although they are applicable to other scenarios. The jReOrg is a physical file reorganization utility for reclaiming underused DASD.

    JConStraints Version 1.1 is the flagship of the j.Wizard suite. This product, which costs $1,295, reveals referential constraints in DB2/400, and maps all generations of parent/child relations. It is useful for ensuring that database referential integrity is in an acceptable state, for tracking down database constraint violations, and for verifying that HA software is correctly mirroring referential integrity constraints, the company says.

    While IBM already helps users find constraint violations with the WRKPFCST command, viewing this sort of information through a green screen is tedious and time-consuming, Adamski says. “Some of the information [provided by WRKPFCST] is kind of cryptic, and we take that and turn it into English,” he says.

    Additionally, whereas the WRKPFCST command displays only six columns of information, jConStraints displays 10 columns, which is used to provide information on the parent file, library, and update and delete rules. Other advantages of the product include the capability to download data to spreadsheets and the addition of a mapper feature that displays parent/child relations in a Windows-like tree view.

    The jDBR tool was also designed to help users ensure that their database objects are properly in synch. This product, which Adamski calls “Display DBR on steroids,” can display the relationship of the physical files to the logical files in the iSeries database. “Currently there’s no way to do that” using IBM tools, he says. The jDBR costs $995.


    The third and final member of the j.Wizard suite is jReOrg Version 1.1. This product, which costs $495, is a graphical implementation of IBM’s Reorganize Physical Files command, used for purging placeholders for deleted records. This product enables users to reorganize individual or multiple files, or entire libraries, logical partitions, or systems, with a few clicks of a mouse.

    The jReOrg also provides a few little bonuses of its own. For example, the product will only show you which files have deleted records in them, Adamski says. It also lists files in order of which ones have the most deleted records in them. The jReOrg also doesn’t require users to recompile their file reorganization programs or update a database control file when new libraries are added, which is typically the case with CL and RPG programs.

    All of Shane’s software is written in Java and runs on standard Windows PCs. The j.Wizard suite works with OS/400 V4R5 and later and requires a TCP/IP connection to the AS/400 or iSeries. For more information and trial downloads, go to www.shanesoftware.com.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    PERFSCAN

    Revolutionary Performance Management Software

    At Greymine, we recognize there is a void in the IT world for a dedicated performance management company and also for a performance management tool that’s modern, easy to use, and doesn’t cost an arm and a leg. That’s why we created PERFSCAN.

    PERFSCAN is designed to make your job easier. With revolutionary technology, an easy-to-read report and graphics engine, and real time monitoring, tasks that used to take days can now take minutes. This means you will know your system better and will be able to provide better service to your customers.

    OUR FEATURES

    PERFSCAN is full of robust features that don’t require you to take a three-day class in order to use the product effectively.

    Customizable Performance Reporting

    Whether you are troubleshooting a major system problem or simply creating a monthly report, PERFSCAN lets you select any combination of desired performance metrics (CPU, Disk, and Memory).

    User Defined Performance Guidelines

    No matter if you are a managed service provider managing complex systems in the cloud or a customer analyzing your on-premises solution, PERFSCAN gives you the flexibility to define all mission critical guidelines how they need to be.

    Understanding The Impact Of Change

    Tired of all the finger pointing when performance is suffering? PERFSCAN’s innovative What’s Changed and Period vs. Period analysis creates a culture of proof by correlating known environmental changes with system performance metrics.

    Comprehensive Executive Summary

    Creating performance graphs is easy. Understanding what they mean is another thing. With one mouse click, PERFSCAN includes an easy-to-understand executive summary for each core metric analyzed.

    Combined Real-Time Monitor And Performance Analysis Tool

    With PERFSCAN’s combined built in enterprise real-time monitor and historical performance analysis capability, you will always know how your mission-critical systems are performing.

    Cloud Performance Reporting Is Easy

    Managing performance for production systems in the cloud can be a black hole to many system administrators. The good news is PERFSCAN analyzes all core metrics regardless of the location. That’s why MSPs and customers love PERFSCAN.

    Detailed Job Analysis

    PERFSCAN shows detailed top job analysis for any desired period. All metrics are displayed in two ways: Traditional Report and Percentage Breakdown Pie Chart. This toggle capability instantly shows the jobs using the most system resources.

    Save Report Capability

    Your boss lost the report you gave to him on Friday. Now what do you do? With PERFSCAN’s save report capability, any report can be retrieved in a matter of seconds.

    Professional PDF Reporting With Branding

    Creating professional looking reports for your customers has never been easier with PERFSCAN. Branding for our partners and service provider customers is easy with PERFSCAN.

    Check it out at perfscan.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Mad Dog 21/21: Vow Tipping Discover the DBVisualizer

    Leave a Reply Cancel reply

Volume 4, Number 46 -- November 16, 2004
THIS ISSUE
SPONSORED BY:

LANSA
AURA Equipments
iTera
Bytware
Affirmative Computer

Table of Contents

  • PGM Provides Springboard for iSeries Web Development
  • Startup Delivers Database Tools for OS/400 HA Environments
  • Expand’s New Data Acceleration Technology Proves Fast in Tests
  • Linoma Offers PGP Studio with Data Transfer Tool

Content archive

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

Recent Posts

  • Fortra Issues 20th State of IBM i Security Report
  • FNTS Launches Managed Services for Power Servers in IBM Cloud
  • Total LTO Shipped Capacity Up Slightly in 2022
  • Four Hundred Monitor, May 24
  • Update On Critical Security Vulnerability In PowerVM
  • Critical Security Vulnerability In PowerVM Hypervisor
  • IBM Power: Hosted On-Premises Or In The Cloud?
  • Guru: Watch Out For This Pitfall When Working With Integer Columns
  • As I See It: Bob-the-Bot
  • IBM i PTF Guide, Volume 25, Number 21

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 © 2023 IT Jungle