4。REVOER恢复CMD: db2 "recover database to 2010-07-11-00.41.41 using local time"SQL0104N An unexpected token "2010-07-11-00.41.41" was found following "TO".Expected tokens may include: "USER". SQLSTATE=42601CMD: db2 "recover databas...(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)
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)
关于命令db2_all,rah的区别使用summary如下:rah: to send to all physical serversdb2_all: to send to all database partitions:db2_all '<<+1< command':send command to only database partition 1:db2_all '<<-1< command':send command to all dat...(more)
查看缓冲池1) 看所有buffer pool的总情况,用get snapshot for database on db_name
2) 看每个bufferpool的单独情况,用get snapshot for all bufferpool on db_name
2) 看每个tablespace使用buffer pool的情况, 用get snapshot for tablespaces on db_name查看缓冲池命中率...(more)