DB2 LUW 8.2 FP14 Red Hat AS 2.1
I primarily use alter table (and therefore altobj()) from CC.
Is it OK to delete those T* backup tables that get created when I alter
tables w/ altobj()? It looks like sometimes they get left there and
sometimes not?
Is it OK to delete any rows that I see left around in
SYSTOOLS.ALTOBJ _INFO?? If there are no alters happening, should
SYSTOOLS.ALTOBJ _INFO be empty?
altobj() does a LOAD COPY YES and apparently leaves stuff in
~/sqllib/tmp. Once a backup is done, is is safe to delete everything
in ~/sqllib/tmp? Some of these files are named pipes?
TIA
aj
I primarily use alter table (and therefore altobj()) from CC.
Is it OK to delete those T* backup tables that get created when I alter
tables w/ altobj()? It looks like sometimes they get left there and
sometimes not?
Is it OK to delete any rows that I see left around in
SYSTOOLS.ALTOBJ _INFO?? If there are no alters happening, should
SYSTOOLS.ALTOBJ _INFO be empty?
altobj() does a LOAD COPY YES and apparently leaves stuff in
~/sqllib/tmp. Once a backup is done, is is safe to delete everything
in ~/sqllib/tmp? Some of these files are named pipes?
TIA
aj