db2 学习笔记
1。手工强制db2归档
2。not logged initially option
3。blk_log_dsk_ful 参数
4。提高备份性能的参数parallelism ,backbufsz
5。备份到磁盘上的文件名
1。手工强制db2归档
db2 => ? archive log ?
archive log for database database-alias [user username [using password]]
[on-dbpartitionnum-clause]
on-dbpartitionnum-clause:
on {{dbpartitionnum dbpartitionnums} (db-partition-number
[to db-partition-number] , ... ) all dbpartitionnums [except
{dbpartitionnum dbpartitionnums} (db-partition-number
[to db-partition-number] , ...)]}
2。not logged initially option
当用create talbe 或者alter talbe 语句带上这个选项，表示不对表的insert或者update 记录日志，特别对于导入大量的数据时，而且这些数据很容易重新创建时，这个选项尤其有用。
3。blk_log_dsk_ful 参数
the dbm configuration parameter blk_log_dsk_ful can be used to prevent "disk full" errors from being generated when db2 cannot create a new log file in the active log path.
4。提高备份性能的参数parallelism ,backbufsz
backup database db2cert to /dev/rmt0
with 2 buffers
buffer 512
parallelism 2
this command backs up the database db2cert to a tape device on an aix system. two buffers of 512 (4 kb) pages each are allocated. two parallel tasks are used to backup in parallel
the value of the parallelism parameter. using this parameter can reduce the amount of time required to complete the backup. it defines the number of processes or threads that are started to read data from the database. each process or thread is assigned to back up a specific table space. when it completes backing up the table space, it requests another. increasing the value requires additional processor and memory resources. the default value is one.
the backup buffer size and number of buffers. if you use multiple buffers and i/o channels, you should use at least twice as many buffers as channels to ensure that the channels do not have to wait for data. the size of the buffers should ideally be a multiple of the table space extent size. if you have differing extent sizes, choose a multiple of the largest extent size. if the buffer size if not specified the value is taken from the database manager configuration parameter backbufsz, which by default is 1024 (4 kb) pages.
5。备份到磁盘上的文件名
sample.0.db2inst1.node0000.catn0000.20050705103703.001
database alias - a one to eight character database alias name that was supplied when the backup command was invoked.
type - type of backup taken, where: "0" is for full database, "3" is for table space.
instance name - a one to eight character name of the instance.
node number - the node number.
catalog node number - the node number of the database's catalog node.
time stamp - a 14-character representation of the date and time the backup was performed. the timestamp is in the format yyyymmddhhmmss, where:
- Copyright © 2001- 2010 丰搜网 All Rights Reserved
- ICP备案编号:粤ICP备06052964号
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器
