博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
DB2同平台迁移数据库
阅读量:5242 次
发布时间:2019-06-14

本文共 2814 字,大约阅读时间需要 9 分钟。

[appinst@dbsvr1 bakdata]$ db2 backup db EATH online to /tmp/bakdata/ include logs without promptingBackup successful. The timestamp for this backup image is : 20190611173438 db2pd -db EATH -tabAddress            TspId ContainNum Type    TotalPgs   UseablePgs PathID     StripeSet  Container 0x00007F4C860A74A0 0     0          File    32768      32764      0          0          /data/database/appinst/NODE0000/EATH/T0000000/C0000000.CAT0x00007F4C860A8BC0 1     0          Path    1          1          0          0          /data/database/appinst/NODE0000/EATH/T0000001/C0000000.TMP0x00007F4C860AC360 2     0          File    49152      49120      0          0          /data/database/appinst/NODE0000/EATH/T0000002/C0000000.LRG0x00007F4C860ADAE0 3     0          File    8192       8188       0          0          /data/database/appinst/NODE0000/EATH/T0000003/C0000000.LRG0x00007F4C860AF260 4     0          File    1024       992        0          0          /data/database/appinst/NODE0000/EATH/T0000004/C0000000.LRG0x00007F4C860B09E0 5     0          File    16384      16368      0          0          /data/database/appinst/NODE0000/EATH/T0000005/C0000000.USR0x00007F4C860B2100 6     0          Path    1          1          0          0          /data/database/appinst/NODE0000/EATH/T0000006/C0000000.UTMdb2ckbkp -h  EATH.0.appinst.NODE0000.CATN0000.20190611173438.001 | more  db2 create db EATZ using codeset GBK territory CN--从EATH恢复到EATZmkdir /data/EATZ[appinst@reportsvr ~]$ db2 create db EATZ using codeset GBK territory CNDB20000I  The CREATE DATABASE command completed successfully.[appinst@reportsvr ~]$ db2(c) Copyright IBM Corporation 1993,2007Command Line Processor for DB2 Client 9.7.9You can issue database manager commands and SQL statements from the command prompt. For example:    db2 => connect to sample    db2 => bind sample.bndFor general help, type: ?.For command help, type: ? command, where command can bethe first few keywords of a database manager command. For example: ? CATALOG DATABASE for help on the CATALOG DATABASE command ? CATALOG          for help on all of the CATALOG commands.To exit db2 interactive mode, type QUIT at the command prompt. Outside interactive mode, all commands must be prEAixed with 'db2'.To list the current command option settings, type LIST COMMAND OPTIONS.For more detailed help, rEAer to the Online REAerence Manual.db2 => connect to EATZ   Database Connection Information Database server        = DB2/LINUXX8664 9.7.9 SQL authorization ID   = APPINST Local database alias   = EATZRESTORE DATABASE EATH FROM /tmp/bakdata taken at 20190611173438 on /data/EATZ INTO EATZ LOGTARGET '/tmp/bakdata'   db2pd -util ROLLFORWARD db EATZ TO END OF LOGS AND COMPLETE OVERFLOW LOG PATH ('/tmp/bakdata')

 

转载于:https://www.cnblogs.com/houzhiqing/p/11096854.html

你可能感兴趣的文章
Entity Framework 4.1 Code-First 学习笔记
查看>>
Android开发——Fragment知识整理(一)
查看>>
一些奇思幻想
查看>>
半分钟内能看透问题本质的人是如何思考的?
查看>>
EL表达式和JSTL
查看>>
网站并发低解决
查看>>
MSTest、NUnit、xUnit对照表
查看>>
洛谷P1162 填涂颜色【BFS】
查看>>
sql根据'/'截取最后的字符串
查看>>
leetcode 45. Jump Game II
查看>>
windowsGVIM配置及使用
查看>>
Linux查看物理CPU个数、核数、逻辑CPU个数
查看>>
新任 CEO 致员工公开信:微软下一步做什么?
查看>>
Java transient关键字
查看>>
《Spring5官方文档》新功能(4,3)
查看>>
Spring Boot (一): Spring Boot starter自定义
查看>>
Primitives vs Objects
查看>>
74HC165输入
查看>>
C语言中元素访问之数组
查看>>
Unix时间戳与C# DateTime时间类型、C语言互换 1970-01-01 00:00:00
查看>>