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

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

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

----- 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 misunderstanding 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

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:1103158829.765100.238460@z14g2000cwz.googlegr oups.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

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 misunderstanding 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