$ db2 LIST DATABASE PARTITION GROUPS SHOW DETAILDATABASE PARTITION GROUP PMAP_ID DATABASE PARTITION NUMBER IN_USE---------------------------- ------- ------------------------------DATABASE PARTITION GROUP PMAP_ID DATABASE PARTITION NUMBER IN_USE-----...(more)

Copy from CogKnowHow The Cognos content store tables are used by Cognos 8 as repository database. So a regular database backup is very important! All you folders, reports and security are stored in these tables. The table structure is created wh...(more)

 db2 ? sql952SQL0952N  Processing was cancelled due to an interrupt.Explanation:The user may have pressed the interrupt key sequence.The statement processing is terminated. Some changes may have beenapplied to the database, but not committe...(more)

[dwpinst1@global-tracking db2home]$ db2 -tvf error_view.sqlEnter current password for dwpinst1: CONNECT TO PHXDBDW1 USER dwpinst1   Database Connection Information Database server        = DB2/LINUXX8...(more)

db2 :表空间 缓冲池的页大小是一致的测试环境中表空间和缓冲池大小为8k row最大限制为1801    在此表空间定义的表结构中 字段长度定义不能大于1800.[dwpinst1@global-tracking db2home]$ db2 -tvf tmptable2_last.sqlEnter current password for dw...(more)

dd count=1 bs=4k skip=15 seek=8 if=/dev/LVName of=/dev/LVName -- JFS2seek就是去掉8个，不包括0，没有0这个概念这个还是说明了seek在备份的时候，是没有一点关系的# dd if=1.txt of=1.bak bs=1 count=1 seek=0以下答案可知seek=0和seek=1的情况下都是把位置放在第一个的# ...(more)

from: http://www.cnblogs.com/jackhub/archive/2013/03/15/3147204.htmlTablespace  investigation DMS,HWM database   test Tablespacename = USERSPACE1 1. USERSPACE1初始状态   TablespaceExtent size (pages) = 32 Totalnumber of pages = 8...(more)

use mastergodrop database testdbgocreate database testdbgouse testdbgocreate table test1 (id int,updated datetime,memo char(6000))goinsert into test1 values (1,GETDATE(),'xxx')go 10000dbcc showfilestats() --1 1 1284 1273 testdb gobackup database test...(more)

在之前的博文中说了如何去查看SQL的访问计划，当我们发现当前计划需要调整或者想看看有无优化空间时，我们可以使用db2advis工具，该工具是针对 用户提供的工作负载（此工作负载非彼工作负载，你懂的，不懂也没关系。这里的工作负载就是一组SQL语句的组合）而给出的优化建议，优化建议包...(more)

In a partitioned database environment, each table space is associated with a specific database partition group. This allows the characteristics of the table space to be applied to each database partition in the database partition group. When allocati...(more)