Monday, January 22, 2007

Conversion of '07 - Still Processing

Well the ftp and load process is still going at 130 hours, but so far very few errors, and the few that are happening are easily by passable or fixable. I am very pleasantly surprised. Our estimates have greatly increased due to the higher than expected bandwidth use by the users during business hours. If everything continues on track the last file should be sent via FTP on this coming Wednesday morning.

I used a combination of DBMS_META_DATA and CTAS , extracted the create DDL and created the entire database sans data on my laptop and have gotten all of the DDL for the PL/SQL ran and the majority of the objects created. A boatload of errors and uncompiled PL/SQL, but at least it is all there.The project from the oracle end is ticking along nicely.

From the hardware end, well that is another story. The hardware to replace the VMS system oh man, people that say "disk is cheap" need to have their heads examined! To increase the capacity on our SAN to hold this new DB, this includes the drives themselves, a new drive enclosure, cabling, more room on the DAS (more drives) on the tape array to hold near line backup, another 25 tapes for the tape array for the offline/offsite and various odds and ends to make all that happen - initial estimate, $425,000. We almost fell off of our chairs at that. That was just the storage for the DB. The application server estimate from HP via our broker is in, $375,000 and we can't have it for 45 days.


3 comments:

Anonymous said...

Disk is actually cheap. SAN is expensive. Is the cost you cite reflecting an expensive array, switches and HBAs?

Herod T said...

Ok, yes, you are right. Disk is cheap. But 800 gig of disk sitting on my desk, no matter how cheap is useless. Has to be plugged into something.

That was a new HBA/IO box on the SAN as well as some network gear on the backend to where the new app server will be.

Of course some cables are back ordered, slowing everything down.

But at this juncture, it appears the hardware will be the least of our worries.

Anonymous said...

There are so many online data entry jobs in the internet but I would like to take a chance with any reliable company