[U2] UVODBC on AIX
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Hello All, I visited a customer site the other day to find that our installation person has installed the Universe software on an AIX server but not done anything with the UVODBC. I get an error from the client driver that the daemon isn't running. I reported this to our installer and he pretty much left me to it claiming not to know anything about it. Nice My knowledge of installing Universe is limited to a couple of times on an NT server, so this is being dropped on me and I need some advice. Anyway, is anyone able to point me in the direction of information on this please or able to point out what could be wrong here. I have run the Config command and can see the UVODBC is installed and licensed, but the client still reports it not to be running. Thanks Andy Moore Selima Software Ltd Tel: 0114 2815000 Fax: 0114 281 email: [EMAIL PROTECTED] Support: http://tracker.selima.co.uk http://tracker.selima.co.uk/ Forum: http://forum.selima.co.uk http://forum.selima.co.uk/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC on AIX
The daemon that UVODBC on AIX uses is the uvrpcd and this is defined in the /etc/services file. The daemon should automatically start following a boot / reboot of the server. The UVODBC group needs to be included as part of the UniVerse installation process. It is also worth doing a netstat -a |grep rpc to see what state it is in. I would be inclined to change your installer and start using your Support Provider! ;) Pete Dick Technology Support www.epicor.com This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC on AIX
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Our installer is a member of staff employed by us, I am sure a swift kick when I next see him will make sure he keeps up with his installations in the future so I don't look like an idiot when ariving on site. As for our support provider, I think they (you) may be getting a call shortly if this doesn't start working when I take a look at it. Thanks Andy Moore Selima Software Ltd. -Original Message- From: Peter Dick [mailto:[EMAIL PROTECTED] Sent: 31 October 2005 12:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC on AIX The daemon that UVODBC on AIX uses is the uvrpcd and this is defined in the /etc/services file. The daemon should automatically start following a boot / reboot of the server. The UVODBC group needs to be included as part of the UniVerse installation process. It is also worth doing a netstat -a |grep rpc to see what state it is in. I would be inclined to change your installer and start using your Support Provider! ;) Pete Dick Technology Support www.epicor.com This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- 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] SQL Server Data Access
Have a look at the UniObjects docs on your client cd. There are examples in vb and java. I've done links with vb6, c# and java. It's all good. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] SQL Server Data Access
Hi David, Well basically all that we require is the ability to interrogate a SQL Server and download any data that is applicable for updating on our UV database, and then reverse the process going from UV to SQL server. Thanks Sunny. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Tod Sigafoos Sent: 29 October 2005 02:05 To: Sunny Matharoo Subject: Re: [U2] [UV] SQL Server Data Access Sunny, SM I know this may have discussed before but has anyone developed a VB SM interface between SQL Server and UV. what kind of 'interface' are you looking for? UV has a connection that works well with SqlServer so possibly before we get a lot of code generated you describe better what exactly you are looking to do -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ --- 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] AIX Backup, Format Disk, Restore
Does anyone out there still do this (if you ever have)? Take a backup of the file systems (in our case, AIX UNIX), format the disks clean, then restore the data back down to lay it back contiguous. Are there any (noticeable) I/O advantages to doing this for a UniVerse database on today's servers? Provided our files are properly sized, of course. Our Systems guys are itching to do this. Thanks, Gary P. Canedy Database Analyst ProMutual Group (617) 757-6775 --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Status of a WRITE to a Type 1 File
We're using Universe 10.0.10.0 on Win 2000 Server. I need to determine when a Basic WRITE Statement of a record to a Type 1 file has completed so I can execute a subsequent action on the record written, but not before all the data in the record has been written. These can be large records requiring various numbers of seconds to write so I'm uncomfortable using a defined-length SLEEP command. TIA, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Status of a WRITE to a Type 1 File {Unclassified}
Dave, It can take 'numbers of seconds' to write? Phew, they must be b--i--g records! Could you consider changing from WRITE to WRITESEQF? And maybe from Type 1 to Type 19? If the 'subsequent action' is inside the UniVerse environment, I would expect that the program would access the copy buffered in memory anyway, regardless of whether it had yet been flushed to disk. If the 'subsequent action' is outside the UniVerse environment, then I would hope that a WRITESEQF would not return control to the next statement in the Basic program until the write was complete. If Windows lies to UV about that, and gets confused when another process tries to access the not-quite-written data, hmm ... You could try writing two files, one a flag, the other the data: - Write flag, status 'in process' - Write data - Write flag, status 'done' And the consumer process waits on the flag 'done' before trying to read the data. That might serialise the I/O for you. HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Tuesday, 1 November 2005 08:53 To: u2-users@listserver.u2ug.org Subject: [U2] Status of a WRITE to a Type 1 File We're using Universe 10.0.10.0 on Win 2000 Server. I need to determine when a Basic WRITE Statement of a record to a Type 1 file has completed so I can execute a subsequent action on the record written, but not before all the data in the record has been written. These can be large records requiring various numbers of seconds to write so I'm uncomfortable using a defined-length SLEEP command. TIA, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com --- 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] Status of a WRITE to a Type 1 File
Do you have something external waiting on this record to appear? If so, you might consider writing out the record out under a temporary name and then renaming it to a name that your watcher is looking for. We do this all the time with drop file interfaces; write the record with a .tmp extension and then change it to an .out extension (via !ren) once the record has been completely written. Your watcher would then only pick up the files with an .out extension. Possible? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Monday, October 31, 2005 12:53 PM To: u2-users@listserver.u2ug.org Subject: [U2] Status of a WRITE to a Type 1 File We're using Universe 10.0.10.0 on Win 2000 Server. I need to determine when a Basic WRITE Statement of a record to a Type 1 file has completed so I can execute a subsequent action on the record written, but not before all the data in the record has been written. These can be large records requiring various numbers of seconds to write so I'm uncomfortable using a defined-length SLEEP command. TIA, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.6/151 - Release Date: 10/28/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] AIX Backup, Format Disk, Restore
If you are using AIX you can gain pretty much the same defragmentation advantage, however slight it might be, by using the built in filesystem defragment on AX 4.x and above: smit: System Storage Management (Physical Logical Storage) File Systems Add / Change / Show / Delete File Systems Journaled File Systems Defragment a Journaled File System I haven't heard of anyone doing what you are describing in many a year. [EMAIL PROTECTED] wrote: Does anyone out there still do this (if you ever have)? Take a backup of the file systems (in our case, AIX UNIX), format the disks clean, then restore the data back down to lay it back contiguous. Are there any (noticeable) I/O advantages to doing this for a UniVerse database on today's servers? Provided our files are properly sized, of course. Our Systems guys are itching to do this. Thanks, Gary P. Canedy Database Analyst ProMutual Group (617) 757-6775 --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- 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] Status of a WRITE to a Type 1 File
Write a tag record and watch for the tag instead of the actual data record. When the tag appears, you're sure the related data record is there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Monday, October 31, 2005 11:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] Status of a WRITE to a Type 1 File We're using Universe 10.0.10.0 on Win 2000 Server. I need to determine when a Basic WRITE Statement of a record to a Type 1 file has completed so I can execute a subsequent action on the record written, but not before all the data in the record has been written. These can be large records requiring various numbers of seconds to write so I'm uncomfortable using a defined-length SLEEP command. TIA, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration 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/