Re: Alter table (no more locks)

IF your system allowed, you can : 1. Unload all the data from the table. 2. Recreate the table again 3. Load back the data. However, you must take pre-caution that :- 1. Don't load in your 'unloaded' file in one SQL statement, wherever possible split the unloaded file into multiple file. (in which the number of rows is below the max locks available) 2. Backup the database b4 your doing all these. Scott Black wrote: > HP-UX 10.20 > IDS 7.30.UC2 > > I'm sure someone has run into this problem before. I locked a table in > exclusive mode, then modified a column as: > > set lock mode to wait;> begin work; > lock table product in exclusive mode; > alter table product> modify(category smallint); > commit work; > > For which I received: > > Lockmode set. > Started transaction. > Table locked. > 312: Cannot update system catalog (syscolauth). > 134: ISAM error: no more locks > Error in line 8> Near character position 24 > 377: Must terminate transaction before closing database. > 853: Current transaction has been rolled back due to error> or missing COMMIT WORK. > > I assume it must be running out of locks in a temp table, or the system > table. How do I get around this? I could increase the number of locks, > the table only has 120K or so rows. But suppose it had several million? > > Thanks in advance.