pellus
25th October 2008, 15:13
I am doing this right now. There are reconfiguration of tables done of course. I thought all reconfig needed an export and an import but in the log I see three kinds of reconfig. Can someone explain what the difference is, i.e. what the system does in the three cases. See below
tsmsc820311 C3 0 Reconfiguration with export is required
tssoc000311 C4 0 Reconfiguration with export/import is required.
tssoc100311 C2 0 Reconfiguration is required

dave_23
25th October 2008, 19:39
I am doing this right now. There are reconfiguration of tables done of course. I thought all reconfig needed an export and an import but in the log I see three kinds of reconfig. Can someone explain what the difference is, i.e. what the system does in the three cases. See below
tsmsc820311 C3 0 Reconfiguration with export is required
tssoc000311 C4 0 Reconfiguration with export/import is required.
tssoc100311 C2 0 Reconfiguration is required


No idea about #1
#2 is when you do an operation that cannot be handled by "alter table"
such as dropping a field.

#3 means the system will issue an "alter table" instead of export/import.

Dave

Cesar Lopez
2nd November 2008, 00:29
Here you have:

--C1 An error occurred while checking. The Error field will contain
the actual error.

--C2 Reconfiguration is required for this table and the database can
handle the entire reconfiguration. The reconfiguration will be
carried out using reconfiguration method 1.

--C3 Reconfiguration is required for this table. The database can
handle the entire reconfiguration. However, if this table is
reconfigured, bdbreconfig must create an export of the table
data before reconfiguring the table. The reconfiguration will be
performed using reconfiguration method 2.

--C4 Reconfiguration is required for this table. The database cannot
handle the reconfiguration. The reconfiguration will be
performed using reconfiguration method 3.

the method refers as the comment posted, to an alter, or export/delete/create/import and also to the refint, indexes and basicly the options in bdbreconfig

this is for 8.x portingsets, before it was always export/delete/create/import

Regards

pellus
4th November 2008, 13:30
Thankyou all. But I am curious about the variation where the database can handle it but an export has to be done. What typical table/domain change will lead to this? And what is the export good for?