复制db2 "select substr(tbsp_name,查询
1,25) tbsp_name,substr(container_name,1,50) container_name,total_pages,usable_pages from sysibmadm.snapcontainer" Exp : [db2inst1@localhost ~]$ db2 "select substr(tbsp_name,1,25) tbsp_name,substr(container_name,1,50) container_name,total_pages,usable_pages from sysibmadm.snapcontainer" TBSP_NAME CONTAINER_NAME TOTAL_PAGES USABLE_PAGES SYSCATSPACE /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000000/C 8192 8188 TEMPSPACE1 /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000001/C 0 0 USERSPACE1 /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000002/C 4096 4064 IBMDB2SAMPLEREL /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000003/C 4096 4064 SYSTOOLSPACE /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000004/C 4096 4092 IBMDB2SAMPLEXML /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000005/C 4096 4064 SYSTOOLSTMPSPACE /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000006/C 0 0 1.2.3.4.5.6.7.8.9.10.11.12.13.14.
