RE: [U2] RE: Universe Replication [ad]
[ad] Interesting. We have been toying with the idea of migrating our Visage.DRS product across to UV from D3, but have been unsure of the demand level, especially as IBM have a product (then again, so to RD, but possibly with similar limitations?). DRS gracefully recovers from network interruptions, and you can also suspend updates on mirrored systems, allowing clean backups to be produced. We can also produce a clean replicated system from a dirty backup (ie: backup produced while system is active), support replication to multiple replication servers (subscribers), and keep logs in 4 places to ensure a high level of redundancy. That said, we would have the same limitation on type 1/19 files on *NIX platforms, though I can see a fairly straight forward solution on windows that would work with updates from anywhere. More details here if you are interested, even if only the approach we have used http://www.stamina.com.au/Visage/visageDRS.htm Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Tuesday, 11 December 2007 4:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Universe Replication The problem I ran into with replication (UV on Linux), is that if the subscriber system was off-line or the subscriber process not running, writes on the publisher would cause the writing application to hang and eventually error. Since our goal was to the use subscriber system for reporting as well as testing, this caused a problem whenever the back-up system need to be rebooted or taken off-line. We concluded that we needed something more asynchronous that would allow buffered updates to the back-up system. Other problems, such as managing many published files spread over many accounts, and the fact that type 1/19 files are not replicated, caused us to abandon replication. However, it is likely that IBM has continued to improve replication and my problems may not have been typical. But I am curious if a work-around to allow buffering of updates to the subscriber system was ever developed, because for us that was a stopper. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Dec 10, 2007 4:06 AM, Barry Rogen [EMAIL PROTECTED] wrote: Robin, We attempted (operative word) to embrace Replication for a solution to our needs. We are a little different, in that we are running Unix. We have a D/R system off site and the primary/production box here. Our intentions were similar, to establish a scenario where our second system would not only be our D/R, but allow us to offload many of our reportings from the production system. Data Replication was touted as the solution. A solution that would update our D/R system real time from our production system. If you would like to discuss in further detail, off line, U2's Data Replication solution (in the real world), I would be more that happy to spend some time. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeRoy Dreyfuss Sent: Sunday, December 09, 2007 6:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Universe Replication Hello Robin, 10.2.x is still pretty new, even though it has been out a whole year now. With most busy organizations, uptake on a new release can be pretty slow, so I doubt many folks have it going in a production environment. When I worked for the U2 group, I did quite a bit of testing with replication. It is ideal for what you propose to use it for. In 10.2, the services changed to improve overall replication performance and recoverability after a network outage. If you've never set it up before, there are some things to consider first. For example, how reliable are the file pointers? Can everyone of the file pointers be opened? Are they referencing files that live in other file systems and not where the account itself exists? Replication expects that the files not be UV/NET files and will skip them when you start looking for files within accounts to publish. Like transaction logging, replication ships with TCL verbs to greatly speed up the selection, publish, and subscribe process when there are many files per account to be replicated. They are documented in the UV 10.2 documentation set. I made improvements to two of those programs-- just ping me off-line if you'd like the updated programs. I
RE: [U2] RE: Universe Replication
Is there a replication system that does replicate all file types? Seems to me that not replicating all file types would be a major problem, seeing as many people use type 1/19 files for a variety of reasons. Jerry Banker Sr Programmer Analyst Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org snip That said, we would have the same limitation on type 1/19 files on *NIX platforms, though I can see a fairly straight forward solution on windows that would work with updates from anywhere. snip/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question
Have you checked Ontario Systems? www.ontariosystems.com They use Cache. I can't say how their new stuff works because we have one of their products that is about 15 years old. However, we are still supported, which says a lot for a company. Jerry Banker Sr Programmer Analyst Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 7:24 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] server-side ODBC question We're evaluating phone systems and need to access our UV customer data for call routing. One of the systems (Vertical Televantage) can only communicate with other databases via ODBC. In this scenario, UV would need to be the ODBC server and Televantage the client. Caller ID would be passed to UV, and it would return back whatever customer data we might want to use to route to the appropriate call center agent. Back around '03 I explored something similar with our SQL Server based CRM application and ended up making UV the ODBC client instead. Seems like I couldn't find a way to go the other direction except via a desktop VB app - not in the background as a service. I did successfully connected to UV as an ODBC server from Excel some years back, but again, that was via the desktop. I also remember setting up a separate SQL-ized UV account and Q-pointers back to my Pick flavor account's data to make that work. That was on a different platform and version of UV, though. Has anyone done something similar using ODBC and UV as the ODBC server? Does what I remember about the process still hold true, or am I completely off base? Thanks, John John Hester System Network Administrator Momentum Group (949) 833-8886 x623 http://www.themomgroup.com --- 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/
[U2] WHERE for universe?
Does universe support WHERE (or have an equivalent), I would like to be able to see what a user is doing as well as maybe their stack. Thanks dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] WHERE for universe?
Doug - Check out PORT.STATUS. Run it from the uv account. PORT.STATUS [ USER name ] [ PORT number ] [ DEVICE pathname ] [ PID process# ] [ FILEMAP ] [ LAYER.STACK ] [ MFILE.HIST ] [ LOCK.HIST ] [ { ENABLE | DISABLE } LOCK.HIST ] [ ODBC.CONNECTIONS ] [ LPTR ] [ RUNNING ] [ SUSPENDED ] --- Regards, Robert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Tuesday, December 11, 2007 10:20 To: u2-users@listserver.u2ug.org Subject: [U2] WHERE for universe? Does universe support WHERE (or have an equivalent), I would like to be able to see what a user is doing as well as maybe their stack. Thanks dougc --- 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/
[U2] UV - System melting down due to broken file... [not-secure]
UV 10.0.8 on Solaris 8 I'm desperately trying to get hundreds of users off my system as it is in rapid melt-down mode... smat -s showed the following: Semaphore # 81 -1677721665535 57901 100634 105436 What on earth is a state of -16777216 mean? Mark Hennessey State of Connecticut Department of Social Services Information Technology Services Child Support Systems Voice: 860-424-5261 Fax: 860-424-4813 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Monday, December 10, 2007 6:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} [snip] We have a lot of DTS (SQL Server 2005 SSIS) packages which access our UV databases this way. Mostly it works fine, if at times a little slowly when the tables being extracted are large and the I-Types really complex. Thanks, Mike. Is it possible to write data to UV from the client application when connecting this way? -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
John asked Is it possible to write data to UV [from a remote ODBC client]? I'm not aware of any technical reason why not, but we work really hard to not allow it. :-) So I can't really say Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: Wednesday, 12 December 2007 10:50 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} -Original Message- From: [EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Monday, December 10, 2007 6:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} [snip] We have a lot of DTS (SQL Server 2005 SSIS) packages which access our UV databases this way. Mostly it works fine, if at times a little slowly when the tables being extracted are large and the I-Types really complex. Thanks, Mike. Is it possible to write data to UV from the client application when connecting this way? -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, December 11, 2007 6:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question Have you checked Ontario Systems? www.ontariosystems.com They use Cache. I can't say how their new stuff works because we have one of their products that is about 15 years old. However, we are still supported, which says a lot for a company. Thanks, Jerry. Glancing at their site it looks like they do outbound dialing. We're in need of an inbound call center application on top of an IP-PBX. So far we've looked at Avaya, Cisco, and Vertical. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Tuesday, December 11, 2007 2:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} John asked Is it possible to write data to UV [from a remote ODBC client]? I'm not aware of any technical reason why not, but we work really hard to not allow it. :-) So I can't really say Thanks, Mike. Yes, I would think for most applications you'd never want to. We just need to write caller ID and agent extension into a file somewhere within UV so the agent taking the call can pull up the right account before answering. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] server-side ODBC question {Unclassified}
Type 1/19 files are GREAT for this type of thing! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of John Hester Sent: Wednesday, 12 December 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Tuesday, December 11, 2007 2:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question {Unclassified} John asked Is it possible to write data to UV [from a remote ODBC client]? I'm not aware of any technical reason why not, but we work really hard to not allow it. :-) So I can't really say Thanks, Mike. Yes, I would think for most applications you'd never want to. We just need to write caller ID and agent extension into a file somewhere within UV so the agent taking the call can pull up the right account before answering. -John --- 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] [UV] server-side ODBC question
I'd recommend ShoreTel and Inter-Tel (MiTel). Both seem to beat Avaya. We are currently in the process of deciding between them, or an Asterisk solution (which is looking more and more tempting and not based on cost alone). Karl quote who=John Hester -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, December 11, 2007 6:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] server-side ODBC question Have you checked Ontario Systems? www.ontariosystems.com They use Cache. I can't say how their new stuff works because we have one of their products that is about 15 years old. However, we are still supported, which says a lot for a company. Thanks, Jerry. Glancing at their site it looks like they do outbound dialing. We're in need of an inbound call center application on top of an IP-PBX. So far we've looked at Avaya, Cisco, and Vertical. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo floppy diskfile AD
- Original Message - From: Manu Fernandes [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, December 10, 2007 10:09 AM Subject: RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile Right, But which value to use on which field ? Thanks Manu snip Manu, I am not aware of any way to create a virtual floppy disk on UV/NT, either directly or using UniAdmin. I've tried to do it with UniAdmin and failed because UniAdmin expects an Operating System device, like a physical tape drive or floppy disk drive, and there is none in a virtual floppy disk. Perhaps someone else on the list has the answer. We use three tools for transferring software from generic Pick databases to Universe and Unidata: 1.the d3conv program pre-processes a virual d3 account save into a record that can be restored onto a Universe account using the Universe uvrestore program. 2.AD Our File Caddy programs, TAPE-DUMP and TAPE.LOAD, create multiple T-DUMPs (your choice of any one file to all the files on an account) and then T-LOADs each file onto a Universe account, creating the file as it goes if it does not already exist on the account. /AD Also, mvBase supports virtual files that can have a BLOCK-SIZE of 500. I haven't tried it, but you might be able to T-LOAD a virtual d3 floppy disk file onto an mvBase virtual tape file, but then you will still have to get it from mvBase to Universe. 3. If you are talking just about 1 file or a few files, and if you have access to the machine on which it resides today, I would use either Accuterm or Dynamic Connect/wIntegrate to move the data and/or dict sections of that one file to Universe. If you don't have access to the machine on which this file exists, I would try restoring it onto mvBase and then using Accuterm or Dynamic Connect/wIntegrate to move it to Universe. If you have more than one account, please feel free to contact me off-line if you would like to consider using either d3conv or TAPE.DUMP and TAPE.LOAD, with or without the intermediate transfer to mvBase. AD We also offer SpoolerPlus, our generic Pick print spooler for Universe and Unidata, to eliminate the need to rewrite all the print commands embedded in your D3 (or any generic Pick) software to Universe print commands and giving up your generic Pick print spooler functionality. /AD hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo floppy diskfile
Hi Dave, Thanks for your reply. When I want to transfer a full account, I perform a account-save to a pseudo tape and then on universe I use D3RESTORE which work good. In this case, I got a pseudo tape with a t-dump structure and for it there is no tool into universe. I can look into the code of D3RESTORE and transform it to a D3TLOAD but before do it I search the community for any advice. I'm surprised that nobody use diskfile as a pseudotape, when I read the uv's doc I understand that must be possible but how to define it ? Regards. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Dave Taylor Envoyi : mercredi 12 dicembre 2007 03:17 @ : u2-users@listserver.u2ug.org Objet : Re: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo floppy diskfile AD - Original Message - From: Manu Fernandes [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, December 10, 2007 10:09 AM Subject: RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile Right, But which value to use on which field ? Thanks Manu snip Manu, I am not aware of any way to create a virtual floppy disk on UV/NT, either directly or using UniAdmin. I've tried to do it with UniAdmin and failed because UniAdmin expects an Operating System device, like a physical tape drive or floppy disk drive, and there is none in a virtual floppy disk. Perhaps someone else on the list has the answer. We use three tools for transferring software from generic Pick databases to Universe and Unidata: 1.the d3conv program pre-processes a virual d3 account save into a record that can be restored onto a Universe account using the Universe uvrestore program. 2.AD Our File Caddy programs, TAPE-DUMP and TAPE.LOAD, create multiple T-DUMPs (your choice of any one file to all the files on an account) and then T-LOADs each file onto a Universe account, creating the file as it goes if it does not already exist on the account. /AD Also, mvBase supports virtual files that can have a BLOCK-SIZE of 500. I haven't tried it, but you might be able to T-LOAD a virtual d3 floppy disk file onto an mvBase virtual tape file, but then you will still have to get it from mvBase to Universe. 3. If you are talking just about 1 file or a few files, and if you have access to the machine on which it resides today, I would use either Accuterm or Dynamic Connect/wIntegrate to move the data and/or dict sections of that one file to Universe. If you don't have access to the machine on which this file exists, I would try restoring it onto mvBase and then using Accuterm or Dynamic Connect/wIntegrate to move it to Universe. If you have more than one account, please feel free to contact me off- line if you would like to consider using either d3conv or TAPE.DUMP and TAPE.LOAD, with or without the intermediate transfer to mvBase. AD We also offer SpoolerPlus, our generic Pick print spooler for Universe and Unidata, to eliminate the need to rewrite all the print commands embedded in your D3 (or any generic Pick) software to Universe print commands and giving up your generic Pick print spooler functionality. /AD hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com --- 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/