RE: [U2] UD: Variable size
Kevin: You're right. However, we've been using this technique (on D3) for 10-12 years and there are a number of restrictions in the application to limit this problem (it only occurred on a logging file that got too large). Secondly, we're converting the UI to a web browser and this will eliminate this technique/program from use. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Saturday, September 01, 2007 8:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD: Variable size Is it just me, or as this output gets bigger does this seem like an increasingly problematic implementation? --- 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] UD: Variable size
We started out the same way, but eventually re-wrote our program for displaying report info so that it works from a file using READSEQ (if an array is passed in, it temporarily saves it as a record in a DIR-type file). We tried a few different methods, but found that reading in each screen's worth of data as needed was easily fast enough to keep up with users -- even when scrolling one line at a time. Regards, David Beahm Date: Fri, 31 Aug 2007 20:24:29 -0700 From: Bill Haskett [EMAIL PROTECTED] Subject: [U2] UD: Variable size I run a screen scrolling program that builds a report as a BASIC variable then scrolls it to screen one page at a time. I recently ran into a condition where the size of the report, in the internal BASIC variable, gets so large that UD terminates, and the telnet session aborts. It's not the data, it's the size of the internal BASIC variable. There are several thousand pages. Does anyone know of a UniData configuration variable, or environment variable, I can set to increase the size of an internal BASIC variable? Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD: Variable size
not enough information. terminates in what manner? with what error? on what platform? The contents of UniBasic variables are stored in shared memory. Are you getting a 'error when creating shared memory' sort of error? There would also be an 'ipclog' file created by UniData - full path to it referenced in the UDTBIN/udt.errlog. This includes the memory table use of that process before exiting. If so - the tuning would be at the kernel level - shmmax or such. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! Bill Haskett [EMAIL PROTECTED] os.netTo Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] UD: Variable size 08/31/2007 09:24 PM Please respond to [EMAIL PROTECTED] er.u2ug.org I run a screen scrolling program that builds a report as a BASIC variable then scrolls it to screen one page at a time. I recently ran into a condition where the size of the report, in the internal BASIC variable, gets so large that UD terminates, and the telnet session aborts. It's not the data, it's the size of the internal BASIC variable. There are several thousand pages. Does anyone know of a UniData configuration variable, or environment variable, I can set to increase the size of an internal BASIC variable? Thanks, Bill --- 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/jpeg which had a name of 19949171.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 19466118.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic02534.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] UD: Variable size
Sorry Wally. UD 7.1.9 on Win 2K3 w/SP2. The telnet session, in AccuTerm, and wIntegrate, just disconnects with the [Connection Aborted] client message on the screen. When I select a smaller number of records (which is normal in 999 times out of 1,000), everything works fine. A review of the UDTBIN directory shows the only items modified yesterday, or within the past month, was cleanupd.log - just the cleanup process showing cleanup: accounting for killed user process. udtno = 3, pid = 3108, uid = 197626, usertype = 1, tty = 192.168.1.101, timedate = 08:48:25 Sep 01 2007, current time = Sat Sep 01 08:50:31 2007 cleanupd.errlog - same as above with the same messages. sbcs.log - looks like: Starting: Fri Jul 27 00:29:11 2007 Starting: Fri Jul 27 00:29:11 2007 SBCS version: 7.1 BEGSMALL = 1 BEGMED = 5 BEGLARGE = 20 BEGHUGE = 45 Begsmall = 0 Begmed = 163 Beglarge = 490 Beghuge = 981 Beginning of emergency area = 1638, size = 410 Recover = 1 Debugmode = 0 Shm Attach Address: 0 Shm Max. Size.: 1048576 SBCS process id...: 2024 IPC facilities: q - 2 (request queue) q - 3 (reply queue) q - 4 (new version queue) m - -1459619840 Successfully Started. Fri Aug 03 11:42:11 readobj: can't find object/catalog file=(E:\IBM\ud71\sys\CTLG\m\M.DEL-CLIENT) Fri Aug 03 11:42:36 readobj: can't find object/catalog file=(E:\IBM\ud71\sys\CTLG\m\M.DEL-CLIENT) Tue Aug 07 13:06:59 readobj: can't find object/catalog file=(E:\IBM\ud71\sys\CTLG\m\MVNET.0) Wed Aug 08 09:23:50 readobj: can't find object/catalog file=(E:\IBM\ud71\sys\CTLG\m\MVNET.0) Mon Aug 20 07:28:56 readobj: can't find object/catalog file=(E:\IBM\ud71\sys\CTLG\w\wIntDBEdit) Tue Aug 28 05:46:01 readobj: can't find object/catalog file=(E:\IBM\ud71\sys\CTLG\w\wIntDBEdit) Fri Aug 31 15:23:24 readobj: cannot open file=(E:\IBM\ud71\sys\CTLG\a\AE) udadminlog.settings - just a few funny characters in it. 0 - don't know what this is or where it came from. udtsort.errlog - just the following entry for the 29th. Wed Aug 29 12:39:37 :warning: first character of the record is '\0' discard it! That's it for yesterday and today. The udt.errlog and udt.log show the same thing and the last entry was for the 27th of July. The udt.errlog has nothing in it and the udt.log shows: SMM Successfully Started. : Fri Jul 27 00:29:10 2007 SBCS Successfully Started. : Fri Jul 27 00:29:10 2007 Cleanupd Successfully Started. : Fri Jul 27 00:29:10 2007 I hope Thanks, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Saturday, September 01, 2007 7:50 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD: Variable size not enough information. terminates in what manner? with what error? on what platform? The contents of UniBasic variables are stored in shared memory. Are you getting a 'error when creating shared memory' sort of error? There would also be an 'ipclog' file created by UniData - full path to it referenced in the UDTBIN/udt.errlog. This includes the memory table use of that process before exiting. If so - the tuning would be at the kernel level - shmmax or such. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! Bill Haskett [EMAIL PROTECTED] os.net To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc
RE: [U2] UD: Variable size
Ok - we don't generate ipclogs on Windows - just UNIX systems. so... 1) Try running the program from a console session to see if there is a screen message that doesn't get a chance to display before your telnet disconnect. 2) Also - you can monitor the program's memory use from another session (or periodic EXECUTE in your program). - get the PID from 'listuser' output (USRNBR column) - from the shell: 'sms -L pid' Watch the entries in the 'Memory Info' table section of that output. Do you fill the table? (table size is shown in parens in the heading to that section - reflects udtconfig SHM_LMINENTS setting) Does one entry continue to grow to some point? This output is what we would be looking at in an ipclog. You just need to catch it as close to the abort as possible. Do you have an open support case on this topic? Regards, Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! [demime 1.01d removed an attachment of type image/jpeg which had a name of 27364313.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 27683844.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Variable size
Wally: Thanks. Here's the result of connecting from the console (a remote desktop session): 25R1Cp2 Weml (0)- 0LIST-DTALOGS No more entries in MI table in LCT-2 Connection to host lost. Here's what an sms -L shows: Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. C:\Documents and Settings\wphaskettsms -L LCTs (128) - 31883448-1 13281660 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 1164-1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 . . File system table size (N_FILESYS):200, Used: 3 Device ID Available Space NFS File System Name (in 512 Bytes) 1745276306 13324739 no C:\ 3694171166 58480960 no D:\ 2014220919168400056 no E:\ A review of your troubleshooting presentation shows: udtshared memory errors... . No more entries in MI table in LCT -n -udt run-time error when acquiring a new global page or creating an indirect segment to hold a large string -Increase SHM_LMINENTS to make the table bigger -Or, increase SHM_GPAGESZ to reduce the entries required . Reference: Chapters 3,4 -UniData Troubleshooting Guide I altered SHM_LMINENTS from 32 to 64 (not sure why though) and restarted UniData. What's the difference between altering SHM_LMINTS (# of entries in the MI table of an LCT - currently set at 32) and SHM_GPAGESZ (the size of the global page in a SM segment - current set at 256). Anyway, when I reran the report and it came out ok. The table now looks like: C:\Documents and Settings\wphaskettsms -L | more LCTs (128) - 15084080-1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 . . File system table size (N_FILESYS):200, Used: 3 Device ID Available Space NFS File System Name (in 512 Bytes) 1745276306 13324739 no C:\ 3694171166 58480960 no D:\ 2014220919168400040 no E:\ I didn't contact IBM because I figured this was my problem and there was a configuration parameter that should be set. I just couldn't figure out what parameter needed changing when a problem manifested itself through a telnet abort. Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Saturday, September 01, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD: Variable size Ok - we don't generate ipclogs on Windows - just UNIX systems. so... 1) Try running the program from a console session to see if there is a screen message that doesn't get a chance to display before your telnet disconnect. 2) Also - you can monitor the program's memory use from another session (or periodic EXECUTE in your program). - get the PID from 'listuser' output (USRNBR column) - from the shell: 'sms -L pid' Watch the entries in the 'Memory Info' table section of that output. Do you fill the table? (table size is shown in parens in the heading to that section - reflects udtconfig SHM_LMINENTS setting) Does one entry continue to grow to some point? This output is what we would be looking at in an ipclog. You just need to catch it as close to the abort as possible. Do you have an open support case on this topic? Regards, Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier
RE: [U2] UD: Variable size
Bill Haskett wrote: I altered SHM_LMINENTS from 32 to 64 (not sure why though) and restarted UniData. What's the difference between altering SHM_LMINTS (# of entries in the MI table of an LCT - currently set at 32) and SHM_GPAGESZ (the size of the global page in a SM segment - current set at 256). Anyway, when I reran the report and it came out ok. The table now looks like: C:\Documents and Settings\wphaskettsms -L | more LCTs (128) - 15084080-1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 _ I'm glad you were able to sort it out. Your change to increase the MI table seems effective. I guess my note wasn't clear. In order to see the MI table in the 'sms' output, you need to specify the PID of the udt process you want to examine. For instance - if the PID of the process running is '999' (from listuser USRNBR output - or other utility) sms -L 999 for future reference.. cheers Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! [demime 1.01d removed an attachment of type image/jpeg which had a name of 24412629.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 24934186.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD: Variable size
Is it just me, or as this output gets bigger does this seem like an increasingly problematic implementation? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/