WebOct 22, 2007 · FPAGES show the amount of pages reserved for table usage and includes free pages. So FPAGES can be compared to the pages used given by list tablespaces show detail. You get a deviation if you have FPAGES-NPAGES > 0 for your tables. If you would have any old stats that might also give a deviation. /Hans Naveen via db2-l wrote: WebWhen the LIST TABLESPACES SHOW DETAIL command is issued, it will attempt to free all pending free extents in the table space. If the pending free extents are freed …
LIST TABLESPACES command - IBM
WebApr 15, 2016 · db2 => list tablespaces show detail ... 本地库用户名 连接本地库:db2 connect to 本地库 user 本地库用户名 using 本地用户密码 2、开启联邦支持开启联邦支持,查看数据库管理配置文件,FEDERATED属性 db2 get dbm cfg 如联邦属性为NO, 则需开启属性,重启数据库。 ... WebNumber of quiescers (displayed only if the table space state is "quiesced: SHARE", "quiesced: UPDATE", or "quiesced: EXCLUSIVE") Table space ID and object ID for each quiescer (displayed only if the number of quiescers is greater than zero). Examples. The following are two sample outputs from LIST TABLESPACES SHOW DETAIL. crt ss6900v
Command Reference - Columbia University
Web查询sysibmadm.tbsp_utilization,看到有一些dms表空间的tbsp_free_size_kb剩余空间为0,利用率是100%,而为什么在db2 list tablespaces show detail,看到相关的表空间时,却发现还是有剩余空间的呢?难道我查询的有问题? 哪位知道什么原因啊? 谢谢! WebJun 6, 2012 · There are a few ways you can increase the number of free pages. You need to know how many file containers are assigned to the tablespace and how many free and used pages you have using the following query (or db2 list tablespaces show detail from the command line): SELECT SUBSTR (TBSP_NAME,1,15) NAME ,TBSP_TYPE TYPE … crt ss9900