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 > Any help on this error .

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-25-10, 13:21
DBFinder DBFinder is offline
Registered User
 
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
Any help on this error .

D:\SGILL\JunLi>db2 insert into client (GIVEN_NAME) values ('00000')

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0901N The SQL statement failed because of a non-severe system error.

Subsequent SQL statements can be processed. (Reason "parent in 1-1 rel.

already has child".) SQLSTATE=58004


db2 v9.5 FP4 CLIENT is view on CLIENT_IDV view which is further view on CLIENT_NEW table.

Regards
Reply With Quote
  #2 (permalink)  
Old 01-25-10, 15:19
Lenny77 Lenny77 is offline
Registered User
 
Join Date: Jul 2009
Location: NY
Posts: 886
This SQLCODE might occur when distributed commit processing
encounters an error. In this case, all servers in the unit of work that
support distributed two-phase commit backed out the unit of work. If a
server that does not support distributed two-phase commit has updates in
the unit of work, that server must be queried to determine if its updates
were committed or backed out.

Finally, this error might occur during commit if post-processing cannot be
completed because of an update that changes the partition of a row.
Resource unavailable problems can prevent the post-processing from
completing. The existence of held cursors can prevent the post-processing
from completing. Commit is failed. The transaction is aborted.
Reply With Quote
  #3 (permalink)  
Old 01-26-10, 19:52
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Looks like a db2 bug
Reply With Quote
  #4 (permalink)  
Old 01-27-10, 03:31
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
Yes, a SQL0901 is pretty much always a DB2 bug.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
  #5 (permalink)  
Old 01-27-10, 03:43
serinakuebler serinakuebler is offline
Registered User
 
Join Date: Jan 2010
Location: USA
Posts: 1
Exploiting my broadband and High Definition cable TV

A comrade of mine announced my high definition transmission depended upon how durable my digital cable tv signal was. I've bought a comcast cable television package that bundles my high-speed internet and digital cable tv with High definition channels together. My picture is terrific, i do not feel it could be significantly better. Still does any one know if there is any truth to what my buddy claims.

SIGNATURE:

__________________________________________________ __________
comcast bundle deals for existing customers | comcast discount codes
Reply With Quote
  #6 (permalink)  
Old 01-27-10, 08:06
DBFinder DBFinder is offline
Registered User
 
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
PMR has been registered.

Thanks for replies
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