Re: Error on Illustra

Thanks for the help on this one. The RTFM is not so streight. The first option with MI_LOCKS will shut down the server, even if I just explicitly set the default 2400 in the miparam file. The second option worked but without your help I would have never deciphered the stuff in E 4-8, at least not from my FM - R3.2. Is there any performance consideration/degradation when the lock is set with: using (lock=table) in the SQL statement? Thanks again, Voja. Paul Brown wrote: > > lpv (lpv@visioninc.com) wrote: > : I'm running into this error running Illustra 3.2 on NT: > > [ snip ] > > : XS1003:Lock manager: TABLE_ID <1> > > [ snip ] > > RTFM > > _Illustra_Installation_and_System_Administration_Guide_ > > Section 2.9.2.7, page 2-13 > > "The MI_LOCKS paramater specifies the number of locks to allocate > from shared memory. > > If the lock table seems to be running out of space (error s1003), > try increasing MI_LOCKS." > > Set MI_LOCKS to the number of pages in your big table. Alternatively, > try looking at Appendix E of the _Illustra_User's_Guide_. > > SELECT * > FROM BigTable (lock = table) > WHERE A BETWEEN B AND C;> > > >