How to increase allocated table size for particular table using db2 command

467 Views Asked by At

How to increase allocated table size for particular table using DB2 command.Or is there a alternative way to increase memory for all table by 5mb at once.

1

There are 1 best solutions below

0
Peter Miehle On

you do not increase the memory for the table, but for the tablespace it is located in.

select tbspace from syscat.tables where tabname = 'MYTAB'

db2 "alter tablespace tbspace extend (all 100000)