1.如何知道一个索引是分区索引还是非分区索引?
2.分区表上一定要有非分区索引吗?
sycat.indexes和syscat.indexpartitions
1.创建表
1).首先以root权限执行下列命令
touch /tmp/tbsp01
touch /tmp/tbsp02
touch /tmp/tbsp03
chown ba5oltp1 /tmp/tbsp*
2).创建分区要使用的表空间
[ba5oltp1@db2cls02 ~]$ db2 "create tablespace tbsp01 managed by database using (FILE '/tmp/tbsp01' 3000)"
DB20000I The SQL command completed successfully.
[ba5oltp1@db2cls02 ~]$ db2 "create