473,289 Members | 2,106 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

regarding BACKUP/RESTORE

aka
Hi,

I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15) from
a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3 (64-bit,
Big-endian) server located in US. The target server has DB2 V8.2 FP 15
installed and instance name and filesystem user groups rights an so on are
all identical.
From the manuals I see that a crossplatform backup-restore should be
supported between the two systems.
I did a full offline backup of the db with compress option. Resulting backup
file is about 10GB. Then I ftp'ed this image in binary mode to the target
machine. I did a restore like this

db2 restore database <dbfrom /tmp/<image_nametaken at <time_stamp>
comprlib <aix_compression_lib>

this said restore was successful. I did a rollforward complete (successful)
and could connect to the database so it seemed all went well. I began
running some SQL and scripts and noticed soon that our character data is
somewhat corrupted. We have a lot of text data from over 40 countries in
many different languages and the character data from some languages (like
chinese and arabic for example) has been completely replaced by 0x00 0x1A
bytes in char and varchar columns.

Does someone has an idea before I go with IBM support?

Regards,
aka.
Feb 16 '08 #1
3 2590
aka wrote:
I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15) from
a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3 (64-bit,
Big-endian) server located in US. The target server has DB2 V8.2 FP 15
installed and instance name and filesystem user groups rights an so on are
all identical.
From the manuals I see that a crossplatform backup-restore should be
supported between the two systems.
I did a full offline backup of the db with compress option. Resulting backup
file is about 10GB. Then I ftp'ed this image in binary mode to the target
machine. I did a restore like this

db2 restore database <dbfrom /tmp/<image_nametaken at <time_stamp>
comprlib <aix_compression_lib>

this said restore was successful. I did a rollforward complete (successful)
and could connect to the database so it seemed all went well. I began
running some SQL and scripts and noticed soon that our character data is
somewhat corrupted. We have a lot of text data from over 40 countries in
many different languages and the character data from some languages (like
chinese and arabic for example) has been completely replaced by 0x00 0x1A
bytes in char and varchar columns.

Does someone has an idea before I go with IBM support?
I'm going out on a limb here, but I don't think you have a restore problem.
neither backup nor restore give a hoot about your VARCHAR and CHAR columns.
It does not look at the data.

Now, to confirm that please compare the HEX content of the data.
Running the HEX() function ON THE SERVER via SQL.

I would start looking at codepage conversion, locale, territory.
Not my cup of tea, so I can't be more specific. But I'd be very
surprised if backup/restore is guilty.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Feb 16 '08 #2
aka
Hi Serge,

thanks for confirming that BACKUP / RESTORE should not mangle with our
character data, that was also my thinking.

What I did was SELECT HEX(REP_MESSAGE) FROM ... and it returned a string
like this 001A001A001A001A...

Now because control center can not show many of the UTF-8 encoded data
especially when there are different languages mixed in the same field we
tend to use Toad for browsing the db and looking at our tables.
My experience so far is that Toad has less problems in reading out these
fields even if there is sometimes an invalid unicode character in the data
(which comes mostly from byte oriented substring operations), but by
browsing some tables on the target machine I saw whole screens full of
..?.?.?.?.?.?.?.?.?.?.?.?.?.?.?.?.?.?.?.? where I see chinese (at least I
believe) characters over here in our data warehouse.

I set the LANG=en_US.UTF-8 on both machines in my PUTTY window...

I'll be on this topic next week and researching further.

Thanks & regards,
aka.
"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:61*************@mid.individual.net...
aka wrote:
>I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15)
from a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3
(64-bit, Big-endian) server located in US. The target server has DB2 V8.2
FP 15 installed and instance name and filesystem user groups rights an so
on are all identical.
From the manuals I see that a crossplatform backup-restore should be
supported between the two systems.
I did a full offline backup of the db with compress option. Resulting
backup file is about 10GB. Then I ftp'ed this image in binary mode to the
target machine. I did a restore like this

db2 restore database <dbfrom /tmp/<image_nametaken at <time_stamp>
comprlib <aix_compression_lib>

this said restore was successful. I did a rollforward complete
(successful) and could connect to the database so it seemed all went
well. I began running some SQL and scripts and noticed soon that our
character data is somewhat corrupted. We have a lot of text data from
over 40 countries in many different languages and the character data from
some languages (like chinese and arabic for example) has been completely
replaced by 0x00 0x1A bytes in char and varchar columns.

Does someone has an idea before I go with IBM support?
I'm going out on a limb here, but I don't think you have a restore
problem.
neither backup nor restore give a hoot about your VARCHAR and CHAR
columns.
It does not look at the data.

Now, to confirm that please compare the HEX content of the data.
Running the HEX() function ON THE SERVER via SQL.

I would start looking at codepage conversion, locale, territory.
Not my cup of tea, so I can't be more specific. But I'd be very surprised
if backup/restore is guilty.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Feb 16 '08 #3
aka
just for completeness...

I'd tried another db and it worked all fine, I redid my dwh db and it also
worked fine...so I can't reproduce the problem.

Case closed.

Thanks,
aka.
"aka" <ak*@aka-soft.dewrote in message news:fp**********@online.de...
Hi,

I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15)
from a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3
(64-bit, Big-endian) server located in US. The target server has DB2 V8.2
FP 15 installed and instance name and filesystem user groups rights an so
on are all identical.
From the manuals I see that a crossplatform backup-restore should be
supported between the two systems.
I did a full offline backup of the db with compress option. Resulting
backup file is about 10GB. Then I ftp'ed this image in binary mode to the
target machine. I did a restore like this

db2 restore database <dbfrom /tmp/<image_nametaken at <time_stamp>
comprlib <aix_compression_lib>

this said restore was successful. I did a rollforward complete
(successful) and could connect to the database so it seemed all went well.
I began running some SQL and scripts and noticed soon that our character
data is somewhat corrupted. We have a lot of text data from over 40
countries in many different languages and the character data from some
languages (like chinese and arabic for example) has been completely
replaced by 0x00 0x1A bytes in char and varchar columns.

Does someone has an idea before I go with IBM support?

Regards,
aka.

Feb 19 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Tim Morrison | last post by:
MSDE2000 I have an application in which I am running a TSQL command of BACKUP DATABASE and RESTORE DATABASE for the backup and restore commands for my application. For testing purposes, i did the...
3
by: butatista | last post by:
Please help SQL Server 2000 Standard I am trying to restore databases on my server and am unable to get them to restore using the database option. For example, the location of my backup...
2
by: Vikrant | last post by:
Friends, I have read DB2/UDB 8.x 'RESTORE DATABASE Command', with my 'limited' knowledge & skill. I think it should address my concern, but I want advice/ opinion / experience and any care I...
4
by: Hardy | last post by:
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but...
1
by: supriya | last post by:
Hi, I found vshadow sdk in MSDN.I am unable to use the shadow copy for backup and restore because it is creating only non persistent shadow copy in winxp.How can i create persistent shadow copy...
2
by: Raghava | last post by:
hi all, i was working on DB2 and came across an issue. i.e. can a tablespace be rollforwarded to POINT-IN-TIME? the scenario is as follows: i created a data base and a tablespace in it. i have...
0
by: raj.raghavan | last post by:
Hi, I have a database were all the indexes are in a seperate filegroup a few large tables are in a seperate filegroup. We take backup at different times and I have backup of primary, two filegroup...
5
by: smoi | last post by:
Hi all, My manager ask me to do backup for 3 database and restore them in a new server. I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL...
2
by: clilush | last post by:
I've been working with db2 8.2fp14 for over a year now and was wondering what is a "standard" way of doing a backup to provide 24/7 operations with disaster recovery capabilities? My thoughts were...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.