Title: Administrator Tips
![]() |
![]() |
![]() |
Issue Sponsored By:
> Bytware Inc.
![]()
IN THIS ISSUE:
> How to use DB2's cross-reference files to help manage your database -- Part II
> How to use DB2's cross-reference files to help manage your database -- Part I
> Logical files in different library than physical files
> Utility helps you get information about logical files
> Logical files not restored
> Win a $50 Amazon.com gift certificate
![]()
![]() |
![]() |
| |
![]() |
![AD]() |
![]() |
It's here: The ease of native anti-virus enablement.
i5/OS is now shipping and a fully-functional, 15-day trial of StandGuard Anti-Virus is included. With V5R3, IBM has enabled virus scanning and i5/OS integrates with a native anti-virus solution to provide on-access scanning and cleaning. Virus protection on the iSeries no longer has to be a manual or tedious process. Enjoy the simplicity and peace-of-mind of constant protection from the industry-leading McAfee scanning engine.
StandGuard Anti-Virus. Battle Tested. Battle Proven.
|
| |
|
![]() |
![]() |
![Headlines]()
![]()
How to use DB2's cross-reference files to help manage your database -- Part II
[Search400.com]
Ron Turull
In part I of this series, Ron introduced you to the eight database cross-reference files that the AS/400-iSeries automatically maintains for the database files on your system. In part II he looks at a real-life example of how you can put cross-reference files to work in your shop: locating a logical file to use in an application.
MORE INFO:
> View other tips by Ron Turull
How to use DB2's cross-reference files to help manage your database -- Part I
[Search400.com]
DB2 maintains a number of cross-reference files that you can use to easily retrieve information about files on your system. They contain information on files, fields, keys, referential constraints and much more, and they are easy the work with.
Logical files in different library than physical files
[Search400.com]
Here's a simple way to list logical files where the logical files are in a different library than their associated physical files.
Utility helps you get information about logical files
[Search400.com]
Search400.com expert Tim Granatir provides a utility that allows you to look just at the source member of a logical file and get information about that file immediately.
Logical files not restored
[Search400.com]
One user writes, "In a disaster recovery restore from our SAVLIB *NONSYS the *PRINT report said all the logical files were restored, but the JOBLOG said they weren't. There were a number of object types omitted from the restore completely. These were Data Dictionaries, DTAQs, USRQs and Journals. Can you advice how these should be restored, and how we can get our logical files back?" Site expert Ken Graap responds.
![Also on Search400.com]()
![]()
TOPICS: User poll: Keeping your data center efficiently cooled
Do you struggle with keeping your data center efficiently cooled?
TOPICS: Managing the iSeries Forum -- Interact with other administrators
Are you an iSeries administrator with questions? Join your peers in our Managing the iSeries Forum to ask and answer questions on systems management issues. Search400.com experts frequent the forums and share their expertise.
TIPS: Win a $50 Amazon.com gift certificate
Hurry! Time is running out. Don't miss out on this month's tip contest. We're giving away a $50 Amazon.com gift certificate. Need something special to make your summer a little more exciting? With a gift certificate from Amazon you can get it. Submit a winning tip and treat yourself to something you really want.
|
![]() |
|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Contact Us
Sales
For sales inquiries, please contact us at:
[EMAIL PROTECTED]
Editorial
For feedback about any of our articles or to send us your article ideas, please contact us at:
[EMAIL PROTECTED]
|
|
![]() |
![]() |
|
![]() |
|
![]() |
|
