Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update a table with blob data type-: SQLCODE: -904, SQLSTATE: 57011, S

Status
Not open for further replies.

krishrad

Technical User
Feb 5, 2008
12
0
0
US
When i am trying to update a blob object am getting error : SQLCODE: -904, SQLSTATE: 57011, SQLERRMC: 00C900D1;00000907
always. How to investigate this and possible solution to this.
 
Your lob is exceeding the system limit defined for DB2. Either ask your DBA's to increase it, or use a smaller lob.


Reason code 00C900D1 - The amount of space allowed for processing LOB values by a user has been exceeded. The amount of space allowed per user is indicated by panel DSNTIP7.

Regards

Frederico Fonseca
SysSoft Integrated Ltd
 
Hey,

I fixed by incresing the LOBVALA value.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top