Backup DB2 UDB 7.x on Linux Restore on Windows?

Hi,

I'm new to DB2 and have what may be a stupid question:

Is it possible to backup a DB2 UDB 7.x database on a Linux server and
restore it on a Win2k server (both running the same version of DB2)?

Backups on the Linux box seem to be a single file. Backups on the Windows
box seem to be a directory structure.

The DBMOVE command doesn't look like the answer since it leaves behind CLOB
data.

Am I missing something?

-Al

Nov 12 '05 #1

Subscribe Reply

4914

db2inst1

This has exactly what you are looking for.

http://www-106.ibm.com/developerwork...dm-0403melnyk/

CLOB data is not a problem..

GOODLUCK

Al wrote:

Hi,

I'm new to DB2 and have what may be a stupid question:

Is it possible to backup a DB2 UDB 7.x database on a Linux server and
restore it on a Win2k server (both running the same version of DB2)?

Backups on the Linux box seem to be a single file. Backups on the Windows box seem to be a directory structure.

The DBMOVE command doesn't look like the answer since it leaves behind CLOB data.

Am I missing something?

-Al

Nov 12 '05 #2

Knut Stolze

Al wrote:

Hi,

I'm new to DB2 and have what may be a stupid question:

Is it possible to backup a DB2 UDB 7.x database on a Linux server and
restore it on a Win2k server (both running the same version of DB2)?
No, you can't. Have a look at the documentation for RESTORE DATABASE.
http://publib.boulder.ibm.com/infoce...e/r0001976.htm
The DBMOVE command doesn't look like the answer since it leaves behind
CLOB data.

How's that? After all, the documentation says that LOBs are handled:
http://publib.boulder.ibm.com/infoce...e/r0002079.htm

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Nov 12 '05 #3

----- Original Message -----
From: "Knut Stolze"

Al wrote:
The DBMOVE command doesn't look like the answer since it
leaves behind CLOB data.

How's that? After all, the documentation says that LOBs are
handled:

http://publib.boulder.ibm.com/infoce...e/r0002079.htm
Thanks for responding. I may be misunderstandin g the docs, but what leads me
to believe this is:

| tabnnnc.yyy
| The exported LOB files of a specific table.
| "nnn" is the table number. "c" is a letter of
| the alphabet. "yyy" is a number ranging from
| 001 to 999.

| These files are created only if the table being
| exported contains LOB data. If created, these
| LOB files are placed in the "lobpath" directories.
| There are a total of 26 000 possible names for
| the LOB files.

This would seem to imply that tables with one or more CLOB fields and more
than 26,000 rows (a comically small number for a production DB) will lose
data. Is this really the case?

-Al

Nov 12 '05 #4

Thanks. My concern with the CLOB data is that it appears that only the first
26,000 rows come across due to the naming scheme. I'll try experimenting
with multiple LOBPaths and see if that works.

-Al
"db2inst1" wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
This has exactly what you are looking for.

http://www-106.ibm.com/developerwork...dm-0403melnyk/

CLOB data is not a problem..

GOODLUCK

Al wrote:

Hi,

I'm new to DB2 and have what may be a stupid question:

Is it possible to backup a DB2 UDB 7.x database on a Linux server and
restore it on a Win2k server (both running the same version of DB2)?

Backups on the Linux box seem to be a single file. Backups on the Windows box seem to be a directory structure.

The DBMOVE command doesn't look like the answer since it leaves behind CLOB data.

Am I missing something?

-Al

Nov 12 '05 #5

Knut Stolze

Al wrote:

----- Original Message -----
From: "Knut Stolze"
Al wrote:
> The DBMOVE command doesn't look like the answer since it
> leaves behind CLOB data.

How's that? After all, the documentation says that LOBs are
handled:

http://publib.boulder.ibm.com/infoce...e/r0002079.htm

Thanks for responding. I may be misunderstandin g the docs, but what leads
me to believe this is:

| tabnnnc.yyy
| The exported LOB files of a specific table.
| "nnn" is the table number. "c" is a letter of
| the alphabet. "yyy" is a number ranging from
| 001 to 999.

| These files are created only if the table being
| exported contains LOB data. If created, these
| LOB files are placed in the "lobpath" directories.
| There are a total of 26 000 possible names for
| the LOB files.

This would seem to imply that tables with one or more CLOB fields and more
than 26,000 rows (a comically small number for a production DB) will lose
data. Is this really the case?

I don't know for sure but you can specify multiple directories, and you can
place the 26000 files (the alphabet has 26 letters and the "yyy" numbers
rango from 000 through 999) in each of the directories.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Nov 12 '05 #6

Similar topics

1984

Full Backup of DB2 V8.2

by: Fabian Knopf | last post by:

Hi @ll, how can i backup my DB2 V8.1 database and install it to another machine where DB2 V8.2 is running. Cu, Fabian

DB2 Database

1867

[Restore DB] backup from linux & resotore to windows

by: NEXUZ6 | last post by:

Can I restore a backup taken from a DB2 7.2 on Linux to a 8.1 Win ? How ? Tkx

DB2 Database

7313

Restore From Offline Backup

by: Buck Turgidson | last post by:

I have an SAP development system running on Linux. It is not a critical system, but I would like a restore-able backup. I have taken an offline backup, but I am unable to restore it. I am guessing I need to quiesce the database somehow and get it into an offline state. What are commands to do so in db2? This is what I get when Itry to restore.

DB2 Database

3017

Backup and Restore of PostgreSQL

by: Tim Penhey | last post by:

Hi All, I have a java web server (Tomcat) running a web application that uses PostgreSQL for all of the data. All of the management of the application is done through the web application and I would like to provide a backup and restore option for the user. Backup would somehow get all of the data/schema (maybe not schema) from the DB and zip it and send it to the customer through the web-app to allow them to save the backup on their...

PostgreSQL Database

5581

DB2 cross-platform RESTORE, tools for backup transformation?

by: maha | last post by:

Dear DB2 experts! I'm stuck with the following issue: from a customer I got a DB2 backup file, created on an AIX-32 machine that I cannot restore on my windows platform. I admit that I posses only limited knowledge on the administration side of DB2, but I have done a lot of research, without solving the problem. What I tried: For a regular RESTORE I would need a linux Big Endian machine

DB2 Database

4991

Backup in Db2 Linux and Restore in DB2 Windows

by: abelbfilho | last post by:

I have a backup image with name DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.001 and I want to restore it on Windows (in another server). In Windows Server I created this folder structure: D:\DADOSADV.0\db2\NODE0000\CATN0000\20060812\ and rename the backup image file to 230006.001 When I type (Prompt DOS) db2ckbkp -H 230006.001 and I receive this result ===================== MEDIA HEADER REACHED:

DB2 Database

5756

Restore backup performed on Unix server to a Windows server

by: Christian Maslen | last post by:

Hi All, I understand in older versions of DB2/UDB this was not possible. The following article explains how I might do this http://www.ibm.com/developerworks/db2/library/techarticle/0207kline/0207kline.html Is this still a restriction in version 9.x? I'd specifically like to restore a backup performed on an AIX server to a Windows server.

DB2 Database

4930

db2 UDB backup using COMPRESS option

by: zgh1970 | last post by:

Hi, Friends, default DB2 compression library. I am wondering if this option will have any new restriction on RESTORE in the following. (Can I used that backup imsage for restore at the follwoing compatible situations?) : There are operating system considerations when using the RESTORE DATABASE command:

DB2 Database

3283

pg_dump backup doesnt restore everything - things missing... restore howto required

by: glubber | last post by:

I have a cronned perl script that runs on a different server. when I try to restore it to the server below things dont copy across correctly. the target server is described below. debian 4.0 - Linux testbox.jumboentertainment.com.au 2.6.18-4-686 #1 SMP Mon Mar 26 17:17:36 UTC 2007 i686 GNU/Linux with the latest apt-get installation of postgres

PostgreSQL Database

9589

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9423

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10216

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9865

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6675

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5310

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5448

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3965

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2815

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General