Interrupted load

[zsiadat]

Greetings,

I am dumping and loading (ASCII) a rather large database which takes more than 8 hours to fully load. The sysadmin for the machine I was doing this on has configured RDP to throw me out after a certain amount of inactivity. My problem now is that I am not sure whether the load was completed or not before my session (and with it the load process) got terminated.

Is there any way for me to check if the load was completed or not at the time when I got disconnected? I would prefer not to do the load again, and at the same time I have to be sure that all tables were loaded correctly.

Thanks,
zsiadat

 

[TomBascom]

It depends on how you were doing things. Unfortunately the fact that you're worried about it combined with the 8 hour time-frame suggests that you may have been doing a plain old interactive dictionary load. In that case there may be *.e files laying around that could tell you something.

If you were doing a binary load then you could check the database .lg file.

In any event you have (hopefully) learned:

1) Always script such processes to run in the background.

2) Include copious error checking logging so that you will know if it worked.

3) Never allow admins to run idle process killers.