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 > Sql0302n

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 14
Sql0302n

Hi- All,

I'm having db2 9.7 on Linux.
I have been experiencing a problem processing an invoice with 700+ lines. The raw data size is small (280k), so that should not be an issue.

Statement heap size is Automatic.

The error we are getting is:

[IBM][CLI Driver][DB2/LINUXX8664] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001

Please help me to solve this error.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Apr 2008
Posts: 39
hello

check the length of column data with respect to data in going to be
inserted. looks like data is being entered is larger then specified column
length in table.

Thanks
Naval K
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 14
Thanks for your response.

I have seen an error below in db2inst1.nfy file. I'm wondering if that is related to this error.

ADM1823E The active log is full and is held by application handle "12267..".
Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Apr 2008
Posts: 39
no these are not related. but yes second one is also an another error. according to that txn log is full. you need to check which job is filling logs.. which job is a long running job.. etc etc . and finally kill few of them to clear out the space
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 14
Ok.

Also having this error in db2diag:

RETCODE : ZRC=0x8B0F0002=-1961951230=SQLO_NOMEM_DBH
"No memory available in 'Database Heap'"
DIA8302C No memory available in the database heap.


DB heap size is 900. If I increase that will it solve the problem?
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Apr 2008
Posts: 39
no.. increasing memory heap will not resolve.. on the other hand .. memory error is another issue for you
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 14
Thanks. We are still working on it.
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