× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Jim,

When you say geographic mirroring, does that mean that you have mirroring software running on multiple systems to maintain the data? If so, this behavior could be a product of the software if one of the units is configured to be the primary source for the file in question and is scheduled to replicate missing records only.

If mirroring software is not the culprit, the file is not configured to reuse deleted records, no commitment control was used, and you are positive that the file was not restored to it's previous state, the only other thing I can think of is that a process was run against the file to restore deleted records. Since you performed an IPL after the deletions, you may want to check the startup routines.

Tom Armbruster


________________________________

From: rpg400-l-bounces@xxxxxxxxxxxx on behalf of JDHorn@xxxxxxxxxxxxxx
Sent: Mon 1/14/2008 3:20 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: records reappearing after DELETE



I know you are all going to think I am nuts but this really happened.

We have a model 520 using v5r4

on friday
deleted a bunch of records from a file using the delete opcode in an rpg
program.
the delete code was used on a logical file
about 1.5 million out of 7 million

as part of our weekend process I -

on saturday
ran a job from the system console to
put the system in a restricted state
save all/nonsys
ipl

on sunday
restore the file and its logicals from tape to a test library

monday
the deleted records were not in the file in the restored test library,
but they were active again in the production library.
no committment control was used anywhere
using dsppfm I could see the there were deleted records in the file in
the test library based on the -record- heading at the top of the screen.

On monday I re-restored the data from the tape and it was still the same.

I looked at the tape display, and the joblogs to verify that all happened
as above.

Only different thing about us that I can think of is we have geographic
mirroring active on our system.

Anyone ever heard of anything like this?


Original file with records back in it. records 10 and 11 have reappeared.

Display Physical File
Member
File . . . . . . : ICMTK9PF Library . . . . :
CAT
Member . . . . . : ICMTK9PF Record . . . . . :
1
Control . . . . . T Column . . . . . :
1
Find . . . . . .
.
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
00101010 44001010
0200140001
00101010 44001010
0200140010
00101010 44001010
02001400010
00101010 44001010
02001400101
00101010 44001010
020014000101
00101010 44001010
020014001010
00101010 44001010
0200140001010
00101010 44001010
02001400001
00101010 44001010
02001400440
5657040-10 5657040-10 11.75" U-BOLT
010028010-11
702DB51 702DB51 21/64" DRILL BITS
01060901FASTENERS
00101406 44001406 0200150001



Restored file the way it is suppossed to be - records 10 and 11 are
deleted

Display Physical File
Member
File . . . . . . : ICMTK9PF Library . . . . :
CATICMTK9
Member . . . . . : ICMTK9PF Record . . . . . :
1
Control . . . . . T Column . . . . . :
1
Find . . . . . .
.
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
00101010 44001010
0200140001
00101010 44001010
0200140010
00101010 44001010
02001400010
00101010 44001010
02001400101
00101010 44001010
020014000101
00101010 44001010
020014001010
00101010 44001010
0200140001010
00101010 44001010
02001400001
00101010 44001010
02001400440
00101406 44001406
0200150001


Jim Horn
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.