I run a 1,000,000 row SQL insert/update which runs fine to completion...
Then the reorganization takes place and SHAZAM JAVAIT ERROR and SQL i/o errors
which conks out my 10 hour 's worth of work... thank god i am only testing....
Any thought's on reorginization killing DB2 Express-C
I thought you could have larger file of any size....
Pinned topic you get JAVAIT 9506 and I/O error for no reason. killing 1,000,00 row table
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-04-18T07:48:51Z at 2012-04-18T07:48:51Z by Pandoria13
SystemAdmin 110000D4XK5837 Posts
Re: you get JAVAIT 9506 and I/O error for no reason. killing 1,000,00 row table2012-04-17T16:53:11ZThis is the accepted answer. This is the accepted answer.Where are you getting this?
what does the db2diag says?
Please give use more context information, and put all the messages in the screen and in the logs.
Re: you get JAVAIT 9506 and I/O error for no reason. killing 1,000,00 row table2012-04-17T23:30:13ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
and I will have to recreate the entire process all over again.
I just have never understood why launching of the control center
would generate a SQL i/o error and the JAVA-IT 9506 after a
massive insert on the next time i invoked the Control Center.
Nothing else was done by me, but after the inserts it appeared
to be reorganization of the INDEX...
I tried repairing DB2 Express-C option but nothing would get around the Error...
I am not at the present just able to flip the switch and compress 10 hours at this time...
James Francis Cray
OOP's Pandoria13 is ElStupido...... killing 1,000,00 row table2012-04-18T07:48:51ZThis is the accepted answer. This is the accepted answer.
- Pandoria13 270004WFHC
I guess it's just human nature, to not point the finger at yourself.
The absolute last two thing which I did prior to trying to launching Control Center,,, was CCLEANER and GLARY UTILITIES.
They appear to be the culprit's to my ElStupido posting, and now I am asking forgiveness.
So, I am off Trying to track down this issue....
James Francis Cray
When I did a DB2 Command Window, DB2START, Connect to SAMPLE, Select * From Z390ZKICK, DB2 Express-C Spewed out the 1,000,000 Row Table, Which was Quite Impressive to say the LEAST...I just had to wait for an extended period... he he he
SO, I AM Sorry for the Wild Goose Chase.