有什么方法可以将 DB2 备份文件恢复到 IBM DashDB 上? [英] Is there any way I can restore a DB2 backup file onto IBM DashDB?

问题描述

我正在尝试将 DB2 备份文件恢复到我的 BlueMix DashDB 服务中.我该怎么做?

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

推荐答案

由于多种原因，您无法将 DB2 备份映像恢复到 dashDB.

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

在入门级共享 dashDB 实例中，您只能访问由其他人共享的物理数据库中的一个架构.

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

即使您有一个专用实例，您也需要 1) 访问数据库本地磁盘以上传图像和 2) 足够的权限(至少 SYSMAINT 权限)来执行恢复.我怀疑您是否可以使用其中任何一个.

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.

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

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屋！