Results 1 to 7 of 7

Thread: DB2 migration

  1. #1
    Join Date
    Dec 2009
    Posts
    22

    Unanswered: DB2 migration

    Hi ,

    I am getting an SQL error while migrating my commerce v8.3 to v9.5 for Websphere commerce

    "com.ibm.db2.jcc.a.zn: DB2 SQL Error: SQLCODE=-802, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.3.111"

    So i am assuming that this might be some thing SQL is un able to handle but
    not absolutely sure ....so how should i go around to slove this migration issues ...Can some one help ?????

    Thanks in advance !

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Start with the error message you are getting.

    Code:
    SQL0802N  Arithmetic overflow or other arithmetic exception occurred.
    
    Explanation:
    
    The processing of a column function or arithmetic expression has
    resulted in an arithmetic overflow.
    
    The statement cannot be processed. For the INSERT, UPDATE, or DELETE
    statements, no inserts or updates are performed.
    
    User response:
    
    Examine the SQL statement to determine the cause of the problem. If the
    problem is data dependent, it is necessary to examine the data processed
    when the error occurred. Refer to the SQL Reference to see the valid
    ranges for the data types.
    
    This error may also be returned when column functions cannot handle the
    value that is returned by the SQL statement. For example, issuing a
    SELECT COUNT statement against a table that has more rows than defined
    by the MAX_LONGINT_INT SQL limit will cause an arithmetic overflow
    error. Consider using the COUNT_BIG column function for tables with more
    than 2 147 483 647 rows.
    
    Federated system users: examine the SQL statement to determine the cause
    of the problem. If the problem is data dependent, examine the data being
    processed at the data sources when the error occurred. Refer to the
    corresponding SQL Reference for the data source to determine the valid
    ranges for the data types.
    
     sqlcode: -802
    
     sqlstate: 22003
    Andy

  3. #3
    Join Date
    Dec 2009
    Posts
    22
    Hi andy,

    Thanks for Quick reply ....that true the sql 802 points to the overflow ..but what i was thinking is is there some thing to do with the jdbc_variable path
    As there was the com.ibm.db2.jcc.a.zn --> May be i have fix the variable after the migration of the db2 from v8-v9.5
    Or Is this related to some dB parameter that has to be fixed for accommodating the migration of large commerce database ???

    Is there any Apars for V9.5 to fix this kind of issues like the one i found for the v8.2
    IBM IZ51591: DATABASES FAIL TO LOAD IN THE AGGREGATION PHASE WITH ERROR SQLCODE: -413, SQLSTATE: 22003 - United States

    So can correct me i'm going out of way about this issues !!!!

    Thanks in advance !

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Can you post the java code that is causing the error along with the DDL for the tables affected?

    Andy

  5. #5
    Join Date
    Dec 2009
    Posts
    22
    Well i'm running one of the commerce script in order to migrate the data from v8.2 to v9.5 ...and i'm ending up in this issues !

    So can you let me which DDL are you refering????

    Do we have to apply some kind of fix like IBM IZ45284: CREATE OR ALTER TABLE WITH XML COLUMN FAILS WITH SQL8029E - United States
    on the v9.5 to solve this issues ... which i'm assuming of table spaces as the issues and which need to larger then what the default v9.5 has ... which is
    throwing up this .. issues ????

    Or wrong mapping to different table which is causing this ???

    But can you correct me if i'm wrong ......

    Thanks in advance !

  6. #6
    Join Date
    Dec 2009
    Posts
    22
    Andy,

    Thanks for the helping hand .....i really appreciate it !

    I was going thru the wcim log .. ..it reflect something which you pointed in that note
    VERBOSE: checkDatabase:
    VERBOSE: -checkFromParam:
    INFO: [wcimDBCheckingTask] select count(*) from BUSAUDIT


    So where should i check this "MAX_LONGINT_INT SQL" variable client side or server side how to use COUNT_BIG column function ????

    In order to solve this issues Is there any fix from IBM on db2v9.5 for aix 5.3 which i need to go for ????

    will this fix be applicable for this issues IBM IZ45284: CREATE OR ALTER TABLE WITH XML COLUMN FAILS WITH SQL8029E - United States

    Thanks in advance !!!

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You are getting a SQLCODE = -802. This is an arithmetic overflow. Which means you are trying to stuff a number that is to large a value for what is trying to hold it. Like trying to put a number above 2,147,483,647 into an integer or smallint.

    Without seeing the specific item that is causing the error, I cannot help you any further.

    Andy

Posting Permissions

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