RE: [U2] [UD] "No More Entries in MI Table in LCT-3
We have a winner! No more callers please! Yep, the file had a recommended modulo of 10K+ frames, and it was, as you mentioned, mod=1. Resized the file and all is well. I must also extend a hearty thanks to Wally Terhune for going above and beyond the call off-list to provide assistance. Thanks man - VERY appreciated. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Gladman Sent: Friday, November 25, 2005 5:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] "No More Entries in MI Table in LCT-3 I've had this message when building an index on a very badly sized file (eg modulo=1) -Ben --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] "No More Entries in MI Table in LCT-3 - solved
bingo. I worked with Kevin a bit off-list Wednesday night. His last email to me: "Ah, got it. This is a lightly used development system and the file was created with a modulo... get this... 1! FILE.STAT recommended a mod of 10961 and after resizing the file the BUILD.INDEX was successful." Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969< New Number! Fax: 303.773.5915< New Number! [EMAIL PROTECTED] "Ben Gladman" <[EMAIL PROTECTED] e.com> To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject Re: [U2] [UD] "No More Entries in 11/25/2005 05:15 MI Table in LCT-3 AM Please respond to u2-users I've had this message when building an index on a very badly sized file (eg modulo=1) -Ben "Kevin King" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm getting the above message when trying to use BUILD.INDEX to > rebuild a single index on this file. I've deleted the index field and > started over, and still no love. Any ideas? > > -Kevin > [EMAIL PROTECTED] > http://www.PrecisOnline.com > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [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 pic15350.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] "No More Entries in MI Table in LCT-3
I've had this message when building an index on a very badly sized file (eg modulo=1) -Ben "Kevin King" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm getting the above message when trying to use BUILD.INDEX to > rebuild a single index on this file. I've deleted the index field and > started over, and still no love. Any ideas? > > -Kevin > [EMAIL PROTECTED] > http://www.PrecisOnline.com > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] "No More Entries in MI Table in LCT-3
Wally Terhune wrote: > If there is an ipclog (referenced in $UDTBIN/udt.errlog) that would be > useful to help me help you tune. > If not - at least provide udtconfig and '$UDTBIN/ipcstat -mb' output > > or - guess some udtconfig settings > > specific to your error > SHM_LMINENTS=30 > SHM_GPAGESZ=2048 - don't make this any smaller than it already is I notice that the udtconfig Kevin posted didn't contain a value for SHM_GPAGESZ. What is the default if the value is not set Wally? I didn't realise some of these things were optional! Anyhow, Wally's suggestions make perfect sense - push the global page size up to 1MB and allow up to 30 pages to be referenced by a process. I suppose I'd also think about bumping up SHM_LPAGESZ to something like 32 or 64 from the default of 8 since a local page can also take an MI slot, and smm will probably grow this incrementally by allocating local pages rather than throw a whole 1M global page at it. Kevin, I suspect that the field you are indexing either directly or indirectly involves a virtual field (I-Type) or some output conversion, and that is why it is taking a reasonable amount of memory to build the index. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] "No More Entries in MI Table in LCT-3
Kevin; I thought it was on IBM's website - but I didn't find it after a quick look. It is on my 2003 Survival CD under Unidata\Documents. Hth Colin >-Original Message- >From: Kevin King > >Thanks Wally. What's this tuning document people have been >referring to? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] "No More Entries in MI Table in LCT-3
Thanks Wally. What's this tuning document people have been referring to? This is udt.errlog: ==UDT(pid:4404) calling reportIpcState(); logfile:/ud/DEV/UDT4404c0.ipclog; func name:U_shmem_alloc(A), errno:0. Current time=Wed Nov 23 12:28:10 2005 . ==UDT(pid:10674) calling reportIpcState(); logfile:/ud/DEV/UDT10674c0.ipclog; fu ncname:U_shmem_alloc(A), errno:0. Current time=Wed Nov 23 12:28:46 2005 . ==UDT(pid:20614) calling reportIpcState(); logfile:/ud/DEV/UDT20614c0.ipclog; fu ncname:U_shmem_alloc(A), errno:0. Current time=Wed Nov 23 12:35:52 2005 . ==UDT(pid:4440) calling reportIpcState(); logfile:/ud/DEV/UDT4440c0.ipclog; func name:U_shmem_alloc(A), errno:0. Current time=Wed Nov 23 13:11:51 2005 . ==UDT(pid:17004) calling reportIpcState(); logfile:/ud/DEV/UDT17004c0.ipclog; fu ncname:U_shmem_alloc(A), errno:0. Current time=Wed Nov 23 15:33:19 2005 And udtconfig: (my apologies for posting everything, just trying to provide as much info as possible. # Unidata Configuration Parameters # Section 1 Neutral parameters # These parameters are required by all Unidata installations. # # 1.1 System dependent parameters, they should not be changed. LOCKFIFO=1 SYS_PV=3 # 1.2 Changable parameters NFILES=1019 NUSERS=86 WRITE_TO_CONSOLE=0 TMP=/ud/temp/ NVLMARK= FCNTL_ON=86 TOGGLE_NAP_TIME=2 NULL_FLAG=0 N_FILESYS=200 N_GLM_GLOBAL_BUCKET=101 GLM_MEM_SEGSZ=4194304 # 1.3 I18N related parameter # # 2.1 Shared memory related parameters SBCS_SHM_SIZE=16777216 SHM_MAX_SIZE=1073741824 SHM_ATT_ADD=0 SHM_LBA=268435456 SHM_MIN_NATT=4 SHM_GNTBLS=100 SHM_GNPAGES=64 SHM_LPINENTS=10 SHM_LMINENTS=15 SHM_LCINENTS=100 SHM_FREEPCT=25 SHM_NFREES=1 AVG_TUPLE_LEN=4 EXPBLKSIZE=64 MAX_OBJ_SIZE=307200 MIN_MEMORY_TEMP=256 GRP_FREE_BLK=5 SHM_FIL_CNT=2048 SPLIT_LOAD=60 MERGE_LOAD=40 KEYDATA_SPLIT_LOAD=95 MAX_FLENGTH=1073741824 PART_TBL=/usr/udthome/parttbl # 2.4 NFA/Telnet service related parameter EFS_LCKTIME=0 TSTIMEOUT=60 # 2.5 Journal related parameters JRNL_MAX_PROCS=1 JRNL_MAX_FILES=400 # 2.6 UniBasic file related parameters MAX_OPEN_FILE=1024 MAX_OPEN_SEQF=150 MAX_DSFILES=1000 #2.7 UniBasic related parameters MAX_CAPT_LEVEL=2 MAX_RETN_LEVEL=2 COMPACTOR_POLICY=1 VARMEM_PCT=50 # 2.8 Number of semaphores per semaphore set NSEM_PSET=8 SETINDEX_BUFFER_KEYS=0 SETINDEX_VALIDATE_KEY=0 # 2.10 UPL/MGLM parameter MGLM_BUCKET_SIZE=50 UPL_LOGGING=0 # 2.11 Printer _HOLD_ file related parameters MAX_NEXT_HOLD_DIGITS=4 CHECK_HOLD_EXIST=0 # # These parameters are only used for RFS which is turned by # setting SB_FLAG to a positive value. # SB_FLAG=0 # 3.2 File related parameters N_PARTFILE=500 # 3.3 AFT related parameters N_AFT=200 N_AFT_SECTION=1 N_AFT_BUCKET=101 N_AFT_MLF_BUCKET=23 N_TMAFT_BUCKET=19 # 3.4 Archive related parameters N_ARCH=2 ARCHIVE_TO_TAPE=0 ARCH_WRITE_SZ=0 # 3.5 System buffer parameters N_BIG=233 N_PUT=8192 # 3.6 TM message queue related parameters N_PGQ=10 N_TMQ=10 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] "No More Entries in MI Table in LCT-3
This actually is an AIX 5 system, udt 5.2, though VERSION is giving me the message "The current account is version 5.1". How the heck is that possible? after upgrading from 5.1 to 5.2, $UDTBIN/updatevoc was never run on that account. If there is an ipclog (referenced in $UDTBIN/udt.errlog) that would be useful to help me help you tune. If not - at least provide udtconfig and '$UDTBIN/ipcstat -mb' output or - guess some udtconfig settings specific to your error SHM_LMINENTS=30 SHM_GPAGESZ=2048 - don't make this any smaller than it already is general shm tuning SHM_GNPAGES=64 SHM_ATT_ADD=0 SHM_GNTBLS=100 stopud/startud Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969< New Number! Fax: 303.773.5915< New Number! [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] "No More Entries in MI Table in LCT-3
This actually is an AIX 5 system, udt 5.2, though VERSION is giving me the message "The current account is version 5.1". How the heck is that possible? I've tried deleting all the indices and rebuilding from scratch, the SB+ dictionary is fine (though multivalued), but other than that it's nothing special. -K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 2:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] "No More Entries in MI Table in LCT-3 That's a little strange. That's a "memory" type error. There is a nice whitepaper from Wally explaining tuning for it - although it's based on Aix. Check the dictionary item and make sure there isn't anything strange going on - especially true if it was generated from SB+. If still having trouble do a delete.index filename ALL to delete the X_filename file and then try to re-create. Of course, no one can be accessing the file while you do this. Hth Colin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] "No More Entries in MI Table in LCT-3
That's a little strange. That's a "memory" type error. There is a nice whitepaper from Wally explaining tuning for it - although it's based on Aix. Check the dictionary item and make sure there isn't anything strange going on - especially true if it was generated from SB+. If still having trouble do a delete.index filename ALL to delete the X_filename file and then try to re-create. Of course, no one can be accessing the file while you do this. Hth Colin >-Original Message- >From: Kevin King > >I'm getting the above message when trying to use BUILD.INDEX >to rebuild a single index on this file. I've deleted the >index field and started over, and still no love. Any ideas? > >-Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] "No More Entries in MI Table in LCT-3
shared memory tuning required Since you don't specify platform, udt version, kernel settings or udtconfig settings (or the ipclog created by this error) - I can only suggest... Simplest is to increase SHM_LMINENTS in udtconfig and restart the database. It may be prudent to increase shmseg in the kernel as well. or increase SHM_GPAGESZ - so you don't need so many entries in the MI table though may need to increase shmmax if you do that. Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969< New Number! Fax: 303.773.5915< New Number! [EMAIL PROTECTED] "Kevin King" <[EMAIL PROTECTED] ne.com>To Sent by: [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] [UD] "No More Entries in MI 11/23/2005 01:36 Table in LCT-3 PM Please respond to u2-users I'm getting the above message when trying to use BUILD.INDEX to rebuild a single index on this file. I've deleted the index field and started over, and still no love. Any ideas? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- 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 graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic27732.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/
