So I've got this pretty sizeable DB that I can't unload because it gets stuck on SYSADM.COMMSQL. COMMSQL shouldn't *truly* exist, so I think "no problem, I'll drop it". Problem is, it won't drop:
"Table has not been created".
Yet the table quite clearly exists. If I create it, it just creates another COMMSQL, and I somehow end up with two of them. I get some phantom errors regarding foreign keys in some user tables, but it all comes down to this issue in SYSTABLES. So...
Anyone got any ideas how I can either drop this table, or unload SYSTABLES (that hangs), or ammend SYSTABLES to remove any reference to COMMSQL?
"Table has not been created".
Yet the table quite clearly exists. If I create it, it just creates another COMMSQL, and I somehow end up with two of them. I get some phantom errors regarding foreign keys in some user tables, but it all comes down to this issue in SYSTABLES. So...
Anyone got any ideas how I can either drop this table, or unload SYSTABLES (that hangs), or ammend SYSTABLES to remove any reference to COMMSQL?