Question

DB2 700的系统如何扩充表空间？

安装的系统版本是700，数据库是DB2 9.1，使用dbacockpit看到表空间已经满了，但是不知道如 何扩充表空间，虽然上面的属性里有说是AutoResized Enable，但是并没有自动扩充表空间，这 是为什么呢？ 麻烦大家帮忙！谢谢！

Answer 1

1. You did not tell us what's the H/W, O/S.and device type, Database-managed space is SAP's standard DB2 tablespace definition. With DMS-based tablespaces, containers are pre-allocated either by DB2 having FILE based containers or by the system administrator having DEVICE-based containers such as RAW devices (UNIX) or PARTITIONS (Windows). 2. If you have no idea how to add a container in DB2 as Basis, you might need to learn the whole DB2 admin for SAP (BC325 or ADM325) or check help.sap.com. ?I believe you will have lots of other DB2 admin issue. You need to learn Why/What then How. Not just ask this kind of question.

Answer 2

BTW, Add containers for the tablespaces belonging to the database partition groups on the new partition: db2 “alter tablespace add …” depends on what kind of the tablespace