By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

altobj() housekeeping

P: n/a
aj
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
Feb 5 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.