RE: [U2] Who uses Transaction Logging in Universe ???
We use our own Write to an MS SQL Database on a different server via the SQLExecute(hstmt) routines Then a simple recovery program if we need it Works for us Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Patricia Wilson Sent: 01 November 2006 21:35 To: u2-users@listserver.u2ug.org Subject: [U2] Who uses Transaction Logging in Universe ??? I am investigating using transaction logging on our Universe DB. We are running 10.1.17 on AIX 5.3... * Who uses it - Love it or hate it? * Downsides/Upsides/Gotchyas! * Any 3rd party alternatives? * General Remarks I need the 411 that the Universe PDF neglects to tell you about - Thanks Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Who uses Transaction Logging in Universe ???
Transaction Logging has become very tunable and supports common file-level commands (check out the improvements made in 10.2!), so some of the gotchas mentioned can be made non-issues. Much of the overhead can be tuned away by carefully testing and examining the uvconfig parameters, system disks, system kernel, etc. A little effort ahead of time goes a long way... Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Data Servers [cid:_2_087965DC08796388004FDF598025721A] Tel: 303-773-7783 Fax: 303-773-5915 Mobile: 720-341-4317 Tie-line: 656-7783 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Dan Fitzgerald [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/02/2006 01:17 AM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject RE: [U2] Who uses Transaction Logging in Universe ??? It's working fine. Pretty robust, a lot of the things I thought I'd have to script/configure/modify work right outta the box. Biggest gotcha - if any of your item sizes are larger than 500K, you'll have to run with larger log files, increasing your exposure. If you're not using transaction commits, it doesn't guarantee data integrity. There's a performance penalty, exacerbated by poorly sized files. From: Patricia Wilson [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Who uses Transaction Logging in Universe ??? Date: Wed, 1 Nov 2006 16:35:06 -0500 I am investigating using transaction logging on our Universe DB. We are running 10.1.17 on AIX 5.3... * Who uses it - Love it or hate it? * Downsides/Upsides/Gotchyas! * Any 3rd party alternatives? * General Remarks I need the 411 that the Universe PDF neglects to tell you about - Thanks Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Stay in touch with old friends and meet new ones with Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http ://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.asp xmkt=en-us --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Who uses Transaction Logging in Universe ???
Patricia, What are you trying to accomplish? AIX has a feature called snapshots. The concept with snapshot is COW or copy on write, as opposed to a moment in time of JFS2 filesystem. Cheers, Angelo Collazo System Administrator -Original Message- I am investigating using transaction logging on our Universe DB. We are running 10.1.17 on AIX 5.3... * Who uses it - Love it or hate it? * Downsides/Upsides/Gotchyas! * Any 3rd party alternatives? * General Remarks I need the 411 that the Universe PDF neglects to tell you about - Thanks Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Who uses Transaction Logging in Universe ???
It's working fine. Pretty robust, a lot of the things I thought I'd have to script/configure/modify work right outta the box. Biggest gotcha - if any of your item sizes are larger than 500K, you'll have to run with larger log files, increasing your exposure. If you're not using transaction commits, it doesn't guarantee data integrity. There's a performance penalty, exacerbated by poorly sized files. From: Patricia Wilson [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Who uses Transaction Logging in Universe ??? Date: Wed, 1 Nov 2006 16:35:06 -0500 I am investigating using transaction logging on our Universe DB. We are running 10.1.17 on AIX 5.3... * Who uses it - Love it or hate it? * Downsides/Upsides/Gotchyas! * Any 3rd party alternatives? * General Remarks I need the 411 that the Universe PDF neglects to tell you about - Thanks Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Stay in touch with old friends and meet new ones with Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
