It's all about the answers!

Ask a question

DB2 database setup instructions curiosity


Mark Martin (4811815) | asked Oct 05 '10, 5:17 p.m.
This is a "just curious" question. The RTC documentation gives the following command to create a DB2 database:

db2 create database JAZZ using codeset UTF-8 territory en PAGESIZE 16K
http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp?topic=/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_db2.html

This sorta works fine (needs a space between 16 & K), but I was poking around the DB2 docs, and tried to look up the supported territory codes. Yeah, dodging real work... Anyway, the supported codeset table does not list en, at least not in the DB2 v9.7 docs.
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.nls.doc/doc/r0004565.html

DB2 does not throw any errors over "territory en" but I am a little concerned it might in future releases or fix paks if this is in fact not a supported setting. Is this a throwback to previous releases of DB2?

Thanks

One answer



permanent link
Anthony Kesterton (7.5k9180136) | answered Oct 06 '10, 5:13 a.m.
JAZZ DEVELOPER
This is a "just curious" question. The RTC documentation gives the following command to create a DB2 database:

db2 create database JAZZ using codeset UTF-8 territory en PAGESIZE 16K
http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp?topic=/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_db2.html

This sorta works fine (needs a space between 16 & K), but I was poking around the DB2 docs, and tried to look up the supported territory codes. Yeah, dodging real work... Anyway, the supported codeset table does not list en, at least not in the DB2 v9.7 docs.
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.nls.doc/doc/r0004565.html

DB2 does not throw any errors over "territory en" but I am a little concerned it might in future releases or fix paks if this is in fact not a supported setting. Is this a throwback to previous releases of DB2?

Thanks


Could you please raise a defect against Documentation on this so it can be checked out.

thanks

anthony

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.