UK Land Registry's Database Size [Kind of off topic]

M. Khalid Khan

UK Land Registry's Database Size [Kind of off topic]
I find it amazing that UK Land Registry would have the largest database in
the world. After all there isn't that much land or that many owners in UK.
Is the registry only for UK or includes Canada, Australia etc ? Do the
people buy and sell a lot ( how is "high real estate transaction velocity"
for a term :)) ? Or is it the rules and regulations that require lots of
data to be kept regarding each transaction ? Then the growth rate isn't
subdued either going from 23 TB to 71 TB in around 3 years. I guess it
just piqued my curiosity.
Khalid




"Cuneyt Goksu(Gmail)" <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
04/28/2011 08:28 AM
Please respond to
IDUG DB2-L <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!






To complement Maja;
I needed latest benchmarks for a presentation a few weeks ago and
collected from DB2 for z/OS Marketing Team.

The latest figures are

- Delivered the largest banking benchmark ever at the Kookmin Bank in
Korea, a record 15,353 transactions per second
- The world?s largest known OLTP database ? 71 TB at UK Land Registry

Details are : http://www.slideshare.net/CuneytGoksu/db2-10-for-zos-update

Cuneyt


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Maja Markotic
Sent: Thursday, April 28, 2011 2:12 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2
shop?!

In his IDUG 2008 Europe presentation "Future DB2 for z/OS Technical
Directions" (session B13) Jeff Josten shared some interesting numbers:

- the largest banking benchmark ever at the Bank of China: 9,445
transactions per second
- the world's largest known peak database workload at UPS: 1.1 billion SQL
statements per hour
- the world's largest known transaction processing database at UK Land
Registry: 23.1 TB

That was back in 2008 though... if I remember correctly, Jeff Jonas shared
more recent numbers during his IDUG 2010 EMEA opening keynote so ask again
after his keynote at IDUG's DB2 Tech conference in Anaheim on Tuesday, May
3 :-)

Maja

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Norbert Wolf
Sent: Thursday, April 28, 2011 11:34 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

Hello,

perhaps you think this is a silly question. How can an company estimate
whether it is a big or small shop? This can be only demonstrated by
comparison with other DB2 z/OS customer.

But if my manager asks me:

- how high is our DB2-MIPS consumption in comparison to other "really big
DB2 z/OS"-shops"?
- or are 80 TB of DB2 data a large amount of DB2 data?
- and other questions more

then I have one big problem:

I am sure that we are now far away from any DB2 z/OS limit (transaction
rate, active connections, etc.). But the best proof of my theory (that we
are no really big DB2 shop) would be a look at "some numbers"
(DB2-MIPS-consumption, used DB2 space, ..) from other DB2 customers.

Perhaps someone can give me a useful hint, there I can get such numbers.
My one investigations (contacting German DB2 Guide, asking vendors, ..)
were not successful yet. Maybe some is able to send me his "the DB2
numbers" .




regards

Norbert Wolf

Datev eG



_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User
Run
Your only source for independent, unbiased, and trusted DB2 information

Disclaimer:
Ova elektronička poruka je povjerljiva i može sadržavati povlaštene
informacije. Ako niste naznačeni primatelj, niste ovlašteni čitati,
printati, pohraniti, obrađivati ili priopćavati ovu poruku. Ako ste ovu
poruku primili greškom, molimo Vas da o tome odmah obavijestite
pošiljatelja i izbrišete ovu poruku, njene privitke i kopije. Zagrebačka
banka d.d. ne preuzima nikakvu odgovornost s obzirom na bilo koju moguću
netočnost bilo kojeg podatka koji je sadržan u ovoj poruci ako takav
podatak nije povezan s registriranim predmetom poslovanja Zagrebačke banke
d.d. Stajališta izražena u ovoj poruci ne odražavaju nužno službena
stajališta Zagrebačke banke d.d. Hvala!
This e-mail is confidential and may also contain privileged information.
If you are not the intended recipient, you are not authorised to read,
print, save, process or disclose this message. If you have received this
message by mistake, please inform the sender immediately and delete this
e-mail, its attachments and any copies. Zagrebacka banka d.d. does not
take any responsibility with regards to any possible inaccuracy of any
data contained in this e-mail if such data do not relate to the registered
operations of Zagrebacka banka d.d. The opinions expressed in this e-mail
do not necessarily reflect the official positions of Zagrebacka banka d.d.
Thank you!

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User
Run
Your only source for independent, unbiased, and trusted DB2 information

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User
Run
Your only source for independent, unbiased, and trusted DB2 information



HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at (312)
653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
Oklahoma; or (972)766-6900 in Texas.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information


Raymond Bell

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to M. Khalid Khan)
Good point.

Owner Percentage of UK Land
Duke of Westminster 95%
Other assorted Royals 4%
Plebs (like me) 1%

3 rows max. Must be pretty long rows...

Cheers,


Raymond

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of M. Khalid Khan
Sent: 28 April 2011 14:56
To: [login to unmask email]
Subject: [DB2-L] UK Land Registry's Database Size [Kind of off topic]


I find it amazing that UK Land Registry would have the largest database in the world. After all there isn't that much land or that many owners in UK. Is the registry only for UK or includes Canada, Australia etc ? Do the people buy and sell a lot ( how is "high real estate transaction velocity" for a term :)) ? Or is it the rules and regulations that require lots of data to be kept regarding each transaction ? Then the growth rate isn't subdued either going from 23 TB to 71 TB in around 3 years. I guess it just piqued my curiosity.
Khalid


"Cuneyt Goksu(Gmail)" <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>

04/28/2011 08:28 AM
Please respond to
IDUG DB2-L <[login to unmask email]>


To

[login to unmask email]

cc

Subject

Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!







To complement Maja;
I needed latest benchmarks for a presentation a few weeks ago and collected from DB2 for z/OS Marketing Team.

The latest figures are

- Delivered the largest banking benchmark ever at the Kookmin Bank in Korea, a record 15,353 transactions per second
- The world's largest known OLTP database - 71 TB at UK Land Registry

Details are : http://www.slideshare.net/CuneytGoksu/db2-10-for-zos-update

Cuneyt


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Maja Markotic
Sent: Thursday, April 28, 2011 2:12 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

In his IDUG 2008 Europe presentation "Future DB2 for z/OS Technical Directions" (session B13) Jeff Josten shared some interesting numbers:

- the largest banking benchmark ever at the Bank of China: 9,445 transactions per second
- the world's largest known peak database workload at UPS: 1.1 billion SQL statements per hour
- the world's largest known transaction processing database at UK Land Registry: 23.1 TB

That was back in 2008 though... if I remember correctly, Jeff Jonas shared more recent numbers during his IDUG 2010 EMEA opening keynote so ask again after his keynote at IDUG's DB2 Tech conference in Anaheim on Tuesday, May 3 :-)

Maja

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Norbert Wolf
Sent: Thursday, April 28, 2011 11:34 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

Hello,

perhaps you think this is a silly question. How can an company estimate whether it is a big or small shop? This can be only demonstrated by comparison with other DB2 z/OS customer.

But if my manager asks me:

- how high is our DB2-MIPS consumption in comparison to other "really big DB2 z/OS"-shops"?
- or are 80 TB of DB2 data a large amount of DB2 data?
- and other questions more

then I have one big problem:

I am sure that we are now far away from any DB2 z/OS limit (transaction rate, active connections, etc.). But the best proof of my theory (that we are no really big DB2 shop) would be a look at "some numbers" (DB2-MIPS-consumption, used DB2 space, ..) from other DB2 customers.

Perhaps someone can give me a useful hint, there I can get such numbers. My one investigations (contacting German DB2 Guide, asking vendors, ..) were not successful yet. Maybe some is able to send me his "the DB2 numbers" .




regards

Norbert Wolf

Datev eG



_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Disclaimer:
Ova elektronička poruka je povjerljiva i može sadržavati povlaštene informacije. Ako niste naznačeni primatelj, niste ovlašteni čitati, printati, pohraniti, obrađivati ili priopćavati ovu poruku. Ako ste ovu poruku primili greškom, molimo Vas da o tome odmah obavijestite pošiljatelja i izbrišete ovu poruku, njene privitke i kopije. Zagrebačka banka d.d. ne preuzima nikakvu odgovornost s obzirom na bilo koju moguću netočnost bilo kojeg podatka koji je sadržan u ovoj poruci ako takav podatak nije povezan s registriranim predmetom poslovanja Zagrebačke banke d.d. Stajališta izražena u ovoj poruci ne odražavaju nužno službena stajališta Zagrebačke banke d.d. Hvala!
This e-mail is confidential and may also contain privileged information. If you are not the intended recipient, you are not authorised to read, print, save, process or disclose this message. If you have received this message by mistake, please inform the sender immediately and delete this e-mail, its attachments and any copies. Zagrebacka banka d.d. does not take any responsibility with regards to any possible inaccuracy of any data contained in this e-mail if such data do not relate to the registered operations of Zagrebacka banka d.d. The opinions expressed in this e-mail do not necessarily reflect the official positions of Zagrebacka banka d.d. Thank you!

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information
< http://www.slideshare.net/CuneytGoksu/db2-10-for-zos-update >


HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at (312)
653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
Oklahoma; or (972)766-6900 in Texas.
________________________________

[ http://www.idug.org/images/stories/Tech/idug-mentor-728.jpg ] < http://www.idug.org/top-spotlight/mentor.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information


Roger Hecq

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to Raymond Bell)
Ah yes, . . but the history. For how many years back to maintain the transactions? (Almost Friday)

Roger Hecq
Associate Director
Corporate Center
Group Technology Infrastructure Services (GTIS)
Mainframe & Midrange Services (MMS)
DB2 Global Services Administration
203-719-0492 / 19-337-0492



________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Thursday, April 28, 2011 10:07 AM
To: [login to unmask email]
Subject: Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]



Good point.



Owner Percentage of UK Land

Duke of Westminster 95%

Other assorted Royals 4%

Plebs (like me) 1%



3 rows max. Must be pretty long rows...



Cheers,





Raymond



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of M. Khalid Khan
Sent: 28 April 2011 14:56
To: [login to unmask email]
Subject: [DB2-L] UK Land Registry's Database Size [Kind of off topic]




I find it amazing that UK Land Registry would have the largest database in the world. After all there isn't that much land or that many owners in UK. Is the registry only for UK or includes Canada, Australia etc ? Do the people buy and sell a lot ( how is "high real estate transaction velocity" for a term :)) ? Or is it the rules and regulations that require lots of data to be kept regarding each transaction ? Then the growth rate isn't subdued either going from 23 TB to 71 TB in around 3 years. I guess it just piqued my curiosity.
Khalid




"Cuneyt Goksu(Gmail)" <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>

04/28/2011 08:28 AM

Please respond to
IDUG DB2-L <[login to unmask email]>

To

[login to unmask email]

cc


Subject

Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!








To complement Maja;
I needed latest benchmarks for a presentation a few weeks ago and collected from DB2 for z/OS Marketing Team.

The latest figures are

- Delivered the largest banking benchmark ever at the Kookmin Bank in Korea, a record 15,353 transactions per second
- The world's largest known OLTP database - 71 TB at UK Land Registry

Details are : http://www.slideshare.net/CuneytGoksu/db2-10-for-zos-update

Cuneyt


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Maja Markotic
Sent: Thursday, April 28, 2011 2:12 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

In his IDUG 2008 Europe presentation "Future DB2 for z/OS Technical Directions" (session B13) Jeff Josten shared some interesting numbers:

- the largest banking benchmark ever at the Bank of China: 9,445 transactions per second
- the world's largest known peak database workload at UPS: 1.1 billion SQL statements per hour
- the world's largest known transaction processing database at UK Land Registry: 23.1 TB

That was back in 2008 though... if I remember correctly, Jeff Jonas shared more recent numbers during his IDUG 2010 EMEA opening keynote so ask again after his keynote at IDUG's DB2 Tech conference in Anaheim on Tuesday, May 3 :-)

Maja

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Norbert Wolf
Sent: Thursday, April 28, 2011 11:34 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS V9 question: are we a big or small DB2 shop?!

Hello,

perhaps you think this is a silly question. How can an company estimate whether it is a big or small shop? This can be only demonstrated by comparison with other DB2 z/OS customer.

But if my manager asks me:

- how high is our DB2-MIPS consumption in comparison to other "really big DB2 z/OS"-shops"?
- or are 80 TB of DB2 data a large amount of DB2 data?
- and other questions more

then I have one big problem:

I am sure that we are now far away from any DB2 z/OS limit (transaction rate, active connections, etc.). But the best proof of my theory (that we are no really big DB2 shop) would be a look at "some numbers" (DB2-MIPS-consumption, used DB2 space, ..) from other DB2 customers.

Perhaps someone can give me a useful hint, there I can get such numbers. My one investigations (contacting German DB2 Guide, asking vendors, ..) were not successful yet. Maybe some is able to send me his "the DB2 numbers" .




regards

Norbert Wolf

Datev eG



_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Disclaimer:
Ova elektronička poruka je povjerljiva i može sadržavati povlaštene informacije. Ako niste naznačeni primatelj, niste ovlašteni čitati, printati, pohraniti, obrađivati ili priopćavati ovu poruku. Ako ste ovu poruku primili greškom, molimo Vas da o tome odmah obavijestite pošiljatelja i izbrišete ovu poruku, njene privitke i kopije. Zagrebačka banka d.d. ne preuzima nikakvu odgovornost s obzirom na bilo koju moguću netočnost bilo kojeg podatka koji je sadržan u ovoj poruci ako takav podatak nije povezan s registriranim predmetom poslovanja Zagrebačke banke d.d. Stajališta izražena u ovoj poruci ne odražavaju nužno službena stajališta Zagrebačke banke d.d. Hvala!
This e-mail is confidential and may also contain privileged information. If you are not the intended recipient, you are not authorised to read, print, save, process or disclose this message. If you have received this message by mistake, please inform the sender immediately and delete this e-mail, its attachments and any copies. Zagrebacka banka d.d. does not take any responsibility with regards to any possible inaccuracy of any data contained in this e-mail if such data do not relate to the registered operations of Zagrebacka banka d.d. The opinions expressed in this e-mail do not necessarily reflect the official positions of Zagrebacka banka d.d. Thank you!

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information
< http://www.slideshare.net/CuneytGoksu/db2-10-for-zos-update >


HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at (312)
653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
Oklahoma; or (972)766-6900 in Texas.

________________________________

Independent, not-for-profit, User Run - the IDUG difference! < http://www.idug.org/top-spotlight/mentor.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


________________________________

Independent, not-for-profit, User Run - the IDUG difference! < http://www.idug.org/top-spotlight/mentor.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information


Adam Baldwin

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to Roger Hecq)
Long rows indeed Raymond. It's the 1:1 scale map of the UK that takes up all of the space....Is it Friday yet?

Cheers, Adam

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Lynne Flatley

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to Adam Baldwin)
Yes, as a matter of fact, it's 12:53 am Friday in Sydney...

On Thu, Apr 28, 2011 at 10:47 AM, Adam Baldwin <[login to unmask email]>wrote:

> Long rows indeed Raymond. It's the 1:1 scale map of the UK that takes up
> all of the space....Is it Friday yet?
>
> Cheers, Adam
>
> _________________________________________________________________
>
> Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
> _________________________________________________________________
> International DB2 User Group (IDUG) - Independent, not-for-profit, User
> Run
> Your only source for independent, unbiased, and trusted DB2 information
>

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information


Raymond Bell

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to Lynne Flatley)
That's OK, then!

And Mate, it may as well be Friday: tomorrow the 3rd-in-line ties the knot with a commoner and us plebeians get the day off. Excellent!

But as Roger pointed out, land records since the Doomsday Book is a few rows methinks, so I can see where 71GB might come from.

Laters,


Raymond

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Lynne Flatley
Sent: 28 April 2011 15:54
To: [login to unmask email]
Subject: Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]

Yes, as a matter of fact, it's 12:53 am Friday in Sydney...
On Thu, Apr 28, 2011 at 10:47 AM, Adam Baldwin <[login to unmask email]<mailto:[login to unmask email]>> wrote:
Long rows indeed Raymond. It's the 1:1 scale map of the UK that takes up all of the space....Is it Friday yet?

Cheers, Adam

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

________________________________

[ http://www.idug.org/images/stories/Tech/idug-mentor-728.jpg ] < http://www.idug.org/top-spotlight/mentor.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information


M. Khalid Khan

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to Raymond Bell)
Good Friday point Raymond but a Thursday answer would be appreciated. Now
coming back to Friday who is this Duke of Westminster and how come he is
higher in pecking order than the Queen ? I guess I'm too ignorant about
these matters in spite of having lived in UK for about a year.
Khalid





"Bell, Raymond" <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
04/28/2011 09:07 AM
Please respond to
IDUG DB2-L <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]






Good point.

Owner Percentage of UK Land
Duke of Westminster 95%
Other assorted Royals 4%
Plebs (like me) 1%

3 rows max. Must be pretty long rows...

Cheers,


Raymond



HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at (312)
653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
Oklahoma; or (972)766-6900 in Texas.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information


Mick P Graley

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to M. Khalid Khan)
They are probably using a very popular European software product that would
use tens of thousands of denormalised tables to store those 3 rows ;-)
Sorry! It is a "virtual" Friday here in the UK due to the impending Royal
Wedding public holiday tomorrow.
I must escape to the semi-punk themed "Never Mind the Royal Wedding" beer
festival down the road soon!

Cheers (and have a good weekend as I'm not here tomorrow),

Mick.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Raymond Bell

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to Mick P Graley)
That wouldn't be the 'European software product' that DEFER YES was invented for, would it? In the immortal words of the great mythical UK PM Francis Urquhart, 'You might think that; I couldn't possibly comment'.

Enjoy your Jonny Rotten-themed imbibation. Go easy on the safety pins, eh? ;o)

'See' you Tuesday after the long weekend.


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Mick P Graley
Sent: 28 April 2011 16:29
To: [login to unmask email]
Subject: Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]

They are probably using a very popular European software product that would
use tens of thousands of denormalised tables to store those 3 rows ;-)
Sorry! It is a "virtual" Friday here in the UK due to the impending Royal
Wedding public holiday tomorrow.
I must escape to the semi-punk themed "Never Mind the Royal Wedding" beer
festival down the road soon!

Cheers (and have a good weekend as I'm not here tomorrow),

Mick.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information

Chris Tee

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to Raymond Bell)

Raymond

I presume you mean DEFINE NO. No public holidays in Belgium, so it's work today, work on Monday. Enjoy your long weekend.

Chris

> Date: Thu, 28 Apr 2011 10:41:04 -0500
> From: [login to unmask email]
> Subject: Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]
> To: [login to unmask email]
>
> That wouldn't be the 'European software product' that DEFER YES was invented for, would it? In the immortal words of the great mythical UK PM Francis Urquhart, 'You might think that; I couldn't possibly comment'.
>
> Enjoy your Jonny Rotten-themed imbibation. Go easy on the safety pins, eh? ;o)
>
> 'See' you Tuesday after the long weekend.
>
>
> Raymond
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Mick P Graley
> Sent: 28 April 2011 16:29
> To: [login to unmask email]
> Subject: Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]
>
> They are probably using a very popular European software product that would
> use tens of thousands of denormalised tables to store those 3 rows ;-)
> Sorry! It is a "virtual" Friday here in the UK due to the impending Royal
> Wedding public holiday tomorrow.
> I must escape to the semi-punk themed "Never Mind the Royal Wedding" beer
> festival down the road soon!
>
> Cheers (and have a good weekend as I'm not here tomorrow),
>
> Mick.
>
> _________________________________________________________________
>
> Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
> _________________________________________________________________
> International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
> Your only source for independent, unbiased, and trusted DB2 information
>
> _________________________________________________________________
>
> Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
> _________________________________________________________________
> International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
> Your only source for independent, unbiased, and trusted DB2 information

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv


Raymond Bell

Re: UK Land Registry's Database Size [Kind of off topic]
(in response to Chris Tee)
Ah, yes. DEFER YES is for indexes only; DEFINE NO is for both TS and IX, plus performs a different function - and the one I was referring to. Good spot.

And I am enjoying my long w/e, thanks. 1.5 days down, 2.5 to go.


Raymond

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Tee
Sent: 29 April 2011 09:41
To: [login to unmask email]
Subject: Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]

Raymond

I presume you mean DEFINE NO. No public holidays in Belgium, so it's work today, work on Monday. Enjoy your long weekend.

Chris

> Date: Thu, 28 Apr 2011 10:41:04 -0500
> From: [login to unmask email]
> Subject: Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]
> To: [login to unmask email]
>
> That wouldn't be the 'European software product' that DEFER YES was invented for, would it? In the immortal words of the great mythical UK PM Francis Urquhart, 'You might think that; I couldn't possibly comment'.
>
> Enjoy your Jonny Rotten-themed imbibation. Go easy on the safety pins, eh? ;o)
>
> 'See' you Tuesday after the long weekend.
>
>
> Raymond
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Mick P Graley
> Sent: 28 April 2011 16:29
> To: [login to unmask email]
> Subject: Re: [DB2-L] UK Land Registry's Database Size [Kind of off topic]
>
> They are probably using a very popular European software product that would
> use tens of thousands of denormalised tables to store those 3 rows ;-)
> Sorry! It is a "virtual" Friday here in the UK due to the impending Royal
> Wedding public holiday tomorrow.
> I must escape to the semi-punk themed "Never Mind the Royal Wedding" beer
> festival down the road soon!
>
> Cheers (and have a good weekend as I'm not here tomorrow),
>
> Mick.
>
> _________________________________________________________________
>
> Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
> _________________________________________________________________
> International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
> Your only source for independent, unbiased, and trusted DB2 information
>
> _________________________________________________________________
>
> Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
> _________________________________________________________________
> International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
> Your only source for independent, unbiased, and trusted DB2 information

________________________________

[ http://www.idug.org/images/banners/banner_728x90.gif ] < http://events.unisfair.com/index.jsp?eid=556&SEID=4595&CODE=idug >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
International DB2 User Group (IDUG) - Independent, not-for-profit, User Run
Your only source for independent, unbiased, and trusted DB2 information