Skip to main content

My critical data

Were you to visit my office in Parliament, you would find no paper visible. And if you opened the drawers and the cupboards, very little would be then revealed. What there is, lies between the covers of books. From Tuesday to Thursday, there will be a pile of magazines waiting to be read. What's left unread goes for re-cycling at 1715 on Thursday as I depart for home.

Anything that arrives on paper and whose contents need to be preserved is scanned in and held in "the cloud". That is data storage out there in "internet land". Managed by a commercial company on my behalf. Actually, I am so paranoid that my data are held by multiple companies.

My fears about my data have been with me most of my life. When at primary school, I missed quite a lot of my time there because of illness, I used to have books full of codes. Not for any purpose related to my concealing the content of my writings. Rather, just because I enjoyed manipulating the symbols which are the letters of our alphabet.

I guarded the books with my codes with great care. And regret that somewhere along the road, I have mislaid this evidence of my juvenile endeavour.

Inevitable juvenescence took me to a new all-consuming hobby.

One of my father's close friends, a former desert rat in WW2 and by then a local lawyer, took my father to a bankruptcy sale in Perth. A Manufacturer of sailing dinghies was being wound up. Father returned home with a pram.

That's not something with four wheels, and in more elevated social circles beyond my parents' means, with a nanny attached as motive power. Rather it is (thanks Wikipedia), a small utility dinghy with a transom bow rather than a pointed bow. In short, the front end is blunt.

That started a long love affair with small boats. And led in relatively short order, to our moving from pottering about to racing. This pram came with sails, not wheels.

Once I became skipper of a dinghy, the intensity of my racing increased. In my peak year, I participated in about 400 races. And I maintained books describing each race. That had a genuine utility as should I return to a location, I could review my previous endeavours and their outcomes to inform my tactics.

Let's not overplay my skills. But I did manage to become Scottish Junior Single-Handed Champion at a competition on Forfar Loch. Not quite as impressive as it sounds as the total number of competitors was single figures.

My career peaked in 1967 when after the first day's competition I was in the lead at the Scottish OK Championships. The "OK" was the type of dinghy I was now competing in. And as luck would have it, a camera from STV's Scotsport was present to film the event.

A highlight of my life. Arthur Montford, host of that program, you have to be my generation to remember how revered and mocked in equal proportion he was, wished me all the best for the next day—predictably demoting me to runner-up at the end.

The Champion was Lewis Bilton. His abilities were far beyond my reach and always had been. A series of flukes had promoted me beyond my normal achievement level on day 1.

In those days, Scotland's dinghy racers were not worthy of any comparison with those of other countries. The road to Shirley Robertson's Olympic Gold Medals in Sydney in 2000 and Athens in 2004 was a very long one. It was totally invisible in 1967.

What is today also totally unknown is the whereabouts of my dinghy racing records. I last saw them in our basement about the time of Ms Robertson's Australian success. I continue to hold out hope that I will find them at the bottom of a box in the garage. Unopened from one of our house moves. But probably not.

My first and most alarming encounter with data being mislaid or lost came in January 1971. It was not my data, but its loss could have been catastrophic for my programming colleagues and me.

I have previously written of my early days at Bank of Scotland as a newly engaged trainee computer programmer. I started in October 1969.

My recruitment was part of a quadrupling of the programming workforce at the Bank driven by Government plans to "decimalise" the currency. In May 1969 the Decimal Currency Act (https://www.legislation.gov.uk/ukpga/1969/19/contents) had been passed. The date for moving from Pounds, Shillings (20 in a pound), and Pence (12 in a shilling, 240 in a pound) to Pounds and (new) pence was "baked into" the Bill and was a mere twenty-one months ahead - 15th February 1971.

Although it did not form part of then Opposition leader Harold Wilson's "White Heat of Technology" speech to the Labour Party's conference on 1st October 1963 (http://nottspolitics.org/wp-content/uploads/2013/06/Labours-Plan-for-science.pdf), the move to decimalise the currency was, in my opinion, driven by the general sentiment enunciated in that speech.

For the Bank of Scotland, and for other less technologically advanced banks, the timetable was quite challenging. The Bank had acquired its first accounting machines in the 1950s and by the early 1960s was using proper computers. Hence there were quite a few computer programs needing converted. Thus I, and a cohort I remain part of to this day, were brought in, rapidly trained, and deployed on the conversion.

Two genius ideas assisted our efforts. Douglas S Robb was a highly gifted systems analyst who had caused many of our accounting systems to already process currency internally in a decimal-sterling form. There were "DSR" program segments (sub-routines if you wish) which were widely used in the Bank's programs. DSR cleverly was not just its progenitor's initials but also the name for our "Decimal/Sterling Routine" software.

We started our preparation for decimalisation slightly ahead because of his earlier decisions.

The other idea, I think this came from Jerry Gregson, was to embed into our programs both the process for manipulating the old £sd and new £p currencies that were to swap in 1971. And to have the programs automatically switch their processing mode when they detected the date had reached 15th February. There was another useful wee twist we'll pass by meantime.

That idea meant that as we worked our way through changing our programs, we could implement them in our standard day to day operation as soon as we were ready to. Any errors we had introduced could be dealt with at a measured pace well in advance of decimalisation day.

Banks shut at 1530 on 10th February and reopened at 1000 on the 15th. The intervening period was to allow banks, and others, to convert their systems. The big challenge was the need to print a "closing" bank statement for every account which showed the balance in £sd and then another which had an opening balance in £p.

There were one-off programs which converted the data in our files.

Other banks had the significant challenge of replacing all their computer programs in this five-day window. We didn't.

We completed the task, without any pain, on the Friday after only two day's processing. Other banks didn't quite make it in five.

So back to that data loss in January 1971 which nearly scuppered all our plans.

Overnight, operators in our computer centre mishandled a problem that arose in one of the disk drives on our mainframes. That damaged the majority of our disks and most of the drives that read data from them. While we hadn't lost essential data is was no longer easily accessible to us.

New equipment was sourced from around the world and we recovered in time, just.

But I have been left paranoid about data.

So I back up my data to three of my own computers in three locations. And hold that which really, really matters in two cloud services run by different companies.

All I now need is protection from very big sunspots which have the potential to "zap" every electronic device on the planet.

Any suggestions? Ah - back it up on paper. Good idea.

---------------
A mea culpa. Over the weekend, I had prepared for this week's Environment Committee meeting. Good. However, I had failed to notice that the meeting had moved from its usual slot, for this week only, from Tuesday morning to today (Monday). My diary said Tuesday.

So I was still proof-reading today's diary when Committee clerks contacted me, fortunately before the meeting started.

So the publication of today's diary is late. I have been in a three-hour meeting. Sorry!

Comments

Popular posts from this blog

Settling In

It's now eighteen months since we settled in Edinburgh after a couple of delightful decades in rural Banffshire. Having never lived in a city, we viewed the move with caution and a degree of planning. The car sits relatively idle in residents' parking in our street. It did only about 2,000 miles between its 2021 and 2022 MoT checks. With the nearest Edinburgh City Car Club pickup point just round the corner, I have only to persuade herself that a further conversion of lifestyle would make sense. The garden flat in which we now live suits us fine. Quite a substantial downsize has meant a clear-out of much impedimenta from 50+ years of marriage. And for the first time, we live permanently together. Big changes. With the time to pursue what has been a hobby since the 1960s - genealogical research - that is precisely what has moved centre stage in my daily activities. Enrolment in an MSc course at the University of Strathclyde. Edinburgh is a large village, and on my daily wal...

I don't speak Norwegian

"Jeg snakker ikke norsk"  is the only Norwegian I can speak. And even then, I am told that my pronunciation is so appalling as to render it all but unintelligible to a native of Norway. Word has reached me that Liam Kirkcaldy, humorous writer et al for Holyrood magazine, is scanning the backdrop to my broadcast into Friday's Parliamentary session. This, with the objective of seeing if he can make some funny, or even scabrous, comment on my choice of reading material as seen on the bookshelves behind me. I fear he may be disappointed. Like many of our bookshelves, he will find a predominance of detective novels with an admixture of travelogues, biographies and "Scandic Noire." The really interesting stuff is in another bookcase alongside my armchair in the opposite corner of the room. Accessible without the inconvenience of my having to rise from my seat. So dream on Liam. And out of camera shot. As it happens today, the 20th of April, is the 179th a...

Nature's factory swings into action

Today marks the start of a very different, and much more active, online Parliament. This morning, I shall be part of an informal Rural Economy and Connectivity Committee meeting. In the afternoon, I shall be at a private "set-up" meeting of the new COVID-19 Committee which Parliament agreed to establish yesterday. During tomorrow it's an informal meeting of the Environment, Climate Change and Land Reform Committee. On Friday we have our first formal meeting of the COVID-19 Committee. It's followed in the afternoon by questions to Ministers. The COVID-19 Committee has among its responsibilities, oversight of the new, and rapidly developed legislation brought in in response to the coronovirus epidemic. Some of this is time-limited. There is a requirement for the Government to make various reports to Parliament on how they are using their new, and quite wide-ranging powers. I expect the new Committee will be the first port for these reports. So despite my being req...