Topic
  • 3 replies
  • Latest Post - ‏2012-04-18T07:48:51Z by Pandoria13
Pandoria13
Pandoria13
23 Posts

Pinned topic you get JAVAIT 9506 and I/O error for no reason. killing 1,000,00 row table

‏2012-04-17T12:56:41Z |
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....
Updated on 2012-04-18T07:48:51Z at 2012-04-18T07:48:51Z by Pandoria13
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: you get JAVAIT 9506 and I/O error for no reason. killing 1,000,00 row table

    ‏2012-04-17T16:53:11Z  
    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.
  • Pandoria13
    Pandoria13
    23 Posts

    Re: you get JAVAIT 9506 and I/O error for no reason. killing 1,000,00 row table

    ‏2012-04-17T23:30:13Z  
    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.
    Unfortunately, it was on the Launch of Control Center the next day
    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...

    Pandoris13

    James Francis Cray
  • Pandoria13
    Pandoria13
    23 Posts

    OOP's Pandoria13 is ElStupido...... killing 1,000,00 row table

    ‏2012-04-18T07:48:51Z  
    Unfortunately, it was on the Launch of Control Center the next day
    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...

    Pandoris13

    James Francis Cray
    Why, is it that it's always something completely unassociated causing the Issue, which causes you to be ElStupido on the DB2 Express-C Forum.

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

    Pandoria13

    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.