• The DB2 DBA: Identifying Indexes with Shared Access Paths

  July 13, 2011 Hey, Mike

  The SysIndexStat catalog view has the column Owning_Index_Owner (plus schema, system names, etc.). However, that catalog view does not include constraint-created indexes, nor does it include keyed logical and physical files that share the access path owned by an SQL index. The DSPFD command does show the SQL index that owns the access path for such logical files, but I have not been able to generate this information in an outfile format from that command. The information must exist somewhere (since it shows on screen) and I would think it would be in one of the file description APIs, but

  …

  Read more

• How Do I Email a PC5250 Screen Shot?

  July 13, 2011 Hey, Joe

  I want to email a PC5250 screen shot. But when I press the Print Screen key, nothing happens. It doesn’t copy my screen to the Windows clipboard and I can’t paste it into my email. What am I doing wrong? I’m using the PC5250 product that comes with iSeries Access V5R4M0. –Jay By default, most Windows programs capture your entire desktop display image to the Windows clipboard when you press the PRT key (on some keyboards, you press the PrtSc key, instead). PRT copies the entire desktop image to the clipboard, including all visible Windows and the Windows toolbar. Alternatively,

  …

  Read more

• Silvon Re-Emerges with Update to Stratum BI

  July 12, 2011 Alex Woodie

  It’s been a while since we’ve heard from Silvon, the Chicago, Illinois, software company that has a long history in the AS/400 market. While the company’s CEO, Mike Hennel, says Silvon never wavered from product development and support commitments, he says it’s now putting more focus on marketing and press relations. This is how we found out about the recently shipped version of its BI product, Stratum version 6, which brings improvements in the areas of user interaction, performance, and advanced analytics for manufacturers and distributors. Silvon didn’t exactly go into stealth mode the last few years, but it’s

  …

  Read more

• DR Testing an Integral Part of RES-Q’s Services

  July 12, 2011 Alex Woodie

  When it comes to disaster recovery, preparation is everything. Most organizations realize that a disaster could happen, which leads them to adopt a tape-based backup solution, at the very least. But a failure to regularly practice the disaster scenario and perform recovery drills will usually result in glitches and gotchas if the real thing were to happen. One IT vendor that is putting a strong emphasis on DR testing and preparation is the RES-Q division of Corus360, which recently expanded its recovery center near Atlanta. Corus360 is a value added reseller (VAR) for all the big tier-one systems manufacturers,

  …

  Read more

• LaserVault Launches Hybrid Cloud Backup Appliance for IBM i

  July 12, 2011 Alex Woodie

  LaserVault recently introduced a new hybrid cloud backup solution for IBM i shops that utilizes a Fibre Channel-connected, Windows-based storage appliance and replication of deduplicated data to Rackspace‘s storage cloud. Called the UBD Cloud, LaserVault says the new offering will appeal to IBM i shops that have large volumes of data to protect, relatively small backup windows, and require off-site storage for disaster recovery purposes. The UBD Cloud is based on the Universal Backup Device, which LaserVault first introduced in late 2010. Priced at about $15,000, the UBD is a Windows Server 2008 box housed with up to

  …

  Read more

• iWay Detects Business Events in Social Network Feeds

  July 12, 2011 Alex Woodie

  New software from iWay Software can combine events occurring on multiple systems, such as an IBM i ERP system and a particular Facebook page or Twitter feed, to trigger the execution of a third event, such as the generation of detailed sales leads from a business intelligence system. The rapid proliferation of social networking websites and technologies is changing how business gets done. Particularly for salespeople, working email and the phone just doesn’t cut it anymore. Potential customers are spending more time with social networking channels, making it a logical place for salespeople and customer support personnel to reach them.

  …

  Read more

• Amazing i Server Survival Story from Australia

  July 12, 2011 Alex Woodie

  If you’ve been involved with the IBM i platform for any length of time, you’ve probably heard stories about the incredible abuse that the AS/400 and its successors can take. Whether it’s water, wind, neglect, or dust, the server just seems to go right on ticking. Now we’re hearing of another amazing feat of disaster recovery from the floods in Australia earlier this year. According to a July 5 posting on the website of the daily newspaper The Australian, a group of employees for a furniture retailers staged a daring rescue of two iSeries servers that were located in

  …

  Read more

• Informatica Addresses the Big Data Problem

  July 12, 2011 Alex Woodie

  Informatica is the latest tools vendor to come out with a suite of tools that help address the problem of “big data.” Last month, the Redwood City, California, company debuted Informatica 9.1, which introduces a number of improvements designed to help companies make sense of massive amounts of data. IBM i shops may know Informatica best for PowerCenter, its extract, transform, and load (ETL) too. The Informatica “platform,” on the other hand, refers to a collection of point tools that address a range of data integration concerns, including master data management (MDM), complex event processing (CEP), B2B data exchanges, cloud-based

  …

  Read more

• Roto Rooter Taps Quadrant for IBM i Fax Solution

  July 12, 2011 Alex Woodie

  Roto-Rooter has successfully started using a new fax solution from Quadrant Software, the vendor announced last week. Roto-Rooter was forced to look for a new fax solution after its old product, IBM Domino Fax for i5/OS, was pulled from the market. IBM announced last October that it would stop selling Domino Fax for i5/OS on January 14, 2011, and stop supporting the offering on April 30, 2012. The announcement provided an opening for vendors like Quadrant Software to fill the void left by IBM’s departure from the market. Quadrant’s replacement for the Domino fax product is FastFax for Domino

  …

  Read more

• Attachmate Updates Fraud Fighting Software

  July 12, 2011 Alex Woodie

  Attachmate recently launched the version 4.2 release of Luminet, its enterprise fraud management (EFM) solution that watches every move that users make on an organization’s servers. The new release should be easier for non-technical personnel to use, and be more accurate in identifying the bad guys. There is an epidemic of fraud in this country that is unlike anything we’ve ever seen. Whereas the morally corrupt may have picked up guns to rob a bank in the old days, today the bad guys are using computers to steal money. And while there will always be some criminal element in human

  …

  Read more

Previous Articles Next Articles