Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2006

Tip: Looking for answers? Try searching our database.

Error SQL0901N without any Reasoncode

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Boothby - 12 Jul 2006 10:51 GMT
Hi,

I tried to do a LOAD in a scriptfile and get after the success LOAD an
error.
Look at the output:

...
SQL3213I  Der Indexierungsmodus ist "INCREMENTAL".

SQL3515W  Die Phase "BUILD" wurde beendet (Zeit: "07/10/2006
09:50:44.298996").

Anzahl gelesener Zeilen                                          = 98
Anzahl übersprungener Zeilen                                     = 0
Anzahl geladener Zeilen                                          = 98
Anzahl zurückgewiesener Zeilen                                   = 0
Anzahl gelöschter Zeilen                                         = 0
Anzahl festgeschriebener Zeilen                                  = 98

SQL0901N  Die SQL-Anweisung schlug auf Grund eines nicht schwer
wiegenden
(nicht kritischen) Systemfehlers fehl. Nachfolgende SQL-Anweisungen
können
verarbeitet werden. Ursachencode: "".  SQLSTATE=58004
...

My script makes the LOAD and then the following statement.
"DB2 SET INTEGRITY FOR KRC.KSA_AUSWERTUNGEN IMMEDIATE CHECKED"

I have the problem after we installed the fix pak 12 on the 8.1
Version!

Any Ideas or comments?

Heiko
mike - 12 Jul 2006 11:05 GMT
Anything in the db2diag.log file for the time of the failure ?
Serge Rielau - 13 Jul 2006 12:09 GMT
> Anything in the db2diag.log file for the time of the failure ?

...and please report the -901 to support.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.