Skip to main content

View Diary: Cheers and Jeers: Thursday (208 comments)

Comment Preferences

  •  Cheers - it's raining!!! A slow steady rain! (23+ / 0-)

    Cheers - the 'powers' finally saw the light and agreed with us lowly programmers in that what was proposed was not a true parallel test to compare running programs through IMS databases vs DB2 databases - we have the go ahead to do a re-write - instead of mashing the two together and hope to hell that it'll work - eventually.  "They" were willing to take some very serious financial risks that us programmers thought was extremely stupid and preventable.  So, the three of us are now happily going about figuring out what the pgms are doing and re-writing them for DB2 only (yes, we're dorks and like what we do)

    Cheers - there are finally some tv ads by the democrats that counter what the republicans have put up

    Can't think of any jeers right now, other than the Republican party in general are being complete asses

    •  WOW! That is huge! (14+ / 0-)

      Rewriting IS so much easier. Good for you. And job security, even though it isn't the job you want.

      You're getting a lot more rain than we are, I think. It's been skimming just north of here for hours. Now is raining a little.

    •  Congratulations! (5+ / 0-)

      It is so rare for "powers" to comprehend valid and excellent reasoning, as they usually have undisclosed motivations for pushing through solutions we dinosaurs recognize as truly stoopid.

      My DB2 keeps getting rusty as I can't trot it out often enough, but I'm very happy you have permission to ditch the IMS.  I leave it off my resume (along with my brief Honeywell Bull experience) so I don't find myself on an interview path into a dark and painful abyss.  

      Have fun!!!

      "The fears of one class of men are not the measure of the rights of another." ~ George Bancroft (1800-1891)

      by JBL55 on Thu Sep 13, 2012 at 07:10:10 AM PDT

      [ Parent ]

      •  This is my 4th set of conversions from IMS to (4+ / 0-)
        Recommended by:
        JBL55, mjbleo, LoreleiHI, Thestral

        DB2.  IMS is such a pain in the behind!  My first was converting nursing orders/results and I came in half way through that one.  Then I did a conversion of the nursing notes database - wasn't very big over all - just 2.2million records involved and one table.  The third one was converting the 'codes' databases - something like 45 tables of 'codes' that are used to make up a warranty claim.  It was primarily just select call changes.  But, here's the kicker, in round numbers - 45 tables, 350 pgms, and untold packages and binds were speced, coded, tested and implemented in 6 months (there was one release that had a couple of big oopses in it and a couple other had a few really minor things - but when you're moving that fast, things happen - and they thought we weren't moving fast enough).  The current conversion is dealing with the actual claims generated by the previous mentioned codes databases.  There's lots more to it than that, but....  It's 10-15 tables and 75 pgms with everything including general clean up.

        We're using a 'new' feature of DB2 called 'MERGE' to have DB2 decide whether it's being called to do an INSERT or an UPDATE.  Pretty slick, the biggest area that it helps in is the error handling logic stuff - less coding there - the SQL is still about the same though.

        •  I can just picture the checklists! (4+ / 0-)
          Recommended by:
          mjbleo, LoreleiHI, nchristine, Thestral

          Are you using DB2 V9?

          "The fears of one class of men are not the measure of the rights of another." ~ George Bancroft (1800-1891)

          by JBL55 on Thu Sep 13, 2012 at 07:55:21 AM PDT

          [ Parent ]

          •  I beleive so. (4+ / 0-)
            Recommended by:
            mjbleo, JBL55, LoreleiHI, Thestral

            Yes, lots of checklists and spreadsheets.

            •  I went to a presentation of DB2 V9 for z/OS ... (3+ / 0-)
              Recommended by:
              nchristine, LoreleiHI, mjbleo

              ... this past February, and there are a number of new features I would love to play with.

              Unfortunately I'm in the midst of amending a GUI application written in VB5 (no longer supported) using an ancient version (also unsupported) of a screen scraper called Mitem.

              One day I hope to join the rest of the world in the technical vastness of the future.  Until then, I'm just grateful to be employed.

              "The fears of one class of men are not the measure of the rights of another." ~ George Bancroft (1800-1891)

              by JBL55 on Thu Sep 13, 2012 at 08:46:49 AM PDT

              [ Parent ]

              •  Ouch on the VB5!!!! I also know what you mean (1+ / 0-)
                Recommended by:
                mjbleo

                on just being employed.  I'm contract through Volt for a very big yellow earth moving machine company.  Interesting though.  There are lots of companies that have the 'old' stuff and don't know how to convert to 'modern'.  So, it helps that there are still people out there that know how to maintain the stuff.  IT is being taken for granted now and "they" don't realize how much of their companies are completely (or at least very heavily) dependent upon the IT departments to keep running.

                I'm not positive that they're on V9, but definitely V8.

Subscribe or Donate to support Daily Kos.

Click here for the mobile view of the site