RE: [U2] UniVerse + PERL

[Jeff Marcos]

This is great Kevin. There is a whole new world to explore

Regards,
Jeff Marcos

This e-mail is for the use of the intended recipient(s) only. If you
have received in error, please notify the sender immediately and 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. Corporate
Express checks all outgoing mail and accepts no liability for any loss
or damage caused by software viruses.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Sproule
Sent: Thursday, 4 May 2006 12:24 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniVerse + PERL

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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: Fw: [U2] Unidata Shared Memory Tuning Whitepaper

[Michael H. Martel]

--On Wednesday, May 03, 2006 5:02 PM -0600 Wally Terhune 
<[EMAIL PROTECTED]> wrote:



looking more closely - you are running 7.1 on AIX - all ports of which are
64-bit
so - the 'only one sbcs' and 'only one glm' tuning are not necessary.
You aren't bound to 11 segments per process limit as on 32-bit ports.


I think that's cool.  Would there be a benefit to tuning the GLM to be only 
one segment anyway ?


Thanks!


Michael

--

 o-
  Michael H. Martel  | Systems Administrator
  [EMAIL PROTECTED] | Vermont State Colleges
  http://www.vsc.edu/~michael| PH:802-241-2544 FX:802-241-3363
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Denver Sys Admin Course

[Bill Hazard]

Hi all,
I'm a newbie to Universe (but did some PI programming in 1987).  I will be 
attending the Universe sys admin course in denver starting may 16.  love to 
hook up with anyone who is attending the course or who is in the denver area.
Bill


Bill Hazard
email: [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Fw: [U2] Unidata Shared Memory Tuning Whitepaper

[Wally Terhune]

looking more closely - you are running 7.1 on AIX - all ports of which are
64-bit
so - the 'only one sbcs' and 'only one glm' tuning are not necessary.
You aren't bound to 11 segments per process limit as on 32-bit ports.

Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]


- Forwarded by Wally Terhune/Denver/IBM on 05/03/2006 04:59 PM -

 Wally
 Terhune/Denver/IB
 [EMAIL PROTECTED]  
  To
 Sent by:  u2-users@listserver.u2ug.org
 [EMAIL PROTECTED]  cc
 stserver.u2ug.org
   Subject
   Fw: [U2] Unidata Shared Memory
 05/03/2006 04:35  Tuning Whitepaper
 PM


 Please respond to
 [EMAIL PROTECTED]
er.u2ug.org






If you are running a 32-bit port of UniData on AIX - yes.
I spot 2 glm segments in your ipcstat listing.
bump udtconfig GLM_MEM_SEGSZ=8388608
stopud/startud

Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]


- Forwarded by Wally Terhune/Denver/IBM on 05/03/2006 04:32 PM -

 "Michael H.
 Martel"
 <[EMAIL PROTECTED]  To
 c.edu>u2-users@listserver.u2ug.org
 Sent by:   cc
 [EMAIL PROTECTED]
 stserver.u2ug.org Subject
   Re: Fw: [U2] Unidata Shared Memory
   Tuning Whitepaper
 05/03/2006 04:12
 PM


 Please respond to
 [EMAIL PROTECTED]
er.u2ug.org






--On Wednesday, May 03, 2006 3:25 PM -0600 Wally Terhune
<[EMAIL PROTECTED]> wrote:

>> From the shell: 'ipcstat -mb | grep sbcs'
> sum up the segment size column
> set udtconfig SBCS_SHM_SIZE to that sum
> stopud/startud

That's what I did and what I remembered.  Cool, the memory isn't so bad
after all.  Do I need to worry about the multiple glm segments ?

Thanks!

# i
IPC status from /dev/mem as of Wed May  3 18:12:02 EDT 2006
TID KEYMODE   OWNERGROUP SEGSZ
Shared Memory:
m 0 0xe4663d62 --rw-rw-rw-   imnadm   imnadm96  -> unknown
m 1 0x9308e451 --rw-rw-rw-   imnadm   imnadm 97948  -> unknown
m 2 0x52e74b4f --rw-rw-rw-   imnadm   imnadm 36028  -> unknown
m 3 0xc76283cc --rw-rw-rw-   imnadm   imnadm 42268  -> unknown
m 4 0x298ee665 --rw-rw-rw-   imnadm   imnadm  2844  -> unknown
m 5 0x --rw-rw root   system  4096  -> unknown
m 6 0x --rw-rw root   system  4096  -> unknown
m 7 0x --rw-rw root   system  4096  -> unknown
m 8 0x0d000a91 --rw-rw-rw- root   system  1440  -> unknown
m655369 0x4501475b --rw-rw-rw- root   system  10190848  -> smm R7.1

(ctl)
m 510525450 0x --rw-rw-rw- root   system   4194304  -> smm R7.1

(glm)
m655371 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m 417595411 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m 1013841950 0x --rw-rw-rw- root   system   4194304  -> smm
R7.1 (glm)
m  45744171 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m 148897840 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m  49152050 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m 1019084856 0x --rw-rw-rw- root   system 402653184  -> smm
R7.1 (shmbuf)
m 598343737 0x --rw-r--r-- root   system 100663296  -> sbcs
R7.1
m 292421701 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)




Michael

--

  o-
   Michael H. Martel  | Systems Administrator
   [EMAIL PROTECTED] | Vermont State Colleges
   http://www.vsc.edu/~michael| PH:802-241-2544 FX:802-241-3363
---
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/gif which had a name of
pic28841.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
---
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/gif which had a name of 
pi

Fw: [U2] Unidata Shared Memory Tuning Whitepaper

[Wally Terhune]

If you are running a 32-bit port of UniData on AIX - yes.
I spot 2 glm segments in your ipcstat listing.
bump udtconfig GLM_MEM_SEGSZ=8388608
stopud/startud

Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]


- Forwarded by Wally Terhune/Denver/IBM on 05/03/2006 04:32 PM -

 "Michael H.
 Martel"
 <[EMAIL PROTECTED]  To
 c.edu>u2-users@listserver.u2ug.org
 Sent by:   cc
 [EMAIL PROTECTED]
 stserver.u2ug.org Subject
   Re: Fw: [U2] Unidata Shared Memory
   Tuning Whitepaper
 05/03/2006 04:12
 PM


 Please respond to
 [EMAIL PROTECTED]
er.u2ug.org






--On Wednesday, May 03, 2006 3:25 PM -0600 Wally Terhune
<[EMAIL PROTECTED]> wrote:

>> From the shell: 'ipcstat -mb | grep sbcs'
> sum up the segment size column
> set udtconfig SBCS_SHM_SIZE to that sum
> stopud/startud

That's what I did and what I remembered.  Cool, the memory isn't so bad
after all.  Do I need to worry about the multiple glm segments ?

Thanks!

# i
IPC status from /dev/mem as of Wed May  3 18:12:02 EDT 2006
TID KEYMODE   OWNERGROUP SEGSZ
Shared Memory:
m 0 0xe4663d62 --rw-rw-rw-   imnadm   imnadm96  -> unknown
m 1 0x9308e451 --rw-rw-rw-   imnadm   imnadm 97948  -> unknown
m 2 0x52e74b4f --rw-rw-rw-   imnadm   imnadm 36028  -> unknown
m 3 0xc76283cc --rw-rw-rw-   imnadm   imnadm 42268  -> unknown
m 4 0x298ee665 --rw-rw-rw-   imnadm   imnadm  2844  -> unknown
m 5 0x --rw-rw root   system  4096  -> unknown
m 6 0x --rw-rw root   system  4096  -> unknown
m 7 0x --rw-rw root   system  4096  -> unknown
m 8 0x0d000a91 --rw-rw-rw- root   system  1440  -> unknown
m655369 0x4501475b --rw-rw-rw- root   system  10190848  -> smm R7.1

(ctl)
m 510525450 0x --rw-rw-rw- root   system   4194304  -> smm R7.1

(glm)
m655371 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m 417595411 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m 1013841950 0x --rw-rw-rw- root   system   4194304  -> smm
R7.1 (glm)
m  45744171 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m 148897840 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m  49152050 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)
m 1019084856 0x --rw-rw-rw- root   system 402653184  -> smm
R7.1 (shmbuf)
m 598343737 0x --rw-r--r-- root   system 100663296  -> sbcs
R7.1
m 292421701 0x --rw-rw-rw- root   system 402653184  -> smm R7.1

(shmbuf)




Michael

--

  o-
   Michael H. Martel  | Systems Administrator
   [EMAIL PROTECTED] | Vermont State Colleges
   http://www.vsc.edu/~michael| PH:802-241-2544 FX:802-241-3363
---
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/gif which had a name of 
pic28841.gif]

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

Re: Fw: [U2] Unidata Shared Memory Tuning Whitepaper

[Michael H. Martel]

--On Wednesday, May 03, 2006 3:25 PM -0600 Wally Terhune 
<[EMAIL PROTECTED]> wrote:



From the shell: 'ipcstat -mb | grep sbcs'

sum up the segment size column
set udtconfig SBCS_SHM_SIZE to that sum
stopud/startud


That's what I did and what I remembered.  Cool, the memory isn't so bad 
after all.  Do I need to worry about the multiple glm segments ?


Thanks!

# i
IPC status from /dev/mem as of Wed May  3 18:12:02 EDT 2006
TID KEYMODE   OWNERGROUP SEGSZ
Shared Memory:
m 0 0xe4663d62 --rw-rw-rw-   imnadm   imnadm96  -> unknown
m 1 0x9308e451 --rw-rw-rw-   imnadm   imnadm 97948  -> unknown
m 2 0x52e74b4f --rw-rw-rw-   imnadm   imnadm 36028  -> unknown
m 3 0xc76283cc --rw-rw-rw-   imnadm   imnadm 42268  -> unknown
m 4 0x298ee665 --rw-rw-rw-   imnadm   imnadm  2844  -> unknown
m 5 0x --rw-rw root   system  4096  -> unknown
m 6 0x --rw-rw root   system  4096  -> unknown
m 7 0x --rw-rw root   system  4096  -> unknown
m 8 0x0d000a91 --rw-rw-rw- root   system  1440  -> unknown
m655369 0x4501475b --rw-rw-rw- root   system  10190848  -> smm R7.1 
(ctl)
m 510525450 0x --rw-rw-rw- root   system   4194304  -> smm R7.1 
(glm)
m655371 0x --rw-rw-rw- root   system 402653184  -> smm R7.1 
(shmbuf)
m 417595411 0x --rw-rw-rw- root   system 402653184  -> smm R7.1 
(shmbuf)
m 1013841950 0x --rw-rw-rw- root   system   4194304  -> smm 
R7.1 (glm)
m  45744171 0x --rw-rw-rw- root   system 402653184  -> smm R7.1 
(shmbuf)
m 148897840 0x --rw-rw-rw- root   system 402653184  -> smm R7.1 
(shmbuf)
m  49152050 0x --rw-rw-rw- root   system 402653184  -> smm R7.1 
(shmbuf)
m 1019084856 0x --rw-rw-rw- root   system 402653184  -> smm 
R7.1 (shmbuf)

m 598343737 0x --rw-r--r-- root   system 100663296  -> sbcs R7.1
m 292421701 0x --rw-rw-rw- root   system 402653184  -> smm R7.1 
(shmbuf)





Michael

--

 o-
  Michael H. Martel  | Systems Administrator
  [EMAIL PROTECTED] | Vermont State Colleges
  http://www.vsc.edu/~michael| PH:802-241-2544 FX:802-241-3363
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Fw: [U2] Unidata Shared Memory Tuning Whitepaper

[Wally Terhune]

>From the shell: 'ipcstat -mb | grep sbcs'
sum up the segment size column
set udtconfig SBCS_SHM_SIZE to that sum
stopud/startud

Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]


- Forwarded by Wally Terhune/Denver/IBM on 05/03/2006 03:18 PM -

 "Michael H.
 Martel"
 <[EMAIL PROTECTED]  To
 c.edu>u2-users@listserver.u2ug.org
 Sent by:   cc
 [EMAIL PROTECTED]
 stserver.u2ug.org Subject
   [U2] Unidata Shared Memory Tuning
   Whitepaper
 05/03/2006 02:19
 PM


 Please respond to
 [EMAIL PROTECTED]
er.u2ug.org






Greetings!

I'm trying to find a whitepaper on Shared Memory tuning in unidata.  I know

there used to be one, but I can't seem to lay my hands on it.  I'm looking
at multiple SBCS segements on my AIX box and want to make sure I go about
things the right way.

Thanks!



Michael

--

  o-
   Michael H. Martel  | Systems Administrator
   [EMAIL PROTECTED] | Vermont State Colleges
   http://www.vsc.edu/~michael| PH:802-241-2544 FX:802-241-3363
---
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/gif which had a name of 
pic20402.gif]

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

[U2] Unidata Shared Memory Tuning Whitepaper

[Michael H. Martel]

Greetings!

I'm trying to find a whitepaper on Shared Memory tuning in unidata.  I know 
there used to be one, but I can't seem to lay my hands on it.  I'm looking 
at multiple SBCS segements on my AIX box and want to make sure I go about 
things the right way.


Thanks!



Michael

--

 o-
  Michael H. Martel  | Systems Administrator
  [EMAIL PROTECTED] | Vermont State Colleges
  http://www.vsc.edu/~michael| PH:802-241-2544 FX:802-241-3363
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata Caching

[Brad Davis]

This good to know.  RFS should speed things up then.

Do you know what the paging mechanism is, when the shared memory gets
full?  LIFO, block (record) stats...

-Original Message-
From: Timothy Snyder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 03, 2006 11:32 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata Caching


> Does RFS manage virtual paging - or is it just a block of memory?

The RFS system buffer is a chunk of shared memory that keeps track of
records read from and/or updated to recoverable files.  In other words,
it's maintained at the logical record level.  If a requested record is
found in the system buffer, no attempt is made to retrieve the record
from disk.  I/O to non-recoverable files goes straight to the O/S I/O
routines, just as when RFS is not active.

Tim Snyder
Consulting I/T Specialist , U2 Professional Services
North American Lab Services
DB2 Information Management, IBM Software Group
717-545-6403
[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] UOJ Linux vs Windows

[John Hester]

Bob Little wrote:
When I run this app here at home and do a LISTU, I see nothing - except 
if I have logged into Linux on that server, I will see the same output 
as the bash command "who".


To get a clear picture of how many licenses are being consumed on linux, 
try:


`cat /.uvhome`/bin/uvlictool report_lic -a

I suspect you're able to exceed the normal user limit because UOJ is 
consuming a device license rather than user licenses.  If you have other 
machines on your home network you could verify this by connecting from 
multiple IP addresses.


-John
--
John Hester
System & Network Administrator
Momentum Group Inc.
(949) 833-8886 x623
http://memosamples.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniVerse + PERL

[Barry Brevik]

>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
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] UniAdmin Configuration Weirdness

[Kevin King]

I recently resolved a UniAdmin issue, and having found no information
in searching the web and archives I figured I'd post the issue and
resolution here in case someone else experiences the same.
 
Here's the setup: A customer had an older AIX system that they wanted
to replace.  So they bought a newer, bigger, faster, ... well, you get
the idea... and reclassed the old production machine as their dev/test
box.  Unidata 5.2 was running on the old box, 6.1 on the new box.
 
After the conversion, UniAdmin worked fine on the old box.  No
problems whatsoever.  UniAdmin would not work on the new box, however.
The unirpcd service was running exactly as on the old box, but every
time UniAdmin would try to connect to the new box the message "No RPC
Connection Active" would be displayed.  We tried various versions of
UniAdmin with no success.  Every time the result was the same.
 
The Solution: I noticed on another system where UniAdmin was connected
that the service name was uniadmin60, not uniadmin.  Looking at the
unirpcservices file in /ud/uv/unishared/unirpc I noticed that there
was no uniadmin61, but there was a uniadmin entry.  So looking at the
other machine that was working - to verify I wasn't crazy - I copied
the uniadmin entry in unirpcservices into a new uniadmin61 entry and
restarted unirpcd and UniAdmin works fine.
 
It appears that 5.2 uses the "uniadmin" service name, but 6.0 and 6.1
use the "uniadmin60" and "uniadmin61" entries. Not sure if that's
wholly true, but that's what it seems like.  Wally, can you confirm?
 
Anyway, hope this helps, and if anyone sees anything I've done
horribly wrong, please speak now.
 
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com  
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata Caching

[Timothy Snyder]

> Does RFS manage virtual paging - or is it just a block of memory?

The RFS system buffer is a chunk of shared memory that keeps track of
records read from and/or updated to recoverable files.  In other words,
it's maintained at the logical record level.  If a requested record is
found in the system buffer, no attempt is made to retrieve the record from
disk.  I/O to non-recoverable files goes straight to the O/S I/O routines,
just as when RFS is not active.

Tim Snyder
Consulting I/T Specialist , U2 Professional Services
North American Lab Services
DB2 Information Management, IBM Software Group
717-545-6403
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata Caching

[Brad Davis]

Does RFS manage virtual paging - or is it just a block of memory?

-Original Message-
From: Wally Terhune [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 03, 2006 9:53 AM
To: u2-users@listserver.u2ug.org
Subject: Fw: [U2] Unidata Caching


Unless you are running RFS (for which we have a our own cache in shared
memory), you are likely just experiencing the OS file system cache and
or disk RAID array cache...

Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]


- Forwarded by Wally Terhune/Denver/IBM on 05/03/2006 07:51 AM -

 Jeffrey Butera
 <[EMAIL PROTECTED]
 e.edu>
To
 Sent by:  "U2-Users New Lists"
 [EMAIL PROTECTED] 
 stserver.u2ug.org
cc

 
Subject
 05/03/2006 06:42  [U2] Unidata Caching
 AM


 Please respond to
 [EMAIL PROTECTED]
er.u2ug.org






Can anyone shed insight on how/what Unidata does for caching?

In short, I notice that when I perform some SELECTs or programs which
read a handful of records, they often run faster after first execution -
I'm assuming Unidata is caching.

I was working on adding some caching to an application I'm working on
but if Unidata is already doing a reasonable job I may not see any
sizable performance difference (and don't want to spend many hours
working on this to find it's in vain...)

Any insight appreciated.
--

Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"We're not given the burdens we deserve,
we're given the burdens we can bear."  Several
---
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/gif which had a name
of pic04086.gif]

[demime 1.01d removed an attachment of type image/gif which had a name
of ecblank.gif]
---
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] UniVerse + PERL

[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/

Fw: [U2] Unidata Caching

[Wally Terhune]

Unless you are running RFS (for which we have a our own cache in shared
memory), you are likely just experiencing the OS file system cache and or
disk RAID array cache...

Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]


- Forwarded by Wally Terhune/Denver/IBM on 05/03/2006 07:51 AM -

 Jeffrey Butera
 <[EMAIL PROTECTED]
 e.edu> To
 Sent by:  "U2-Users New Lists"
 [EMAIL PROTECTED] 
 stserver.u2ug.org  cc

   Subject
 05/03/2006 06:42  [U2] Unidata Caching
 AM


 Please respond to
 [EMAIL PROTECTED]
er.u2ug.org






Can anyone shed insight on how/what Unidata does for caching?

In short, I notice that when I perform some SELECTs or programs which read
a
handful of records, they often run faster after first execution - I'm
assuming Unidata is caching.

I was working on adding some caching to an application I'm working on but
if
Unidata is already doing a reasonable job I may not see any sizable
performance difference (and don't want to spend many hours working on this
to
find it's in vain...)

Any insight appreciated.
--
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"We're not given the burdens we deserve,
we're given the burdens we can bear."  Several
---
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/gif which had a name of 
pic04086.gif]

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

Re: [U2] Unidata Caching

[Roger Glenfield]

The version of DB and O/S might help?

Remember to do your testing in a live like environment.  Running a test 
at night with no one else on the system won't point out any short 
comings that will become obvious when 30+ users start whacking at it.


Always assume the worse.  And then add another 50% to your estimates.

Jeffrey Butera wrote:

Can anyone shed insight on how/what Unidata does for caching?

In short, I notice that when I perform some SELECTs or programs which read a 
handful of records, they often run faster after first execution - I'm 
assuming Unidata is caching.


I was working on adding some caching to an application I'm working on but if 
Unidata is already doing a reasonable job I may not see any sizable 
performance difference (and don't want to spend many hours working on this to 
find it's in vain...)


Any insight appreciated.

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

[U2] Unidata Caching

[Jeffrey Butera]

Can anyone shed insight on how/what Unidata does for caching?

In short, I notice that when I perform some SELECTs or programs which read a 
handful of records, they often run faster after first execution - I'm 
assuming Unidata is caching.

I was working on adding some caching to an application I'm working on but if 
Unidata is already doing a reasonable job I may not see any sizable 
performance difference (and don't want to spend many hours working on this to 
find it's in vain...)

Any insight appreciated.
-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"We're not given the burdens we deserve, 
we're given the burdens we can bear."  Several
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Runtime errors

[Dave Walker]

Thanks. I checked out all the runtime options, and the only one I remember
seeing that was even remotely related concerned logging failures related to
opening files. 

Geez, I remember past discussions on the list concerning SOX compliance, and
now I get to play. It ain't any fun, and only promises to get worse.

--
Dave

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett
Sent: Tuesday, May 02, 2006 7:52 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Runtime errors


Dave:

I have an request in with IBM for this information.  I didn't get any
feedback on the list and if I get an answer I'll post it for you and anyone
else who might want it.

Bill

 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker
> Sent: Tuesday, May 02, 2006 7:14 AM
> To: 'u2-users@listserver.u2ug.org'
> Subject: [U2] Runtime errors
> 
> I'm sure we've all seen the user that ignores umpteen "WARNING:
> UNINITIALIZED VARIABLE USED! Zero Assumed!" errors scrolling
> up their screen.
> 
> Is there a way to log non-fatal runtime errors so that they 
> may be reviewed later? Are they already logged someplace that
> I'm not aware of? I've checked the various logs in /usr/ud/
> bin/saved_logs without finding what I'm looking for. 
> 
> TIA,
> --
> Dave Walker
---
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] RE: Using the BCI

[Brian Leach]

Victor,

I've just written an article/tutorial on using BCI for Vmark UK's
newsletter.
As soon as it is published I'll post the link: it has a reasonable set of
examples for both UV and UDT, though it doesn't cover calling stored
procedures (I was going to keep that for an 'advanced' article).

Brian  

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Victor St Clair
> Sent: 02 May 2006 21:49
> To: u2-users@listserver.u2ug.org
> Subject: [U2] RE: Using the BCI
> 
> Hello
> 
> 
> 
> I forgot to add that we are using UniData 7.1, almost always 
> on Windows, although it's not impossible that we might need 
> to install our UniData app on a Unix box.
> 
> 
> 
> Thanks again
> 
> 
> 
> Victor St. Clair
> 
> Jenkon
> 
> 
> 
> [EMAIL PROTECTED] 
> 
> 360-256-4400 Phone
> 
> 360-256-9623 Fax
> 
> www.jenkon.com
> 
> 
> 
> From: Victor St Clair
> Sent: Tuesday, May 02, 2006 1:41 PM
> To: u2-users@listserver.u2ug.org
> Subject: Using the BCI
> 
> 
> 
> Hello All.
> 
> 
> 
> I've seen this question asked from time to time, but I can't 
> get into the archives to find out what the answer has been.
> 
> 
> 
> I find myself the person assigned to a new development 
> project with the responsibility of learning to use the Basic 
> Client Interface to access
> data in an SQL2005 DB.   I have the BCI manual from IBM and 
> am starting
> my journey through it.  But I recall seeing comments in the 
> past to the effect of  "the examples supplied are not that 
> useful, you can get better examples at .".
> 
> 
> 
> The question is basically  "Are there any other sources of 
> information I
> can get on using the Basic Client Interface?"   If any one 
> can point me
> in the direction of useful info I'd greatly appreciate it.  
> And, if possible, are there any pitfalls I need to watch out for?
> 
> 
> 
> Thank you
> 
> 
> 
> Victor St. Clair
> 
> 
> --
> This message has been scanned for viruses and dangerous 
> content by MailScanner, and is believed to be clean.
> ---
> 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] Forcing Subroutine to be Re-read

[Mats Carlid]

Are You calling them indirectly ?

I.e. like :

subr = "nameOfSubroutine"

call @subr( args )

This technique will 'force' the subs 'in memory'
whereas

call nameOfSubroutine(args)

should start a search for the subroutine.

How this search is done and especially if it will
force a fresh copy I don't know but it
could be worth to try.

-- mats.



[EMAIL PROTECTED] wrote:


Hi all,

UV9.6.1.14
HPUX 11

I have a background processor that calls a number of subroutines.  Everytime I 
make a change to any of the subroutines, I have to shutdown the job and restart 
it because the subroutine is still in memory.  Does anyone know of a way that I 
can force the background job to reread the subroutine?

Thanks in advance,

Scott
---
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] Using the BCI

[Bob Witney]

victor

the manuals are fine

email me off list if you would like examples of the routines we have written

bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Victor St Clair
Sent: 02 May 2006 21:41
To: u2-users@listserver.u2ug.org
Subject: [U2] Using the BCI


Hello All.



I've seen this question asked from time to time, but I can't get into
the archives to find out what the answer has been.



I find myself the person assigned to a new development project with the
responsibility of learning to use the Basic Client Interface to access
data in an SQL2005 DB.   I have the BCI manual from IBM and am starting
my journey through it.  But I recall seeing comments in the past to the
effect of  "the examples supplied are not that useful, you can get
better examples at .".



The question is basically  "Are there any other sources of information I
can get on using the Basic Client Interface?"   If any one can point me
in the direction of useful info I'd greatly appreciate it.  And, if
possible, are there any pitfalls I need to watch out for?



Thank you



Victor St. Clair


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---
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/