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.
midrange.com
