Creating the same database but??

İbrahim DEMİR

Creating the same database but??
Hi All;

I have a simple question. What is the best way of creating the same database
but only change will be in codepage. All other configurations must be the
same.
By the way the data is not important for me. Because I have my insert
scripts .

Thanks .
*-----*
*İbrahim DEMİR*
*twt:* @ibrahimdemir
*ff: * @ibrahimdemir
http://www.ibrahimdemir.org

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Steen Rasmussen

Re: Creating the same database but??
(in response to İbrahim DEMİR)
Is this LUW or z/OS – and are you thinking about how to create the database as well as all dependent objects with a different naming convention ?



Steen Rasmussen
CA Technologies
Sr Engineering Services Architect



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ibrahim DEMIR
Sent: Monday, November 29, 2010 2:03 PM
To: [login to unmask email]
Subject: [DB2-L] Creating the same database but??



Hi All;

I have a simple question. What is the best way of creating the same database but only change will be in codepage. All other configurations must be the same.
By the way the data is not important for me. Because I have my insert scripts .

Thanks .
-----
İbrahim DEMİR
twt: @ibrahimdemir
ff: @ibrahimdemir
http://www.ibrahimdemir.org

________________________________

Independent, not-for-profit, User Run - the IDUG difference! < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

William Gannon

Re: Creating the same database but??
(in response to Steen Rasmussen)
Your best (cheapest) bet is probably DB2Look ....



db2look -d <DBname> -e -o <OutputFilename>





William B. Gannon

- IBM Certified Database Administrator

DB2 9 for Linux, Unix and Windows

- IBM Certified Solutions Expert

- IBM Certified Database Administrator

DB2 Universal Database V8.1 for zOS



________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen, Steen
Sent: Monday, November 29, 2010 3:18 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Creating the same database but??



Is this LUW or z/OS - and are you thinking about how to create the database as well as all dependent objects with a different naming convention ?



Steen Rasmussen
CA Technologies
Sr Engineering Services Architect



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ibrahim DEMIR
Sent: Monday, November 29, 2010 2:03 PM
To: [login to unmask email]
Subject: [DB2-L] Creating the same database but??



Hi All;

I have a simple question. What is the best way of creating the same database but only change will be in codepage. All other configurations must be the same.
By the way the data is not important for me. Because I have my insert scripts .

Thanks .
-----
Ýbrahim DEMÝR
twt: @ibrahimdemir
ff: @ibrahimdemir
http://www.ibrahimdemir.org

________________________________

Independent, not-for-profit, User Run - the IDUG difference! < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


________________________________

Independent, not-for-profit, User Run - the IDUG difference! < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv