Hi All,
I have a problem on "SET INTEGRITY" on one table. I have one script to "SET INTEGRITY" on a table with couple million rows. We run it one time per week afer it's parent table is loaded. The environment is UDB on solaris. The script is the only task running on this database. We have some other database on the same machine under the same database instance name.
Normally, it takes about 10 minutes to complete, however it sometimes may running for more than 5 or 6 hours without stop, until I manually terminate the script. However the volumn matrix of the entire database is almost the same for each week, at most 5% difference.
Any idea on this issue? How can I check what UDB is doing internally? It seems the script just hanging there. Any advice is welcome!
Thanks,
Mike
I have a problem on "SET INTEGRITY" on one table. I have one script to "SET INTEGRITY" on a table with couple million rows. We run it one time per week afer it's parent table is loaded. The environment is UDB on solaris. The script is the only task running on this database. We have some other database on the same machine under the same database instance name.
Normally, it takes about 10 minutes to complete, however it sometimes may running for more than 5 or 6 hours without stop, until I manually terminate the script. However the volumn matrix of the entire database is almost the same for each week, at most 5% difference.
Any idea on this issue? How can I check what UDB is doing internally? It seems the script just hanging there. Any advice is welcome!
Thanks,
Mike
Comment