RE: Damaged IBM Cross Reference Files

["Ketzes, Larry" <Larry.Ketzes@xxxxxxxxx>]

He is doing a lot with SQL tables.  I wish I could isolate what exactly is
the cause, and proactively put some type of 'Best Practice' in.  that is
assuming he is doing something SQL wise that is not 'Best Practice'.

I'll probably open a ticket with IBM.  Maybe a trace will show something.

Larry Ketzes | Senior iSeries System Administrator | ALICO - American Life
Insurance Company
One ALICO Plaza, 600 N. King Street, AMIS | Wilmington, DE 19801 | phone:
302.594.2146 | fax: 302.830.4524 | email: larry.ketzes@xxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Wednesday, July 15, 2009 11:58 AM
To: Midrange Systems Technical Discussion
Subject: Re: Damaged IBM Cross Reference Files

Had it happen once. He must be doing SQL tables or stuff with Referential
Integrity. That is what caused mine.

On Wed, Jul 15, 2009 at 9:48 AM, Chris Bipes
<chris.bipes@xxxxxxxxxxxxxxx>wrote:

> I have never had to run this.  I have been using the iSeries since a B10
> in 1988.  I am now managing 5 system all at V5R3.  I have 2 170's. an
> 820, and 2 520's.  What are you running on your system that is causing
> this to happen?
>
>
>
> Chris Bipes
> Director of Information Services
> CrossCheck, Inc.
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ketzes, Larry
> Sent: Wednesday, July 15, 2009 8:30 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: Damaged IBM Cross Reference Files
>
> Does anyone on this list have a problem with their IBM Cross Reference
> Files
> getting corrupted on a kind of regular basis?  I know how to fix them,
> but
> was curious to see if anyone else had to run the RCLSTG SELECT(*DBXREF)
> more
> than a couple times a year.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.