restore with different code page

rdba · #1 (**permalink**) 10-08-09, 14:58

Can we restore an offline backup of a v8 database with code page 819 to a v9.7 database with code page 1208?

n_i · #2 (**permalink**) 10-08-09, 16:05

I don't see why not. However, I think you will have the database with the code page 819 in the end.

rdba · #3 (**permalink**) 10-08-09, 18:38

Is it possible to restore and keep code page 1208?

db2girl · #4 (**permalink**) 10-08-09, 19:57

You can't change the codepage during restore:
IBM DB2 9.7 for Linux, UNIX and Windows Information Center

"When restoring a backup image with one code page into a system with a different codepage, the system code page will be overwritten by the code page of the backup image."

dr_te_z · #5 (**permalink**) 10-09-09, 03:04

You'll need "db2move" for this.

Internet Services

Web Development

Digital Marketing

Consumer Tech