Results 1 to 8 of 8
  1. #1
    Join Date
    May 2007
    Posts
    4

    Question Unanswered: Errors while creating table with VARGRAPHIC data type

    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

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    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
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    May 2007
    Posts
    4

    Re:Errors while creating table with VARGRAPHIC data type

    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

  4. #4
    Join Date
    Jun 2006
    Posts
    471
    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
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  5. #5
    Join Date
    May 2007
    Posts
    4
    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

  6. #6
    Join Date
    Jun 2006
    Posts
    471
    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
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  7. #7
    Join Date
    May 2007
    Posts
    4
    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

  8. #8
    Join Date
    Jun 2006
    Posts
    471
    create a group for db2 system administrators
    add this user to the group
    update dbm cfg with this group name
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •