PHDBKEYSCOPE and Rdb

[Walker, Chris]

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_01BE5BF5.543B7350
Content-Type: text/plain

I am interested in the implications of changing the Rdb dbkey scope used by
Powerhouse from ATTACH to TRANSACTION, and I would be grateful for reports
of experience in this area.

The Powerhouse 7.10 release notes seem to imply that setting the scope to
TRANSACTION has no effect on the way Powerhouse uses dbkeys - it just goes
ahead in the hope that they are still valid, and rolls back the transaction
if they aren't.  Is this true?  Can anybody give me any idea how likely such
invalid dbkeys are?

Is there much chance of improving locking performance by changing to
TRANSACTION?

Chris Walker
Tate and Lyle
London

------_=_NextPart_000_01BE5BF5.543B7350
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IgcKAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzwcCABMACgAwABYABQBAAQEggAMADgAAAM8HAgAT
AAoAMAAFAAUALwEBCYABACEAAAA1MjIyNkM2OTdFQzdEMjExODZGQjAwMDhDN0ZBQzFDNAArBwEE
gAEAFQAAAFBIREJLRVlTQ09QRSBhbmQgUmRiAAwGAQ2ABAACAAAAAgACAAEDkAYAdAcAAC0AAAAD
AACACCAGAAAAAADAAAAAAAAARgAAAABShQAAtw0AAB4AAYAIIAYAAAAAAMAAAAAAAABGAAAAAFSF
AAABAAAABAAAADguMAADAAKACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAA4AIIAYAAAAA
AMAAAAAAAABGAAAAAAOFAAAAAAAACwAEgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAAWA
CCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABoAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAA
AAAAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAAiACCAGAAAAAADAAAAAAAAARgAA
AAA2hQAAAQAAAAEAAAAAAAAAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAA
AB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAACAQkQAQAAAEYCAABCAgAA
CQMAAExaRnUxOp5jAwAKAHJjcGcxMjXSMgD7MzYB6CACpAPjCQIAY2gKwHNldDCWIAcTAoB9CoF1
YwBQkwsDC2BuZwHQNTcLpkAgSSBhbSALgHQXBJAHkBQgZBPxIHRoGmUT8G0LUA3gYXRp4wIgBCBv
ZiAQ0RLAC4BCZxTTUmRiIBcAa0hleSAE8G9wFQB1ixEQFJBiF3BQb3cEkDZoCGARECADUhFQVFQI
QUNIFNBvIFRSCEFOUxmgVElPTlosE8BuFJATsHcIYGz/GCEVAAnAFYABEBtgGRAFsc0JcHAJERXT
ZXgXwAiBfG5jFQEUwgQAE8AJcGFuLgqiCoQKgFQU8Rh5N2wuMRFACXBsHqAY8W7ubxQgBCAREGUT
4BnhFSL/F3AU4BWAIaECQBZ2F5QZ7P4gEOAEICFQHUABIAWQBUDzAiAU03dhGFsX8QQgFzNtBCAt
E/AFQGoX8AVAZ+pvB5FhFPBhFJcYwCPSvyKiFOEXcB6BF4AVkGwDIPJ2B0BpZBrEA2ArEAQg6mIA
0GsU03Qb4ACAANAPFZIT8BYAKlZuJ3QuviAToAQgHjMs4ApQPy6Q1kMDkQBweQbgZBdwFmC+dhUA
B4Av0hPwAQBhKaGvB+AVUBdQImFzEhBoE/H3K0Mndh6BPx7aLrMUMTCgvzIyFiId0RXxFSEDYHYW
cv8JACxwFnIdcRxhA4Ed0RhBZxYoGfszm0NoBRAEIFc7B0AXUHIfNRvxGtNMeesg8B7UTAIgZAIg
HtQR0QIAPYAAAAsAAgABAAAAHgBwAAEAAAAVAAAAUEhEQktFWVNDT1BFIGFuZCBSZGIAAAAAAgFx
AAEAAAAWAAAAAb5b9X/AjFH2QscTEdKAbQAIx8XIiwAAQAA5ACAnil71W74BAwDxPwkEAAAeADFA
AQAAAAgAAABXQUxLRVJDAAMAGkAAAAAAHgAwQAEAAAAIAAAAV0FMS0VSQwADABlAAAAAAAMA/T/k
BAAAAwAmAAAAAAADADYAAAAAAAMAgBD/////AgFHAAEAAAA8AAAAYz1HQjthPUlCTVg0MDA7cD1U
QVRFICsgTFlMRTtsPURFWEVYQzAxLTk5MDIxOTEwNDgyMlotNTcxMjIAAgH5PwEAAABYAAAAAAAA
ANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPVNVR0FSL09VPVVOSVRFRCBNT0xBU1NFUyBMT05E
T04vQ049UkVDSVBJRU5UUy9DTj1XQUxLRVJDAB4A+D8BAAAADgAAAFdhbGtlciwgQ2hyaXMAAAAe
ADhAAQAAAAgAAABXQUxLRVJDAAIB+z8BAAAAWAAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAA
AAAvTz1TVUdBUi9PVT1VTklURUQgTU9MQVNTRVMgTE9ORE9OL0NOPVJFQ0lQSUVOVFMvQ049V0FM
S0VSQwAeAPo/AQAAAA4AAABXYWxrZXIsIENocmlzAAAAHgA5QAEAAAAIAAAAV0FMS0VSQwBAAAcw
cDeKXvVbvgFAAAgwUHM7VPVbvgEeAD0AAQAAAAEAAAAAAAAAHgAdDgEAAAAVAAAAUEhEQktFWVND
T1BFIGFuZCBSZGIAAAAAHgA1EAEAAAAyAAAAPDExODhCRUZBNjEzN0QyMTE4NkU0MDAwOEM3RkFD
MUM0MUQyMTc5QERFWEVYQzAxPgAAAAsAKQAAAAAACwAjAAAAAAADAAYQxc0IpwMABxD3AQAAAwAQ
EAAAAAADABEQAAAAAB4ACBABAAAAZQAAAElBTUlOVEVSRVNURURJTlRIRUlNUExJQ0FUSU9OU09G
Q0hBTkdJTkdUSEVSREJEQktFWVNDT1BFVVNFREJZUE9XRVJIT1VTRUZST01BVFRBQ0hUT1RSQU5T
QUNUSU9OLEFOREkAAAAAAgF/AAEAAAAyAAAAPDExODhCRUZBNjEzN0QyMTE4NkU0MDAwOEM3RkFD
MUM0MUQyMTc5QERFWEVYQzAxPgAAAGqQ

------_=_NextPart_000_01BE5BF5.543B7350--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.