RE: blank records in file

Klez did a lot of nasty stuff, but I don't believe it had a data-access
component.

That being said, yes it IS possible for a virus to effect the iSeries.
Before I get flamed here, I didn't say INfect the iSeries, (although I think
that's possible to) I said EFFECT.

Imagine a virus (or trojan or worm etc) that did the following:

For each data source in ODBC
        Connect to data source
                for each file in systables
                        add blank rows to table
                next
        disconnect
Next

Such a "virus" running on a PC would have a disastrous effect on the
iSeries. If you want a worse case remove "add blank rows to table" and
replace with "for each numeric field multiply by .9" and see how long it
takes to find that data corruption.

Having said that I'm not aware of (and a quick search of SARC didn't find
any) viruses that currently do what I'm suggesting, but it is possible.

However, I think it's much more likely that someone did something wrong on
the iSeries. Also, don't you have a unique key on that file? Wouldn't the
second blank record have violated the unique key constraint?

-Walden


------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)



-----Original Message-----
From: bill totz [mailto:robsurge@hotmail.com]
Sent: Monday, July 29, 2002 14:58
To: RPG400-L@midrange.com
Subject: blank records in file




I am experiencing a problem with our database files. We were recently hit
with a klez worm virus 2 weeks ago which did a number on our network and
mail server. We were able to do a full recovery with the exception of
rebuilding the mail server however I am now getting halts do to the fact
that our databas file are being filled with blank records!! We do not write
to these files as they are maually updated tables. For example, I have a
court location file which should have a total of 10 entries-after receiving
an error in the sys op Q stating that my array isn't large enough to handle
the file which it refers to. Upon examining the file I notice that we have
900-1000 records which are blank in addtion to the existing 10!! I don't
believe that klez could affect os/400 or can it?

Thanks



_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

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