DBA probems

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

As long as there is space in the dbspace that your table is in, the engine will automatically allocate another extent for you. Vic 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 -- Vic Goldberg Manager, Data Operations Cornell University (607) 254-7441 (Voice) (607) 255-6982 (Fax)

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