Re: UniVerse 10 :Network writes not allowed within a transacton.
In a message dated 3/6/2004 10:54:23 PM Pacific Standard Time, [EMAIL PROTECTED] writes: > As far as I know, the u2 databases and some other Pick-like databases do > support some TPM connectivity, but are currently lacking the full functionality > required for the phases of 2pc. > That's not true. You could say, there is no widely accepted and implemented method of doing it. However you can roll your own. I've done it. Will "If you can roll it, you can smoke it" Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse 10 :Network writes not allowed within a transacton.
2pc (two phase commit) requires a DBMS with functionality to support both phases, the voting (preparation) phase and the decision phase. 2pc also requires a TPM (a Transaction Processing Monitor) such as MS-DTC or CICS or WebSphere/MQ. As far as I know, the u2 databases and some other Pick-like databases do support some TPM connectivity, but are currently lacking the full functionality required for the phases of 2pc. There are some well-known problems with 2pc and with various TPM products, but some applications (electronic money transfer, for example) really require 2pc and TPM. Avoid them if you can; use them if you must. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse 10 :Network writes not allowed within a transacton.
In a message dated 3/5/2004 8:13:10 AM Pacific Standard Time, [EMAIL PROTECTED] writes: > The whole point of using transactions is to ensure data integrity. > Writing across a network is a pretty sure-fire way of inviting integrity > problems. > The only way to guarantee that you don't have problems is to ban mixing > the two. Interesting and yes I know this is supposedly banned. But I would think rather than ban it, a two (or three) stage commit could be instituted that would allow it. Or perhaps this would be a four stage commit let's see. 1) Write all the updates to a pending buffer. 2) Transfer any writes for other machines to those other machines. 3) The other machines do the writes, reserving a not yet committed flag. 4) The local machine does its writes the same way. 5) Final step is to trip all the flags ... Something like that anyway. Of course I can see why something that complicated would be outlawed but it seems possible. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse 10 :Network writes not allowed within a transacton.
I believe you will find that this is one of the things documented as being prohibited while a transaction is active. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse 10 :Network writes not allowed within a transacton.
The whole point of using transactions is to ensure data integrity. Writing across a network is a pretty sure-fire way of inviting integrity problems. The only way to guarantee that you don't have problems is to ban mixing the two. If you investigate the NFS protocol (which I guess your remote system is using?) you will find that it explicitly guarantees that the integrity of the link CANNOT be trusted. Now I think you see why transactions forbid its use ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Sent: 04 March 2004 03:08 To: U2-users Subject: UniVerse 10 :Network writes not allowed within a transacton. Dear U2 Users, Is anyone having idea regarding the uniVerse 10 when apply the Begin/End Transaction, it do not allow to write to the remote file. Once execute the program , it prompt the belowing messages Network writes not allowed within a transacton. Is it the security of the Database ? For eg , From Server A , having a program as below to access the remote file of Server B ( ie ASY.FV ) which is code within the Begin / End Transaction ... READU REC FROM ASY.FV , ID ELSE CRT "ERROR READ FILE" EXIT BEGIN TRANSACTION REC<1> = "TEST" : X WRITE REC TO ASY.FV,ID ELSE CRT "FAIL WRITE REC" END IF ( P.ERROR ) THEN ROLLBACK END COMMIT END TRANSACTION RELEASE ASY.FV Error message is as follow FATAL: Network writes not allowed within a transacton. rolling back uncommitted transactions begun within this execution environment. Thanks and Regards DISCLAIMER:- <> -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse 10 :Network writes not allowed within a transacton.
Dear All,
We do install the UV/NET. Even I can edit the remote file and save
it. Only unable to write if combine with the BEGIN TRANSACTION / END
TRANSACTION statement
Regards
Ang
-Original Message-
From: Hona, David S [SMTP:[EMAIL PROTECTED]
Sent: Thursday, 04 March, 2004 11:43 AM
To: 'U2 Users Discussion List'
Subject: RE: UniVerse 10 :Network writes not allowed within a
transacton.
Do you have UV/Net installed on the remote server? Or are you using
NFS?
Apparently, you can't write to remote 'recoverable' (via UV/Net)
files,
during a transaction. I can't see any other restrictions, regarding
UV/Net
accessible files.
Regards
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Ang Suan Yong
Subject: UniVerse 10 :Network writes not allowed within a
transacton.
Dear U2 Users,
Is anyone having idea regarding the uniVerse 10 when apply
the
Begin/End Transaction, it do not allow to write to the remote file.
Once
execute the program , it prompt the belowing messages Network writes
not
allowed within a transacton. Is it the security of the Database ?
For eg , From Server A , having a program as below to
access the
remote file of Server B ( ie ASY.FV ) which is code within the
Begin / End
Transaction
...
[snip]
Error message is as follow
FATAL: Network writes not allowed within a transacton.
rolling back uncommitted transactions begun within this execution
environment.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
DISCLAIMER:-
<>
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse 10 :Network writes not allowed within a transacton.
Do you have UV/Net installed on the remote server? Or are you using NFS? Apparently, you can't write to remote 'recoverable' (via UV/Net) files, during a transaction. I can't see any other restrictions, regarding UV/Net accessible files. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Subject: UniVerse 10 :Network writes not allowed within a transacton. Dear U2 Users, Is anyone having idea regarding the uniVerse 10 when apply the Begin/End Transaction, it do not allow to write to the remote file. Once execute the program , it prompt the belowing messages Network writes not allowed within a transacton. Is it the security of the Database ? For eg , From Server A , having a program as below to access the remote file of Server B ( ie ASY.FV ) which is code within the Begin / End Transaction ... [snip] Error message is as follow FATAL: Network writes not allowed within a transacton. rolling back uncommitted transactions begun within this execution environment. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniVerse 10 :Network writes not allowed within a transacton.
Dear U2 Users, Is anyone having idea regarding the uniVerse 10 when apply the Begin/End Transaction, it do not allow to write to the remote file. Once execute the program , it prompt the belowing messages Network writes not allowed within a transacton. Is it the security of the Database ? For eg , From Server A , having a program as below to access the remote file of Server B ( ie ASY.FV ) which is code within the Begin / End Transaction ... READU REC FROM ASY.FV , ID ELSE CRT "ERROR READ FILE" EXIT BEGIN TRANSACTION REC<1> = "TEST" : X WRITE REC TO ASY.FV,ID ELSE CRT "FAIL WRITE REC" END IF ( P.ERROR ) THEN ROLLBACK END COMMIT END TRANSACTION RELEASE ASY.FV Error message is as follow FATAL: Network writes not allowed within a transacton. rolling back uncommitted transactions begun within this execution environment. Thanks and Regards DISCLAIMER:- <> -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
