RE: [U2] Using the BCI
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/
Re: [U2] [UV] Forcing Subroutine to be Re-read
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] RE: Using the BCI
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] mailto:[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] Runtime errors
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/
[U2] Unidata Caching
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] Unidata Caching
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/
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] u2-users@listserver.u2ug.org 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] 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/
RE: [U2] Unidata Caching
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] u2-users@listserver.u2ug.org 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] 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] UniAdmin Configuration Weirdness
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 http://www.precisonline.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UOJ Linux vs Windows
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] Unidata Caching
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/
[U2] Unidata Shared Memory Tuning Whitepaper
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/
Fw: [U2] Unidata Shared Memory Tuning Whitepaper
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.eduu2-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/
Re: Fw: [U2] Unidata Shared Memory Tuning Whitepaper
--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
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.eduu2-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/
Fw: [U2] Unidata Shared Memory Tuning Whitepaper
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.eduu2-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 pic04696.gif] [demime 1.01d
[U2] Denver Sys Admin Course
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/
Re: Fw: [U2] Unidata Shared Memory Tuning Whitepaper
--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/
RE: [U2] UniVerse + PERL
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/
