|
|
|
 |
Issue 200 September 03, 2008 |
|
|
 |
| Help/Systems |
Robot/SCHEDULE®
automates job scheduling and batch management on your IBM® System i™.
Run jobs on a time schedule, in reaction to other events, or after the
completion of prerequisite jobs. Robot/SCHEDULE helps tame service level
agreements and comply with SOX audits, while making operators available
for critical data center tasks. You save time and money, and ensure
smooth, error-free operations.
|
Analyze
Database Index Usage with SYSPARTITIONINDEXSTAT
By
Kent Milligan
As mentioned in the
August 20th issue of the newsletter,
the iSeries Navigator toolset was enhanced in V5R3 with a Show Indexes
task. This new task, commonly referred to as Index Evaluator, provides
more details on which indexes are being used by the DB2 query optimizer
to improve the performance of your queries and SQL requests.
Starting with V5R4, this same information can also be retrieved via a
program using a DB2 catalog view. SYSPARTITIONINDEXSTAT in
library QSYS2 is a view that externalizes this index usage.
*Read
More...
|
 |
Why Is My
Logical File Being Journaled?
By
Dan Riehl
A new Redbook TechNote from Don Zimmerman of IBM
Rochester addresses a surprising change in i/OS 6.1: journaling of
logical files, SQL views, and indexes. The new Logical file journaling
protection in 6.1 is referred to in the Technote as "covert" journaling.
This change will affect you whether you are using the Start Journal
Physical File(STRJRNPF) and Start Journal Access Path(STRJRNAP) commands
or if you are employing System-Managed Access Path Protection (SMAPP).
As you move to i/OS 6.1, you will need to be aware of this new
journaling change to properly manage your system.
*Read
More...
|
| Vision Solutions |
NEW i5/OS and OS/400 management tips each
week! Check out the System Management Tips Blog from Vision
Solutions at visionsolutions.com/itips
to find valuable new tips from the technical experts at Vision. Also get
these delivered automatically via RSS feed or Google or Vista Desktop
widget! Brought to you by Vision Director –
powerful, automated system optimization for IBM i..
|
|
 |
|
Files and Fields – Where Are They Used?
By
Roger Stein
Any time you consider adding or changing a field in a
file, you can quickly get a picture of its usage by using this utility,
which displays Physical Files, Logical files, Display Files, and Printer
file references in programs, service programs, modules, and source code
files.
If you forgot the name of a program you worked on weeks ago, but
remember it used a certain file, this utility can help you locate it. If
you have a situation where a field in a file is getting unusual results,
this utility will help you locate programs that update the file.
The utility can use wildcards so you can retrieve all the references
to file names MASTER and MASTERL1 (etc.) with just one execution of the
command. And as an added feature, you can also display lines of source
code containing a particular field name.
*Read
More...
|
The Magic
Fit: Not Too Fat, Not Too Thin
By
Vicki Hamende
Seeing is believing when it
comes to application development and deployment.
Glenn
Johnson says it, sees it, and believes it. As
senior
vice president at Magic Software Enterprises, he
believes in delivering applications seamlessly
over the
Internet. He sees it happening in a unique
single
development paradigm that removes the need to
manage
multiple programming languages and write
separate client
and server standards. This leaves folks free to
focus on
writing powerful application business logic. To
i types,
this means the power to choose how to deploy
apps--whether full client or web, on-premise or
on-demand, software or Software-as-a-Service
(SaaS), or
global or local.
*Read
More...
|
| Sign Up for
Other System iNetwork Newsletters!
|
|
|
|
|
 |
 |
 |
![sponsorArray[1].sponsorName](http://www.pentontech.com/IBMContent/Images/sponsor/sponsor_alt_12367.gif)
![sponsorArray[2].sponsorName](http://www.pentontech.com/IBMContent/Images/sponsor/sponsor_alt_12393.gif)
![sponsorArray[3].sponsorName](http://www.pentontech.com/IBMContent/Images/sponsor/sponsor_alt_12394.jpg)
|
|
System iNetwork Systems Management Tips
is edited by Dan Riehl and is published every 1st and 3rd Wednesday.
You are subscribed as: #email# (not #email# ? Subscribe
Now.)
For questions, comments, or reader feedback about an item
covered in System iNetwork Systems Management Tips, or if you
have a technical question, please e–mail Dan Riehl,
System iNEWS technical editor. You can also post technical
questions in the SystemiNetwork.com
forums.
Copyright 2008, Penton Media
221 East 29th Street, Loveland, CO 80538
(800) 621-1544
SystemiNetwork.com
To unsubscribe from System iNetwork Systems Managment Tips
newsletter, click here.
To unsubscribe from all e-mail from the System iNetwork, contact customer service or call
(800) 650-1804 or (970) 203-2914.
"System i" is a trademark of International
Business Machines (IBM) Corporation and is used by Penton Media, Inc.,
under license. System iNEWS, SystemiNetwork.com, and the
SystemiNetwork.com newsletters are published independently of IBM, which
is not
responsible in any way for the content. Penton Media, Inc., is
solely responsible for the editorial content and control of System
iNEWS, SystemiNetwork.com, and the SystemiNetwork.com
newsletters.
|
|
|
|