[U2] RE: U2 Users Digest V1 #2599

2009-04-09 Thread Kevin Sproule
John,

Be aware that sockets are a "stream" based protocol and not a "message"
based protocol.  When you send data to a socket it may arrive in one or
more pieces (packets).  On a LAN this may never occur, but over a WAN or
the internet your data packets will almost surely be broken up into
smaller pieces.  On the receiving end you will need to know the length
of the data you expect or have some sort of end-of-line character(s) to
know when you have received all of the data.

Years ago I wrote a program that worked well on a LAN, but failed
randomly when data was passed through the internet.  I mistakenly
thought that if I sent a packet with 1024 bytes that I would always
receive a packet with 1024 bytes (like writing and reading from disk).
This is not the case.

Kevin M. Sproule
Sr. Technical Consultant
AFS Technologies, Inc.
2141 E. Highland Ave, Ste. 100
Phoenix, AZ 85016
Care Center: (602) 522-8181
Main: (602) 522-8282
e-mail: kev...@afsi.com

Our mission is to be the number one supplier of software to the food and
beverage industry
 

- -Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of doug chanco
Sent: Thursday, April 09, 2009 12:56 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] universe sockets

I am about to do some socket programming with the universe socket API
(universe 10.2.x and aix 5.3.x), are there any
gotchas/advice/suggestions anyone would care to share?

thanks!

dougc
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Does anybody have a hot backup server?

2009-03-26 Thread Kevin Sproule
We have several customers, running UniVerse on Linux and Windows
platforms, that use UV transaction logging to keep a backup server
nearly current with their main server.  We have scripted the copying of
full log files to the backup server where another script rolls them into
a copy of the main database (account).  On pre 10.2 UniVerse, the backup
server is within one full log (10 mb worth of transactions) with the
main server (about 15-30 minutes).  On a UniVerse 10.2 server, running
on Windows, we have set the logs to "time out" after two minutes, so
that the backup server is within two minutes of being current with the
main server.  

The solution is well behaved and we have had it in place for the past
few years.

Kevin M. Sproule
Sr. Technical Consultant
AFS Technologies, Inc.
2141 E. Highland Ave, Ste. 100
Phoenix, AZ 85016
Care Center: (602) 522-8181
Main: (602) 522-8282
e-mail: kev...@afsi.com

 
- -Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Powell
Sent: Wednesday, March 18, 2009 3:07 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Does anybody have a hot backup server?

I am trying to put together a backup strategy that involves keeping a 
standby server within two data hours of the primary. The idea is to be 
able to have users log into the backup server and keep the business 
running in the event of a crash.

I'd like to hear what solutions others have found for this.

I've been trying to contact IBM for the last 6 months but they haven't 
answered and my ERP vendor doesn't know how to do this.

Any ideas are appreciated.

TIA


- ---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

--

End of U2 Users Digest V1 #2581
***


u2-users-digest 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] Phantom creating Zombies

2007-11-05 Thread Kevin Sproule
David,



Easy fix:  EXECUTE "JOBS" CAPTURING JUNK



Put this in your code prior to the PHANTOM launching code.  It will
"reap" any dead child processes (zombies), that may be hanging around.



Kevin M. Sproule
Sr. Technical Consultant
AFS Technologies, Inc.
2141 E. Highland Ave, Ste. 100
Phoenix, AZ 85016
Care Center: (602) 522-8181
Main: (602) 522-8282
e-mail: [EMAIL PROTECTED]

Our mission is to be the number one supplier of software to the food and
beverage industry

[demime 1.01d removed an attachment of type image/gif which had a name of 
image001.gif]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


re: [U2] active directory & Univ=Verse

2006-07-27 Thread Kevin Sproule
>Date: Thu, 27 Jul 2006 18:04:03 GMT
>From: "Dave R" <[EMAIL PROTECTED]>
>Subject: [U2] active directory & Univ=Verse
>
>I am planning switch my UniVerse (9.4.1) Server to "Active Directory"  on >win 
>2003 server.
>What kind of problems am I likely to encounter.
>Thanks
>
>
>D Raven
>[EMAIL PROTECTED]
>cell (949)2282224
>e Fax (815)4259364
>P.O. Box 17811, Irvine CA 92623-7811

D Raven,

I would expect that it would not run at all.  UniVerse 9.4.1 is only qualified 
to run on NT 4.0.  You would need at least version 10.0.15 to run on Windows 
2003.

Kevin M. Sproule
Sr. Technical Consultant
AFS Technologies, Inc.
2141 E. Highland Ave, Ste. 100
Phoenix, AZ 85016
Care Center: (602) 522-8181
Main: (602) 522-8282
e-mail: [EMAIL PROTECTED]

Our mission is to be the number one supplier of software to the food and 
beverage industry
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


re: [U2] [UV] Veritas and UniVerse?

2006-05-24 Thread Kevin Sproule
>Date: Tue, 23 May 2006 17:27:04 -0500
>From: "David Wolverton" <[EMAIL PROTECTED]>
>Subject: [U2] [UV] Veritas and UniVerse?
>
>I have a client telling me that the UniVerse server is crashing when >Veritas 
>Backup Exec is trying to back it up at night. 
>
>They are having to do a hard reboot every morning, and have no backup to >boot!
>
>Veritas Backup Exec 10d with tape drive running on a different server.
>UniVerse is 10.1 and has 'Remote Backup Agent' running on it.  My UniVerse 
>>vendor said there may be an 'environment variable conflict' issue they 
>>thought they heard of.
>
>Anything more precise that anyone knows of?
>
>
>David W.


David,

Backup Exec has a default setting to backup open files "with" a lock.  This 
will tend to terminate any UV processes that try to write to the files during 
the backup.  Change the backup settings to backup open files "without" a lock.


Kevin M. Sproule
Sr. Technical Consultant
AFS Technologies, Inc.
2141 E. Highland Ave, Ste. 100
Phoenix, AZ 85016
Care Center: (602) 522-8181
Main: (602) 522-8282
e-mail: [EMAIL PROTECTED]

Our mission is to be the number one supplier of software to the food and 
beverage industry
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse + PERL

2006-05-04 Thread Kevin Sproule
Barry,



Win32::OLE is used to invoke UniObjects that are described in the
documentation within the UniDK.  The connection does take a license and
the connection will fail if all licenses are in use.  Always check
$uv->IsActive to see if the connection was made.  For maximum
performance call UV subroutines instead of directly executing commands.
Eg.



...

my $subr = $uv->Subroutine('COMMAND.SUB', 2);

$subr->SetArg(0, "COUNT VOC");

$subr->Call;  # call subroutine

if ($subr->Error) { print $subr->Error, "\n" }

$result = $subr->GetArg(1);

$result =~ tr/\376/\012/;  # FM to LF

...



Where COMMAND.SUB "EXECUTEs" the first argument and returns the result
in the second.



>Date: Wed, 3 May 2006 09:27:28 -0700

>From: "Barry Brevik" <[EMAIL PROTECTED]>

>Subject: RE: [U2] UniVerse + PERL

>

>>You can also use Win32::OLE to connect to UV.  This script counts the

>>VOC:

>

>Wow! This is way cool!

>

>Where can I learn more about using Win32::OLE to mine UV files?? Also,
does the connection use a license? By which I >mean, if all licenses are
in use, will the Perl connection fail? We have been running at, or near
our user limit for some >time now.

>

>Great post!

>

>Barry Brevik





Kevin Sproule

Sr. Technical Consultant

AFS Technologies, Inc.

2141 E. Highland Ave.

Suite 100

Phoenix, AZ 85016

Office 602-522-8181 | Mobile 602-549-0470 | Email [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniVerse + PERL

2006-05-03 Thread Kevin Sproule
You can also use Win32::OLE to connect to UV.  This script counts the
VOC:



#!/perl/bin/perl.exe -w

use Win32::OLE;

my ($err, $result, $cmd);



use constant UV_SESSION_OBJECT => 'UniObjects.unioaifctrl'; # name of
UniObject session object



$uv = Win32::OLE->new(UV_SESSION_OBJECT) or die "Cannot get session
object: $!\n";



$uv->LetProperty('UserName','kevin');

$uv->LetProperty('Password','password');

$uv->LetProperty('HostName','192.168.246.139');

$uv->LetProperty('AccountPath', 'KEVIN');

$uv->Connect;  # open connection to sever



if (! $uv->IsActive) { # check status

   print "Not Connected: $uv->{Error}\n";

   exit;

}



print "Connected\n";



$cmd = 'COUNT VOC';

$uv->Command->LetProperty('Text', $cmd);

$uv->Command->Exec;

$err = $uv->Command->{'CommandStatus'};

print $uv->Command->{'Response'};



$uv->Disconnect;  # close connection to server





> Date: Tue, 2 May 2006 18:35:48 +0800

> From: "Ang Suan Yong" <[EMAIL PROTECTED]>

> Subject: [U2] UniVerse + PERL

>

> Dear All

> Is it possible to use Perl connect to UniVerse backend  to run some UV
Command , like CREATE FILE , SELECT FILE?

> Current im trying using DBD::ODBC , the uv connection is find but
statement execution failed . any idea ??

>

> use DBD::ODBC;

> my $db = DBI->connect('dbi:ODBC:UVSOURCE',"userid","password") ||
die("Connection failed") ;

> my $cmd="SELECT * FROM VOC;" ;

> my $stmt= $db->prepare($cmd);

>

> Error Shown as below :

>

> DBD::ODBC::db prepare failed: [IBM][UVODBC][2700828] Error ID = 23 ,

> Severity: ERROR Facility: DBCAPERR - Line 1, column 15 (around "VOC"):

> SQL statement referenced a nonexistent table or view.

>

> Thanks & Regards











Kevin Sproule

Sr. Technical Consultant

AFS Technologies, Inc.

2141 E. Highland Ave.

Suite 100

Phoenix, AZ 85016

Office 602-522-8181 | Mobile 602-549-0470 | Email [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/