Hi,
I'm trying to transfer the data from Websphere portal 6.0 database to IBM DB2 version 8.1.8. while transferring the data it shows the following error:


[sqlproc] CREATE TABLE release.WSRP_PROD_LOD (
[sqlproc] WSRP_PROD_OID CHAR(18) FOR BIT DATA NOT NULL,
[sqlproc] LOCALE VARCHAR(64) NOT NULL,
[sqlproc] TITLE VARGRAPHIC(255),
[sqlproc] DESCRIPTION VARGRAPHIC(1024),
[sqlproc] CONSTRAINT PK560 PRIMARY KEY (WSRP_PROD_OID, LOCALE),
[sqlproc] CONSTRAINT FK560 FOREIGN KEY (WSRP_PROD_OID) REFERENCES release.
WSRP_PROD (OID) ON DELETE CASCADE
[sqlproc] )

[sqlproc] Error during statement execution!
[sqlproc] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1216N Graphic data and graphic functions are not supported for this database. SQLSTATE=56031

Please help to resolve this error.

Thanks
Syed

this data type is not not supported for this database codepage
you probably should create the db with UTF-8 as codepage to support this

Hi Guy Przytula,

Thank you for your reply.

It'll be helpful for me if you explain how to create the db with UTF-8 as codepage.

Regards,
Syed

as indicated in command reference
create database dbname USING CODESET utf-8 TERRITORY ....
check online doc at
http://publib.boulder.ibm.com/infoce.../v8//index.jsp
and search for create database command

Hi Guy Przytula,

I have DB2 enterprise Server Edition version 8.1.8 in my system.

When I tried to create database with the following command:

CREATE DB wpsdb USING CODESET UTF-8 TERRITORY us COLLATE USING UCA400_NO PAGESIZE 8192

It shows the following error:

SQL0104N An unexpected token "PAGESIZE" was found following "UCA400_NO".

Expected tokens may include: "CATALOG". SQLSTATE=42601


1)Is it necessary to install DB2 ESE v8.1 Fix Pack 12 to resolve this error?

Regards,
Syed

there is a similar apar
LI70112
the name of the db does not equal as in the apar
will check on later fp on local machine - I don't have the problem on windows fp12

Hi Guy Przytula,

Thank you for your reply.

I installed DB2 Enterprise server edition fix pack 12 and now i'm able to create database with "vargraphic" datatype.

But when i tried to execute the "db2start" command in command line processor, i got the following error:

06/12/2007 06:14:55 0 0 SQL1092N "DB2ADMIN" does not have the authority to perform the requested command.
SQL1092N "DB2ADMIN" does not have the authority to perform the requested command.

Even though I login to my system as db2admin (administrator created while installing DB2), I got this error.
"db2admin" is in Administrators group.

When I executed the db2 get dbm cfg | find /i"sysadm" command, I got the output as follows:
SYSADM group name (SYSADM_GROUP) =

Please help to resolve this error.

Thanks & Regards,
Syed

create a group for db2 system administrators
add this user to the group
update dbm cfg with this group name