If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 migration

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-11-10, 11:20
sdsu sdsu is offline
Registered User
 
Join Date: Dec 2009
Posts: 22
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 !
Reply With Quote
  #2 (permalink)  
Old 01-11-10, 13:21
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
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
Reply With Quote
  #3 (permalink)  
Old 01-11-10, 13:42
sdsu sdsu is offline
Registered User
 
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 !
Reply With Quote
  #4 (permalink)  
Old 01-11-10, 16:22
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
Can you post the java code that is causing the error along with the DDL for the tables affected?

Andy
Reply With Quote
  #5 (permalink)  
Old 01-11-10, 17:31
sdsu sdsu is offline
Registered User
 
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 !
Reply With Quote
  #6 (permalink)  
Old 01-12-10, 00:07
sdsu sdsu is offline
Registered User
 
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 !!!
Reply With Quote
  #7 (permalink)  
Old 01-12-10, 08:33
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On