RE: DBA problems

I'd make a couple of comments Chunks are allocated to dbspaces not tablespaces but that just me being pedantic:-) Do not use the device name give by your Unix administrator for the chunk instead create link to it and use that instead. This will make your life easier in the long run. Onstat -d will only give you the current instance allocation, if you are using multiple instances you need to check them all to ensure you don't allocate the same space twice. Informix doesn't like this :-)) There are a couple of utilities at www.iiug.org to help with this. Paul Watson # WF Software Ltd # Contractor: Tel: +44 1463 674729 # Someone who can Fax: +44 1463 678729 # bullshit at speed www.wfsoftware.com # > -----Original Message----- > From: Vic Glass [mailto:icc@injersey.infi.net] > Sent: 08 April 1999 10:59 > To: informix-list@iiug.org > Subject: Re: DBA probems > > > Mukund, > > I'm afraid that Vic and Obnoxio are not quite giving you the > whole story > about about the allocation, use and depletion of table space. Vic, who > is not related to me, indicates that more space will automatically be > allocated, the size of which is guided by the "next extent" > specification for the table. Obnoxio, indicates that you need to get > more disk (from your UNIX administrator), and add it, in the form of a > "chunk", to the table space. He also indicates that you > should read the > manual, and there is some truth to this. However, I do not > believe that > you should be executed for allegedly not reading the manual. > Here's the > scoop. > > 1. Before doing anything, you should execute the oncheck command to > determine how many chunks are assigned to the table space in question, > and how many pages are allocated, used and free in each of > those chunks. > The command line is: oncheck -pe > out, where out is a file > name of your > choice that will hold the output of the oncheck command. If in fact > there is only one chunk assigned to the table space, and and > the numbers > are as you specified, then it is difficult to tell how close > you are to > empty. specifically, it is difficult to tell how much of the *last* > extent allocated is used up. For example, if the initial > extent size is > 500,000 Kb, and the next extent is 100,000 Kb, then you will have > anywhere from 0 to 100,000 Kb left in that extent. Whenever > an extent is > allocated, the pages of that extent are designated "used", whether or > not they have data in them or not. > > If you have more than one chunk allocated to the table space and the > other chunks have sufficient space, you may be fine. > > 2. If indeed you have only one chunk assigned to the table > space and it > appears to be running on empty, then you should determine if you have > unallocated disk available. If so, you can add some of this > disk to the > table space in the form of a chunk. You can do this via the onmonitor > administrative utility. If you do not have any disk available, you'll > need to contact the UNIX system administrator to get some. When he > supplies the disk, he will give you a device name, something like > /dev/xxxxxx, and you will use this device name in the > onmonitor when you > add the chunk. > > 3. It would be a good idea to size your database tables if you haven't > already. Do this in conjunction with input from people who know your > application intimately. > > "Space, the final frontier" > > Oh, try executing onstat -d, this give a nice summary of disk > allocation. > > Also (to anyone one else is has read this thing), I can still use some > input about my question on INFORMIXTMP. The system administrator is > getting real retentive and stubborn, and now insists he > cannot live with > the existence of the /INFORMIXTMP directory. He is suggesting > that I use > a symbolic link instead, so that the damn thing is located in another > file system. Any comments other than the need to hire a hit man? > > > > Mukund Shevkar wrote: > > > Hi this is mukund > > > > My online tables are getting full e.g. > > Pages allocated = 36440 and pages used = 36271 > > Tell me how i can allocate more pages(next size ?) before it gets > > full ? > > > > Regards > > > > Thanks > > > > Mukund > > > > ______________________________________________________ > > Get Your Private, Free Email at http://www.hotmail.com >