Month end preliminary stuff is on its way to being fixed! We’re waiting on a tape backup of our old data which we should have by this afternoon. I fixed the program that bombed, that was easy. Jeff created an index on one of the files that is being read and that simple change decreased run time from 13 hours (as of last month end) to just over 47 minutes! WHOA is right. I woke up with Aaron at 3:30 this morning and tried to go back to sleep but couldn’t. All I could think of was “I hope that program is running because it’s going to take 13 hours to run (I forgot about the index being created)” so I went upstairs, logged into our system and didn’t see it running so then I thought “oh great, it’s not going to even be finished till the end of the day, after I normally leave” which meant that I could not use the reports to help identify which GL entries needed to be reversed! But I did a little more digging and saw that the job had actually completed! My first thought was that my program change caused it to bomb and then I checked to ensure that all my changes made it to PRD and they were all there; the new table had data, more than 10,000 entries like I thought it should (which was why the program bombed in the first place). Then I checked the spooled files for QOTHPRDOWN and there were my three reports! WOO HOO! (I’m a dork). I sent them to report manager and then tried to go back to sleep for about 40 minutes. No go that time either. I just got up and read some more of the 3rd Harry Potter book (Prisoner of Azkaban). I’m almost caught up to the number of HP movies I’ve seen.

Filed under: Work

Like this post? Subscribe to my RSS feed and get loads more!