| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2004-05-20 : 12:59:40
|
| Well they already sold it...since it was losing moneyA large Insurance company selling off their Securities firm on the street.Guess what....we get called to archive ALL of their old systems..AND must be responsible for legal and complaince requests for all their data..Systems are a real messQSAM, BDAM, VSAM, CICS, Assembler, SQL Server, INFORMIX, DB2 OS/390...You name it...(actually no Oracle...must have been too complicated for them)Now the question...How?How the hell Do you do this? The Subject Matter Experts are being ejected at light speed?I need to come up with a system transition plan...I'd figure I'd start an invetory list, design an system architect chart...maybe data flow...Of course there is no documentation...or very little...I always heard the brokerage houses flew by the seat of their pants but this ridiculous....Any ideas or sympathy appreciated...Brett8-) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-20 : 13:01:44
|
| ....and why do I get all the crap....at least I company this time out...Brett8-) |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-20 : 13:23:24
|
| >> A large Insurance company>> archive ALL of their old systems>> AND must be responsible for legal and complaince requests for all their dataYou're joking.I recommend a sabatical.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-05-20 : 13:29:48
|
BrettLet the institution formerly known as First Union handle it. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-20 : 13:32:24
|
quote:
Originally posted by nr
>> A large Insurance company>> archive ALL of their old systems>> AND must be responsible for legal and complaince requests for all their dataYou're joking.I recommend a sabatical.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
No joke...And yes, I am making myself extremely busy on other projects...Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-20 : 13:34:50
|
quote:
Originally posted by drymchaser
BrettLet the institution formerly known as First Union handle it.
I wish....did you ever work for an Insurance company Preston?Brett8-) |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-05-20 : 13:50:32
|
| Let's just say I know where your SQL Team user name comes from.You familiar with PRD? It may have been a while back for you. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-20 : 13:59:13
|
quote:
Originally posted by drymchaser
Let's just say I know where your SQL Team user name comes from.You familiar with PRD? It may have been a while back for you.
It is you...thought it might be....What are you doing in Virginia...And I know it's been a while...And let's just say, it's been a blood bath here....Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-20 : 14:00:05
|
| Tell you what...whish I new about SQLTeam back then, when I need info from Rao...oye what a scrub....Brett8-) |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-05-20 : 14:20:39
|
| Took a buyout to return to my home state. Left before the real massacre ensued. I actually miss it some, NJ and the PRD. Contracting down here now which is cool. |
|
|
|
The Enigma
Posting Yak Master
179 Posts |
Posted - 2004-05-20 : 16:45:13
|
| Brett ... now that drymchaser has raised the topic I would really want to know .. where the hell did the handle come from ??? |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-05-21 : 04:47:07
|
simple advice.....print everything....and shove it all into some U-Store-IT facility....and give some immigrant security guard the key.....and walk away.It's a solution....it just may not be an efficient data retrieval mechanism.....but it does satisfy the archival requirements... |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-24 : 13:45:58
|
quote:
Originally posted by The Enigma
Brett ... now that drymchaser has raised the topic I would really want to know .. where the hell did the handle come from ???
It's a mainframe account I've had since 1980....Somewhere it the emergence of Networks, it became my domain account id...Brett8-) |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-05-26 : 17:35:05
|
quote:
Originally posted by X002548
It's a mainframe account I've had since 1980....Somewhere it the emergence of Networks, it became my domain account id...
Riiiiiiight. You expect us to believe that boring story, Brett? Come on! What's the real one? Where's the embarassing reference leading to some secret revelation?--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-27 : 14:46:27
|
| swear to god....may I never have another margarita.....What the hell did I know?drymchaser?Brett8-) |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-05-27 : 15:57:03
|
Mine was X083532 Can't believe I still remember that.  |
|
|
|
|
Business for Sale