they prefer that but infrastructure people don't like that! their monitoring tools can't detect it from capacity point of view. What I keep seeing is developer/vendor like to control upper limit so that when problems happen, customer needs to pay them as customer don't know how to fix DB space problem! DB has it's own system of managing disk space and they know it. The new guy is not me, I am trying to get ride of this ! I don t see it make sense. What I mean is, we should not be see this anymore. Basically they didn't understand why you'd want to use SMS instead of DMS.' 'The guy(s) that built the database probably ported it from a mainframe database, were old mainframe guys that were comfortable with those controls. I am comparing computer science, I am sorry if I do sth wrong on you but I am really discuss from computer science point of view. 'I cringe every time I hear some say something like, 'I like MS SQL as from day 1, we can do it easily'.

Just want to know how many MB I have to increase in storage! If the file thing, '/space/home/yyyy/user/use r_containe r', is the value for in the command 'df -k ' ? What I know is the structure of userspace1 is : CREATE REGULAR TABLESPACE USERSPACE1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 16K MANAGED BY DATABASE USING ( File '/space/home/yyyy/user/user_container' 602908 ) EXTENTSIZE 32 BUFFERPOOL ARBP1 OVERHEAD 24.1 TRANSFERRATE 0.9 DROPPED TABLE RECOVERY ON The avail value is number of Bytes available for each of the Filesystem, ?

I login to the solarix console and type this insteadĭf -k, it show me some data with column : 'df -k ' what should be the is about ? how can I find that out ? I found that one to teach me how to do this: So I can only use alter to extend the userspace1, right? Additional spaceĬan be added to the table space by either adding new containers or extendingĮxisting ones using the ALTER TABLESPACE SQL statement.

'ADM6044E The DMS table space 'USERSPACE1' (ID '2') is full. SQL0289N - Unable to allocate new pages in table space with DB2 ESE in IWD

Toad for db2 freeware