Rdb 7.0 and PH 6.10/6.20

[Kogan, Arthur(50 Pitt)]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01BEDE31.8564A292
Content-Type: text/plain

Hi John.

What kind of locking problems?

There is a little known new feature that was added to PH couple of years ago
specifically for RDB to fix a particular locking problem being experienced
by Telstra here in Australia. It was to do with QUIZ (of all things) locking
a table. The reason was that it ran in a read only transaction, for which
you can not specify the appropriate isolation level. It went something like
this. If there was not anybody accessing the table (I believe it had to be a
large table) at the time Quiz started its transaction, it felt free to lock
the table for efficiency reasons. The new feature was a command line switch
(check with Cognos the exact syntax) that made Quiz use a read/write
transaction, which elliminated this particular type of locking problem.

Hope this helps.

Regards,

Arthur Kogan
Westpac Financial Services
Sydney, Australia

My views are my own and do not necessarily reflect the views of my employer.

> -----Original Message-----
> From:	John Webster [SMTP:john.webster@cdp.co.nz]
> Sent:	Thursday, 5 August 1999 2:06 AM
> To:	'powerh-l@lists.swau.edu'
> Subject:	Rdb 7.0 and PH 6.10/6.20
> 
> Is anyone running PowerHouse 6.10E or 6.20E against Rdb 7.0 ?
> 
> If so, did you experience any locking problems, and how did you resolve
> them?
> 
> (We've got a client who is upgrading to PH 7.10Gx a wee bit at a time - on
> this step they upgraded Rdb only and are experiencing lots of locking
> problems. They are looking at user quotas but are not sure where to
> start...)
> 
> Thanks
> John
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

------_=_NextPart_000_01BEDE31.8564A292
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IiAEAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAdAAAAUkU6IFJkYiA3LjAgYW5kIFBIIDYuMTAvNi4yMACj
BgEJgAEAIQAAADZGRjIwMjkzMUQ0QUQzMTE5NjE4MDAwMDgzMkI2NzUxAM8GASCAAwAOAAAAzwcI
AAQADgAaABwAAwApAQEFgAMADgAAAM8HCAAEAA4AGAAwAAMAOwEBDYAEAAIAAAACAAIAAQOQBgDE
CgAAKwAAAAsAAgABAAAAAwAuAAAAAABAADkAgNwGSjHevgEeAHAAAQAAABkAAABSZGIgNy4wIGFu
ZCBQSCA2LjEwLzYuMjAAAAAAAgFxAAEAAAAbAAAAAb7eLjcQ9qll1UoaEdOeNAAA9rj6EQAAPjvg
AAIBCRABAAAA0gUAAM4FAABtCQAATFpGdVH2TTUDAAoAcmNwZzEyNdIyAPszNgHoIAKkA+MJAgBj
aArAc2V0MB4gBxMCgwBQEFZwcnHeMhFZDlAD1RFlfQqACMhsIDsJbw4wNQKACoF1tmMAUAsDYwBB
C2BuDhAIMDMzC6YgSGkg4EpvaG4uCqIKhAqAFlcQ4AVAawuAZCBvlGYgCQBjGoFnIBKgQm8CYGVt
cz8ZelSSaASQZSAEACBhGvCOaQJAG8AacG5vdwOgcm4H0WZlGlAIcB0QdGkaQndhHUFkAQAasHSg
byBQSCAFoHULULsdEBrReR6gEQAdUGcgEDxzcAWQBpAN4AdAbHljHoAFsVJEQh/yIfB46x1RCrF0
DeB1C2AFwBsNyCBiZRtCZXghsAiBFG5jH9FiIlBUZWw4c3RyHWAc5AOgQXXDJrIdgGEuIEkfRCAB
DmQgEAPwHxAgUVVJeFogKBrRIiEfARtBc34pGvcdYAGRG8AoEBzRIP8JcB9wAiAoVBpCHZAr4AOR
7ydRHWAr8RqxbiJBJsEAgNcA0COwAiAsImN3KjAQ0P8g8AhgIFADkR4ABUAhpC4xuSvBYXAbgRKg
BzB0HRLPBvAaUC7RGvBldiaQKBS/CfAwYQNwESAqMh1xax7y/wQAKBEa4DEBHQEfYjBCAHD6eQbg
ZCJQANAmEAQQG0L3MQIrQymQSSUhHYAysSzi3xDgH+MlMB1SCsBnNzUqgI8aUTcTB3EpQHVpeiGQ
/wGQACAf0R2QKIEuaizxHpD+bDzRCdEf8hsCNwkicgER/w3gJeIiUCv0NLErsh5aH2P9IFFtA4Ea
sB2AHlAhkCkBfS+RKBDQBZA98CkDCFBnvx4ALIIdECWQLqEhkHkCMPxheCqAHxMAwAEAOtQnkPM5
Ei2yL3cFEDHRLlsvZPsmkB2AbQuAMcEf4TSRI3q8dHkhsBrPG9AZa0gxgDM0ZCbxbHA0sBl6UmXy
ZwsRcywZegcQHxAIcLwgS0OgAHAZ1QeQdAqweGMgRkihJgAHMQZSdq8N4AeQGXQGsGQeUHkvAPsn
hxl6TSJQUcAH0B1BHQH+bSJQHhJB0ijRMEIeUDaS9wrAAxA/gmYbwERxMQJUdK9KYVURG9ALUG8h
AHIZa/8K9B2ADzEXkQFAG4Ex0C6woRHkMTYgLVvCTwUQ9mdIoQMgTVZiOYBbwxl2D1rUWqELE1rW
aS0xNMY0AUAdgDE4MAFADNCtX2NiUOADYToMg2IRQDUZIiBQcGImsASQIFvAU01UUDpqGTIzQEFh
80BjZHAuBaAu+G56XRl1YJAGYAIwYPejHNAIcHNkYVLBNSdxImcnkSAxOWbAIDIkOjBboEFNZCdU
bxlg9ydwHhAEkGgtbB5AHYAmsDSwA+BhdS6JCYB1J2QodWJqVzHJYPdSZGCQNy4RQEHS6SAxNi4Y
IC9swAwBXX+/XolaJAzQAcETdG02SR1BZzYAAiAr0XVuAwAbUVDvaNJMUEYSbMJFSlAFwG0S/3LA
IWALcWaBa9YcCzThLCD5LwBkaRqwL8IlmDXiGv/7LwBB0mgeEHWnCXAyETgx1TEBbRwLKFBwJzgx
IXD/NdEgUDgBM2EvYCAQHTEggL8JwB+gNtMgE2wQGCBHI0J7M0AdEGIs8RpRKyE6oi33LfFJBGIB
cDDyIlB8hB/R/2vSLgNB0lTSJZcz8zBQV/PfGw4rkzZRHQEJAG8q1AVAM0YRBcBxdTBQH3FidX81
0R0BMENA8xzjIAE7My7tiHApHBwAcGtSBRkiGXT8PSCK34vvjP+OD45zUhXHauAE8iUwOiAih0CQ
BfsbcGjVIidCB4Fc0iUgNjLfIAEAwGKwCyADcG9pTRl0/lUAgI/5cWCQr5G8ku+T/v9oz2nUHSJO
MDHQH2AhAC3ib10Am+E4wx2QLmlTUaEu/5n2HHYdMWlSHSJ7oEPQCYD/LwBPcSiDmfBmgSABMQJp
UvsvAC/CbWZyOQOV91jmFJECAKPAAAADAP0/UgMAAB4AQhABAAAAIwAAADwwMUJFREU5My4zM0Ux
MTNBMEBQQzEyLmNkcC5jby5uej4AAAsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwAH
gAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADACOACCAGAAAAAADAAAAAAAAARgAAAABShQAA
dBAAAB4AJIAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABQAAADguMDIAAAAAAwAPgAggBgAA
AAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALACmACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMA
DIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwArgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUA
AAAAAAAeADqACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgA7gAggBgAAAAAA
wAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4APIAIIAYAAAAAAMAAAAAAAABGAAAAADiFAAAB
AAAAAQAAAAAAAAADACYAAAAAAAMANgAAAAAAHgAxQAEAAAAPAAAAS09HQU5BMDg3MzhDQzAAAAMA
GkAAAAAAHgAwQAEAAAAPAAAAS09HQU5BMDg3MzhDQzAAAAMAGUAAAAAAAwCAEP////8CAfk/AQAA
AGIAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089V0VTVFBBQy9PVT1XQkMvQ049UkVD
SVBJRU5UUy9DTj1NU01BSUwgQUREUkVTU0VTL0NOPUtPR0FOQTA4NzM4Q0MwAAAAHgD4PwEAAAAX
AAAAS29nYW4sIEFydGh1cig1MCBQaXR0KQAAHgA4QAEAAAAPAAAAS09HQU5BMDg3MzhDQzAAAAIB
+z8BAAAAYgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAYAAAAvTz1XRVNUUEFDL09VPVdCQy9D
Tj1SRUNJUElFTlRTL0NOPU1TTUFJTCBBRERSRVNTRVMvQ049S09HQU5BMDg3MzhDQzAAAAAeAPo/
AQAAABcAAABLb2dhbiwgQXJ0aHVyKDUwIFBpdHQpAAAeADlAAQAAAA8AAABLT0dBTkEwODczOEND
MAAAQAAHMGCP2y8v3r4BQAAIMJKiZIUx3r4BHgA9AAEAAAAFAAAAUkU6IAAAAAAeAB0OAQAAABkA
AABSZGIgNy4wIGFuZCBQSCA2LjEwLzYuMjAAAAAACwApAAAAAAALACMAAAAAAAMABhC1l/gYAwAH
EN4FAAADABAQAAAAAAMAERABAAAAHgAIEAEAAABlAAAASElKT0hOV0hBVEtJTkRPRkxPQ0tJTkdQ
Uk9CTEVNUz9USEVSRUlTQUxJVFRMRUtOT1dOTkVXRkVBVFVSRVRIQVRXQVNBRERFRFRPUEhDT1VQ
TEVPRllFQVJTQUdPU1BFQ0lGSQAAAADpxg==

------_=_NextPart_000_01BEDE31.8564A292--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.