有没有办法将DB2备份文件还原到IBM DashDB？ [英] Is there any way I can restore a DB2 backup file onto IBM DashDB?

问题描述

我正在尝试将DB2备份文件还原到BlueMix DashDB服务中。如何执行此操作？

解决方案

由于几个原因，您无法将DB2备份映像还原到dashDB中。

在入门级别中，共享的dashDB实例只能访问其他人共享的物理数据库中的一个模式。即使你有一个专用的实例，你需要1）访问数据库本地磁盘来上传图像，2）足够的权限（至少要有SYSMAINT权限）才能执行恢复。我怀疑你可以使用它。

你可以做的是运行 db2look 和 db2move 分别提取数据库DDL语句和数据。然后，您可以对dashDB运行提取的DDL脚本，只要您将原始模式名称替换为dashDB中可用的模式名称，并在创建表之后将数据加载到其中。

I am trying to restore a DB2 backup file into my BlueMix DashDB service. How do I go about doing this?

解决方案

You cannot restore your DB2 backup image into dashDB for several reasons.

In an entry-level, shared dashDB instance you only have access to one schema in a physical database shared by others.

Even if you have a dedicated instance, you need 1) access to the database local disk to upload the image and 2) sufficient privileges (at least SYSMAINT authority) to perform the restore. I doubt either will be available to you.

What you can do is run db2look and db2move locally to extract your database DDL statements and data respectively. You can then run the extracted DDL script against dashDB provided you replace the original schema name(s) with the one available to you in dashDB and, after creating the tables, load your data into them.

这篇关于有没有办法将DB2备份文件还原到IBM DashDB？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！