The Four Hundred Archives - Page 874 of 1515

Retrieving and Storing SQL Source for DB2 Database Objects

December 2, 2009 Skip Marchesani

One issue that System i professionals are constantly raising when I’m preaching the gospel of DB2 for i SQL is that it’s difficult, or in some cases, not possible, to capture and store the SQL source statements or DDL (Data Definition Language) that were used to create DB2 database objects on a System i.

This is actually quite easy to do in Navigator using either of two almost identical functions. One is Generate SQL found in Database, and the other will be the focus of this article: Insert Generated SQL found in Run SQL Scripts. For reference, I am running

…

Ken Likes FMTDATE

December 2, 2009 Hey, Ted

I immediately loaded and tested your FMTDATE function when I saw it in Four Hundred Guru. I just wanted to say “Thank You!” The tool is fantastic! We have mostly ISO and LONGJUL dates in our files and it is always a pain when converting or throwing math at them. No more!

Here is an example of some date math I tried on a LONGJUL order date and an ISO invoice date to calculate “Days-To-Ship” using your function:

SELECT fmtdate(OrderDate, 'LONGJUL', 'ISO-') Ordered,
       fmtdate(InvDate, 'ISO', 'ISO-') Invoiced,
       Date(fmtdate(InvDate, 'ISO', 'ISO-'))-
       Date(fmtdate(OrderDate, 'LONGJUL', 'ISO-'))
  FROM ORDERS

–Ken

I got a

…

Admin Alert: Creating a High-Priority Batch Subsystem

December 2, 2009 Joe Hertvik

I recently showed a reader how to create a high-priority batch subsystem on his i5/OS partition. I configured my prototype subsystem to run critical batch jobs at a higher priority than normal batch jobs, so that urgent work received preferential processing when allocating CPU cycles, performing I/O, etc. This week, I’ll demonstrate this technique for any readers who want to create this type of subsystem in their own shop.

The Need

Louis (not his real name) wrote in with an urgent need to run specific batch jobs at a higher priority than other batch work and possibly even higher than

…

Simply Continuous Aims to Narrow ‘Recovery Gap’ with DR Solution

December 1, 2009 Alex Woodie

Simply Continuous recently unveiled a new release of its online disaster recovery (DR) offering, Data Recovery Vault, that allows users to recover the most important data first. Called RecoverNow, the new offering gives users the tools to decide which data sets are the most crucial and should be restored first–an important issue in the first minutes following a disaster. The company, which has been offering its online DR offering since June, also supports OS/400 data through Laservault.

Simply Continuous was founded in San Francisco in 2006 with the goal of filling what its founders, CEO Tom Frangione and CTO

…

ManageEngine Adds i OS Support to Application Performance Tool

December 1, 2009 Alex Woodie

ManageEngine, an Indian developer of systems management software, expanded its i OS repertoire last month with the launch of Applications Manager Release 9. Users of the new software can monitor applications and systems running on IBM i OS servers alongside a range of other operating systems, databases, application servers, and ERP systems. This provides organizations that use System i and Power Systems servers with a powerful solution for monitoring, alerting, troubleshooting, trend analysis, and planning capacity in their heterogeneous IT environments.

In the olden days of IT, when organizations ran monolithic business applications on a single server, troubleshooting performance

…

User Activity Monitoring from PacketMotion to Support i OS

December 1, 2009 Alex Woodie

System i shops that are concerned about the high level of access granted to systems administrators and others, but are hesitant to put controls in place for fear of slowing down transaction times, may want to consider trying out a new agent-less user activity monitoring (UAM) solution that is coming to the platform. PacketMotion recently rolled out support for TN3270 with its appliance-based UAM solution, called PacketSentry, and is close to beginning beta tests for a similar offering that will support the IBM i OS via TN5250.

The practice of over-allocating user credentials is a universal problem. It has been

…

Single-Platform, Technology-Focused Security Unwise Says Ex-IBMer Botz

December 1, 2009 Dan Burger

Pat Botz sees security from the perspective of an entire IT environment. Looking for solutions from a platform-specific point of view is a stumbling block that trips many organizations that attempt to go at this issue from within their platform silos. “When you start looking at where the security issues tend to be,” he says, “they are at the seams where different applications, different platforms, and different networks meet. That is almost always because there is seldom one individual looking at security from an integrated point of view.”

Botz is an ex-IBMer who has worked with a lot of IBM

…

NGS Adds PDF and Excel Report Generation to BI Suite

December 1, 2009 Alex Woodie

Christmas came early this year for customers of New Generation Software (NGS). This week the business intelligence software company unveiled a year-end release of its flagship NGS-IQ suite that contains several handy enhancements, such as generating Excel and PDF reports from i OS data on the fly, and new developer options for embedding queries directly into Web portals and Web sites. The enhancements will go well with all those smartphones stuffed into Christmas stockings this year.

It’s been about six months since NGS debuted NGS-IQ version 7. That release was aimed almost entirely at boosting the product’s capability for the

…

TMW to Give EGL a Chance for i OS App Modernization

December 1, 2009 Alex Woodie

“All we are saying, is give EGL a chance.” You can almost hear the folks in IBM‘s development tool organization in Raleigh, North Carolina, chanting this variation of the old protest song in the hopes of convincing large i OS customers and ISVs to adopt Enterprise Generation Language (EGL) for their application modernization projects. And at least one ISV–trucking software developer TMW Systems of Cleveland, Ohio–is heeding the call, and will give EGL a chance in a pilot project.

TMW develops two RPG-based applications that run on the Power Systems (System i, iSeries, AS/400, i5) platform, including the TL2000

…

System i Hosting Firm Taps CCSS for Systems Management

December 1, 2009 Alex Woodie

CCSS scored a big customer win recently when it announced Connectria, an outsourcing firm with more than 1,000 clients, will be using CCSS software to monitor and manage their System i servers.

Connectria has become a big name in System i outsourcing, and considers System i hosting one of its core specialties. Dozens, if not hundreds, of System i shops have outsourced their entire System i environments to Connectria, or just utilize the company and its nearly two dozen U.S. data centers for disaster recovery purposes.

Now, the St. Louis, Missouri, company is adopting software from systems management software

…

Previous Articles Next Articles

Search for:

Content archive

The Four Hundred
Four Hundred Stuff
Four Hundred Guru

Content archive

Recent Posts

Subscribe

Pages

Search