0

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.

Al Jam
  • 35
  • 1
  • 3
  • 11
  • 1
    Which DB2 platform are you on? The tag "db2-connect" hints at the mainframe. And do you mean on-disk allocation? – data_henrik Aug 27 '15 at 12:06

1 Answers1

0

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)

Peter Miehle
  • 5,984
  • 2
  • 38
  • 55