|
|
|
While attempting to drop a column and/or index, it was noted that a SQL ALTER TABLE operation on a partitioned file removed the TRNLOG and TRANDEP attributes from the partitions although the partition host retained these attributes.
An ALTER TABLE operation on a partitioned file creates a new set of partitions. The host and partitions are initially created without TRNLOG and TRANDEP for performance considerations. At the completion of the ALTER TABLE, calls to PUTFIL() and PUTHDR() are made on the partition host files to enable the TRNLOG and TRANDEP modes on the files. However, these calls only affected the partition hosts and the newly-created partitions were not updated.
To ensure all partitions are assigned proper file modes, when PUTFIL() is now called on a partition host file and PUTHDR() is called with a mode of ctXFL_ONhdr on a partition host file, these functions now also apply the corresponding filemode changes to all existing partitions for that host.
Also, when an ALTER TABLE operation is performed on a partition host file that has existing partition member files, the partition members were recreated using temporary names instead of the original name. SQL is able to access the files, but it is difficult to identify in a directory listing which partition member files belong to which partition host file.
To make this clearer, RENIFIL() was modified such that for a partitioned host file all existing partition members are renamed and the partition host member resource is updated to reflect the new partition member file names.
