db2 学习笔记
2006-03-30 22:07:45 来源:WEB开发网 闂傚倸鍊搁崐鎼佸磹閹间礁纾归柟闂寸绾惧綊鏌熼梻瀵割槮缁炬儳缍婇弻鐔兼⒒鐎靛壊妲紒鐐劤缂嶅﹪寮婚悢鍏尖拻閻庨潧澹婂Σ顔剧磼閹冣挃闁硅櫕鎹囬垾鏃堝礃椤忎礁浜鹃柨婵嗙凹缁ㄧ粯銇勯幒瀣仾闁靛洤瀚伴獮鍥敍濮f寧鎹囬弻鐔哥瑹閸喖顬堝銈庡亝缁挸鐣烽崡鐐嶆棃鍩€椤掑嫮宓佸┑鐘插绾句粙鏌涚仦鎹愬闁逞屽墰閹虫捇锝炲┑瀣╅柍杞拌兌閻ゅ懐绱撴担鍓插剱妞ゆ垶鐟╁畷銉р偓锝庡枟閻撴洘銇勯幇闈涗簼缂佽埖姘ㄧ槐鎾诲礃閳哄倻顦板┑顔硷工椤嘲鐣烽幒鎴旀瀻闁规惌鍘借ⅵ濠电姷鏁告慨顓㈠磻閹剧粯鈷戞い鎺嗗亾缂佸鏁婚獮鍡涙倷閸濆嫮顔愬┑鐑囩秵閸撴瑦淇婇懖鈺冪<闁归偊鍙庡▓婊堟煛鐏炵硶鍋撻幇浣告倯闁硅偐琛ラ埀顒冨皺閺佹牕鈹戦悙鏉戠仸闁圭ǹ鎽滅划鏃堟偨缁嬭锕傛煕閺囥劌鐏犻柛鎰ㄥ亾婵$偑鍊栭崝锕€顭块埀顒佺箾瀹€濠侀偗婵﹨娅g槐鎺懳熺拠鑼舵暱闂備胶枪濞寸兘寮拠宸殨濠电姵纰嶉弲鎻掝熆鐠虹尨宸ョ€规挸妫濆铏圭磼濡搫顫嶇紓浣风劍閹稿啿鐣烽幋锕€绠婚悹鍥у级瀹撳秴顪冮妶鍡樺鞍缂佸鍨剁粋宥夋倷椤掍礁寮垮┑鈽嗗灣閸樠勭妤e啯鍊垫慨妯煎亾鐎氾拷

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:
yyyy is the year (1995 to 9999), mm is the month (01 to 12),
dd is the day of the month (01 to 31), hh is the hour (00 to 23),
mm is the minutes (00 to 59), ss is the seconds (00 to 59).
Sequence number - A three-digit sequence number used as a file extension.
更多精彩
赞助商链接